You can import and export products by clicking Import/export in the shop admin panel menu.
Import template
- a minimal template file
- a template file including all optional columns
Both these templates can be found attached below.
Product codes
The import and export functions will only affect products with codes. If you have products without codes and want them to be included in the import and export, you can either edit the products to give them product codes of your choosing, or click Create product codes. After clicking Create product codes each product will be assigned a code of the form PRODUCT-n, where n is a number.
Exporting products
To export your existing products, click Export products. If there are no products in your shop this will produce a minimal template file that you can use. Alternatively, download one of the template files:
Editing the product file
If you are using Microsoft Excel, please read the note on the Import/export help page.
The product file consists of a row of column headers, followed by a row for each product. Some columns are optional, while others may occur multiple times, as detailed below. The columns, which correspond to the fields on the product editing page, are:
Code
The code for the product.
Category code [may occur multiple times]
The code of the category for the product.
Name
The name of the product.
Summary [optional]
The summary of the product.
Description
The description of the product.
Main image
The name of the main image file for the product. Images can be uploaded by clicking Manage images on the Import/export page. The special value Keep can be used to keep the existing main image for the product.
Image 2, Image 3, Image 4, Image 5, Image 6, Image 7, Image 8 [all optional]
The names of other image files for the product. The special value Keep can be used to keep an existing image for the product. If the cell is left blank, any existing image in this position will be removed.
Units (singular), Units (plural) [both optional]
The product units. Leave the cell blank if the product does not have units.
SEO title
The SEO title for the product. If the cell is left blank, the product name will be used.
SEO description
The SEO description for the product. If the cell is left blank, the product description will be used.
Download after purchase [optional]
The name of a file that can be downloaded after purchase for the product. Files can be uploaded by clicking Manage files on the Import/export page. The special value Keep can be used to keep the existing files for the product. If the cell is left blank, any existing file will be removed.
Status [optional]
The product status. Set to Available to let customers purchase the product. Set to Not available to let customers see the product but not purchase it — the Add to basket button will be replaced with a notice explaining that the product is not available. Set to Not shown to hide the product entirely — this is useful for seasonal products which are only available at certain times of year. If this column is omitted, all products are set to be Available.
Stock control [optional]
Yes to enable stock control for the product, and No otherwise.
Stock notification level [optional]
The stock notification level for the product.
Stock variant group [optional; may occur multiple times]
A variant group that has separate stock levels.
Current stock [optional]
The current stock level for the product. This column should be left blank for products with variants that have separate stock levels; the stock file should be used instead.
Tax
The tax for the product. Unless you have changed the tax names, the tax must be one of the following:
- Standard VAT
- Reduced VAT
- Zero VAT
- Exempt
Price
The per-item price of the product. Prices are entered as they will be displayed — including or excluding tax depending on the option chosen in the basket and checkout configuration.
Price break quantity [optional; may occur multiple times]
The quantity at which the price break in the following column takes effect.
Price break price [must occur after each Price break quantity column]
The per-item price that takes effect at the quantity in the preceding column.
Previous price [optional]
The previous price of the product.
Delivery weight [optional]
The delivery weight for the product.
Variant group [optional; may occur multiple times]
The variant group of type list that the variant in the following column belongs to.
Variant [must occur after each Variant group column]
The variant, which must belong to the group in the preceding column.
Variant price [must occur after each Variant column]
The price difference for the variant in the preceding column.
Variant weight [must occur after each Variant price column]
The weight difference for the variant in the preceding column.
Text variant group [optional; may occur multiple times]
A variant group of type text field to enable for this product.
Brand [optional]
The brand name, if available (for example, Lego).
GTIN [optional]
The Global Trade Item Number of the product, if available. This can be an ISBN (for books), EAN (Europe), JAN (Japan), UTC (North America), or ITF-14 (for multipacks). Enter just the digits of the GTIN, without any extra punctuation.
MPN [optional]
The Manufacturer Part Number assigned by the product’s manufacturer, if available (for example, ABC-123).
Related product [optional; may occur multiple times]
The code of a product to show in a related products section on the product’s page.
Importing products
Before importing your product file, ensure that all categories and variants referenced in the file have been created. To import your product file, use the File field to select the file, choose an action using the Action field, and click Import products. There are three actions available:
Create and update
This action will create new products and update existing products. If a product in your shop is missing from the uploaded file then it will not be changed.
Create, update, and delete
This action will create new products and update existing products. If a product in your shop is missing from the uploaded file then it will be deleted, as long as it has a product code — products without codes are ignored by the import and export functions.
Check import file only
This action will check that the import file is in the correct format and report any problems. It will not make any changes to the shop.
