Importing and Exporting Product Details
The ability to import and export product data in bulk within database tools is a very useful tool, it allows you to make changes to your entire product database in a very short space of time.
Below is an overview of the two import process options and the mapping fields, if you are unsure which method to use, please contact Support.
Please note that if this feature is used incorrectly it can severely affect your website and its contents. There are checks in place to try to prevent corruption of your data but this is not guaranteed, therefore only experienced users should import a database.
Core Product Details
|Product Code/Store ID||Unique Identifier||The unique identifier for the system (when working with codes prefixed with a zero, format to number within xl) With product option the main code must be added to all lines.|
|Product Price||Product Price||The product price, gross value unless you have requested your site to function primarily in net.|
|Product Name||Product Name||This is the product title as it appears on the website.|
|Categories||Product Category||Use one column per category level, all columns mapped to Product Category.|
|Product Images||Product Images||Used for uploading images from the FTP area, must include the file extension and no spaces.|
|Product Images||Product Images (remote)||Used for uploading images from an external URL, must include the full URL.|
|Stock Level||Product Quantity||Actual stock quantity (number) of product for live stock, or 1 for in stock & 0 for not in stock when using standard stock control.
Product Option Details
|Option Code||Option Code||The unique identifier for the option.|
|Option Cost Price||Option Cost Price||The product option cost price.|
|Delete Option||Option Deletion/Archive||Use this to delete a product option, enter 0 or 1. 1 = True
|Quantity Stock||Option Quantity/Stock||As per core product detail.
|Option RRP||Option RRP||The recommended retail price for the product option.|
|Option Tax Rate||Option Tax Rate||The tax rate for the product option.|
|Option Weight||Option Weight||The weight of the option, used to calculate shipping.|
|Option Price||Product Option Price||The price of the option, in gross unless you have specified to use net values.|
|Option Set Name||Product Option Set||The name of the option set, one column per option set.|
|SEO 1 (can be renamed)||MPN (can be renamed)||A free text field that can be displayed on the product page.|
|SEO 2 (can be renamed)||EAN (can be renamed)||A free text field that can be displayed on the product page.|
|SEO 3 (can be renamed)||ISBN (can be renamed)||A free text field that can be displayed on the product page.|
|SEO 4 (can be renamed)||UPC (can be renamed)||A free text field that can be displayed on the product page.|
Product Display Details
|Recommended Product||Recommended (0 or 1)||Can be used to set a product as recommended, use 0 or 1. 1 = True|
|Archive/Delete/Draft/Discontinued||Archive Product (0, 1, 2 or 3)||Can be used to archive, delete, draft or discontinue a product, use 0, 1, 2 or 3. - 0 = Archive , 1 = Delete, 2 = Draft, 3 = Discontinued*|
|Display on Cart Page||Cart Page Product (0 or 1)
||Can be used to display the product on the cart pages, use 0 or 1. 1 = True
|Display on Homepage||Homepage Product (0 or 1)
||Can be used to display the product on the homepage, use 0 or 1. 1 = True|
|Product Status||Product Status (0,1,2)
||Can be used to change the status of a product, use:
Disable = 0
Active = 1
Draft = 2
* For more information on discontinued products click here.
Additional Product Details
|Advert Only||Advert Only||
Used to set a product as Advert Only, use 0, 1 or 2.
0 = No (default), 1 = Yes + show price, 2 = Yes + hide price
|CBM||CBM||For reference purposes only.
|Product Condition||Condition||Used to set product condition, use New (default), Used or Refurbished.|
|Item Rate||Item Rate Shipping||Used to set the rate for shipping methods using Item Rate calculation.|
|Feature Group||Product Attribute Group
||Used in conjunction with Product Feature, specifies the group that the feature belongs to.|
|Product Feature||Product Attribute
||Used in conjunction with Feature Group, defines the Feature to be assigned to the product.|
|Cost Price||Product Cost Price
||The product cost price, in Net.
|RRP||Product RRP||The Product Recommended Retail Price|
|Shipping Note||Product Shipping Note||Usually used to display delivery promotions or lead time on a product.|
|Product Variant||Product Variant Grouping||Enter the variant group that you would like to assign the product to.|
|Related Product||Related Product||Enter the product code of the related product, one per row.|
|SEO 1||MPN||Free text field, can be renamed.|
|SEO 2||EAN||Free text field, can be renamed.|
|SEO 3||ISBN||Free text field, can be renamed.|
|SEO 4||UPC||Free text field, can be renamed.|
|Product Tax Rate||Tax Rate||Product tax rate, do not include percentage symbol or use more than 2 decimal places.|
|Weight in Grams||Weight in Grams||Used to specify the weight of the product.|
|Exclude From All Discounts||Exclude From All Discounts||To stop a product from receiving a discount. 0 = No, 1 = Yes
Can also be used with options.
|Collect In Store||Collect In Store||To enable a product for store collection.
0 = No, 1 = Yes, 2 = Store Only
|Short Description||Short Description||Character limit is 125 by default.|
|Main Description||Long Description||Main product description, more descriptions can be added. Column header name will become the description tab name.
|Collection||Collection Name||Can be renamed, used to assign a product to a collection.
|Brands||Brand Name||Can be renamed, used to assign a product to a brand.|
|Extra Search Tags||Extra Search Tags||For website search use, list terms without commas.|