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

RetroArt
New Member
1 0 0

I'm trying to upload a CSV file with 25 products; there are no options/variants for the products but most of the products do have more than one image. On my first attempt, 14 products of 49 uploaded successfully, but I cannot upload the remaining 35. I get the "Validation failed: The variant 'Default Title' already exists." for every line. The current file is formatted EXACTLY the same way; all I did was delete the rows with the successfully uploaded products. Anyone have a solution??

 

Replies 72 (72)
Trevor
Community Moderator
Community Moderator
3210 432 734

Hey, @RetroArt!

 

What steps have you tried already in terms of troubleshooting? When it comes to this error, this typically means you'll want to delete "Default Title" from every line other than the first line of each product. However, if your main goal is to upload multiple images per product, then following our guide here should help outline the steps you'll need to take to achieve this. 

 

If this doesn't work then feel free to post a few screenshots of your CSV, or upload the file to Settings/Files, and paste the link here as I'd be happy to help get that resolved. 

Trevor | Community Moderator @ 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

Lubabalo_Mazong
Shopify Partner
2 0 1

Hi Guys

 

Seems like almost all of us newbies kinda hit the rock error..

 

https://cdn.shopify.com/s/files/1/0072/6079/9033/files/New_Shopify.csv?5    

 

this is the link for any expert to help please and thank

Trevor
Community Moderator
Community Moderator
3210 432 734

Hey, @Lubabalo_Mazong!

 

Taking a look at your CSV file, I can see that you have multiple lines of the same handle but the titles vary: 

24-07-5tldu-z4ebv

 

What your file is telling our system is that line 2 is the parent product, and lines 3-7 are the variants (children to the parent). If this is intended, then you'd need to remove the titles and descriptions from lines 3-7, and use Option 1 Name & Value to describe the variant options. If these are intended to be separate products altogether, then the handle must be unique for every product. You can download a sample CSV here which should help with getting this fixed up. 

 

Let me know how that goes!

Trevor | Community Moderator @ 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

Lubabalo_Mazong
Shopify Partner
2 0 1
TheLion
New Member
2 0 1

Hi @Trevor 

 

I'm having the same problem, please can you check out my csv for problems?

https://cdn.shopify.com/s/files/1/0077/7846/7895/files/products_export_few_lines_and_images.csv?233

 

I'm trying to import 13 products with single images each, but receiveing this error:
Line 2-14: Validation failed: The variant 'Default Title' already exists. 

My products are simple and have no variants. But with "Title" and "Default Title" as my Options1 Name and Options1 Value, no luck.

 

Your soonest response will be much appreciated thanks

Trevor
Community Moderator
Community Moderator
3210 432 734

Hey, @TheLion!

 

Taking a look, each product is missing a handle. This file should load perfectly fine once you add unique handles to each product line: 

28-49-bgyfp-yuawe

Hope that helps!

Trevor | Community Moderator @ 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

TheLion
New Member
2 0 1
estuffs
New Member
3 0 0
Trevor
Community Moderator
Community Moderator
3210 432 734

@estuffs 

 

Currently, your CSV file is telling the system that you have 1 product, with multiple variant options as you have most columns filled in. To add additional images to a specific product, you'd need to create a new row for each image. You'd need to fill in the handle and the image source columns for each new line which should give you the desired result. We have a help doc here that dives into these steps in further detail if you need it! 

 

Let me know if you have any questions!

Trevor | Community Moderator @ 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

TeddyRambo
Tourist
8 1 1

Hi @Trevor 

 

Can you please let me know what the correct format is for importing a product with two variants, for example color and size ?

 

I've tried including options1name and options2Name on the same line for a product but get errors when importing.

Then i tried on separate lines and still got errors


Thanks for your help

 

HandleTitleBody (HTML)VendorTypeTagsPublishedOption1NameOption1ValueOption2NameOption2ValueOption3NameOption3 ValueVariant SKUVariant GramsVariant Inventory TrackerVariant Inventory QtyVariant Inventory PolicyVariant Fulfillment Service
LampTable Lamp
<h2 TABLE LAMP</h2>  
 LampsLightingTRUEColorWhitesizeLarge  abc   DenyManual
Lamp       Orange Small  abcd   DenyManual
Lamp       Chocolate    abcde   DenyManual
Lamp       Black    abcdef   DenyManual
Trevor
Community Moderator
Community Moderator
3210 432 734

@TeddyRambo 

 

When creating a product that has more than one variant option, then you'll need to ensure that each possible variation is created. This means that if you have White, then you need to have a line for white/small and white/large as the system won't automatically assume that each option has a specific size associated to it. 

19-09-evqut-j8zvw

Hope that helps!

Trevor | Community Moderator @ 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

Derek_Morin
Shopify Expert
212 0 32

If your CSV file doesn't have any "handle", you can try the Moose Sync app to import your products and schedule some automatic updates.

 

By default, if the handle is missing, it will "fill" it with the Product title data. If you don't have any product title either, well that's bad from a customer-experience point of view, but still, Moose Sync can make it work by filling the Product title with the content from one or more other "columns" (csv field). For example, using a "virtual field", you can aggregate 2 fields, let's say "SKU" and "ShortDescription" into one single field (Product title) and import your data smoothly in your Shopify store. 

maudie
Tourist
5 0 2

Hi Peter,

Can you help me too please? I do not want to add variants, I just want to add 4 images for EVERY product. I can send you my excel file with all the products if you like.

Best,

Maud

Trevor
Community Moderator
Community Moderator
3210 432 734

@maudie 

Our help doc here dives into the steps on how to add multiple images to your CSV file for each product. If you have any issues getting that setup, let me know! 

Trevor | Community Moderator @ 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

TanshaQuo
New Member
3 0 0

I am facing a similar issue, have to upload hundred but not succesfull for 5 also. 

Please help solve below error:

Failed:

  • Line 2-14: Validation failed: The variant 'Default Title' already exists.
HandleTitleBody (HTML)VendorTypeTagsPublishedOption 1Option 1 ValueOption 2Option 2 ValueOption 3Option 3 ValueVariant SKUVariant Grams
Brass FigurinePAGADI GANESHAPremium Brass GaneshaMantraFigurineGod figurineTRUEColourBrass CopperSize19"Warranty2 year 20000
Brass Figurine Premium Brass GaneshaMantraFigurineGod figurineTRUEColour

Brass Antique

Size19"Warranty2 year 20000
Brass FigurineLAKSHMIPremium Brass FigurineMantraFigurineGod figurineTRUEColourMicro Gold CoatingSize3.25"Warranty5 Years 270
Brass FigurineGOMATHABlessing of Holy CowMantraFigurinefigurineTRUEColour

Brass Antique

Size5.5"Warranty2 year 2160
Brass FigurineGOMATHABlessing of Holy CowMantraFigurinefigurineTRUEColourBrass CopperSize2.75Warranty2 year 420
Trevor
Community Moderator
Community Moderator
3210 432 734

@TanshaQuo 

All of your handles are the same, but you have multiple titles that indicate these are separate products. You would need to update the handles if they are separate products, or remove the titles except for the first one and try again. 

Trevor | Community Moderator @ 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

stallionretail
New Member
4 0 0

Hi Peter 

I have been trying everything suggested on this forum but still have this same problem.Validation failed: The variant 'Default Title' already exist. 

Can you check my csv file

https://cdn.shopify.com/s/files/1/0377/3782/4301/files/product_template25.csv?v=1596029935

Trevor
Community Moderator
Community Moderator
3210 432 734

@stallionretail 

As you're using the additional fields for images, and not variants, the CSV file is confusing the system by having values in the following columns: 

  • Option 1 Name
  • Option 1 Value
  • Variant Fulfillment Service
  • Variant Requires Shipping
  • Variant Inventory Tracker
  • Variant Inventory Policy
  • Variant Grams
  • Variant Taxable 
  • Gift Card
  • Variant Weight Unit

Removing the values that appear in each of the columns for rows 3-5, 7-9, and 11-13 will result in a successful import. A few things to note about your CSV file:

  • Your handles are quite long. I would recommend shortening the handles to make it appear cleaner, and more concise. 
  • You'll want to add inventory to the products as currently they are set to 0

Let me know if you run into any issues!

 

Trevor | Community Moderator @ 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

stallionretail
New Member
4 0 0

Hi Peter 

Thank you so much, work well. I think my handle was so long, I just create short handle and works well. I dont know how to add inventory to the products, I filled the Variant Inventory Qty 10 but uploaded 0 quanity.

Screen Shot 2020-07-29 at 6.19.51 PM.png