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