How do I fill in and import my offer file?

The offer file lets you create and update several offers in a single operation in Mirakl. This article explains how to download the template, fill in the columns, secure the format of your EAN codes and import the file into Mirakl.

Before you start

• Access to your Mirakl Alltricks back office
• A spreadsheet tool able to save in CSV UTF-8 format
• Your product listings already created, validated and published

Download the Mirakl offer file template

The offer file template is downloaded from your Mirakl back office. Download the correct import template before entering any data: the column headers of the template determine how Mirakl reads the file.

Fill in the columns of the offer file

Once you have the Mirakl template, all you have to do is complete it. Here are the instructions for the Offer import file:

• SKU Offre (Stock Keeping Unit): unique reference of a product for a given seller and a given price. It must be unique for each reference.
• ID Produit: fill in the EAN of the product, which must contain 13 digits.
• Product ID type: write "EAN".
• Prix Offre: the selling price in euros (€), VAT included. It must use the Number format.
• Quantité Offre: the quantity available in stock.
• Alerte quantité minimum: minimum stock quantity threshold that triggers an email alert. No alert is sent if this cell is left empty.
• Famille logistique: the name of the logistic class linked to the shipping fees (Petits, Grands, Perso 1...). The "Petits" family is selected by default if the cell is empty.
• Délai d'expédition: number of working days needed to ship the offer.
• Prix public conseillé: please note that this price is displayed on our website, and must therefore be valid with regard to regulatory requirements.

The Logistic class column determines which shipping fee grid applies to the offer. Two values cover almost every case:

Secure the format of your EAN codes

The solution is as follows:

1. Select the column containing the EAN codes.
2. Right-click and select the Format menu.
3. On the Number tab, choose Custom.
4. Delete the digits filled in under Type.
5. Type the digit 0 thirteen times in a row.
6. Save the file.

If your EAN codes do not contain 13 digits, follow this process:

1. Save the Offer 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, close the file and reopen it in that format. It will appear in CSV UTF-8 format. Keep the file open on your desktop throughout the process.
2. Delete the 1st row of the file.
3. Apply to the EAN column the custom format with thirteen zeros described in the EAN field format procedure.
4. Replace "Neuf" in the Etat Offre column with "11".
5. Prices: decimals must be separated by a dot.

Import the offer file into Mirakl

Once the file is completed and saved in the correct format, import it from your Mirakl back office.

In short

• Download the offer file template from Mirakl before entering your data.
• Make sure the product is Validated and Published before pushing the offer.
• Fill in the SKU Offre, the ID Produit as a 13-digit EAN, the price and the quantity.
• Format the EAN column as custom with thirteen zeros to avoid scientific notation.
• Save in CSV UTF-8, then import the file into Mirakl.

Learn more

• How do I check my offers?
• How do I set up my prices and my strike-through prices?
• How do I fill in and import my product import file?