Add/Update/Delete Products Using Mirakl Template Files

Mirakl allows you to import Products using Excel style files which are convenient for bulk adding and updating of products, prices and quantities.

 

How Information is Stored and Used

To better understand how you can import files to Mirakl, it is important to first explain how the information is stored.

Mirakl splits the information into 2 logical groups:

• Product Information
• Offer Information

The Product Information includes all general manufacturer characteristics that a product may have like size, length, color, pictures, EAN Code, SKU, etc.

The Offer Information consists of the details specific to what you are offering as a merchant. Examples are the price, condition (new/used), available stock, packaging size, etc.

This then allows a merchant to create a Product, then connect 1 or more Offers to it. This can be useful if you have purchased the same product in 2 different batches with different prices, so the one offer for the set quantity would appear with price A, while the other offer would have price B.

 

Making New Products Appear on the Jinius Storefront

Add Products

In order to add or update Products using the Mirakl Template file, what you need to do is:

1. Log into Mirakl and go to "Price and stock" → "File imports".
   
   
2. Here click on “Excel Template” in the “Products” section on the right of the screen:
   
   
   

3. Here you need to make sure:

   a) In the first drop-down that “Products” is selected

   b) In the Attributes drop-down, choose which Product Characteristics should be in the template: required, recommend and/or optional
   If you are unsure, select “All”.

   c) Select which Product Categories the products you will be importing will be allocated to.

   d) Press “Generate Template” to download the file to your computer.
   

   Suggestion:

   The Product Characteristics that will be include in the Template File will depend on the Categories you choose. For this reason, it is an idea to Generate a new Template File for each sub-category you want to add, e.g. if this is a clothes shop, one template file for T-Shirts, one for socks, another for trousers, etc.
   This way each file will have only the Characteristics relating to each category and might be more manageable.
   
   

4. After opening the file in Excel, you need to now fill in the Product Information details for all the products you wish to import. A few things to keep in mind are:

   a) In the “Category” column drop-down, choose the category the product in this line should be added to.

   b) “SHOP_SKU” is the unique product code you have given this product. If you have variants of a product, each variant needs a unique SHOP_SKU code.

   c) If there are variations of the product, e.g. exists in multiple sizes and colors, each variant must:

   • Be on it’s own line in the spreadsheet, all the information needs to be the same except for the Characteristics that differ.

   • The “Variant Group Code” value must be the same among the variants as this is what Mirakl uses to "know” what variations of the same product exist and present them nicely on the storefront.

   d) All fields marked in Red need to be filled in as they are mandatory.

   e) Excel sometimes converts long numbers into a scientific format. If this happens, select the column in Excel, right-click, select “Format Cells” and in the “Number” tab, select “Text” and press OK. When you re-write the values, they should now appear correctly.
   
   

5. Once you have filled in all the products you want to import, save the file.
   
   

6. In Mirakl, go to Price and stock → “File imports” and:

   a) Press “Select a file”

   b) Select the file on your computer that you saved in step #5

   c) In the “File Content” drop-down, select “Products”

   d) Set the Import Mode to “Normal”

   e) Press the “Import” button
   
   
   

7. At this point Mirakl will check the file for errors. To see if any errors were found, go to "Price and stock" → “File imports” → Track Product Imports. Here you will see all the files you have imported and if there were any errors, you will see a notification in the “Errors” column as shown below.
   This allows you to download a report describing what the error is.
   Correct any errors you find in the file you added your Products in step #4 and repeat steps 5-7.
   
   
   
8. If no errors are reported, the products will be shown in "Catalog Manager" in status “Pending”. Once the Jinius Team reviews and approves the products, their status will change to “Published” and you can then add Offers for your products, which is described in the next section.
   Important: You must wait until a product is in status “Published” before creating an Offer for it, otherwise the offer creation will fail.
   
   

Add Offers

Now that we have Products added, we can also add Offers for those products. The process is very similar to the way you add products:

1. Log into Mirakl and go to "Price and stock" → “File imports”
   
   
2. Here click on “Excel Template” in the “Offers” section on the right of the screen.
   a) Here you need make sure that “Offers” is selected in the drop-down.
   b) Press “Generate Template” to download the file to your computer.
   
   
   

3. Open the file in Excel and fill in the Offer Information details for the products you want to appear on the Storefront:

   a) All fields marked in Red need to be filled in as they are mandatory

   b) In order for a product to appear on the Storefront, it needs to have a Price and a Quantity above 1.

   c) Logistic Class depends on the size of the product of this offer and affects shipping costs.

   d) Excel sometimes converts long numbers into a scientific format. If this happens, select the column in Excel, right-click, select “Format Cells” and in the “Number” tab, select “Text” and press OK. When you re-write the values, they should now appear correctly.
   
   

4. Before saving the file, you need to associate each Offer with the correct Product. This is done by giving each Offer a unique code that corresponds to a Product. The unique codes each Product has are “SHOP_SKU”, “SKU” and “EAN” codes. To make this association:

   a) In the “Product ID Type” column select the Field you will be matching.

   b) In the “Product ID” column write the value of that field of the Product.

   Example, if you want to associate you Offers using the “SHOP_SKU”, in the “Product ID Type” select the “SHOP_SKU”, and in the “Product ID” column write the value of the corresponding Product as shown below:
   
   
   You can of course use the EAN or SKU codes instead in the same way.
   
   Important Note!
   VAT by default is set to 19%. If you have products that fall under a different VAT bracket, select the VAT for those products in the column "vat-percentage":
   
   
   

5. Once you have filled in all the Offers you want to add, save the file.
   
   

6. In Mirakl, go to "Price and stock" → “File imports” and:

   a) Press “Select a file”

   b) Select the file on your computer that you saved in step #5

   c) In the “File Content” drop-down, select “Offers”

   d) Set the Import Mode to “Normal”

   e) Press the “Import” button
   
   
   

7. At this point Mirakl will check the file for errors. To see if any errors were found, go to "Price and stock" → “File imports” → Track Offer Imports. Here you will see all the files you have imported and if there were any errors, you will see a notification in the “Errors” column.
   
   

8. If no errors are reported, the products will be shown in "Price and stock" → Offers, and shortly the Jinius Storefront will also be updated to reflect your new Offers.

 

Add Products and Offers at the Same Time

Instead of adding your Products in one file, then the Offers in a second file, you also have the option to add both at the same time. The process and information required is the same, the only thing that changes is the file template that you use:

1. Log into Mirakl and go to Price and stock → File imports.
   
   
2. Here click on “Excel Template” in the “Products and offers” section on the right of the screen:
   
   
   

3. Here you need make sure:

   a) In the first drop-down that “Products and Offers” is selected

   b) In the Attributes drop-down, choose which Product Characteristics should be in the template: required, recommend and/or optional
   If you are unsure, select “All”.

   c) Select which Product Categories the products you will be importing will be allocated to.

   d) Press “Generate Template” to download the file to your computer.
   
   

4. The file you download requires the exact same information described in sections “Add Products” and “Add Offers”, with the only difference that for each line in the Template File, you need to add both the Product Information and the Offer Information.
   For details on how to fill the fields in, refer to the other 2 sections mentioned.
   
   

5. Once you have saved the file, in Mirakl, go to "Price and stock" → “File imports” and:

   a) Press “Select a file”

   b) Select the file on your computer that you saved in step #5

   c) In the “File Content” drop-down, select “Products AND offers”

   d) Set the Import Mode to “Normal”

   e) Press the “Import” button
   
   

6. At this point Mirakl will check the file for errors. To see if any errors were found, go to "Price and stock" → “File imports” → Track Offer Imports. Here you will see all the files you have imported and if there were any errors, you will see a notification in the “Errors” column.
   
   

7. If no errors are reported, the products will be shown in "Price and stock" → Catalog Manager and the offers "Price and stock" → Offers List in the “Pending Offers” section, until they are reviewed and approved by the Jinius Team.
   
   

8. Now you need to wait until the products change to the “Published” status. This means that they have been approved. Once this happens, double-check that all products that you imported have offers (Quantity and price) associated with them.
   If there are any missing, simply re-import the file so that the remaining Offers are added.

 

Updating Existing Product and Offer Information

After you have imported your products and offers into Mirakl, you will eventually need to update your listings with new stock availability, price changes, correcting or adding description or product names, etc.

The way this is done is by uploading a new file with the exact same process as if you were adding a new Product of Offer as described in sections:

• Add Products
• Add Offers
• Add Products and Offers at the Same Time

The only thing that you must ensure is that the “SHOP_SKU” and “EAN” in the new file codes match the existing codes of the products/offers that already exist.

Mirakl will match these values in the new file with existing products and if it finds a match, it will update the values.

Important! If you do not use the same unique “SHOP_SKU” and “EAN” codes, instead of updating the existing products, new products will be created instead.

 

Deleting Existing Offer Information

Once a Product has been imported into Mirakl, it cannot be removed, but what can of course be done is to de-list it from the Jinius Storefront. The logic behind this is that you might want to re-add an Offer for a Product in the future.

To de-list a Product from the Storefront using a File Template is very similar to how you add a new Offer as described in sections, so for more details refer to them:

• Add Offers
• Add Products and Offers at the Same Time

The process is:

1. Download the “Offer” or “Product AND Offer” template file as described in the sections above.
   
   
2. As you will only be deleting Offers, the only columns you need to fill in are:
   a) “Offer SKU”: the unique Offer codes that you want to be deleted
   b) “Offer State”: the offer state of the original offer (new/used)
   c) “Update/Delete”: from the drop-down select the value ‘DELETE’
   
   
3. Save the file and import it as described in the section above. What Mirakl will now do is match the “Offer SKU” in your file with existing Offers and perform the action you instructed it do, which is “DELETE”.