Product Import Errors - 'add option values'

Shopify Discussion

Topic summary

A user encountered a CSV import error in Shopify: “Validation failed: You need to add option values for Color” affecting lines 2-41. The issue prevented product variants with multiple colors and images from importing successfully.

Root Cause Identified:
Each variant row in the CSV file must include the product handle/title in its respective cell. Without this, Shopify cannot associate variant colors with their parent product.

Solution:

  • Every line containing a product variant needs the handle/title field populated
  • Recommended approach: manually create one product in Shopify admin, export it as CSV to use as a template, then replicate the structure for other products
  • Reference Shopify Help Center documentation on required CSV columns

Side Discussion:
Another user asked whether importing from Etsy to Shopify would delete their original Etsy store data (question remained unanswered).

Resolution: The original poster confirmed the solution worked after implementing the handle/title fix for each variant row.

Summarized with AI on November 3. AI used: claude-sonnet-4-5-20250929.
9

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.