Product Creation: How do I fill in my import 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 these steps:

1 - Save the import file in CSV UTF-8 format. The file must be encoded in UTF-8. This ensures that titles and descriptions appear correctly. Once this is done, please close the file and reopen 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 second line of the file

3 - EAN field format:

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

E.g.: 5465476546546 will be condensed to 5.46548E+12.

This will corrupt the data and prevent your product from being created. 

The solution is as follows: 

•Select the column with the EANs.

•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.

The Variants:

Product variants are variants based on size. 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 with different sizes.  

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

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

Find out more in the dedicated article: https://alltricks-support.freshdesk.com/support/solutions/articles/101000461729-all-about-the-variant-group-code-english-subtitles-

Example of a Product Import file for City Bikes: (attached)