Connex for QuickBooks Desktop User Guide
Connex for QuickBooks Online User Guide
Frequently Asked Questions
Integrations Help Guide
- Amazon Settlement Report
- Channel Advisor
- Custom Store
- Match Deposit Tool
- Other Partners
- Roaster Tools
- Spreadsheet Import Tool
Rules Engine Guide
General Troubleshooting Guide
QuickBooks Point of Sale (POS) - ARCHIVED
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?
How do fields map?
Here is a guide:
|Order Total||Not mapped to any field. Used for display purposes on our order previewer.|
|Order Number||Order number|
|Reference Number||Payment ref. no.|
|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.|
|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|