How do I import my products by file?

1) Fill in the product import file:

2) Save the file in the correct import format:

3) Import the Products file :

Requirements

To import your file, please follow this process:   

1 - Save the import file in CSV UTF-8 format. The file must be encoded in UTF-8. This allows titles and descriptions to appear correctly. Once this is done, please close the file and re-open it in this format. It will appear in CSV UTF-8 format. Keep the file open on your desktop throughout the process.

2 - Delete the 2nd line of the file

3 - Format of the EAN field:

NB: Excel changes your EAN code to scientific format because it recognizes it as a number.  

Ex: 5465476546546 will be condensed into 5.46548E+12.

This will corrupt the data and prevent the creation of your product. 

The solution is as follows: 

-Select the column with the EAN

-Right click and select the Format menu

-On the Number tab, choose Custom

-Delete the numbers entered in Type

-Type the number 0 thirteen times in a row

4 - Save the file. 

Variants:

Product variants are size variants. Products are grouped together using the same variant code (called VGC: Variant Group Code or Grouping Attribute). 

In the file, use the Grouping Attribute column to group identical products of different sizes.  

We only group products by size, not by color. To group variants, products must have exactly the same characteristics (e.g. same color, same bike handlebar, handlebar...) and differ only in size. 

The attribute value chosen must be unique and specific to the products grouped together.

Find out more in the dedicated article

Example of an Import Products file for City Bikes :