Getting Started with ShipStation

Introduction

Connex for QuickBooks 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:

  1. Log into ShipStation.
  2. On the top right, click the gear and API Settings on the left gray bar.
  3. If you don't see the keys, click regenerate API Keys:
  4. Login to connexforquickbooks.com with your Connex account.
  5. On the my connections page, choose ShipStation.
  6. Enter your API key and API secret.
  7. Leave the URL as http://www.shipstation.com.
  8. Click submit.

How do I export shipped orders only?

By default, Connex will sync orders as soon as they are created in ShipStation. If you want Connex to insert the tracking number and date onto orders, you need to export shipped orders. Here are the steps: 

  1. On the Connex configure page, click the order export to QB tab.
  2. In the order status field, enter shipped.
  3. 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.

Does your solution support split orders?

When splitting orders in ShipStation, the user has an option to fill out the amount paid fields for the new order which is being created. Make sure that the amount paid and order total fields are the same, so Connex can create payments.
 
ShipStation adds a -1 at the end of split orders. To exclude split orders from exporting, you can tell Connex to remove the -1. Connex will find a duplicate and skip it. To add the rule, read this guide.
 
What date do you use to export orders?

Connex uses the date created in ShipStation. If you imported an August order on September 15th, then you would query the order using Sept. 15th. ShipStation uses Pacific Standard Time. If you want an order on September 15th at 3:00 PM EST, query 12:00 PM.

Can I create a summary of orders?

Yes, our tool supports a summary of orders. You can summarize orders by their creation date in ShipStation or their ship date. To summarize orders by ship date, login to Connex. At the configure page, enter shipped on the second tab next to order status. ShipStation uses Pacific Standard Time. When you run the sync, the timers will reset to 12:00 AM and 11:59 PM later that day.

How does Connex determine whether an order is paid?

ShipStation has an amount paid field. If it's greater than zero or the order has shipped, then the order is paid. To mark shipped orders where paid is zero as unpaid, follow these steps:

  1. Login to Connex.
  2. Hover over the gear box.
  3. Click rules engine.
  4. Click add new rule.
  5. Add this rule.

Demo

Here is a demo of a two way sync of QuickBooks and ShipStation:

Have more questions? Submit a request
Powered by Zendesk