Had same error, no solution from forums helped, but kept on trying and.. succeeded :)
The problem was with MS Excell (suspecting European formatting), but dind't want to mess with it.
Easy solution: open new google sheets online, copy everything from product excel to the google sheet and download it as .csv
works as a charm for me :)
HI folks, I am really hoping someone can help me here as I am at my wits end....I have attached a screenshot of a wholesalers CSV file. I have used this file to import products but I am having no luck whatsoever trying yo use it to update inventory numbers...I keep getting various faults...missing headings initially. I inserted what I thought were the missing columns/headings and now I am getting an email telling me that "Line 2: Couldn't be updated because the handle doesn't match what's in Shopify" for ALL 5992 lines....
We would typically recommend ensuring that your CSV file matches what our system requires for headers/columns to ensure your products are uploaded/updated accordingly. If the headers/columns do not match, then our systems will have a hard time understanding what the columns are meant to be translated to, or will skip the column entirely.
Based on the screenshot you provided, I can assume that the "Code" column would have been interpreted for the "handle" column our CSV format has. Given that you're getting the error that the handles do not match, I would recommend finding the product shown on line 2 within your admin. When you have that product open, scroll down to the bottom of the page where you see the "SEO" section. If you edit this section, you'll see the handle that has been applied to the product. Does the handle that appears here (i.e. domain.com/product/handle) match what you have within your CSV file? If no, then knowing the handle will give you a starting place for understanding how our system interpreted the original CSV file so you can update it accordingly.
A possible workaround would be to export your products to a CSV file from the admin area. You'll then be able to see the layout of the CSV file required, but also would be able to update the inventory fields within a CSV file designed for our system. In theory, if you sorted your current CSV file by barcode, and then sorted the exported CSV by barcode, you could copy and paste the information over. Though, there may be formatting issues here depending on if the lines match up.
Just sent you my file by email Peter, thanks for your help!
Peter, also, on the csv template you propose here https://help.shopify.com/csv/product_template.csv, the last column "Status" is missing no?
So I ad it on my file, you'll see.
What errors are you seeing? Taking a quick look at the file, I'd start with your variant lines. If you have variants, then you don't need the extra data:
You'll see that you don't need to have a value in every row for Option 1/2/3 Name if you have variants. That said, you have values in Option 3 Name but no values in Option 3 values. Both columns need to be filled if you need to include a third option. Otherwise, remove the data found in the Option 3 name.