| |
1 |
1 |
# www/[ec_url_concat [ec_url] /admin]/products/upload-utilities.tcl |
| |
2 |
2 |
ad_page_contract { |
| |
3 |
3 |
Upload utilites admin page. |
| |
4 |
4 |
|
| |
5 |
5 |
@author Eve Andersson (eveander@arsdigita.com) |
| |
6 |
6 |
@creation-date Summer 1999 |
| |
7 |
7 |
@cvs-id $Id$ |
| |
8 |
8 |
@author ported by Jerry Asher (jerry@theashergroup.com) |
| |
9 |
9 |
} { |
| |
10 |
10 |
} |
| |
11 |
11 |
|
| |
12 |
12 |
ad_require_permission [ad_conn package_id] admin |
| |
13 |
13 |
|
| |
14 |
|
doc_body_append "[ad_admin_header "Upload Utilities"] |
| |
|
14 |
set page_title "Upload Utilities" |
| |
|
15 |
set context_bar [template::adp_parse [acs_root_dir]/packages/[ad_conn package_key]/www/contextbar [list context_addition "Upload Utilities"]] |
| |
15 |
16 |
|
| |
16 |
|
<h2>Upload Utilities</h2> |
| |
17 |
|
|
| |
18 |
|
[ad_context_bar [list "../" "Ecommerce([ec_system_name])"] [list "index.tcl" "Products"] "Upload Utilities"] |
| |
19 |
|
|
| |
20 |
|
<hr> |
| |
21 |
|
|
| |
22 |
|
These utilities help you load catalog data into the database: |
| |
23 |
|
|
| |
24 |
|
<ul> |
| |
25 |
|
<li><p><a href=\"upload\">Product Loader</a> |
| |
26 |
|
uploads a data file that contains one line per product |
| |
27 |
|
in your catalog. Each line has fields corresponding to a subset of the |
| |
28 |
|
columns in the <tt>ec_products</tt> table. The first line of the data file is a |
| |
29 |
|
header that defines which fields are being loaded and the order that |
| |
30 |
|
they appear in the data file. The remaining lines contain the product |
| |
31 |
|
data. |
| |
32 |
|
</p></li> |
| |
33 |
|
<li><p><a href=\"extras-upload\">Product Extras Loader</a> |
| |
34 |
|
is similar to the product loader except it |
| |
35 |
|
loads data into <tt>ec_custom_product_field_values</tt>, the table which contains |
| |
36 |
|
the values for each product of the custom fields you have added. |
| |
37 |
|
The file format resembles the products import data file format. |
| |
38 |
|
</p></li> |
| |
39 |
|
<li><p><a href=\"categories-upload\">Product Category Map Loader By Name-Matching</a> |
| |
40 |
|
creates the mappings between products in <tt>ec_products</tt> table |
| |
41 |
|
and categories in <tt>ec_categories</tt>, <tt>ec_subcategories</tt>, and <tt>ec_subsubcategories</tt> tables |
| |
42 |
|
by inserting rows into <tt>ec_category_product_map</tt> and <tt>ec_subcategory_product_map</tt>.) The |
| |
43 |
|
data file you create for uploading should consist of product sku and |
| |
44 |
|
category or subcategory names, one per row. This process attempts to be |
| |
45 |
|
smart by using the SQL \"LIKE\" function to resolve close matches between |
| |
46 |
|
categories listed in the data file and those known in the database. |
| |
47 |
|
</p></li> |
| |
48 |
|
<li><p><a href=\"categories-upload-by-id\">Product Category Map Loader By Index Matching</a> |
| |
49 |
|
creates the product-categories mappings by finding exact matches to the |
| |
50 |
|
category tables' indexes <tt>category_id</tt>, <tt>subcategory_id</tt>, <tt>subsubcategory_id</tt>. |
| |
51 |
|
</p></li> |
| |
52 |
|
|
| |
53 |
|
<li><p> |
| |
54 |
|
<a href=\"import-images\">Bulk Product Image Loader</a> imports product images for existing |
| |
55 |
|
products, and creates thumbnails for them. |
| |
56 |
|
Place product images in a set of directories accessible by this server. Then use this utility |
| |
57 |
|
to upload a file that maps product <tt>sku</tt> to the location of the product images |
| |
58 |
|
<tt>full_imagepathname</tt>. |
| |
59 |
|
</p></li> |
| |
60 |
|
|
| |
61 |
|
</ul> |
| |
62 |
|
|
| |
63 |
|
<p> |
| |
64 |
|
<b>Note:</b> Products need to be loaded and their extra fields need to be defined before |
| |
65 |
|
loading product extras. |
| |
66 |
|
</p> |
| |
67 |
|
<p> |
| |
68 |
|
<b>Note:</b> Categories and subcategories need to be created before using |
| |
69 |
|
a Product Category Map Loader. |
| |
70 |
|
</p> |
| |
71 |
|
<p> |
| |
72 |
|
<b>Note: </b>There may be a peak load condition on the server for an extended period |
| |
73 |
|
when bulk loading of product images create product thumbnails (optional feature). |
| |
74 |
|
</p> |
| |
75 |
|
[ad_admin_footer] |
| |
76 |
|
" |
