All things Shopify and commerce
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??
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
@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:
Ignored:
Here's the spreadsheet:
why is it not allowing me to upload these products? Thank you in advance for your help!
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
It is hard to tell without seeing the full file; however, based on the screenshot and the first error, the variants are repeating themselves:
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
Hi @Peter
I had the same problem, it was a single SKU product.
Handle | Title | Body (HTML) | Vendor | Type | Tags | Published | Option1 Name | Option1 Value | Option2 Name | Option2 Value | Variant SKU | Variant Grams | Variant Inventory Tracker | Variant Inventory Qty | Variant Inventory Policy | Variant Fulfillment Service | Variant Price | Variant Compare At Price | Variant Requires Shipping | Variant Taxable | Image Src | Image Position | Image Alt Text | Variant Image | Variant Weight Unit |
cute-dog-190116 | Flower Dog-Reviews | 2020 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 Paintings | Diamond Paintings | Animal,Diamond Painting,Dog | TRUE | Title | Default Title | 300 | shopify | 1000 | continue | manual | 15 | TRUE | FALSE | https://cdn.shopify.com/s/files/1/0250/6666/8106/products/190116-1_1024x1024.jpg?v=1566531856 | Flower Dog - | kg | ||||||
cute-dog-190116 | Flower Dog-Reviews | 2020 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 Paintings | Diamond Paintings | Animal,Diamond Painting,Dog | TRUE | 300 | shopify | 1000 | continue | manual | 15 | TRUE | FALSE | https://cdn.shopify.com/s/files/1/0250/6666/8106/products/190116-3_1024x1024.jpg?v=1566531860 | Flower Dog - | kg | ||||||||
cute-dog-190116 | Flower Dog-Reviews | 2020 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 Paintings | Diamond Paintings | Animal,Diamond Painting,Dog | TRUE | 300 | shopify | 1000 | continue | manual | 15 | TRUE | FALSE | https://cdn.shopify.com/s/files/1/0250/6666/8106/products/190116-9_1024x1024.jpg?v=1566531863 | Flower Dog - | kg | ||||||||
cute-dog-190116 | Flower Dog-Reviews | 2020 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 Paintings | Diamond Paintings | Animal,Diamond Painting,Dog | TRUE | 300 | shopify | 1000 | continue | manual | 15 | TRUE | FALSE | https://cdn.shopify.com/s/files/1/0250/6666/8106/products/1_9ebfa4b5-276a-492b-b7a6-339dd85cf209_102... | Flower Dog - | kg | ||||||||
cute-dog-190116 | Flower Dog-Reviews | 2020 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 Paintings | Diamond Paintings | Animal,Diamond Painting,Dog | TRUE | 300 | shopify | 1000 | continue | manual | 15 | TRUE | FALSE | https://cdn.shopify.com/s/files/1/0250/6666/8106/products/2_c82ac23c-7609-4800-8f3b-bd44bc41fcc6_102... | Flower Dog - | kg | ||||||||
cute-dog-190116 | Flower Dog-Reviews | 2020 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 Paintings | Diamond Paintings | Animal,Diamond Painting,Dog | TRUE | 300 | shopify | 1000 | continue | manual | 15 | TRUE | FALSE | https://cdn.shopify.com/s/files/1/0250/6666/8106/products/3_fc72290e-cc7e-4ad1-ad53-3105ebb55460_102... | Flower Dog - | kg | ||||||||
cute-dog-190116 | Flower Dog-Reviews | 2020 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 Paintings | Diamond Paintings | Animal,Diamond Painting,Dog | TRUE | 300 | shopify | 1000 | continue | manual | 15 | TRUE | FALSE | https://cdn.shopify.com/s/files/1/0250/6666/8106/products/4_e07c7ce4-9dcf-4009-aa41-ea5fcbe9ad89_102... | Flower Dog - | kg | ||||||||
cute-dog-190116 | Flower Dog-Reviews | 2020 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 Paintings | Diamond Paintings | Animal,Diamond Painting,Dog | TRUE | 300 | shopify | 1000 | continue | manual | 15 | TRUE | FALSE | https://cdn.shopify.com/s/files/1/0250/6666/8106/products/5_d91d94a5-615b-48ec-aba0-3ce574921263_102... | Flower Dog - | kg | ||||||||
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
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,
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
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.
You're missing values in:
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
Dear Trevor,
I updated the file with option name and value but still the issue persists.
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
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
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
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
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
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?
Thanks
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
Hi. did you solve this? and how?
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
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
I made many attemts and for allthe products the issue is similar, could not resolve the issue.
Hello
I'm getting error
Tryed to set blank or text 'Default Title'. But still getting this error. Can you check it?
Dan
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
Hi @Trevor
Usually I have no problem when uploading the product file however, this time i received an error saying: "
To import products that couldn't be updated, fix any errors in the CSV file and try importing it again.
Failed:
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 🙂
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
Please help me about this error
Hi. Were you able to solve this? and how?
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.
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
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
Every product handle (look in the Handle column has to be unique, fix that and it will load
All the same product handles are for the additional pictures for that product. They need to be the same.
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:
If anyone can help that would be great!
Try removing the Google Shopping related columns from your CSV, that fixed it for us when we ran into the same error.
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.
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.
I'm having this same issue. I've tried everything.
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
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.
Portrait of Stephen positioned next to an image of planet Earth, with the Stephen's World ...
By JasonH Mar 18, 2024Digital marketers and app developers have tracked activity in apps and websites for yea...
By Ollie Mar 13, 2024February was an exciting month with Shopify Editions, informative webinars, and more! F...
By JasonH Mar 7, 2024