We have put together a list of the most common error messages and what you can do to fix them so that the upload will be successful.
Common errors experienced with all CSV import functions:
| Error | How can I fix this error? |
| Unquoted fields do not allow \r or \n (line ###) | Save the CSV file using the UTF-8 format. More information can be found in this article. |
| Illegal Quoting in line ### | Save the CSV file using the UTF-8 format. More information can be found in this article. |
| You can have only one CSV import running at a time | You tried to upload the CSV file multiple times while a previous upload was loading. The upload was stopped this time as the previous upload is still running. Wait a few minutes and try again. |
Common Errors specific to both Bulk Product Import and Update functions:
|
Error |
How can I fix this error? |
|
There are variants with missing SKU |
SKU is required for all variants. To learn more about SKUs, click here. |
|
SKU must be unique to each variant |
Each SKU and variant must have a 1:1 relationship. For example, if "SHIRT-RED-S" is already used for one variant, you cannot associate this with another variant. This is to ensure that the system recognizes that particular variant, according to its SKU. |
|
The SKU specified is already associated to another variant |
SKU in the spreadsheet cannot be already associated to another existing variant within TradeGecko. |
|
There are repeated Options |
A product cannot have two of the same option label (for example, Size can only be used once within the same product, so if Size is used as option 1 label it cannot be used as option 2 label) |
|
Options must be unique to each variant within a product |
Within the same option, option value cannot be repeated. (for example, under option label Size, if Medium has been used in one row, it cannot be used again in a different row) |
|
Missing Initial Cost Price |
Initial Cost Price is required for all variants, for accounting purposes. To learn more about Initial Cost Price, click here. |
|
There are Options Values that do not belong to any Option Label |
This is because there is an option value defined without an option label. For example, if we write "Small" in Option 3 Value column without defining a label in Option 3 Label column, then we will get this error. |
|
Invalid Weight Unit |
The accepted weight units for TradeGecko are: g, kg, lb, oz (ex: 10kg) |
|
Invalid Volume Unit |
The accepted volume units for TradeGecko is ml (ex: "10ml") |
|
There are non-sellable variants which are marked to be published to B2B store |
Variants that are marked not sellable (sellable = False in the CSV file) cannot also be marked to be published to any e-commerce channel (published = true in the CSV file). |
|
Invalid Initial Cost Price |
Initial Cost Price cannot be 0 or negative. For more details, click here. |
|
PG::UniqueViolation: ERROR: duplicate key value violates unique constraint "products_pkey" DETAIL: Key (id)=(1929587) already exists. |
Does not happen often. Try uploading again. |
|
invalid_variant_id: |
The Variant does not exist. Create a new variant. |
|
invalid_product_id: |
The Product does not exist. Create a new product. |
|
unmatch_sku_variant_id: |
SKU exists for another Variant. Ensure your SKUs are unique. |
Print 
PDF
Problems I'm encountering:
All the individual SKU's and barcodes are unique.
Hi Leon,
When importing your inventory CSV to TradeGecko, there's an Excel bug that treats the barcode column as numbers so it strips any leading zeros (when the CSV is exported out)
Example 1: 000000000845 would be converted to 845
Example 2: Some versions of Excel export barcode such as 1000000000 as 1e14
There are also instances where the barcode numbers are embedded with comma delimiters. Moving forward, we are working on improving the improper formatting that's being added by Excel here.
For a workaround: Before exporting the CSV from Excel, make sure that the barcode column data type is String.
If you have any more questions feel free to contact us at support@tradegecko.com
I have imported the inventory CSV, worked fine, but the Average Unit Cost was wrong (my input error). It doesn't seem I can manually change it, nor reload new cvs file over existing SKUs?