Product Import CSV looks fine, but getting error, "Option value provided for unknown options"

Solved
brandunleashed
Excursionist
19 2 2

Hi,

I am trying to add a new option to products, and  I keep getting an error. You can see my  csv file in the attachment. Am I doing something wrong? Thanks.

Accepted Solution (1)

Accepted Solutions
Nick_Marketing
Shopify Partner
1049 242 302

This is an accepted solution.

The reason you are seeing this error because for every Option 1 Value there must be an equal combination of Option 2. For example: Left Only style comes in Gold and Sterling material. You must specify that in the .csv sheet.

This is what you had:

Option1 ValueOption2 NameOption2 Value
A PairMaterialGold Vermeil
Left Only Sterling Silver
Right Only  
   



This is how it should be:

Option1 ValueOption2 NameOption2 Value
A PairMaterialGold Vermeil
A Pair Sterling Silver
Left Only Gold Vermeil
Left Only Sterling Silver
Right Only Gold Vermeil
Right Only Sterling Silver

 

Hope it helps!

Nick | Ecommerce & Marketing Technology Consultant | Toronto, CANADA
- For consulting work availability, please send me a Private Message or submit a ✍️Contact Form.
- For FREE Shopify Tutorials, Subscribe to my YouTube channel (▶️ Ecommerce TV).

View solution in original post

Replies 2 (2)
Nick_Marketing
Shopify Partner
1049 242 302

This is an accepted solution.

The reason you are seeing this error because for every Option 1 Value there must be an equal combination of Option 2. For example: Left Only style comes in Gold and Sterling material. You must specify that in the .csv sheet.

This is what you had:

Option1 ValueOption2 NameOption2 Value
A PairMaterialGold Vermeil
Left Only Sterling Silver
Right Only  
   



This is how it should be:

Option1 ValueOption2 NameOption2 Value
A PairMaterialGold Vermeil
A Pair Sterling Silver
Left Only Gold Vermeil
Left Only Sterling Silver
Right Only Gold Vermeil
Right Only Sterling Silver

 

Hope it helps!

Nick | Ecommerce & Marketing Technology Consultant | Toronto, CANADA
- For consulting work availability, please send me a Private Message or submit a ✍️Contact Form.
- For FREE Shopify Tutorials, Subscribe to my YouTube channel (▶️ Ecommerce TV).

View solution in original post

brandunleashed
Excursionist
19 2 2