A field mapping guide
What data do you sync?
Connex Inventory will import all of your products, during the initial install. Our software will import the last 7 days of sales receipts and invoices to Connex.
How do products map?
Here is how products map:
| QuickBooks Online | Connex Inventory | Notes |
| Sku | Sku | If blank, we map the QuickBooks item name. |
| Item Name | Name | |
| Sales Description | Product Description | |
| Sales Price | Sales Price | |
| Unit Cost | Unit Cost | |
| Preferred Vendor | Vendor |
How do orders map?
Here is how orders map:
| QuickBooks Online | Connex Inventory | Notes |
| DocNumber | Order Number | If blank we use the id on the record itself. We highly recommend adding an order number to each sale. |
| N/A | Selling Channel Name | We map the field to QuickBooks Online. |
| Order Date | Order Date | Located on the top right of the sale. |
| Total Tax | Total Tax | |
| Shipping Date | Shipping Date | |
| Total Amount | Order Total | |
| Shipping Method | Shipping Method | If you add a line item with UPS, FedEx or the phrase shipping, Connex maps the line item to shipping. You can use the QuickBooks Online shipping field, if activated. |
| Shipping Amount | Shipping Amount | |
| Order Detail > Item Name | Product SKU / Item Name | |
| Order Detail > Item SKU | Product SKU | If blank we use the QuickBooks item name field. |
| Order Detail > Rate | Unit Price | Price for 1 unit |
| Order Detail > Unit Quantity | Unit Quantity | |
| Order Detail > Bundled Items | For each bundled item, our tool will add a line item to the sale. In Connex, go to settings > add bundled items as line items. | |
| Order Detail > Discount | Order Discount | |
| Customer Name | Customer Name |