Here you can find typical errors and issues that can occur while uploading CSV files.
Errors Report is a report that is automatically sent to your email once you try to upload a CSV file in your account. There you can find a list of mistakes you made in a CSV.
Errors Report looks like this:
➀ The Row number where you have made a mistake:
In your errors report the Row number where you've made a mistake is called a Record Number.
A Row number is indicated without a Header string.
1) If you haven’t got a Header string in your file, so a Record 171 in a Report will be an actual Record 171 in your file,
2) If you have a Header string in your file, so a Record 171 in a Report will be a Record 172 (Row 172).
➁ Error transcript
You will also find the information on how to fix your occurred error.
▲ Only a problematic product will be indicated in a report, not his variant. If you have an error in a product variant, check carefully all the product variants, find and change a product (row) where the error occurred,
▲ If there is an error in one of the product variants, the product will be uploaded without problematic variants,
▲ If there is an error in several products (but not all of them), the products without errors will be downloaded successfully. So the problematic products should be fixed and uploaded to the platform again.
Ⓧ SKU is required
This error appears when:
- You forget to fill in the required SKU column. ⟶ So, you should just to fill it in,
- The SKU column has an invalid name. ⟶ Please change the name of the SKU column,
- You used a wrong delimiter in your CSV file. ⟶ Please use commas as delimiters.
Please check delimiters while you are saving a file.
Our platform accepts only the following delimiters: Comma, Semicolon, and Tab.
Ⓧ Product main image / Product name / Description redefined in variant
This error appears when you fill in the fields Product main image / Product name / Description differently for different variants of one product.
Main Image URL
These attributes should be the same for all the variants of 1 product.
If your product has a lot of variants fill in all the information for them in the first row. Leave blank all the fields with common product attributes for other product variants.
Ⓧ Duplicate SKU
This error occurs if a product variant SKU has been duplicated in a file or you already have a product with this SKU. ⟶ Change a product variant SKU so that it will be unique.
SKU — is a unique identifier for a product variant. Therefore, it must belong to one product variant only and cannot be duplicated.
Ⓧ Fpdec.Invalid format...
This error occurs if the value of some product field has the wrong format. E.g., if a comma was used as the decimal delimiter: Fpdec.Invalid format: 9,99 ⟶ Use dots instead of a comma.
You must use a dot as a delimiter for decimals. Numbers indicated with comma are perceived as text by our system.
Ⓧ Product SKU 'xxx': could not find product to update
This error occurs while adding new products via CSV. ⟶ Just indicate the Store ID.
Ⓧ GTIN is invalid
Excel often changes the format of long GTIN numbers into scientific ones. E.g.: 8,0527E+12 instead of 8052700000000. ⟶ All you need is to change the scientific format into the number format.
If you have some difficulties uploading a CSV file, please, write to our Merchant Support Team who will be happy to help you!