Can anyone spot an issue in this CSV? (Validation failed: You need to add option values for Color)

Tarkus
New Member
1 0 0

Hi I'm trying to import a CSV file to my shop but the following error is shown:

  • Validation failed: You need to add option values for Color

Here's the model I'm using for all of my products:

https://drive.google.com/file/d/1zz1draJyGA3otJdZ06ebTfVPjZayCF86/view?usp=sharing

Any information is welcomed! Thanks.

Replies 3 (3)
MBilal
Tourist
7 0 4

Hi Tarkus, 

You need to fill all the color columns of products till the end. If you have any concerns please let me know. 

Thanks,
Muhammad Bilal
SkypeID: m_bilal_4

FatimaZahra
New Member
1 0 0

Hello,

I have the same issue. I tried filling all the color value column but I got errors for the color "black" (for example) already exists

Shay
Shopify Staff
528 87 105

Hi @FatimaZahra 

Without seeing your CSV file to troubleshoot the error itself, I can only guess as to what the issue is. If you have your CSV file laid similarly as the one that OP originally shared, the issue is most likely that the Variant Name and Value columns are most likely not accurately setup. To showcase what I mean, here is a sample from a multi-variant item on my test store:

Screenshot 2021-10-24 11.55.23 AM.png

 

Option1 Name column only requires the first field to be filled in for each set of product. The next column which provides the values for that variant style needs to be filled in for all variants. In my sample product there are 2 variant choices for this product, the first one is the container size (Necklace, Jar, Bathtub and Digital) and then the color (Unicorn, Blue, Red, Guide).

I highly recommend creating one of your products in your store admin and then exporting it as a template for other products with multiple variants, it's a great way to be sure you are formatting your CSV properly. You can also find a sample CSV file in our Help Center here: Using CSV files · Shopify Help Center.

 

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