Product import issues: You need to add option values for Title

klwd
Shopify Partner
4 0 0

Hi everyone

 

I have been trying to sort this for weeks! I have tried everything suggested on this forum already with no luck.

 

Please could somebody take a look at my import spreadsheet and tell me what our issues are?

 

https://cdn.shopify.com/s/files/1/0039/3029/2297/files/products-master-041228-REV02.csv?24

 

Thank you so much!

 

The errors say this:

 

Shopify completed your batch import.
120 products successfully imported.
4 existing products ignored.
92 products failed to import.

Errors:

Line 140-143: You need to add option values for Title
Line 144-145: You need to add option values for Title
Line 148-149: You need to add option values for Title
Line 150-152: You need to add option values for Title
Line 153: You need to add option values for Title
Line 154-155: ignored because it did not contain product data
Line 162: You need to add option values for Title
Line 163: ignored because it did not contain product data
Line 164-165: Validation failed: The variant 'Default Title' already exists.
Line 166: You need to add option values for Title
Line 167: You need to add option values for Title
Line 168-169: ignored because it did not contain product data
Line 170-175: Validation failed: The variant 'Default Title' already exists.
Line 176-179: Validation failed: The variant 'Default Title' already exists.
Line 180-182: Validation failed: The variant 'Default Title' already exists.
Line 183-185: Validation failed: The variant 'Default Title' already exists.
Line 186-188: Validation failed: The variant 'Default Title' already exists.
Line 189-191: Validation failed: The variant 'Default Title' already exists.
Line 192-194: Validation failed: The variant 'Default Title' already exists.
Line 202-204: Validation failed: The variant 'Default Title' already exists.
Line 205-207: Validation failed: The variant 'Default Title' already exists.
Line 208-210: Validation failed: The variant 'Default Title' already exists.
Line 211-213: Validation failed: The variant 'Default Title' already exists.
Line 221-228: Validation failed: The variant 'White Gloss' already exists.
Line 277-278: Validation failed: The variant 'Default Title' already exists.
Line 279-281: Validation failed: The variant 'Default Title' already exists.
Line 308: You need to add option values for Title
Line 309: You need to add option values for Title
Line 310-332: You need to add option values for Title
Line 333-335: Validation failed: The variant 'Default Title' already exists.
Line 336: You need to add option values for Title
Line 337: You need to add option values for Title
Line 354-355: Validation failed: The variant 'Default Title' already exists.
Line 356: You need to add option values for Title
Line 357: You need to add option values for Title
Line 358-360: Validation failed: The variant 'Default Title' already exists.
Line 361-363: You need to add option values for Title
Line 364-366: Validation failed: The variant 'Default Title' already exists.
Line 367-368: Validation failed: The variant 'Default Title' already exists.
Line 369-370: Validation failed: The variant 'Default Title' already exists.
Line 371-373: Validation failed: The variant 'Default Title' already exists.
Line 374-376: Validation failed: The variant 'Default Title' already exists.
Line 377-379: Validation failed: The variant 'Default Title' already exists.
Line 380-381: Validation failed: The variant 'Default Title' already exists.
Line 382: ignored because it did not contain product data
Line 383-385: Validation failed: The variant 'Default Title' already exists.
Line 386-388: Validation failed: The variant 'Default Title' already exists.
Line 389-391: Validation failed: The variant 'Default Title' already exists.
Line 392: You need to add option values for Title
Line 393: You need to add option values for Title
Line 394: You need to add option values for Title
Line 395: You need to add option values for Title
Line 396: You need to add option values for Title
Line 397: You need to add option values for Title
Line 398: You need to add option values for Title
Line 399: You need to add option values for Title
Line 400: You need to add option values for Title
Line 401: You need to add option values for Title
Line 418-420: Validation failed: The variant 'Default Title' already exists.
Line 421-423: Validation failed: The variant 'Default Title' already exists.
Line 424: You need to add option values for Title
Line 483: You need to add option values for Title
Line 507-509: Validation failed: The variant 'Default Title' already exists.
Line 510-511: Validation failed: The variant 'Default Title' already exists.
Line 512-513: Validation failed: The variant 'Default Title' already exists.
Line 514: You need to add option values for Title
Line 515-516: Validation failed: The variant 'Default Title' already exists.
Line 517-518: Validation failed: The variant 'Default Title' already exists.
Line 519-520: Validation failed: The variant 'Default Title' already exists.
Line 521-523: Validation failed: The variant 'Default Title' already exists.
Line 524-525: Validation failed: The variant 'Default Title' already exists.
Line 526-527: Validation failed: The variant 'Default Title' already exists.
Line 545: You need to add option values for Title
Line 546: You need to add option values for Title
Line 547: You need to add option values for Title
Line 548: You need to add option values for Title
Line 549: You need to add option values for Title
Line 560: You need to add option values for Title
Line 561: You need to add option values for Title
Line 565: You need to add option values for Title
Line 566: You need to add option values for Title
Line 567-568: Validation failed: The variant 'Default Title' already exists.
Line 569-570: Validation failed: The variant 'Default Title' already exists.
Line 571: You need to add option values for Title
Line 572: You need to add option values for Title
Line 573: You need to add option values for Title
Line 574: You need to add option values for Title
Line 575-576: You need to add option values for Title
Line 577: You need to add option values for Title
Line 578: You need to add option values for Title
Line 579: You need to add option values for Title
Line 580: You need to add option values for Title
Line 581: You need to add option values for Title
Line 582: You need to add option values for Title
Line 583-584: You need to add option values for Title
Line 585: You need to add option values for Title

Replies 11 (11)

Don
Shopify Staff
2762 199 388

Hi there @klwd!

 

Don here from Shopify. 🙂

 

Thanks for providing a link to your CSV file here and for outlining the errors you have been seeing.

 

I can see at least a few examples where there is an entry under the 'handle' field that does not have any accompanying info under the 'title' column:

 

17_00-c5u57-zqpdy

 

Similarly, further down in the file we see missing info under the Option 1 Name and Option 1 Value fields:

 

 

It is important when working with CSV files to ensure that the file format is matched exactly and that all necessary fields have data entered.

 

You can read a bit more about each of the fields in this format here and you can even click on the link on that guide to download a sample CSV file format to refer to.

 

Go through your CSV file, ensure that the formatting is exactly correct and try importing it again.

 

It might help if you divide your catalog up into parts so that you can work on correctly importing each part as you go.

 

All the best!

 

 

Regards,

Don

 

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

klwd
Shopify Partner
4 0 0

Hi @Don 

 

Thanks for your reply. In your first example. There is no title because this is a row for using a second image for the same product. Therefore in row 139 there is just the same handle as 138, but a different image URL.

 

What is the correct way of doing this?

 

Thanks

 

Rob

klwd
Shopify Partner
4 0 0

hi @Don I didnt hear back from you RE the above issue. 

 

Please can you give me an example how to add 2 different images for the same product in a spreadsheet. 

Don
Shopify Staff
2762 199 388

Hi there @klwd!

 

Don from Shopify once again. 🙂

 

Sorry I didn't get back to you here before now.

 

If you just wish to add more product images via CSV file then the extra lines you are referring to here need to only have the handle and image src fields filled out (image alt text is optional) as per our guide to using CSV files.

 

No other fields are required here, so any other info you would have entered on these lines will cause issues as we have seen here.

 

Try removing all data entered for lines being used to add images to your product except for the handle and image src fields as outlined on our guide above.

 

All the best!

 

Regards,

Don

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

Don
Shopify Staff
2762 199 388

Hi there @klwd!

 

Don from Shopify once again. 🙂

 

Sorry I didn't get back to you here before now.

 

If you just wish to add more product images via CSV file then the extra lines you are referring to here need to only have the handle and image src fields filled out (image alt text is optional) as per our guide to using CSV files.

 

No other fields are required here, so any other info you would have entered on these lines will cause issues as we have seen here.

 

Try removing all data entered for lines being used to add images to your product except for the handle and image src fields as outlined on our guide above.

 

All the best!

 

Regards,

Don

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

VintageParts
Visitor
1 0 4

Something is incorrect with this, as when we do our initial uploads with multiple pic urls, most uptake just fine without issue using only title and urls, but "reupload checking the overwrite box" to correct and backfill any issues, such as upload pic urls that may have timed out, it returns failures with 'You need to add option values for Title' . We tried additional pics with only title and url, also tried using only handle and urls, both return the same result and do not upload the additional pic files as well, why?

WeFish
Visitor
2 0 0

Hi,

I am having the same problems when trying to reupload my products. The creation of the product was fine, but when reuploading them, it returns failures with 'You need to add option values for Title'. Did you find any solution for this problem?

 

Thanks

talk19
Visitor
2 0 2

I am also having this same issue. 

talk19
Visitor
2 0 2

Ah I got the answer!

Weird that you have to do this but under "Option 1 Name" you have to enter: Title

Under "Option 1 Value" you have to enter: Default Title

 

Save the file and then upload and select overwrite - it should go through without error.

EndlessBob
Visitor
1 0 0

Big thanks to Talk19 for an answer that works. For items that simply have NO variants, it's unclear how to handle the import errors stating "Line <n>: You need to add option values for Title". The answer above works. If you provide "Title" for the option name and the actual title value for the option value, it shows an unsightly, unprofessional, non-variant.

 

Why these goofy values are required and simply not being able to leave these columns blank is beyond me here two full years later.   

SweetDesigns
Visitor
1 0 0

Hi Everyone,

 

I am having a similar issue- we are doing a price update of all of our products and their variants.  I thought I kept only relevant columns in my csv (since all we are changing is prices), but I am getting the error message "ignored because it did not contain product data".  There are product titles missing on certain rows because they are variants of the same product, and this is how the product list exported from Shopify.

Any insight would be helpful!

Please see scrnsht of all my columns:

Screen Shot 2021-07-25 at 11.01.16 AM.png