All things Shopify and commerce
Hi 🙂 I'm trying to import a CSV file to my shop but the following error is shown:
Here's the model I'm using for all of my products:
Any information is welcomed! Thanks.
You need to fill all the color columns of products till the end. If you have any concerns please let me know.
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
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:
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
As a business owner, have you ever wondered when your customer's first impression of yo...By Skye Jun 6, 2023
We're excited to announce improvements to the threaded messaging experience in our communi...By TyW May 31, 2023
Thank you to everyone who participated in our AMA with Klaviyo. It was great to see so man...By Jacqui May 30, 2023