The Product Import wizard helps you import products into product catalog from a file. Importing a list of products is a quick and convenient way to create the product catalog for the first time or update many products at once in the existing catalog, when needed.
Preparation The product list that you wish to import in the catalog should be contained in a CSV file.
CSV is a convenient format for storing spreadsheet data in simple text file. This format is widely supported by different spreadsheet editors, including Microsoft Excel, OpenOffice Calc and Google Docs & Spreadsheets. See Wikipedia article Comma-Separated Values for a detailed description.
The CSV file that you import into product catalog may contain the following fields:
|Field Name||Contents and behavior|
A unique number which identifies a product. • If specified and a product with the same ID already exists in the catalog, the existing product attributes are replaced with the values in other CSV fields. If a CSV field is empty, the corresponding attribute remains untouched. • If specified but there's no product with this ID in the catalog, the CSV row is skipped. • If empty, the product is added to the catalog with the system specified ProductID.
|ProductName||The text that will appear as the product name everywhere in the storefront, shopping cart and administration interface. When you add a new product to the catalog, the name is required – it is impossible to create products without names.|
|ProductCategory||The product will appear under the specified category in the catalog. To specify a subcategory, specify it as a path, starting from the category in which you will be importing the products (you will be prompted for it in Step 2), separating each subcategory in the path by a forward slash ('/'). If the specified category doesn't exist in the catalog, it will be automatically created.
There's no need to specify categories for products already in the catalog. The shopping cart system will keep them in the same categories and will only update their attributes.
It is impossible to put a product in several categories during import. However, this can be done later using the Product Manager.
|ProductSalePrice||The price that will be shown in the storefront. Number only, no currency symbols. Period as decimals separator.|
|ProductListPrice||Any other price you wish to associate with the product. Use it for any purposes you need. Number only, no currency symbols. Period as decimals separator.|
|ProductQuantityInStock||The number of product items you have in stock and are able to sell.|
|ProductLowStockLevel||When the quantity of the product items left in stock reaches this number, the software can notify you.|
|ProductSKU||Any code that you use to keep track of the product in your stock.|
|ProductAvailable||A string, either 'Online' or 'Offline.' If the product is specified as 'Offline,' it will not be shown to the customer in the storefront. This is useful if you need to change some product options and do not want your customers to order it until you finish. Default value: 'Online'|
|ProductTaxClass||A string, either 'Taxable' or 'Nontaxable.' Default value: 'Nontaxable'|
|ProductLargeImage||The image file that your customers will see on the product info page. Specify the image file name with extension, but without any path. The actual image files are imported separately.|
|ProductSmallImage||The image file that your customers will see next to the product name in various lists in the storefront. Specify the image file name with extension, but without any path. The actual image files are imported separately.|
|ProductImageAltText||The text that your customers will see if they do not load the product images (for example, in case their Internet connection is slow).|
|ProductShortDescription||A brief text description for your product. Appears next to the product name in various lists in the storefront. HTML code is allowed.|
|ProductDetailedDescription||A detailed text description for your product. Appears on the product info page. HTML code is allowed.|
|ProductPerItemShippingCost||A number indicating the cost of shipping of one product item. Number only, no currency symbols. Period as decimals separator.|
|ProductPerItemHandlingCost||A number indicating the cost of handling of one product item. Number only, no currency symbols. Period as decimals separator.|
|ProductWeight||A number indicating the product's weight, in units specified in store settings. Number only, no currency symbols. Period as decimals separator.|
|ProductFreeShipping||A string, either 'YES' or 'NO.' If you specify 'YES,' the product's shipping cost, even if specified, won't be added to a total order amount. Default value: 'NO'|
|ProductNeedShipping||A string, either 'YES' or 'NO.' Use 'NO' for digital goods (downloadable files). Default value: 'YES'|
|ProductPageTitle||The text that will appear in the user’s browser's window title in front of your store name and in search results for the product info page.|
|ProductMetaKeywords||The keywords that search engines will associate with the product when they will index the product info page.|
|ProductMetaDescription||The text that search engines will use as the description for the product info page in the search results.|
|ProductSEOPrefix||The string that will be added to the beginning of the URL that will point to the product info page. Allowed characters: 'a'-'9' and dash ('-'). All other characters will be automatically replaced with underscores ('_').|
|Product<custom attribute tag>||You can add a custom product attribute to the product type to which you're importing the products, and specify the attribute values in such a field.
For example, if you add the 'Book Author' attribute (with 'author' as the attribute tag) to the 'Books' product type, you can specify authors for all books in a CSV field named 'ProductAuthor'.
It is possible to include several fields of this type in one CSV file, one for every custom attribute.
IMPORTANT! All CSV fields not listed in the above table will be ignored. It is impossible to import or update product properties not described in the table.
If a CSV field is left blank, the corresponding product attribute will be set to its default value. If it is not defined in the table, it will be set to zero for numeric values and to an empty string for string values.
The fields in the CSV file can be separated either by semicolons (';') or commas (','). If a CSV field contains one of these characters, it should be put in quotes. Spreadsheet editors normally export CSV files using this technique. If you have problems exporting files to CSV format, refer to your editor's help system.
We provide a sample CSV file prepared for importing into product catalog. It contains all of the above fields and several products for a sample DVD store. You're free to study the file and use it as a starting point for listing your own products.
If you specified product image file names in your CSV file, you need to prepare actual image files. Product images can be imported in the catalog in two ways: • They can be uploaded to a single directory on the server where the shopping cart software is installed. • They can be imported in a single TAR archive. The archive file can either reside on your local computer or be uploaded to the server where the shopping cart software is installed. TAR archives are supported by most compression software. If your compression software doesn't handle TAR archives, you can download the free 7-Zip archiver which can make TAR files.
Once you prepare both the CSV file and the images, start the three-step importing process described below.
Step 1 of 3. Selecting a file to import. During this step, you should select the CSV file containing the data you need to import. The file can be located either on your PC or be uploaded to the server where the shopping cart software is installed.
IMPORTANT! While importing, a large number of catalog products are replaced. If the wrong file is imported, you may lose your actual product catalog information. We recommend performing a full system backup before any import; this will let you restore your product catalog in case any errors arise during import. Data backup may be performed in the Admin >> Data Backup & Restore section.
Choose the file, click OK and then click Next.
Step 2 of 3. Checking the file and choosing import parameters.
The purpose of this step is to verify the integrity and correctness of the CSV file specified for import. If it contains any errors, they are displayed in the Import file check log and no import is made. The wizard also determines the quantity of products it will add to and update in the catalog, which is useful for checking.
If this file is allowed to be imported, you will be prompted for Target product type and Target category. Please specify the product type and category in which you want the products to appear. If you specified categories in the imported file, the wizard will expect them to exist in the Target category that you specify in this step. If such categories do not exist, they will be created under the specified Target category.
Also in this step, if the CSV file contains product image file names, you are prompted for the location of actual image files. Choose the TAR file on your local computer or a server directory (it may contain uncompressed images or a TAR file).
Click Start to begin the importing process.
Step 3 of 3. Importing. This step includes importing CSV data and images (if specified).
The Import Log displays additional information about the process, such as creation of categories or missing image files, if any.
After the process is finished, you may review the log, click Close to close the Product Import wizard and then refresh the admin area to reflect the change in product numbers.
You may now delete the imported CSV and TAR files. You may re-create them at any time by exporting products back from the catalog.