Product Loader + uploads a data file that contains one line per product + in your catalog. Each line has fields corresponding to a subset of the + columns in the ec_products table. The first line of the data file is a + header that defines which fields are being loaded and the order that + they appear in the data file. The remaining lines contain the product + data. +
Product Extras Loader + is similar to the product loader except it + loads data into ec_custom_product_field_values, the table which contains + the values for each product of the custom fields you have added. + The file format resembles the products import data file format. +
Product Category Map Loader By Name-Matching + creates the mappings between products in ec_products table + and categories in ec_categories, ec_subcategories, and ec_subsubcategories tables + by inserting rows into ec_category_product_map and ec_subcategory_product_map.) The + data file you create for uploading should consist of product sku and + category or subcategory names, one per row. This process attempts to be + smart by using the SQL \"LIKE\" function to resolve close matches between + categories listed in the data file and those known in the database. +
Product Category Map Loader By Index Mapping + creates the product-categories mappings by finding exact matches to the + category tables' indexes category_id, subcategory_id, subsubcategory_id. +
The product loader uploads a CSV file that contains one line per product -in your catalog. Each line has fields corresponding to a subset of the -columns in the ec_products table. The first line of the CSV file is a -header that defines which fields are being loaded and the order that -they appear in the CSV file. The remaining lines contain the product -data. - -
The product extras loader is similar to the product loader except it -loads data into ec_custom_product_field_values, the table which contains -the values for each product of the custom fields you've added. -The file format is -also similar to that of the product data CSV file. - -
Note:You must load the products and define the extra fields -you wish to use before you can load the product extras. - -
The product category map loader creates the mappings between products -and categories and products and subcategories (specifically, it inserts -rows into ec_category_product_map and ec_subcategory_product_map.) The -CSV file you create for uploading should consist of product id and -category or subcategory names, one per row. This program attempts to be -smart by using the SQL like function to resolve close matches between -categories listed in the CSV file and those known in the database. - -
Note:You must create the categories and subcategories before -you can use the product category map loader. - -
Currently, there is no feature for bulk uploading images. However, the code will automatically recognize images that are placed in the product's directory. Use the filename \"product\" and either \".gif\" or \".jpg\" extension for product image. Thumbnails use the filename \"product-thumbnail.jpg\". No facility exists for GIF thumbnails, because they tend to have larger file sizes which signifcantly slow page loads via ssl. Note: PNG extensions are not supported either, as there is no ns_pngsize function (at the time of this writing).
++ Note: Products need to be loaded and their extra fields need to be defined before + loading product extras. +
++ Note: Categories and subcategories need to be created before using + a Product Category Map Loader. +
++ Note: There may be a peak load condition on the server for an extended period + when bulk loading of product images create product thumbnails (optional feature). +
[ad_admin_footer] "