Can I upload a spreadsheet of eBay sales?
eBay only allows us to query sales up to 90 days. Using a spreadsheet, you can map the fields.
How do I download the spreadsheet?
TBD.
How do fields map?
Here is a guide:
| eBay | QuickBooks |
| Order Total | Not mapped to any field. Used for display purposes on our order previewer. |
| Order Number | Order number |
| Reference Number | Payment ref. no. |
| Creation Date | Date |
| Type | Order status. Not mapped to any field, but can be used for rules. |
| Final Value Fee - fixed | Merchant fees, which are added as a line item. |
| LookupCustomLabel | Item name and item description |
| Shipping cost | Shipping amount in QuickBooks, added as a line item. |
| Quantity | Quantity |
| Item subtotal | Unit Price |
| Amount Paid | Total Paid |
| Refunded Retail Sales | This field is missing from the spreadsheet. If you add it and enter the total of the refund, then our tool maps a refund in QuickBooks. |
| Buyer name | Customer name |