Re: Product Import Errors - 'add option values'

Solved

Product Import Errors - 'add option values'

hmfedders
Tourist
5 0 5

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

Accepted Solution (1)
Shay
Shopify Staff
2996 462 612

This is an 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:

 

Screenshot 2022-03-29 12.03.45 PM - Display 2.png

 

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. 

Shay | Social Care @ Shopify 
 - Was my reply helpful? Click Like to let me know! 
 - Was your question answered? Mark it as an Accepted Solution
 - To learn more visit the Shopify Help Center or the Shopify Blog

View solution in original post

Replies 10 (10)

Sophieyal
Tourist
4 0 0

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

hmfedders
Tourist
5 0 5
Sophieyal
Tourist
4 0 0

Okay, I'm going through it now

Sophieyal
Tourist
4 0 0

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

hmfedders
Tourist
5 0 5
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
Visitor
1 0 0

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
Tourist
4 0 0

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

Shay
Shopify Staff
2996 462 612

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

Shay | Social Care @ Shopify 
 - Was my reply helpful? Click Like to let me know! 
 - Was your question answered? Mark it as an Accepted Solution
 - To learn more visit the Shopify Help Center or the Shopify Blog

hmfedders
Tourist
5 0 5
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
Shopify Staff
2996 462 612

This is an 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:

 

Screenshot 2022-03-29 12.03.45 PM - Display 2.png

 

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. 

Shay | Social Care @ Shopify 
 - Was my reply helpful? Click Like to let me know! 
 - Was your question answered? Mark it as an Accepted Solution
 - To learn more visit the Shopify Help Center or the Shopify Blog