Sudden issue with Shopify order export (CSV) file

Technical Q&A
1

Every day I export the order CSV file and load it into Excel, and always column A (Name) only holds the order numbers. But today I noticed that column A is much wider than normal and when scrolling down the file I noticed lines like this in the export file and wonder what’s going on with the order export function?

Image 015.png
Image 015.png566×507 6.86 KB

And there is more going on. Amounts used to import without decimal points, so euro 60,25 used to import as 6025. but now it is imported as 60.25 (column subtotal, shipping and total) BUT NOT the Taxes and Discount Column!!! Is the order export file being messed up by someone?

Image 016.png
Image 016.png364×304 4.41 KB

2

@ckong

The likely culprit is Excel as it often has issues opening CSV files that are exported from Shopify. Are you able to replicate this when you open the CSV in Google Sheets or Numbers?

3

Hi Peter, Excel isn’t the cause because the odd lines are there too when I import the file as a textfile in Notepad++

But there has been some improvement, because now all amounts are without decimal point again, like it was and should be for me.

And I can deal with the unwanted lines in my Excel file by simply filtering them out and delete them.