Wix Stores: Product Import Error Messages

Each variant must be unique

In variant rows of the same product, in the productOptionDescription columns, you cannot repeat the same option combination (e.g. small;blue).

Must be TRUE or FALSE only

For each product or variant, enter either "TRUE" or "FALSE" in caps.

Discount value is not valid

You must enter a digit (e.g. 3, not three). 

If an item's discountMode is "percent", the discount value must be between 1 - 99.

The discountValue cannot be more than 9 digits long.

Max chars for each option choice is

{ X }

You have entered too many characters in this field. Do not exceed the number of characters specified in the error message.

Must be a number

You must enter a digit (e.g. 3, not three). 

Must be either "Amount" or "Percent"

For each product or variant, enter either "AMOUNT" or "PERCENT" in caps.

Each option choice must be unique

In product rows, when entering available options in the productOptionDescription columns, you cannot repeat an option, e.g. small; medium; medium; large. Delete the repeated option.

Surcharge (charge +/- for product variants) number is not valid

Leave this field blank for products. 

Leave this field blank for variants with no surcharge. 

Enter a positive number if the variant costs more than the product.

Enter a negative number if the variant costs less than the product.

The surcharge can have no more than 9 digits. 

The surcharge can have no more than 2 digits after the decimal point. 

Price is not valid

Leave this field blank for variables.

The price can be a positive number or zero; it cannot be a negative number.

The price can have no more than 9 digits. 

The price can have no more than 2 digits after the decimal point.

Max 1000 variants per product 
supported

You entered more than the maximum 1000 variants allowed per product. You must delete some of the variants.

HandleId must be unique for each 
product

Each product must have a different handleId. Edit the handleId field so that no two IDs are the same.

Note: Variants of a product must have the same handleId as the product. 

Must be either "COLOR" or 
"DROP_DOWN"

For each option, enter either "COLOR" or "DROP_DOWN" in caps in the product option type column. 

Enter "COLOR" for color options and "DROP_DOWN for everything else.

SKU must be unique

Each SKU must be different.

You do not need to enter SKU values for variants.

Must be either "Product" or "Variant"

For each product, enter "Product".

For each variant, enter "Variant".

If you do not use SKUs, leave blank.

Only { X } choices per 
product option

You entered more than the maximum amount of product choices per option (e.g. too many sizes). Delete some of the choices.

Max 15 images only

You entered more than the maximum 15 images allowed per product or variant.  

Required field

You left a mandatory field blank. Enter the required value.

Tip: Row 3 in the Template file indicates which columns are required.

Variant must have same "handleid" 
as its product

Edit the handleID so that each of a product's variants has the same handleId as the product. 

Must be either "in_stock", "out_of_stock", 
or a number

If you track inventory, enter the number of the product or variant you have in stock (e.g. 100).

If you do not track inventory, enter whether the item is InStock or OutOfStock.

Incorrect option choice

For product rows:
If a product has options, list all options choices. For example, "small; medium; large".
The choices must be separated by semi-colons and can be maximum 20 characters.

For variant rows:
For each variant row, you must enter the variant. This must correspond to the information entered in the product row. So for example, if you entered "small; large"  and "blue; green" in the product row, enter "small;blue", "small;green" "large;blue" and "large;green" in each of the variant rows.

For both products and variants:
If you chose "COLOR" for the productOptionType, then in the productOptionDescription column, you must enter one of the following:

1. RGB + an RGB value + text description (e.g. RGB(94,162,38):green
2. A hexadecimal value + text description (e.g. #ffffff:white)

If you chose "DROP_DOWN" for the productOptionType, then in the productOptionDescription column, you must enter a text description per option.

The text description can be no more than 20 characters per option.