- Connex for QuickBooks Integrations Guide
- From QuickBooks to ShipStation
-
Connex for QuickBooks User Guide
- Getting Started with Connex for QuickBooks
- Remote Desktop (RDP)
- Customers Matching
- Inventory Site
- Inventory Sync
- Multicurrency
- Orders
- Price Levels
- Products
- Refunds
- Sales Tax
- Sales Orders
- Unit of Measure
- Web Connector
- Getting Started with Rules
- Rules Engine Common Rules
- FAQ
- Deposit Match
- Cost of Goods Sold
- Troubleshooting
-
Connex Ecommerce Analytics
-
Frequently Asked Questions
-
General Troubleshooting Guide
- Deposit Match Troubleshooting
- QuickBooks Desktop Error Messages
- Inventory Troubleshooting
- Incorrect Orders Troubleshooting
- Sales Tax Troubleshooting
- Web Connector Troubleshooting
- QuickBooks Online Error Messages
- Match Deposit Tool Troubleshooting
- Product Matching Troubleshooting
- Customer Matching Troubleshooting
- Rules Engine
- Orders from QuickBooks
- Payments Troubleshooting
- Company File
-
Connex for QuickBooks Integrations Guide
-
Rules Engine Guide
How do fields map when syncing orders from QuickBooks to ShipStation
A field mapping diagram
How do fields map?
Here is a list:
- QuickBooks item matches to the ShipStation SKU. If you map the QuickBooks barcode to manufacturer part number to the ShipStation SKU, then these fields will appear on the sale. Otherwise, barcode and manufacturer part number have no mapping.
- QuickBooks Description matches to the ShipStation item description.
- The QuickBooks sold to maps to the ShipStation ship from address.
- The QuickBooks ship to maps to the ShipStation ship to address.
- The QuickBooks memo field maps to the ShipStation private notes field.
- The QuickBooks date fields maps to the ShipStation date address.
- The sale no. matches to the ShipStation order number field.
- Unit of measure maps to the ShipStation order item custom fields.
- Bin and site map to the ShipStation order item custom fields.
How do shipping details map?
Connex will map the Quickbooks "Sold to" to the Shipstation "Ship from" Here's an example.
Quickbooks: "Sold to"
Shipstation: "Ship from"
There are two ways to map shipping details: by the rule, custom field, and by the value custom field.
To map a custom field: read this guide.
To map the value custom field: read this guide.
How do custom fields map?
Connex will map QuickBooks order and line item custom fields to ShipStation. Here is an example:
The field called telephone is a custom field in QuickBooks. We can map telephone to custom field 1, 2, or 3:
The fields site, bin and order item custom fields appear on the line item: