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:
|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|
|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.|