English (US) 简体中文
search shadow

Menu

Articles in this section

CSV Uploading Errors

Here you can find typical errors and issues that can occur while uploading CSV files.

Errors Report

Errors Report is a report that is automatically sent to your merchant panel "Uploads" page 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:

mceclip0.png

1 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.

Please note: A Row number is indicated without a Header string. 

For example:

  1. If you haven’t got a Header string in your file, so a Record 4 in a Report will be an actual Record 4 in your file,
  2. If you have a Header string in your file, so a Record 4 in a Report will be a Record 5 (Row 5).

 

2 Error transcript

You will also find the information on how to fix your occurred error. 

Please note:

  1. 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 variants of this product, find and change a product variant (row) where the error occurred,
  2. If there is an error in one of the product variants, the product will be uploaded without problematic variants,
  3. If there is an error in several products (but not all of them), the products without errors will be uploaded successfully. So the problematic products should be fixed and uploaded to the platform again.

 

Possible Errors

Ⓧ SKU is required 

This error appears when:

  1. You forget to fill in the required SKU column. ⟶ So, you should just to fill it in,
  2. The SKU column has an invalid name. ⟶ Please change the name of the SKU column,
  3. 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.

Please note:

Main Image URL

Product Name

Description 

=

These attributes should be the same for all the variants of 1 product.

Screenshot_2020-03-24_at_09.37.41.png Tips: 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.

Ⓧ Product SKU: found the same variant 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.

Please note: 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.

Please note: 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!

Was this article helpful?
0 out of 2 found this helpful
Return to top

Related articles

Comments

0 comments

Please sign in to leave a comment.