Help! Product CSV File Upload Error: Validation failed: The variant 'Default Title' already exists.

Highlighted
Shopify Staff
Shopify Staff
1454 89 320

@stallionretail 

If the products have already been created within your admin, then you will need to import the CSV but select the "Overwrite" option when importing your CSV file:

20-07-qsql0-cg8uw

Using this option will update the products with the new information you have inputted into the CSV file. 

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

0 Likes
Highlighted
New Member
4 0 0
0 Likes
Highlighted
Shopify Staff
Shopify Staff
1454 89 320

@stallionretail 

Ah! My apologies, I realize my mistake now. When reviewing the CSV file, I was a bit confused about why this wasn't working. Due to the launch of "locations", the inventory can not be updated via a regular product CSV and would require using an "Inventory" CSV. You can access the inventory area by going to Products/Inventory, and export your current products. From there, update the inventory fields, and import the newly saved CSV file. 

I'm sorry I missed that before, but that should do the trick!

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

1 Like
Highlighted
New Member
4 0 0

Hi Peter,

Do you know how to make products available on all channels? 

I can only  make them available for  50 products, I have almost 1k inventory. I dont know how can I do it.

Screen Shot 2020-07-30 at 11.37.19 PM.png

0 Likes
Highlighted
Shopify Staff
Shopify Staff
1454 89 320

@stallionretail 

When you select all products on the page using the white box that appears at the top, you should then see an option that says "select all 50+ products in the store" - Selecting this will select all of your products so you can make bulk changes for your availability. 

 

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

0 Likes
Highlighted
New Member
2 0 0

 

@Peter joining this thread

i run a store and upload a spreadsheet twice a year. This is the first time upload is not letting me import giving me these errors:

Failed:

  • Line 79-96: Validation failed: The variant '0' already exists.
  • Line 977-994: Validation failed: The variant '0' already exists.
  • Line 1675-1684: Validation failed: The variant 'XS' already exists.
  • Line 2399-2413: Validation failed: The variant 'XS' already exists.
  • Line 2733-2750: Validation failed: The variant '0' already exists.
  • Line 2882-2917: Validation failed: The variant '0' already exists.
  • Line 2959-2977: Validation failed: The variant 'XS' already exists.

Ignored:

  • Line 2-6: ignored because handle jacket-black already exists.
  • Line 7-15: ignored because handle dress-forest already exists.
  • Line 16-24: ignored because handle dress-tuscany already exists.
  • Line 25-33: ignored because handle dress-forest already exists.
  • Line 34-42: ignored because handle dress-tuscany already exists.
  • etc

Here's the spreadsheet: 

2020-08-17 11_05_28-shopify upload for missing products - Sheet1 - Excel.png

why is it not allowing me to upload these products? Thank you in advance for your help!

0 Likes
Highlighted
New Member
2 0 0

@Peter 

I actually see why the handle issue is occuring but cant figure out the size issues. all my clothing go by this size range. why is it choosing to exclude some

 

0 Likes
Highlighted
Shopify Staff
Shopify Staff
1454 89 320

@rootchi 

It is hard to tell without seeing the full file; however, based on the screenshot and the first error, the variants are repeating themselves: 

 

20-08-ol5pn-zb8e5

 

Given my knowledge of the error, the system is seeing lines 79-96 as the same product, and not two separate products which would mean the handles are the same. That is the only conclusion I can draw based on the context provided. If you can supply the file, then I can take a deeper look. If you do not feel comfortable providing the file in a public forum then I can follow up with you via email to obtain it there. 

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

0 Likes
Highlighted
New Member
2 0 0

Do you mind helping me with my problem?

Here are screenshots of my .csv file and the errors I get.

Screen Shot 2020-08-28 at 9.46.50 AM.pngScreen Shot 2020-08-28 at 9.45.23 AM.png

0 Likes
Highlighted
Shopify Staff
Shopify Staff
1454 89 320

@JulianAlb 

The likely answer for the first error is that the inventory field is either blank or has an invalid entry. The inventory policy needs to be set to 'deny' or 'continue', if its left blank, or has any other value then this error will appear. For the second and third errors, products with only a single option should be set to Title under the "Option 1 Name" field.  Followed by Default Title in "Option 1 Value" if the product has only a single option. If it has more than one option, then you will need to input valid entries for each field. I'd recommend reviewing our CSV help doc here as it dives into each column, and whether or not it is required. 

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

0 Likes