You can sync sales to QuickBooks and purchase orders from SellerCloud as bills
How do I pair SellerCloud?
Here are the steps:
- Login to Connex.
- On the Connex dashboard, click add connection.
- Enter your SellerCloud user name and password.
- Ask SellerCloud to provide the client name of the server on your account. If the client name was tt, enter this URL: https://tt.ws.sellercloud.com
Can I filter orders by company?
Each sale is associated with a company in SellerCloud. You can filter sales, using company. On the Connex configure page, expand orders > sync orders to QuickBooks > sync orders manually to QuickBooks. In the selling channel list filter, enter a list of companies to sync.
In our order previewer, here is an example of the filter:
How do the fields map?
Here is a list:
SellerCloud | QuickBooks | Notes |
Time of Order | Order Date | |
Selling Channel Name | Customer Name | Can be mapped to customer name in the settings. |
Source Warehouse | Not Mapped | Can be mapped to the QuickBooks inventory site field. |
Currency Code | Customer Currency Code | |
eBay Sales Record Number | PO Number | |
Unique Source Order ID | Not Mapped | Can be mapped to the order number field in QuickBooks. This field is the order number from Amazon, eBay, etc. |
Order ID | Order Number | Order ID is provided by Seller Cloud. |
Shipping Total | Shipping | Added as a line item or mapped to the QuickBooks Online shipping field. |
Shipping Service | Shipping Method | Added as a line item or mapped to the QuickBooks Online shipping field. |
Ship Date | Shipping Date | Added as a line item or mapped to the QuickBooks Online shipping date field. |
Tracking Number | Tracking Number | Added as a line item or mapped to the QuickBooks Online tracking field. |
Shipping Fee | Shipping Cost | Can be mapped as a line item on the sale, using our rules engine. |
Order Total Discount | Order Discount | Mapped as a line item. |
Shipping Total Discount | Shipping Discount | Mapped as a line item. |
Price Per Case | Unit Price | |
Quantity | Quantity | |
ProductID Requested | Item Name / SKU | |
Display Description | Item Description | |
Status Name | Not Mapped | Can be used to create rules and make comparisons. |
Billing Address | Billing Address | Name, Company, Phone, Email, Address |
Shipping Address | Shipping Address | Name, Company, Phone, Email, Address |
Payment Type | Payment Method | |
Payment Amount | Amount Paid | Used to create payments for invoices in QuickBooks. |
Order Total | Not Mapped | |
Total Tax | Tax | Mapped as a line item or use QuickBooks tax codes. |
Company | Selling Channel / Customer Name | Can be mapped to the customer name field. Select selling channel as the customer matching mode. |