product can't be imported due to invalide info - and validation failed: you need to add option value

[SHERRIB]

Hi - I'm trying to upload a file that is just one product with many variations. I keep getting the error: product can't be imported due to invalid info - and validation failed: you need to add option value. I don't understand, because i have option values entered for every line. I've tried formatting in a number of different ways, too, with no luck. I've also tried switching my option 1 (name and value) and option 2 (name and value) columns with no luck.  This is happening on the 2 attached files. I've had this happen before, but the items just had a couple options, so i uploaded them manually. 😞  (freaking sad face).

thanks for any help.

Sherri

[SHERRIB]

I've tweaked the fabric file - and got any with no options (default title, title) to import. I'm not getting any products with variations to import - i've tweaked the file (yellow fields) to remove the first option and am just trying the option that is different for each - still no luck.

[SHERRIB]

I just tried updating the bohin file, too - concatenated the 2 options to 1... am trying that, now. sigh.

[SHERRIB]

sigh - got this error. I can't understany why it is saying i need to add the option values when that field is completed on every line:

• 1 product couldn't be changed due to invalid information

To import products that couldn't be updated, fix any errors in the CSV file and try importing it again.

Failed:

• Line 2-52: Validation failed: You need to add option values for TYPE

[SHERRIB · Accepted solution]

got it!!! little m'f'r had a space missing in the header title for "Option1 Value" - dang!!! 

moving on! leaving this here, in case it can help someone else.