Catalogue import - Creation by file

• Click on My Stock > Import by file
• Click on "Configure and download an Excel file template in operator format". 
• Select "Products" for the desired file type
• Select "All" for the attribute level
• Select the sub-categories you are interested in for your products
• Click on Generate Template. The template file appears at the top of the page and you can download it. 

Once you have downloaded the import template file, fill it in with as much information as possible. 

Please note that each line corresponds to a reference of your catalog (e.g.: to import a t-shirt 5 sizes, you will have to fill 5 lines). 

Instructions for Product Features : 

• Category: select the desired category from the drop-down menu.
• Vendor SKU (Stock Keeping Unit): unique reference of a product from a particular vendor, with a given price. It must be unique for each reference.  
• Brand: If the brand does not appear in the list, please contact your Account Manager or ask support. 
• Images: to be inserted in url and jpg format (e.g.: https://media.alltricks.com/hd/56558cc4080e7.jpg), with a maximum weight of 10Mb. To import more than 3 images, please contact your Account Manager or ask support. 
• PDF manual: do not fill in (functionality not available).
• EAN: official identifier, must contain 13 digits. If you are a seller/distributor, please fill in the official EAN of the product.  
• Grouping attribute: to group products with a size variation (see next slide for more information).
• Main Image Key/Image 2 Key/Image 3 Key: do not fill in
• SP2_Sport : fill in the type of sport concerned. Mandatory to correctly categorize your products on the site.
• Attributes beginning with "SP4" (if any): must be filled in to correctly categorize your products on the site.
• Other columns (e.g. Cyclist Size): fill in as many attributes as possible using the drop-down menu when it appears.  

Product variants are variants on size. The products are grouped together with the same variant code (VGC: Variant Group Code). 

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

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

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

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. 

Click on My Stock > Import by file

Click on Open the configuration wizard. The goal is to perform a mapping between Alltricks categories and your product categories. There are 7 steps to this mapping process. You must repeat this process for any new product category you wish to import that has not yet been mapped.

Select the product import file and click on Send

Click on Next Step

Product flow mapping: Categorization

Click on Product Flow Mapping > Categorization

Check that your products have been imported with the correct information (especially for the EAN format)

At the bottom of the page, select the column corresponding to the category of your product

Click on Product Flow Mapping > Category Mapping

- Clicking on the "+" will open the sub-category of each category. Each sub-category must be mapped to the Operator's sub-categories. Categories with identical names can be automatically mapped by clicking on the mapping icon.  For the others, you will have to do it manually by dragging the categories from your catalog (on the left) to those of the Operator (on the right). 

- Once a category is mapped, it turns gray. To change the mapping, click on Remaining Mapping and then click on the cross next to the category you want to change. 

- Click on Next Step. 

By clicking on the arrows, you trigger an auto-mapping of your categories. All categories with identical names are recognized and mapped automatically. A window opens with proposals, validate them and click on Confirm

Drag and drop the remaining categories in your catalog (left) to the corresponding categories in the Operator (right)

Attribute Mapping 

Click on Product Flow Mapping : Attribute Mapping

Your attributes must match those of the Operator. 

-All attributes in red are mandatory to import your product catalog. 

-As for the categories, the attributes with the same names can be mapped automatically by clicking on the mapping icon. For the others, you have to do it manually by dragging the attributes from your catalog (left) to those of the Operator (right) 

Use the search bar to easily find your attributes

For more information on the Operator's requests, hover over the attribute and an explanatory window will appear. 

By clicking on Automatically map, a window opens and you can validate each step

Values Mapping

Click on Product Flow Mapping : Value Mapping

In the same way as for attributes, values with the same names can be mapped automatically using the Mapping icon. For the others, you have to do it manually by dragging the values from your catalog (left) to those of the Operator (right) 

The list of Brand values is predefined and it is possible that one of your brands is not registered. In this case, please send an email to your Account Manager. Specify in the subject line "New brand to be created" and insert the list of brands to be created, with the corresponding logos.

Definition of the rules

You can transform or validate the content of your attributes on this step. 

Example: Add automatically a capital letter at the beginning of each sentence for the attribute "Description" : Transformations > Capital letter at the beginning of the sentence

Assessment and validation

Click on Product Flow Mapping : Assessment and validation

Finally, before importing the catalog, you can check that the information has been correctly imported at each step. 

If some categories, attributes or values are rejected, you will have to start the mapping process again. To do this, simply click on Previous Step or a specific step in the process on the left. 

Controlling your imports

Click on: My Stock > Import by file > Follow up on product imports

You can easily control your product imports from your store. You can also download the error report to understand how to modify your product imports. 

Import of subsequent products

The previous mapping process only needs to be done once to map the format of your Product file to the Operator's file. 

For other product imports of the same categories, you can upload your files directly (with the initial Mirakl import template) by going to: My Stock > Import by file

1 - Select Products in File content and select Normal for Import mode

2 - To import the file on the Marketplace, click on Choose the file

3 - Then click on Import to validate the import

Important: if you add new product categories, which have not been mapped yet, or new attribute values, you will have to do a new mapping with these new data.