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 with another variant |
SKU in the spreadsheet cannot be already associated with 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, the 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. |
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 the Option 3 Value column without defining a label in the Option 3 Label column, then this error will be surfaced. |
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 that are marked to be published to the 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. |
PG::UniqueViolation: ERROR: duplicate key value violates unique constraint "products_pkey" DETAIL: Key (id)=(1929587) already exists. |
It 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. |
File too large |
This error occurs when your spreadsheet has more than 10,000 rows. To fix this, please split your spreadsheet into multiple .csv files, each with less than 10,000 rows. For an optimal upload experience, we recommend uploading .csv files in batches with 5,000 rows or less. |