What are import errors?
On Mirakl, an import error refers to an issue that occurs during the import of product or offer data into the Mirakl platform. Import errors can be caused by various reasons such as incorrect file format, missing required fields, invalid values, or conflicts with existing data. Mirakl provides an error report that details the nature of the errors encountered during the import process, allowing the user to identify and resolve the issues before reattempting the import.
What are error reports?
On Mirakl, an error report is a document that contains information on the errors encountered during the import process of product or offer data. The report lists the errors by type, such as missing or invalid required fields, formatting errors, or conflicts with existing data. The report provides details on the specific error, including the row number of the error and a description of the issue encountered. The error report allows the user to quickly identify and address the errors, improving the efficiency and accuracy of the data import process.
They may arise during various stages of the import process:
- To check for such errors, click on the icon under the "Errors" column to download the errors report
- To check the "Process details", click on the (i) icon
The offer import process may result in the following statuses: waiting for product creation - pending - being processed - failed - import complete.
Most common offer file import errors
The following are the specifications of the most common errors, along with tips on what to do if you encounter them in your import error report:
Error message | Description - Cause / Solution |
The product linked to the new offer is different from the product linked to the existing offer. |
You are trying to change the product linked to an existing offer. Solution:
|
The product linked to the new offer is different from the product linked to an old offer which has the same shop id. |
You are trying to create an offer using the ID of a deleted offer. The new offer is linked to a different product than the product the deleted offer was linked to. There is a waiting period defined by the operator before you can create the new offer. Solution:
|
The product does not exist. |
In your file, you must indicate the "product-id" and "product-id-type" to match your offers with the product. If you got this error message, it is because no product with this identifier exists in Mirakl. Solution:
|
This import type does not allow the use of the 'update-delete' column. |
You cannot use the "update-delete" column with the current import mode. Solution: use the "NORMAL" import mode to use the "update-delete" column in your file |
No existing offer to update. |
You are either:
Solution:
|
The state of the product is unknown. |
The product state you entered does not exist. Solution:
|
The field "{0}" is mandatory. |
The value of a mandatory offer field is missing. This information is mandatory to create an offer. Solution: check if each of your mandatory offer fields have a value |
The 'price' field is mandatory. |
If you got this error message, you are in one of the following cases:
This information is mandatory to create an offer. Solution: check if you have added this field, that it is properly written and has a value |
The 'sku' field is duplicated in the source file. |
The sku already exists in the file. Solution: You cannot duplicate a sku in the file |
The logistic family is unknown. |
The logistic family you entered does not exist. Solution: Specify an existing logistic family |
The available date range is incorrect. |
The correct format of each date is "yyyy-mm-dd". Solution: Check if the date format is "yyyy-mm-dd" and the start date is prior or identical to the end date |
The discount date range is incorrect. |
The correct format of each date is "yyyy-mm-dd". Solution: check if the date format is "yyyy-mm-dd" and the start date is prior or identical to the end date |
The discount price is incorrect: must not be null or must be lower than price. |
You cannot specify a discount price equal or greater than the original offer price. Solution:
|
This product is not available for sale. |
The operator has temporarily or definitively decided not to sell this product. Solution: Contact your operator |
The 'price' field has an invalid range. |
The price of your offer is lower or greater than the limit price set by the operator. Solution:
|
The 'discount_price' field has an invalid range. |
The discount price of your offer is lower or greater than the limit price set by the operator. Solution:
|
The mandatory additional field is missing. |
The mandatory additional field set by the operator is missing in your file. Solution: Call API AF01 to get the list of available additional fields |
The 'leadtime-to-ship' field has an invalid value. The value must be a positive integer and must not exceed the limit defined by the operator. |
The "leadtime-to-ship" field value is incorrect. Solution:
|
The 'product-id' field is mandatory when 'product-id-type' is filled. |
The "product-id" and "product-id-type" fields are linked together and cannot be separated. The "product-id-type" is used to know the type of the product reference you filled in the "product-id" field. |