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

RetroArt
Visitor
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 90 (90)
Trevor
Community Moderator
3391 459 979

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

 

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

rootchi
Visitor
3 0 0

 

@Trevor 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!

rootchi
Visitor
3 0 0

@Trevor 

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

 

Trevor
Community Moderator
3391 459 979

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

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

singhudit61
Visitor
1 0 1
I've tried including options1name and options2Name on the same line for a product but get errors when importing.
muzi
Shopify Partner
1 0 0

Hi @Peter 

I had the same problem, it was a single SKU product.

HandleTitleBody (HTML)VendorTypeTagsPublishedOption1 NameOption1 ValueOption2 NameOption2 ValueVariant SKUVariant GramsVariant Inventory TrackerVariant Inventory QtyVariant Inventory PolicyVariant Fulfillment ServiceVariant PriceVariant Compare At PriceVariant Requires ShippingVariant TaxableImage SrcImage PositionImage Alt TextVariant ImageVariant Weight Unit
cute-dog-190116Flower Dog-Reviews2020 Popular diamond painting
 
              <strong>5D Diamond Dog Painting Embroidery DIY Crafts Cross Stitch Home Art Decor Accessories</strong><br><strong>Cute Dog Painting Embroidery DIY 5D Diamond Cross Stitch for Living Room Bedroom Gifts Decor<span></span></strong><br><br><strong>Features:</strong><br><span>DIY painting, ingenuity, to do the painting with resin sequin, resin sequin unique luster is dazzling, shining in the light, is currently most popular DIY decorations.</span><br><span>Wealth and Good Fortune Diamond Painting Embroidery Home Decoration.</span><br><span>Perfect to decorate your living room or bedroom to match different decoration style.</span><br><br><strong>Specifications:</strong><br><span>Material: Rhinestone + canvas</span><br><span>Product process: 5D diamond painting</span><br><span>Pattern: Dog</span><br><span>Color: As shown</span><br><span>Size:</span><br><span>Canvas: about 30 x 30cm/11.02 x 11.02 in</span><br><span>Spot drill: about 24 x 24cm/9.45 x 9.45 in</span><br><span>Space: Living room/bedroom/classroom/entrance</span><br><br><strong>DIY Diamond painting production steps:</strong><br><span>1. Open the box and check the diamond draw special tools;</span><br><span>2. According to resin diamond color coding, choose a color on the plate, if the paste the same color at a time, you can increase the speed;</span><br><span>3. Find the appropriate color code on the canvas and start pasting until done;</span><br><span>4. After finishing, in order to be able to make the diamond painting steady, you can get some pressure on the canvas for a while;</span><br><span>5. Finally completed, you can put your results to framed up, enjoy decorating your home and add vitality to your home.</span><br><br><strong>DIY diamond painting precautions:</strong><br><span>1. Refer to the previous steps.</span><br><span>2. If you do not know what color to use, refer to the color chart.</span><br><br><strong>Note:</strong><br><span>1. This is DIY diamond painting, not finished, and you need to finish it yourself. All products are manual measurement, please allow 1-2cm deviation</span><br><span>2. Because the light is different from the screen, the color of the item may be slightly different from the picture. Please understand.</span><br><span>3. We only sell semi-finished diamond paintings excluding frames.</span><br><br>
            </div>
         

         
           
Diamond PaintingsDiamond PaintingsAnimal,Diamond Painting,DogTRUETitleDefault Title   300shopify1000continuemanual15 TRUEFALSEhttps://cdn.shopify.com/s/files/1/0250/6666/8106/products/190116-1_1024x1024.jpg?v=1566531856 Flower Dog -  kg
cute-dog-190116Flower Dog-Reviews2020 Popular diamond painting
 
              <strong>5D Diamond Dog Painting Embroidery DIY Crafts Cross Stitch Home Art Decor Accessories</strong><br><strong>Cute Dog Painting Embroidery DIY 5D Diamond Cross Stitch for Living Room Bedroom Gifts Decor<span></span></strong><br><br><strong>Features:</strong><br><span>DIY painting, ingenuity, to do the painting with resin sequin, resin sequin unique luster is dazzling, shining in the light, is currently most popular DIY decorations.</span><br><span>Wealth and Good Fortune Diamond Painting Embroidery Home Decoration.</span><br><span>Perfect to decorate your living room or bedroom to match different decoration style.</span><br><br><strong>Specifications:</strong><br><span>Material: Rhinestone + canvas</span><br><span>Product process: 5D diamond painting</span><br><span>Pattern: Dog</span><br><span>Color: As shown</span><br><span>Size:</span><br><span>Canvas: about 30 x 30cm/11.02 x 11.02 in</span><br><span>Spot drill: about 24 x 24cm/9.45 x 9.45 in</span><br><span>Space: Living room/bedroom/classroom/entrance</span><br><br><strong>DIY Diamond painting production steps:</strong><br><span>1. Open the box and check the diamond draw special tools;</span><br><span>2. According to resin diamond color coding, choose a color on the plate, if the paste the same color at a time, you can increase the speed;</span><br><span>3. Find the appropriate color code on the canvas and start pasting until done;</span><br><span>4. After finishing, in order to be able to make the diamond painting steady, you can get some pressure on the canvas for a while;</span><br><span>5. Finally completed, you can put your results to framed up, enjoy decorating your home and add vitality to your home.</span><br><br><strong>DIY diamond painting precautions:</strong><br><span>1. Refer to the previous steps.</span><br><span>2. If you do not know what color to use, refer to the color chart.</span><br><br><strong>Note:</strong><br><span>1. This is DIY diamond painting, not finished, and you need to finish it yourself. All products are manual measurement, please allow 1-2cm deviation</span><br><span>2. Because the light is different from the screen, the color of the item may be slightly different from the picture. Please understand.</span><br><span>3. We only sell semi-finished diamond paintings excluding frames.</span><br><br>
            </div>
         

         
           
Diamond PaintingsDiamond PaintingsAnimal,Diamond Painting,DogTRUE     300shopify1000continuemanual15 TRUEFALSEhttps://cdn.shopify.com/s/files/1/0250/6666/8106/products/190116-3_1024x1024.jpg?v=1566531860 Flower Dog -  kg
cute-dog-190116Flower Dog-Reviews2020 Popular diamond painting
 
              <strong>5D Diamond Dog Painting Embroidery DIY Crafts Cross Stitch Home Art Decor Accessories</strong><br><strong>Cute Dog Painting Embroidery DIY 5D Diamond Cross Stitch for Living Room Bedroom Gifts Decor<span></span></strong><br><br><strong>Features:</strong><br><span>DIY painting, ingenuity, to do the painting with resin sequin, resin sequin unique luster is dazzling, shining in the light, is currently most popular DIY decorations.</span><br><span>Wealth and Good Fortune Diamond Painting Embroidery Home Decoration.</span><br><span>Perfect to decorate your living room or bedroom to match different decoration style.</span><br><br><strong>Specifications:</strong><br><span>Material: Rhinestone + canvas</span><br><span>Product process: 5D diamond painting</span><br><span>Pattern: Dog</span><br><span>Color: As shown</span><br><span>Size:</span><br><span>Canvas: about 30 x 30cm/11.02 x 11.02 in</span><br><span>Spot drill: about 24 x 24cm/9.45 x 9.45 in</span><br><span>Space: Living room/bedroom/classroom/entrance</span><br><br><strong>DIY Diamond painting production steps:</strong><br><span>1. Open the box and check the diamond draw special tools;</span><br><span>2. According to resin diamond color coding, choose a color on the plate, if the paste the same color at a time, you can increase the speed;</span><br><span>3. Find the appropriate color code on the canvas and start pasting until done;</span><br><span>4. After finishing, in order to be able to make the diamond painting steady, you can get some pressure on the canvas for a while;</span><br><span>5. Finally completed, you can put your results to framed up, enjoy decorating your home and add vitality to your home.</span><br><br><strong>DIY diamond painting precautions:</strong><br><span>1. Refer to the previous steps.</span><br><span>2. If you do not know what color to use, refer to the color chart.</span><br><br><strong>Note:</strong><br><span>1. This is DIY diamond painting, not finished, and you need to finish it yourself. All products are manual measurement, please allow 1-2cm deviation</span><br><span>2. Because the light is different from the screen, the color of the item may be slightly different from the picture. Please understand.</span><br><span>3. We only sell semi-finished diamond paintings excluding frames.</span><br><br>
            </div>
         

         
           
Diamond PaintingsDiamond PaintingsAnimal,Diamond Painting,DogTRUE     300shopify1000continuemanual15 TRUEFALSEhttps://cdn.shopify.com/s/files/1/0250/6666/8106/products/190116-9_1024x1024.jpg?v=1566531863 Flower Dog -  kg
cute-dog-190116Flower Dog-Reviews2020 Popular diamond painting
 
              <strong>5D Diamond Dog Painting Embroidery DIY Crafts Cross Stitch Home Art Decor Accessories</strong><br><strong>Cute Dog Painting Embroidery DIY 5D Diamond Cross Stitch for Living Room Bedroom Gifts Decor<span></span></strong><br><br><strong>Features:</strong><br><span>DIY painting, ingenuity, to do the painting with resin sequin, resin sequin unique luster is dazzling, shining in the light, is currently most popular DIY decorations.</span><br><span>Wealth and Good Fortune Diamond Painting Embroidery Home Decoration.</span><br><span>Perfect to decorate your living room or bedroom to match different decoration style.</span><br><br><strong>Specifications:</strong><br><span>Material: Rhinestone + canvas</span><br><span>Product process: 5D diamond painting</span><br><span>Pattern: Dog</span><br><span>Color: As shown</span><br><span>Size:</span><br><span>Canvas: about 30 x 30cm/11.02 x 11.02 in</span><br><span>Spot drill: about 24 x 24cm/9.45 x 9.45 in</span><br><span>Space: Living room/bedroom/classroom/entrance</span><br><br><strong>DIY Diamond painting production steps:</strong><br><span>1. Open the box and check the diamond draw special tools;</span><br><span>2. According to resin diamond color coding, choose a color on the plate, if the paste the same color at a time, you can increase the speed;</span><br><span>3. Find the appropriate color code on the canvas and start pasting until done;</span><br><span>4. After finishing, in order to be able to make the diamond painting steady, you can get some pressure on the canvas for a while;</span><br><span>5. Finally completed, you can put your results to framed up, enjoy decorating your home and add vitality to your home.</span><br><br><strong>DIY diamond painting precautions:</strong><br><span>1. Refer to the previous steps.</span><br><span>2. If you do not know what color to use, refer to the color chart.</span><br><br><strong>Note:</strong><br><span>1. This is DIY diamond painting, not finished, and you need to finish it yourself. All products are manual measurement, please allow 1-2cm deviation</span><br><span>2. Because the light is different from the screen, the color of the item may be slightly different from the picture. Please understand.</span><br><span>3. We only sell semi-finished diamond paintings excluding frames.</span><br><br>
            </div>
         

         
           
Diamond PaintingsDiamond PaintingsAnimal,Diamond Painting,DogTRUE     300shopify1000continuemanual15 TRUEFALSEhttps://cdn.shopify.com/s/files/1/0250/6666/8106/products/1_9ebfa4b5-276a-492b-b7a6-339dd85cf209_102... Flower Dog -  kg
cute-dog-190116Flower Dog-Reviews2020 Popular diamond painting
 
              <strong>5D Diamond Dog Painting Embroidery DIY Crafts Cross Stitch Home Art Decor Accessories</strong><br><strong>Cute Dog Painting Embroidery DIY 5D Diamond Cross Stitch for Living Room Bedroom Gifts Decor<span></span></strong><br><br><strong>Features:</strong><br><span>DIY painting, ingenuity, to do the painting with resin sequin, resin sequin unique luster is dazzling, shining in the light, is currently most popular DIY decorations.</span><br><span>Wealth and Good Fortune Diamond Painting Embroidery Home Decoration.</span><br><span>Perfect to decorate your living room or bedroom to match different decoration style.</span><br><br><strong>Specifications:</strong><br><span>Material: Rhinestone + canvas</span><br><span>Product process: 5D diamond painting</span><br><span>Pattern: Dog</span><br><span>Color: As shown</span><br><span>Size:</span><br><span>Canvas: about 30 x 30cm/11.02 x 11.02 in</span><br><span>Spot drill: about 24 x 24cm/9.45 x 9.45 in</span><br><span>Space: Living room/bedroom/classroom/entrance</span><br><br><strong>DIY Diamond painting production steps:</strong><br><span>1. Open the box and check the diamond draw special tools;</span><br><span>2. According to resin diamond color coding, choose a color on the plate, if the paste the same color at a time, you can increase the speed;</span><br><span>3. Find the appropriate color code on the canvas and start pasting until done;</span><br><span>4. After finishing, in order to be able to make the diamond painting steady, you can get some pressure on the canvas for a while;</span><br><span>5. Finally completed, you can put your results to framed up, enjoy decorating your home and add vitality to your home.</span><br><br><strong>DIY diamond painting precautions:</strong><br><span>1. Refer to the previous steps.</span><br><span>2. If you do not know what color to use, refer to the color chart.</span><br><br><strong>Note:</strong><br><span>1. This is DIY diamond painting, not finished, and you need to finish it yourself. All products are manual measurement, please allow 1-2cm deviation</span><br><span>2. Because the light is different from the screen, the color of the item may be slightly different from the picture. Please understand.</span><br><span>3. We only sell semi-finished diamond paintings excluding frames.</span><br><br>
            </div>
         

         
           
Diamond PaintingsDiamond PaintingsAnimal,Diamond Painting,DogTRUE     300shopify1000continuemanual15 TRUEFALSEhttps://cdn.shopify.com/s/files/1/0250/6666/8106/products/2_c82ac23c-7609-4800-8f3b-bd44bc41fcc6_102... Flower Dog -  kg
cute-dog-190116Flower Dog-Reviews2020 Popular diamond painting
 
              <strong>5D Diamond Dog Painting Embroidery DIY Crafts Cross Stitch Home Art Decor Accessories</strong><br><strong>Cute Dog Painting Embroidery DIY 5D Diamond Cross Stitch for Living Room Bedroom Gifts Decor<span></span></strong><br><br><strong>Features:</strong><br><span>DIY painting, ingenuity, to do the painting with resin sequin, resin sequin unique luster is dazzling, shining in the light, is currently most popular DIY decorations.</span><br><span>Wealth and Good Fortune Diamond Painting Embroidery Home Decoration.</span><br><span>Perfect to decorate your living room or bedroom to match different decoration style.</span><br><br><strong>Specifications:</strong><br><span>Material: Rhinestone + canvas</span><br><span>Product process: 5D diamond painting</span><br><span>Pattern: Dog</span><br><span>Color: As shown</span><br><span>Size:</span><br><span>Canvas: about 30 x 30cm/11.02 x 11.02 in</span><br><span>Spot drill: about 24 x 24cm/9.45 x 9.45 in</span><br><span>Space: Living room/bedroom/classroom/entrance</span><br><br><strong>DIY Diamond painting production steps:</strong><br><span>1. Open the box and check the diamond draw special tools;</span><br><span>2. According to resin diamond color coding, choose a color on the plate, if the paste the same color at a time, you can increase the speed;</span><br><span>3. Find the appropriate color code on the canvas and start pasting until done;</span><br><span>4. After finishing, in order to be able to make the diamond painting steady, you can get some pressure on the canvas for a while;</span><br><span>5. Finally completed, you can put your results to framed up, enjoy decorating your home and add vitality to your home.</span><br><br><strong>DIY diamond painting precautions:</strong><br><span>1. Refer to the previous steps.</span><br><span>2. If you do not know what color to use, refer to the color chart.</span><br><br><strong>Note:</strong><br><span>1. This is DIY diamond painting, not finished, and you need to finish it yourself. All products are manual measurement, please allow 1-2cm deviation</span><br><span>2. Because the light is different from the screen, the color of the item may be slightly different from the picture. Please understand.</span><br><span>3. We only sell semi-finished diamond paintings excluding frames.</span><br><br>
            </div>
         

         
           
Diamond PaintingsDiamond PaintingsAnimal,Diamond Painting,DogTRUE     300shopify1000continuemanual15 TRUEFALSEhttps://cdn.shopify.com/s/files/1/0250/6666/8106/products/3_fc72290e-cc7e-4ad1-ad53-3105ebb55460_102... Flower Dog -  kg
cute-dog-190116Flower Dog-Reviews2020 Popular diamond painting
 
              <strong>5D Diamond Dog Painting Embroidery DIY Crafts Cross Stitch Home Art Decor Accessories</strong><br><strong>Cute Dog Painting Embroidery DIY 5D Diamond Cross Stitch for Living Room Bedroom Gifts Decor<span></span></strong><br><br><strong>Features:</strong><br><span>DIY painting, ingenuity, to do the painting with resin sequin, resin sequin unique luster is dazzling, shining in the light, is currently most popular DIY decorations.</span><br><span>Wealth and Good Fortune Diamond Painting Embroidery Home Decoration.</span><br><span>Perfect to decorate your living room or bedroom to match different decoration style.</span><br><br><strong>Specifications:</strong><br><span>Material: Rhinestone + canvas</span><br><span>Product process: 5D diamond painting</span><br><span>Pattern: Dog</span><br><span>Color: As shown</span><br><span>Size:</span><br><span>Canvas: about 30 x 30cm/11.02 x 11.02 in</span><br><span>Spot drill: about 24 x 24cm/9.45 x 9.45 in</span><br><span>Space: Living room/bedroom/classroom/entrance</span><br><br><strong>DIY Diamond painting production steps:</strong><br><span>1. Open the box and check the diamond draw special tools;</span><br><span>2. According to resin diamond color coding, choose a color on the plate, if the paste the same color at a time, you can increase the speed;</span><br><span>3. Find the appropriate color code on the canvas and start pasting until done;</span><br><span>4. After finishing, in order to be able to make the diamond painting steady, you can get some pressure on the canvas for a while;</span><br><span>5. Finally completed, you can put your results to framed up, enjoy decorating your home and add vitality to your home.</span><br><br><strong>DIY diamond painting precautions:</strong><br><span>1. Refer to the previous steps.</span><br><span>2. If you do not know what color to use, refer to the color chart.</span><br><br><strong>Note:</strong><br><span>1. This is DIY diamond painting, not finished, and you need to finish it yourself. All products are manual measurement, please allow 1-2cm deviation</span><br><span>2. Because the light is different from the screen, the color of the item may be slightly different from the picture. Please understand.</span><br><span>3. We only sell semi-finished diamond paintings excluding frames.</span><br><br>
            </div>
         

         
           
Diamond PaintingsDiamond PaintingsAnimal,Diamond Painting,DogTRUE     300shopify1000continuemanual15 TRUEFALSEhttps://cdn.shopify.com/s/files/1/0250/6666/8106/products/4_e07c7ce4-9dcf-4009-aa41-ea5fcbe9ad89_102... Flower Dog -  kg
cute-dog-190116Flower Dog-Reviews2020 Popular diamond painting
 
              <strong>5D Diamond Dog Painting Embroidery DIY Crafts Cross Stitch Home Art Decor Accessories</strong><br><strong>Cute Dog Painting Embroidery DIY 5D Diamond Cross Stitch for Living Room Bedroom Gifts Decor<span></span></strong><br><br><strong>Features:</strong><br><span>DIY painting, ingenuity, to do the painting with resin sequin, resin sequin unique luster is dazzling, shining in the light, is currently most popular DIY decorations.</span><br><span>Wealth and Good Fortune Diamond Painting Embroidery Home Decoration.</span><br><span>Perfect to decorate your living room or bedroom to match different decoration style.</span><br><br><strong>Specifications:</strong><br><span>Material: Rhinestone + canvas</span><br><span>Product process: 5D diamond painting</span><br><span>Pattern: Dog</span><br><span>Color: As shown</span><br><span>Size:</span><br><span>Canvas: about 30 x 30cm/11.02 x 11.02 in</span><br><span>Spot drill: about 24 x 24cm/9.45 x 9.45 in</span><br><span>Space: Living room/bedroom/classroom/entrance</span><br><br><strong>DIY Diamond painting production steps:</strong><br><span>1. Open the box and check the diamond draw special tools;</span><br><span>2. According to resin diamond color coding, choose a color on the plate, if the paste the same color at a time, you can increase the speed;</span><br><span>3. Find the appropriate color code on the canvas and start pasting until done;</span><br><span>4. After finishing, in order to be able to make the diamond painting steady, you can get some pressure on the canvas for a while;</span><br><span>5. Finally completed, you can put your results to framed up, enjoy decorating your home and add vitality to your home.</span><br><br><strong>DIY diamond painting precautions:</strong><br><span>1. Refer to the previous steps.</span><br><span>2. If you do not know what color to use, refer to the color chart.</span><br><br><strong>Note:</strong><br><span>1. This is DIY diamond painting, not finished, and you need to finish it yourself. All products are manual measurement, please allow 1-2cm deviation</span><br><span>2. Because the light is different from the screen, the color of the item may be slightly different from the picture. Please understand.</span><br><span>3. We only sell semi-finished diamond paintings excluding frames.</span><br><br>
            </div>
         

         
           
Diamond PaintingsDiamond PaintingsAnimal,Diamond Painting,DogTRUE     300shopify1000continuemanual15 TRUEFALSEhttps://cdn.shopify.com/s/files/1/0250/6666/8106/products/5_d91d94a5-615b-48ec-aba0-3ce574921263_102... Flower Dog -  kg
                          
Trevor
Community Moderator
3391 459 979

@muzi 

It's hard to tell as the CSV file does not embed well into the forum post. Is this a single product, with additional lines for only images, or something else? What are the errors you're getting?

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

dgzm
Visitor
1 0 0

Hi Peter,

 

My question is would it not be possible to add Option1 Value even though I have one option only. 

I am receiving the same error. "Validation failed: The variant 'Default Title' already exists." I believe it causes because I am not organizing the OptionName and Value. 

However, all I want to do is to show that single option value to the customers to let them know what they are buying. Is "Default Title" mandatory for the single option items?

thanks, 

 

 

issue 1.png

Trevor
Community Moderator
3391 459 979

@dgzm 

If your products do not have variant options, then Option 1 name will need to be "Title" as the field is required. Option 1 Value will need to be Default Title. If you are seeing an error that the field already exists, then you likely have it duplicated on one or more products. More information on the CSV columns, and what is and isn't required can be found in our help centre here

If you're unable to spot the issue, then let me know as I can verify the store to obtain the file to take a deeper look. 

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

jeevankumarkr
Visitor
2 0 1

I made many attemts and for allthe products the issue is similar,  could not resolve the issue. PFA for the csv I tried to use.

Trevor
Community Moderator
3391 459 979

@jeevankumarkr 

You're missing values in: 

  • Option1 Name (Required field)
  • Option1 Value (Required field) 

In addition, it looks like your secondary lines for each product are only for additional images. If that is the case, then you'd want to remove the values in columns R, S, T & AV. More information on adding multiple images can be found here. I would also recommend reviewing our Help Document on the definitions of the CSV fields to learn more about which are required and which can be left blank.

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

jeevankumarkr
Visitor
2 0 1

Dear Trevor,

I updated the file with option name and value but still the issue persists.

 

Trevor
Community Moderator
3391 459 979

@jeevankumarkr 

You'll need to remove the values from the columns I mentioned in my last reply. Once you have, the CSV will import successfully. 

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

knockoutstudio
Visitor
1 0 0

I'm having the same issue. I am using the exact same CSV file that worked perfectly for uploading my original products, but now am uploading 2-pack versions of those products. Seems to be formatted correctly per the instructions. CSV is here: https://cdn.shopify.com/s/files/1/0510/5362/5543/files/kelvin_products_2pk.csv?v=1639166263

Trevor
Community Moderator
3391 459 979

@knockoutstudio 

 

At first glance, I would say it's your additional rows for images. If you have values in columns that should not be filled in when adding additional images, then you're telling the system it's a product variant.

 

Rows used to add additional images to the product only need the handle, image source, and image position (if applicable) filled in. You can also add image alt text if needed. More information on adding additional images can be found here. 

 

I'd start there and see if that helps resolve the issue. 

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

Ltaty2605
Visitor
2 0 0

Hi There, can anyone help me. I'm trying to import a csv file but i get the error: Invalid CSV header: Missing headers: Title.

I checked my file but could't find the error.

I want to import new products whithout photos.

Thanks

 

Trevor
Community Moderator
3391 459 979

@Ltaty2605 

 

Sounds like you're missing the "Title" column. You'll need to review our Help Document that provides all the columns your CSV will need in order for you to import your products. 

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

Ltaty2605
Visitor
2 0 0

@Trevor 

Hi, I have the title column.

I tryed all the suggestions of this subject, but didn't work for me.

can you check my file? 

https://docs.google.com/spreadsheets/d/1hXTQS_Gi0ZMEdcF_us8dOuiyu0nxtT1v/edit?usp=sharing&ouid=11464...

Thanks

Trevor
Community Moderator
3391 459 979

@Ltaty2605 

 

Headers look fine, but you're missing data in the "Handle" fields. If you're missing data in the required fields, it will cause errors. By removing the content that didn't have handles, I wasn't presented with immediate errors when importing the CSV.

 

Though, after import, there were a number of images that failed to download, so I would check your image sources to ensure they are accurate. I'd start with ensuring your CSV is filled in correctly, then see what errors come up once you have. 

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

Umer990
Visitor
2 0 0

Hi. did you solve this? and how? 

Riverium
Tourist
4 0 1

Hi hope you are still here and can assist please. Having the same issue however I've been triple checked all your comments to everyone here- and everything seems fine but I still get this error. 

Here is my file https://docs.google.com/spreadsheets/d/1HgwXTkmLiJbZkRr1ANUZTnKWsugjDsDADeMsrrwsrWU/edit

Trevor
Community Moderator
3391 459 979

@Riverium 


It looks like you're trying to import products with multiple images by using rows to add the images. When doing this, you need to ensure that only the handle, image source and image position columns have values. If other columns have values for image rows then it tells the system it is a variant. 

Importing your CSV and cross referencing the errors, I can see that you have values in columns that should otherwise be empty since all the handles are the same and you only have the on variant option: 

 

 

More information on adding multiple images can be found here.

 

To add to this, you'll find that your product tags won't import because the Shopify admin does not support right to left text (RTL) - RTL is supported in Shopify Themes and the checkout. 

 

It also looks like some of your image sources won't allow our systems to download the image - The server you're attempting to download the image from could be blocking the request, so you may need to import these images manually. 

 

There are also a handful of handles/products that were ignored because "they already exists," which suggests that you have duplicate handles in your CSV. 

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

bidenntrumpp
Visitor
1 0 0

I made many attemts and for allthe products the issue is similar,  could not resolve the issue.

Dancul
Shopify Partner
8 0 1

Hello

I'm getting error 

  • Line 2-2696: Validation failed: The variant 'Default Title' already exists.

Tryed to set blank or text 'Default Title'. But still getting this error. Can you check it?

https://cdn.shopify.com/s/files/1/0578/8732/6361/files/03-09-for_import-Izol_120-200mm_import_v1_not...

 

Dan

Trevor
Community Moderator
3391 459 979

@Dancul 

 

I'd start by ensuring all required fields are filled in. Quick glance, you're missing handles for your products, so I'd start there. More information on CSV's can be found here

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

sprite_camy
Visitor
1 0 0

Hi @Trevor 

Usually I have no problem when uploading the product file however, this time i received an error saying: "

  • 37 products were modified
  • 2 products couldn't be changed due to invalid information

To import products that couldn't be updated, fix any errors in the CSV file and try importing it again.

Failed:

  • Line 1724-1765: Validation failed: The variant 'S' already exists.
  • Line 1766-1819: Validation failed: The variant 'XS' already exists."

Also, the specific Line mentioned here doesn't seem right, because I've checked that the 2 missing products that can't be uploaded is handle ss180-blk & SS18-blk which are at "Line 1524-1565 & Line 1566-1619" 

 

I have various products that have no problem when uploading together in this file, but only the two products have errors. I would like to know why is it not allowing me to upload these two products , Thank you in advance 🙂

 

 

Trevor
Community Moderator
3391 459 979

@sprite_camy 

 

Apologies for the late reply. The line numbers can sometimes be misleading as they may not be a true reflection of where the issue is. 

 

However; the best troubleshooting step is to take these two products and separate them from the CSV into a new CSV. This way, you can narrow down the issue to see if it's with the products or somewhere else in the sheet. 

 

At first glance, your sheet is set up correctly, however; after separating the products into a new CSV, I got the error "Option value provided for unknown options" 

 

That's when I noticed you were missing Option 2 Name for both products. Adding a name to both columns allowed these two products to be successfully imported. 

 

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

hung33434
Visitor
1 0 0

Please help me about this error

  • Line 62-91: Validation failed: Value is not using the expected value_type: 'boolean'.
  • Line 92-121: Validation failed: Value is not using the expected value_type: 'boolean'.
  • Line 122-181: Validation failed: The variant 'Men & Women / S' already exists. Please change at least one option value.
  • Line 182-241: Validation failed: The variant 'Men & Women / S' already exists. Please change at least one option value.
Umer990
Visitor
2 0 0

Hi. Were you able to solve this? and how? 

Mad_Modeler
Pathfinder
183 2 33

The main reason for this happening is that you haven't assigned a unique title to each product under the "Handle" heading in the spreadsheet, check this out first.

Most ecommerce platforms do this for but like in many other things, Shopify is very labour intensive and requires you to have a crystal ball.

Then you come on  here, get loads of complicated answers, when really these so called "experts" should be holding your hand and starting with the simplest solutions first.

You will also notice that it takes about 50 replies to get a commonsense answer out of them, this is because they write software, but never actually use it.

dtiff811
Visitor
2 0 0

I'm having this same issue. I've tried everything, I'm just not seeing what/where the issue is. Help would be greatly appreciated!
https://docs.google.com/spreadsheets/d/1kfl-dTKceDz8MmW99G95NW5AxhDHhqvOSeuTGX2YF2I/edit?usp=sharing

Trevor
Community Moderator
3391 459 979

@dtiff811 

 

Leaning on the email you get when you import your products will help highlight where you have errors in your CSV file. Option 1 Name is a required field, if you only have one option, then you'd enter "Title" otherwise, you'd need to enter values into Option 1 Name and Option 1 Values. More information on required columns can be found here. 

 

If the additional rows are for images, then you'd also need to remove values from all columns except the handle, image source, image position columns for each additional row. More information on adding multiple images can be found here. 

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

Mad_Modeler
Pathfinder
183 2 33

Every product handle (look in the Handle column has to be unique, fix that and it will load

dtiff811
Visitor
2 0 0

All the same product handles are for the additional pictures for that product. They need to be the same. 

Print_Proper
Tourist
8 0 1

Hi .. something is definitely broken. Same issue.... so i tested it by exporting 1 x prodcuct.. didnt touch the CSV file at all... imported it back in (still in virgin state untouched) and its giving me the same error 

Failed to import:

  • Line 2-51: is not using the expected value_type: 'boolean'.

If anyone can help that would be great!

 

mturkeli
Shopify Partner
1 0 0

Try removing the Google Shopping related columns from your CSV, that fixed it for us when we ran into the same error.

Print_Proper
Tourist
8 0 1

Just did and it worked... but when I exported the same product again to double check it all... all the google data is back in there!


Tried it again. Removed all google data + replaced picture 1 with a test image. Import success. Exported it again... and all the google data is still there + test image there... bit also picture 1 still there when it should be been removed & replaced by test image.

Shopify have re-indexed by admin as it may solve the issue. Waited a day, tried again, issue still presents itself.

Shopify also tested this product export. I sent them the CSV. They imported it to their test store no issues. Just not working with my store. Continuing to troubleshoot with them. No answers as yet as CSV is fine and working in their test store.

ilDodo94
Shopify Partner
1 0 0

I had the exact same problem myself. It happened less than a week ago, for 2 years I never had problems importing identical .csv files. I solved it as suggested by removing the Google Shopping column. Thank you very much for the advice.

vocalkeny
Visitor
1 0 0

I'm having this same issue. I've tried everything.

Maz
Shopify Staff
1161 129 178

Hello, @vocalkeny!

 

Thanks for joining this discussion.

 

Sorry to hear that you're also experiencing this. 

 

Feel free to share a couple of screenshots of your CSV file, or upload the file to Settings/Files, then provide the link here via copy and paste, and we can take a look! 

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

Print_Proper
Tourist
8 0 1

Ok so as of last week the boolean error is gone, even if I dont remove google shopping columns. Shopify are aware of it but havent advised how or when they fixed it. So communication was given to me about boolean error at all. I am just glad its gone (for now).


However a new issue presents itself - cannot remove data in google shopping custom label 0 column.. eg "Kids".. it is able to be changed to something else eg "babies" but not removed completely. Havent tried other google shopping columns. Shopify are aware of this issue, I have sent them a video showing the error via csv. They are working on a fix.