When I export orders, the time of the sale is plotting into the wrong column and throws off the last 7 columns of data. The time shows up in “buyers email” so the actual email pushes to the next: Sale Price, etc.
Also, I don’t have a business account, so I’ve been manually entering the Paypal fee, but that doesn’t appear to export…the exported fields are blank.
Sorry – ignore that last bit. I’ve been entering the Paypal fee into the “Item cost” field, but didn’t see it in the exported spreadsheet since the columns were misaligned. The fee amounts are there, just in the wrong place.
Sorry–there were two issues, but I figured out the latter.
The original issue is that when I export, the date and time of the sale plot into two columns separately, but there should be only one column. So everything to the right of the date and time is misaligned by one column–the data plots under the wrong headings for the last 7 columns.
I tried to insert a screen shot into this post, but was unsuccessful.
In Reply To
rgherndon https://help.iwascoding.com/u/rgherndon
March 7
The drag and drop would not import the screen shot…can you see the
attachment to this email?
The comma in the date field indeed breaks the column order.
Until we have a fix for this, please change the separator type to semicolon when exporting the orders from GarageSale.
Okay, thanks. Trying to import the data into a larger spreadsheet with additional information and really didn’t want to have to move those columns manually every time I did so.