Connex can sync orders from ShipStation to QuickBooks and vice versa. This article guides you through the set-up.
Is there a demo?
How do I connect to ShipStation?
You must obtain an API key and API secret from ShipStation. Here are the steps:
- Log into ShipStation.
- On the top right, click the gear icon
- On the Left click account> API Settings
- If you don't see the keys, click regenerate API Keys.
- Login to our software.
- On the my connections page, choose ShipStation.
- Enter your API key and API secret.
- Leave the URL as http://www.shipstation.com.
- Click submit.
How does syncing affect the total number of sales I sync?
If you sync orders from QuickBooks to ShipStation and send tracking details back to QuickBooks, two orders are added to your yearly limit.
How do fields map with ShipStation and QuickBooks?
Here is a diagram:
ShipStation | QuickBooks |
Order Number | Order Number |
Store | QuickBooks customer, if the user maps by selling channel name. |
Order Date | Order Date |
Ship Date | Ship Date |
Internal | Line item with notes or internal notes field in QuickBooks Online |
To Buyer / Customer | QuickBooks memo field |
Shipping Paid | QuickBooks shipping amount |
Shipping Method | QuickBooks line item with shipping method or shipping method field for QuickBooks Online |
Tracking number | QuickBooks tracking number for QuickBooks Online users or line item with shipping details in QuickBooks |
Shipping cost | QuickBooks line item with shipping costs. Read the section about mapping shipping costs below this guide. |
Billing name | QuickBooks customer display name as |
Billing phone | QuickBooks customer phone |
Billing company | QuickBooks customer company |
Billing Line 1 / 2 | QuickBooks billing address |
Billing city, state, postal code, and country | QuickBooks billing address |
Shipping name | QuickBooks shipping address |
Shipping line 1/ 2 | QuickBooks address line 1 and 2 |
Shipping city, state, zip, country | QuickBooks shipping address |
Tags | Can be used for rules. No mapping on QuickBooks sales. |
Ship by | No mapping. We use ship date. |
Item name | QuickBooks item description |
Item SKU | QuickBooks item name or SKU |
Unit price | Unit price |
Tax paid | Either a QuickBooks line item or you can use it to map a QuickBooks tax code. |
Total paid | Determines whether an order is paid. |
Custom fields 1 - 3 | Use our rules engine to map these fields to and from QuickBooks. |