Product Import Errors - 'add option values'

[hmfedders]

I'm pulling my hair our trying to import products to my store! I keep getting the error:

• 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-41: Validation failed: You need to add option values for Color

I can't seem to fin where the error is, would love some input if anyone can help.

Here's the file:

https://docs.google.com/spreadsheets/d/e/2PACX-1vShN6JloyN4Yobux6VhXWWGfU4gigahx7ehwYwtFYpCl8bSXYGRc...

[Sophieyal]

Hello! I saw you post. The error can actually be fixed. But the link sent is not responding.

[hmfedders]

Thank you for looking at it!

Try this link: https://docs.google.com/spreadsheets/d/1G-4SRMZlvFAygSM0vN6GwwB4lYZL4FqaDH0ZSZ7CuFk/edit

[Sophieyal]

Okay, I'm going through it now

[Sophieyal]

What part of the chart aspect are you having problem with? Is it the color, tag, or what?

[hmfedders]

I’m using the .CSV template from Shopify to upload new products in to my store. Each product has multiple variants and images, when I upload the line sheet I get an error saying ‘failed import - option values cannot be blank…”

[RashmiOgiral]

Hi, I am new to Shopify. I am evaluating import of products and data from my existing Etsy store. Can someone clarify if the data or product on Etsy will be erased? I mean will the store on Etsy will still be alive..

Regards

[Sophieyal]

Is this your physical product? And you want to import from  etsy to shopify?

[Shay]

Hi and thank you @hmfedders for sharing a link to your sample CSV file you are working on. I had a look and the error you are seeing is most likely from having an incomplete CSV file upon import. 

There is a lot of data missing in your CSV file, like is the product taxable, does it require shipping, etc. 

I recommend in situations like this to make one of your products manually in the admin and then export out the one product to use as your own custom template to see what information is needed in your CSV file. Most of it can be duplicated from that point to easily fill in the blanks of the other products. 

You can also reference the information in our Help Center for columns that must have a value. 

[hmfedders]

Hi Shay,

Thanks for looking into this!

I tried our suggestion and keep getting the error:

*Failed:*

- Line 2-41: Validation failed: You need to add option values for Color

[Shay · Accepted solution]

Thanks for the update @hmfedders. I took a look at some test products in my own store, and I think I found the issue. 

In the CSV file, each ROW must have a handle/title. So each line for your variant colors needs to have the handle/title cell filled in. Please see my screenshot below to show what I mean:

The product is Bottled Starlight, and it has a range of variants in colors and containers. Each variant line needs to have a handle/title in order to know what product the variant is connected to. 

[visualwallart]

it works.

Thanks