Import & Export Products

Instead of manually adding products to your online shop, this feature allows you to import your products to the shop by using a simple Excel (.XLSX) file. Additionally, it is also possible to export your complete product inventory. 

 

1. Where to find Import & Export Products?

It is possible to find the Import & Export button on the top of the Products menu, under the Shop tab of the editor.

 

2. Using Import & Export

By clicking on the button a new menu will cover the main area of the editor.

 

2.1. Importing products

To import your product(s), drag your XLSX file to the highlighted area or select it from your computer by clicking on Add XLSX File

Advanced vs. simplified product import

If you tick the box Enable simplified product import, the Editor will generate a simple XLSX file when you click on Show XLSX file example. This file only contains the most relevant product information and helps you upload products quicker by inputting just a name, description, price and image (optional). Read more about the simplified product import file here

If the box Enable simplified product import is not ticked, the Editor will generate the advanced XLSX file (described below).

Keep in mind that when you import products using the simplified XSLX file, Enable simplified product import must be ticked in order for the Editor to be able to read the file correctly. The box should be unticked if your are uploading an advanced file. 


2.2. Exporting all your existing products

Click on Generate XLSX file to generate a file with your current product list.


 

2.3. Show XLSX file example

To retrieve a template XLSX file for you to fill in, download the file provided by clicking on the link on the bottom of the section. 


2.3.1. Product ID 

After opening the XLSX file in Excel, the first column you will find is the Product ID. This ID refers to the group of variants of a specific product. For example, if you are selling a t-shirt in multiple colors, all variants must have the same Product ID, otherwise the editor would create individual products for each color.


2.3.2. Active

The second column refers to the visibility of the product. Simply type down 1 in case you want to make your product visible on the catalog or 0 if you wish for it to be hidden. Please note that if this field is left blank, the products will be hidden and you'll have to manually make them visible.


2.3.3. SKU

In the SKU column you can add a Stock Keep Unit if you wish to do so.


2.3.4. Option Identity

The Option Identity refers to a unique number associated with each product. When you first create the product, you can leave it blank however this field is extremely useful if in the future you wish to modify your product variants through a XLSX file without adding them again.


2.3.5. Tags

In the tags column you should add all the relevant tags to each variant. Don't forget to separate them by using a semicolon.


2.3.6. Quantity

In the quantity column simply add the available number of products for sale.


2.3.7. Images

To attach an image to your product and variants, all you must do is type down the complete name of the image file you want to display - including the file extension, e.g imagename.jpg. The editor will automatically associate an image with the same name from the File Manager. This means you must manually upload the relevant images to your File Manager before importing your products. In case you wish to upload more than one picture for each variant don't forget to separate the image names by using a semicolon.


2.3.8. Shipping Details

In the following columns you can add shipping details for each product variant - it is possible to set the shipping weight, which should be added in grams; as well as height, length and depth, which should be added in centimetres.


2.3.9. Product Name, Description & SEO

In these columns you must add a name and description for your product, as well as a title, description and keywords for SEO purposes. In case your website supports different languages, you will need to fill in the field for each of the languages.


2.3.10. Attribute Label & Value

The attribute labels refer to your Variation Labels. If you sell t-shirts that varies in size and color, these should be your labels. In the values you should type down the variant options – in this case, let’s say the t-shirt is sold in Small, Medium and Large and in the colors Red, Yellow and Blue, you must add all nine combinations. If you haven’t previously defined variation labels or options, the editor will automatically add them once you have uploaded the file. In case your product has no variants, leave both fields blank.


2.3.11. Price

Finally, in the last column you should add the price for your products. Again, if your website supports different currencies, you must add the price in each currency. Note that prices should be entered excluding tax/VAT.


2.3.12. Overview

Fully completed, your XLSX file should look something like the image below. You can see each line represents a variant, but all under the same product, indicated by the Product ID. When imported, the editor would simply import one single product with all 9 variants. It is possible to add as many products and variants as you wish.

 

Anything we’ve not covered?

Contact Us