Connex can sync orders from Ordoro to QuickBooks as individual sales or a summary.
How do I pair Ordoro and QuickBooks?
Here are the steps:
- Login to Connex.
- On the Connex dashboard, click add connection.
- Choose Ordoro.
- Enter your admin Ordoro user name and password.
- Click submit.
Tip: If you are receiving pairing failures, click "update login" and ensure the Ordoro username and password match.
Can I sync a daily summary of sales from Ordoro to QuickBooks?
You can sync a daily summary of transactions and group them by selling channel and currency code. For an example summary transaction, read this guide.
On the configure page, expand customers. Select selling channel as the customer matching mode. Our tool will detect the currency code and add the orders to the store name plus the currency code.
How do the Ordoro and QuickBooks fields map?
Here is a field mapping diagram:
|Order Status||Not Mapped||Can be used to filter incoming sales to QuickBooks.|
|Selling Channel||Customer Name||Can be mapped to customer name, if you choose that option. Can be used to filter incoming sales to QuickBooks.|
|Order Number||Order Number|
|Order Date||Order Date|
|Billing Address||Billing Address||Customer name, address, city, state, country, and postal code.|
|Shipping Address||Shipping Address||Customer name, address, city, state, country, and postal code.|
|Tags||Not Mapped||Can be used to change field mappings, using our rules engine.|
|Payment Method||Payment Method|
|Tax||Tax||Can be mapped as a line item or QuickBooks tax code.|
|Shipping Amount||Shipping Amount|
|Tracking Number||Tracking Number|
|Shipping Date||Shipping Date|
|Supplier||Vendor Name||Used on purchase orders.|
|Total Discount||Discount||Mapped as a line item.|
|Line Item SKU||QuickBooks Item Name or SKU|
|Line Item Quantity||Line Item Quantity|
|Line Item Description||Line Item Description|
|Order Source Warehouse||Not Mapped||Can be used to make field mappings, using our rules engine.|
|Total Shipping Cost||Shipping Line Item|
|Shipping Method||Shipping Line Item|
|Split Shipment Parent Order Number||Not Mapped||Used to merge two split orders into a single sale.|