Wix Stores: Understanding Product Import Error Messages
6 min
In this article
- Error message example
- Error messages and solutions
- What's next?
When importing products to Wix Stores, you may encounter some errors. This article will help you understand what these message mean and explain how to update your CSV file so you can import all your products successfully.
Error message example
After importing, you'll see an overview showing the number of products imported successfully, and the ones that failed to import. You can click Generate Error CVS to download an error list.
Important:
Only the Product row is indicated in the error report. In other words, if row 5 is a product row and rows 6 to 13 are the variants and media belonging to that product, the errors are all listed as 'row 5'.
Use the tables below to understand the error messages and learn how to fix them.
Error message | What it means & how to correct |
|---|---|
Schema contains too many columns, up to 100 are allowed | You added more than 100 extra columns. Remove all extra columns. |
Missing required fields in schema | Required columns were removed. Re-add the missing columns or download a new template and make sure not to delete columns before importing. |
Requested inventory quantity must be non-negative | In inventory columns, levels must be positive numbers. |
Missing name and type for modifier. When modifier ID is not provided, it must include a name and type | ModifierName and ModifierType columns are missing information. Add a name to each modifier. Add a type to each modifier type column (can be SWATCH_CHOICES, TEXT_CHOICES, or FREE_TEXT). |
Missing name and type for modifier choice. When choice ID is not provided, it must include a name and type | If you entered data for a product in the modifierDescription column, you must also enter data in the modifierName and modifierType columns. |
Missing option name and type. When option ID is not provided, it must include a name and type | If you entered data for a product in the productOptionChoices column, you must also enter data in the productOptionName and productOptionType columns. |
Missing name and type for option choice. When choice ID is not provided, it must include a name and type | Provide both a name and type for option choices. |
Duplicate option name. Option must have a unique name | 2 or more product option names are identical. Update them so each one is unique. |
Duplicate modifier name. Modifier must have a unique name | 2 or more modifier names are identical. Update them so each one is unique. |
Duplicate option choice name. Option choice must have a unique name | 2 or more product option choices are identical. Update them so each one is unique. |
Duplicate modifier choice name. Modifier choice must have a unique name | 2 or more modifier choices are identical. Update them so each one is unique. |
Failed to create/update product and variant with pre order enabled | You need to add the pre-order data for each variant (i.e. enabled status, pre-order message, limit to number of pre-orders allowed). |
Failed to create brand, won't create product | There was a technical problem. Try importing again. |
Failed to create ribbon, won't create product | There was a technical problem. Try importing again. |
Too many variants in request, allowed 1000 but was actual | Reduce number of different variants to 1000 or fewer per product. |
Too many options in request, allowed 100 but was actual | Reduce number of different product options to 100 or fewer across all products. |
Too many modifiers in request, allowed 100 but was actual | Reduce number of different modifiers to 100 or fewer across all products. |
Too many info sections in request, allowed 100 but was actual | Reduce number of different info sections to 100 or fewer across all products. |
Choice does not exist | Ensure referenced choices exist. |
Customization does not exist | There was a technical problem. Try importing again. |
Failed to create customizations | There was a technical problem. Try importing again. |
Failed to add customization choices | There was a technical problem. Try importing again. |
Missing product option choices. Every variant option id must exist in options.id | A product option choice that appears in a variant isn't listed in the productOptionChoices column. Add the missing product option choice(s). |
Error messages and solutions
Below is a list of possible error messages and how to correct them.
Error message | What it means & how to correct |
|---|---|
Duplicate option choice. Different variants can't have the same option choice | 2 or more product option choices are identical. Update so each one is unique. |
Duplicate option. Different options can't have the same name and type | 2 or more product options have the same name and type (SWATCH_CHOICES or TEXT_CHOICES) Update so each one is unique. |
When product has more than 1 variant, it's not allowed to send empty choices | If you entered variants, you must enter the relevant data in the productOptionChoices columns. |
Inconsistent variants types. All variants must have the same option type | Make sure all variants have the same typed properties. |
Duplicate product slugs. Each product must have a unique slug | Each product must have a unique Handle (column A). Note that the same handle is used for the media and variants that belong to the product. |
Barcode must be unique across the store | Make sure every barcode in your store is unique. |
Duplicate barcode is not allowed to be sent in the request | Make sure every barcode in your store is unique. |
SKU must be unique across the store | Make sure every SKU in your store is unique. |
Duplicate SKU is not allowed to be sent in the request | Make sure every SKU in your store is unique. |
Too many products in store | You can import up to: - 15mb of data - 10k rows (only the first 10K rows are imported) |
Product description is too large | Reduce the length of the product description |
Product media does not exist | Must contain either 1 media URL or 1 media ID. Media IDs are automatically added when exporting. Learn how to add an image URL. |
Price per unit settings are not aligned between product and variant | Align price per unit settings between product and variants. |
Duplicate product IDs in request | Remove duplicate product IDs. |
Error message | What it means & how to correct |
|---|---|
Missing product options. Options must be provided for variants | A product cannot have variants without product options. Add the missing product options. |
Compare at price must be greater than or equal to actual price | The value in the strikethroughPrice column must be greater than the value in the price column. |
Adjusted actual price is outside the valid range. Must be between 0 and 999999999 | The value in the price column must be between 0 and 999999999. |
Adjusted compare at price is outside the valid range. Must be between 0 and 999999999 | The value in the strikethroughPrice column must be between 0 and 999999999. |
Adjusted cost is outside the valid range. Must be between 0 and 999999999 | The value in the cost column must be between 0 and 999999999. Note: "Cost" refers to cost of goods. |
Missing variant price. Every variant must have a price | Enter a price for this product variant. |
Field contains only spaces | Enter data in the relevant column. |
Options limit exceeded, more than limit options for site | Reduce the overall number of product options. |
Modifiers limit exceeded, more than limit modifiers for site | Reduct the overall number of modifiers. |
Each option can have up to 100 choices | Each product option can have up to 100 choices (e.g. 100 sizes). Delete some product option choices. |
Choice name is not unique | Each product option choice or modifier choice for a product must have a unique name. |
Choice type is not supported for customization type | Use supported choice types. |
Choice value is not supported for choice type | Use a supported product option choice value. |
This type of customization does not support choices | For product options, select either SWATCH_CHOICES or TEXT_CHOICES. For modifiers, select either SWATCH_CHOICES, TEXT_CHOICES or FREE_TEXT. |
Customization render type is not supported | Use supported render types. |
Free text settings are invalid | Text formatting is invalid. |
Insufficient inventory for the requested quantity | Must be IN_STOCK, OUT_OF_STOCK, or an inventory number (e.g. 55). |
Cannot track quantity for this inventory item | Enable quantity tracking/Must be IN_STOCK, OUT_OF_STOCK, or an inventory number (e.g. 55). |
Minimum quantity limit reached | Must be IN_STOCK, OUT_OF_STOCK, or an inventory number (e.g. 55). |
Maximum quantity limit reached | Must be IN_STOCK, OUT_OF_STOCK, or an inventory number (e.g. 55). |
What's next?
After correcting all the errors and saving your changes, click Import Another File to upload the corrected file.
