Cloud Cart Connector can sync orders from ShipStation to QuickBooks and vice versa. This article guides you through the set-up.
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 cloudcartconnector.com with your Intuit account.
- 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 do I export shipped orders only?
By default, Cloud Cart Connector will sync orders as soon as they are created in ShipStation. If you want Cloud Cart to insert the tracking number and date onto orders, you need to export shipped orders. Here are the steps:
- On the Cloud Cart Connector configure page, click the order export to QB tab.
- In the order status field, enter shipped.
- Click save and sync.
Send Orders from ShipStation to QuickBooks
This is the default behavior of our solution. On the configure page, scroll down and complete the settings. Under task settings, you'll see orders to QuickBooks is checked. Click save and sync.
Send Orders from QuickBooks to ShipStation
Cloud Cart Connector requires a special address format to process orders. For more info, read this KB. To set-up the sync, follow these steps:
- On the configure page, scroll down to task settings.
- Make sure only orders from QuickBooks to ShipStation is checked.
- Go to the advanced tab.
- Adjust the times for orders from QuickBooks.
- Click save and sync.
Here is an example order. Note that the dimensions and weight are prepopulated based on the SKUs in the order. To prepopulate shipping information, you can use an automation rule:
- On the top right, click the gear
- On the left, click automation rules
- See this sample
For more info on automation rules, please contact ShipStation. You can set up rules based on a SKU or total quantity.
There is no custom store to set-up in ShipStation because our system creates the store. Our system will create a new store called manual orders.
Your total discount should not exceed the total cost of the order. Since ShipStation never sends coupon codes or exact discount details, here's how it's calculated:
On one order, you have the customer purchasing $104 worth of product and using a $110 coupon code. On another order, a customer purchased goods for $111 and use a $110 discount. The first order has $0 as the amount paid. The second order has $1 as the amount paid. Let me explain how the discount calculation works:
Total Discount cannot dip below $0
Total of Order (111) - Total - Discount (1) = Total Discount (110)
Total of Order (104) - Total - Discount (110 - 104) = Total Discount (0, due to rule above.)
Here is a demo of a two way sync of QuickBooks Online and ShipStation: