How do fields map, when Connex updates sales with shipping details?

A guide on updating sales in QuickBooks after shipment

What is the use case?

You hand enter sales into QuickBooks. You ship the sale and invoice the customer for the products and shipping. The customer usually pays, after shipment. 

What versions of QuickBooks are compatible?

The integration works with QuickBooks Online and QuickBooks Desktop.

I use QuickBooks Online. Can I sync to the shipping fields?

For QuickBooks Online, there are specific fields for shipping and tracking details and Connex will use them:

What fields will sync?

Here is a ShipStation tracking label:

Here is a list:

I have free shipping. How do I only send the shipping method and tracking details?

Here are the steps:

1. Login to Connex.
2. Click settings.
3. Click orders from QuickBooks.
4. Select Update QuickBooks transaction with tracking info only.
5. Click save.
6. Sync the sale from QuickBooks to ShipStation.
7. Ship the sale in ShipStation by creating a label.
8. Sync the sale to QuickBooks.

Here is the end result:

I want to charge a specific amount to the customer. Is this supported?

In this example, we will charge $10 shipping to the customer regardless of the shipping cost:

1. In QuickBooks, create a transaction.
2. Add a line called shipping with $10 in the amount field. Leave description blank:
3. Login to Connex.
4. Click settings.
5. Click orders from QuickBooks.
6. Select Update QuickBooks transaction with tracking info only.
7. Click save.
8. Sync the sale from QuickBooks to ShipStation.
9. Ship the sale in ShipStation by creating a label.
10. Sync the sale to QuickBooks.

I want to sync the shipping cost from ShipStation, after the order ships?

Here are the steps:

1. Login to Connex.
2. Click settings.
3. Click orders from QuickBooks.
4. Select Update QuickBooks transaction with shipping cost from carrier and tracking info.
5. Click save.
6. Sync the sale from QuickBooks to ShipStation.
7. Ship the sale in ShipStation by creating a label.
8. Sync the sale to QuickBooks.

Here is a sample sale from QuickBooks Desktop:

Can I map a shipping cost as $0, based on a rule?

In this example, we will say if the selling channel is Free QB Sales, then map $0 as the cost. Here is the field in ShipStation:

Here are the steps:

1. Go to the rules engine.
2. Click add new rule.
3. As the action, choose map shipping cost.
4. In the rule field, enter these values: Free QB Sales as the value to compare, equals as the comparison, and selling channel as the field.
5. In the map to, enter 0.

Can I offer free shipping, if the order total is greater than $100?

Here are the steps:

1. Go to the rules engine.
2. Click add new rule.
3. As the action, choose map shipping cost.
4. In the rule field, enter these values:100 as the value to compare, equals as the comparison, and order total as the field.
5. In the map to, enter 0.