I get two errors when I try to upload my products with a CSV file.
I have double, triple and quadruple checked that none of my titles are blank and that none of my handles are too long (they’re all under 50 chars even).
So why is it still failing on me?
See attached file.
Hi @lazzlo ,
Your file is formated incorrectly, seems like there is some quote wrapping which wraps all the line which results in misformed data where only 1 field exist and it’s considered as handle by shopify, all the other fields are blank. Try to open your file on Excel and you will see that file isn’t formated properly, attaching screenshot how I can see your file.
Thank you for your reply Simon!
So it seems to work when I remove the quotes for the Body (HTML) column. But the reason I added the quotes is because the body contains commas. How can I include commas in a column without the system thinking that this comma means that the column has ended?
@lazzlo you need to wrap only Body(HTML) not the whole line. As I can see you wrapped whole line.
Sorry, I seem to be missing something here.
I can’t see that I’ve wrapped the entire line with quotes. See 1 and 4 in the screenshot. The quotes are where they should be, in position 2 and 3.
@lazzlo open this file using text editor and you will see quotes escaping (attaching screenshot). Excel allows you to take a look af final result (where quotes escaping is already applied as well as quotes wrapping which allows you to use commas).
Also keep in mind that if you wrap body with quotes on your file and later on edit such file on excel it may remove those quotes because it excel save visible values and not actual ones, so be carefull while working with such files.
If you want to upload catalog which has such descriptions I can suggest you to use tools which allows you to upload your catalog using excel files which doesn’t require such escaping.
If you want you can take a look at my tool Feeds Bridge which allows you to upload Excel files and those can be synchronized to shopify. It’s free to use up to 500 SKUS.
Lovely! Thank you so much for your help!
