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.
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.
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.
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.
In the tags column you should add all the relevant tags to each variant. Don't forget to separate them by using a semicolon.
In the quantity column simply add the available number of products for sale.
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.
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.
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.