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??
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.
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
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:
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!
10 Likes from me. Thanks Peter
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
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:
Hope that helps!
Works perfectly thank you
Same error here, https://cdn.shopify.com/s/files/1/1742/2493/files/shopify-product_template_-_Copy.csv?1154
I want to add multiple images to one product for the same handle.
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!
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
| Handle | Title | Body (HTML) | Vendor | Type | Tags | Published | Option1Name | Option1Value | Option2Name | Option2Value | Option3Name | Option3 Value | Variant SKU | Variant Grams | Variant Inventory Tracker | Variant Inventory Qty | Variant Inventory Policy | Variant Fulfillment Service |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Lamp | Table Lamp | <h2 TABLE LAMP |
Lamps | Lighting | TRUE | Color | White | size | Large | abc | Deny | Manual | ||||||
| Lamp | Orange | Small | abcd | Deny | Manual | |||||||||||||
| Lamp | Chocolate | abcde | Deny | Manual | ||||||||||||||
| Lamp | Black | abcdef | Deny | Manual |
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.
Hope that helps!
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.
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
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.
| Handle | Title | Body (HTML) | Vendor | Type | Tags | Published | Option 1 | Option 1 Value | Option 2 | Option 2 Value | Option 3 | Option 3 Value | Variant SKU | Variant Grams |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Brass Figurine | PAGADI GANESHA | Premium Brass Ganesha | Mantra | Figurine | God figurine | TRUE | Colour | Brass Copper | Size | 19" | Warranty | 2 year | 20000 | |
| Brass Figurine | Premium Brass Ganesha | Mantra | Figurine | God figurine | TRUE | Colour | Brass Antique |
Size | 19" | Warranty | 2 year | 20000 | ||
| Brass Figurine | LAKSHMI | Premium Brass Figurine | Mantra | Figurine | God figurine | TRUE | Colour | Micro Gold Coating | Size | 3.25" | Warranty | 5 Years | 270 | |
| Brass Figurine | GOMATHA | Blessing of Holy Cow | Mantra | Figurine | figurine | TRUE | Colour | Brass Antique |
Size | 5.5" | Warranty | 2 year | 2160 | |
| Brass Figurine | GOMATHA | Blessing of Holy Cow | Mantra | Figurine | figurine | TRUE | Colour | Brass Copper | Size | 2.75 | Warranty | 2 year | 420 |
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.
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
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!
