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

[brandunleashed]

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. 🙂

[Nick_Marketing · 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 Value	Option2 Name	Option2 Value
A Pair	Material	Gold Vermeil
Left Only		Sterling Silver
Right Only

This is how it should be:

Option1 Value	Option2 Name	Option2 Value
A Pair	Material	Gold Vermeil
A Pair		Sterling Silver
Left Only		Gold Vermeil
Left Only		Sterling Silver
Right Only		Gold Vermeil
Right Only		Sterling Silver

Hope it helps!

[brandunleashed]

Thank you so much!!

[sbmoto]

Thanks for this answer, but what if this issue is still happening and all the option values are paired as they should be. There also aren't any blank lines either and I am currently at a loss.