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


Field Maps to Description
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


Field Maps to Description
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


Field Maps to Description
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


Field Maps to Description
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


Product Descriptions


Field Maps to Description
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.


Other Information


Field Maps to Description
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.