From QuickBooks to ShipStation
      Back to home
      1.  
      2. Connex Commerce Integrations Guide
      3. From QuickBooks to ShipStation

      How do fields map when syncing orders from QuickBooks to ShipStation

      A field mapping diagram

      How do fields map?

      Here is a list:

      1. 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.
      2. QuickBooks Description matches to the ShipStation item description.
      3. The QuickBooks sold to maps to the ShipStation ship from address.
      4. The QuickBooks ship to maps to the ShipStation ship to address.
      5. The QuickBooks memo field maps to the ShipStation private notes field.
      6. The QuickBooks date fields maps to the ShipStation date address.
      7. The sale no. matches to the ShipStation order number field.
      8. Unit of measure maps to the ShipStation order item custom fields.
      9. Bin and site map to the ShipStation order item custom fields.

      How does the ShipStation field requested shipping method map?

      In this example, we will add a rule to map the QuickBooks Enterprise field ship via to the requested shipping service field. We will send FedEx from QuickBooks to ShipStation:

      1. Go to rules engine > add new rule.
      2. Select map shipping method as the template.
      3. In the conditions, delete all.
      4. Add these two conditions: 
        1. Ship Via, Map All (Blank)
        2. Selling Channel Name, Equals, QB
      5. Leave the value field blank at the bottom.
      6. Click submit.

      Next, set up a field mapping with ShipStation:

      1. In ShipStation, go to settings > selling channel set up.
      2. Click edit, next to the store.
      3. Click shipping services.
      4. Create a field mapping.
      5. Enter FedEx and configure the mapping:

      Here is the end result:

      How do shipping details map?

      Connex will map the Quickbooks "Sold to" to the Shipstation "Ship from" Here's an example.
      Quickbooks: "Sold to"

      qbsoldto


      Shipstation: "Ship from"

      SSshipfrom

      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: