Data column misaligned in .csv export


#1

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.

Any advice? Thanks!


#2

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.


#3

Hi,

don’t know whether I completely undersatand your issues. Or even if there is an issue left :wink:

So your (manually inserted) PayPal fees are exported but in the wrong column?

Thanks,
Paul


#4

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.


#5

What application are you using to view the exported CSV file?

A screenshot would be very helpful. Why couldn’t you post one earlier? Did you get an error message of some sort?


#6

The drag and drop would not import the screen shot…can you see the
attachment to this email?


#7

Sorry, once again the screenshot didn’t make it through. Can please you send it to garagesale@iwascoding.com with reference to this discussion.


#8

ilja https://help.iwascoding.com/u/ilja
March 7

Sorry, once again the screenshot didn’t make it through. Can please you
send it to garagesale@iwascoding.com
https://help.iwascoding.commailto:garagesale@iwascoding.com with
reference to this discussion.

Visit Topic
https://help.iwascoding.com/t/data-column-misaligned-in-csv-export/4046/7
or reply to this email to respond.

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?

Visit Topic
https://help.iwascoding.com/t/data-column-misaligned-in-csv-export/4046/7
or reply to this email to respond.

To unsubscribe from these emails, click here
https://help.iwascoding.com/email/unsubscribe/b66f9417475eae179039e7212a54f3bec73dd2d73d07b174e8adadc5109367c7
.


#9

Thanks for the file.

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.

That did the trick for me.


#10

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.

I appreciate your time!


#11

This topic was automatically closed 10 days after the last reply. New replies are no longer allowed.