Export Sales Data

Has there been a change / is there a problem with the export Sales Data function?

I normally go to the page, enter the dates, and download, without touching the other settings, as I believe a default single file.

Yesterday, in trying to download the weekends sales into my excel program to create my shipping labels, the format downloaded had changed from normal.
Whereas, in the past, when opening the zip file and clicking on the unzipped file, it would open with the data in separate columns in Excel, yesterday, it opened as a document with all data in single cells

in A1:
salesmainid,companyname,title,firstname,lastname,address1,address2,town,county,postcode,country,state,dcompanyname,dtitle,dfirstname,dlastname,daddress1,daddress2,dtown,dcounty,dpostcode,dcountry,dstate,phone,dphone,email,subtotal,discount,totalprice,priceincludestax,totaltax,promdiscount,totalweight,totalshipping,actualshippingtype,createddate,status,psp,customeremailsent,storeemailsent,currencycode,acceptedtsandcs,sourced,shippingstatusdate,shippingstatus,statusdate,itemcode,itemname,price,itemweight,quantity,acceptsemails,promcode

in the past it would show:

in A1
salesmainid

in A2
companyname

The following rows of data were similarly affected.

I have tried changing the deliminator from comma to pipe, and also ticked and unticked the enclose in double-quotes field - only to find that the data is still all in the first cell of each line, but with the obvious change to the separators.

Using the excel inbuilt import from comma deliminated fields does not work well, as, for example, what may be in field "Address1" might be something like:
"2, The Street"
So placing the street address in two separate fields, making all other cells for that data row move to the right, under the wrong headings.
In the past, that data entry would all fall in one cell under "Address1" column.

I note that there has been a change in the date / time format, and wonder if the download has been changed at the same time.

Please advise how to get it back to the data being in separate cells, otherwise I am going to have to completely revise my label creating spreadsheet that amalgamated data from Romancart and other sources.



Edited by EddieODG - 01 March 2022 at 10:14am

I am pleased to find that I am not alone in suffering this problem... suggesting that it is not something I am doing.
Unfortunately, as for many sellers, Monday will be the busiest day for shipping, and so to find that something so important has been fiddled with over the weekend, and then changed is disappointing. It took me a long time to manually create shipping labels that I have specifically created an Excel spreadsheet to do with the exported sales data.

I have been waiting several weeks now for Romancart to resolve the split testing feature, which is not working, and appears to not have been looked at for years, as I was first told that the link given to paste into my site was wrong, and needed to be changed to https...

Well that was quickly dealt with.

But the split testing would still not work, and was told they would need to look at it as it was probably due to how cookies were now handled... that was a few weeks back, and despite emailing to ask for an update, I have heard nothing.

Now into the second day after posting this problem, still no response from Romancart.

It seems to have been corrected today.
Thank you.