Shipstation

Certain information in this article may be missing or out of date. We are in the process of updating the content.

ShipStation is a web-based shipping solution that streamlines order fulfillment for your online business. This article will give you an overview of the ShipStation/Grow integration.

Connecting to ShipStation

Log in to Grow and select Settings under your name in the top-right corner

1. Click on the Data tab at the top left of the global navigation.
2. Select Connections in the Data Library section.
3. Click on the blue Connect button, search for ShipStation, and click on the logo.
4. On the new pop-up screen, enter your connection nickname, API key, and API secret.
   To get your API Key and API Secret, follow these steps:
• In your ShipStation account, select the gear icon in the top right corner.
• Select API Settings from your Account heading.
• Select Generate New API Keys and copy the API Key and API Secret.

You are now connected to ShipStation!

Data Warehousing

ShipStation is on the Grow Data Warehouse, which we highly recommend you use. For more information about warehousing your data, visit the Data Warehouse Help Article.

Tables

The list of tables available will depend on your unique ShipStation project. You can expect to see one table per dataset associated with the project ID in your connection.

Suggested Tables

The following suggested tables are available in Grow. These are toggled on by default when you sync your data for the first time.

• Customers
• Orders
• Products
• Shipments

Other Tables

These additional tables are available in Grow.

• Carriers
• Fulfillments
• Packages
• Stores
• Users
• Ship From Locations

Warehousing your Data

1. In the Connections Overview page, click on your ShipStation connection.
   This opens the Connection Details page.
2. Select the Manage Connection button inside the Connection Details section to open the warehouse table selection flow.
3. After selecting the data that you want stored in the Data Warehouse, click the Sync & Store button at the bottom of the Manage Connection page.
   This begins the initial population of your warehouse with the tables you defined. Populating your data warehouse for the first time may take a while, sometimes up to several hours.

You may continue working within the app while your data is In Queue or Processing.

If your data source is not already connected, refer to the Connecting to a Data Source for more details.

Sync Interval

Full Sync

The default sync interval is 1 week.

Full sync intervals is 12 hours for Other Tables.

Incremental Sync

Incremental Sync is available for all ShipStation warehouse tables. The default incremental sync interval is 1 hour.

Incremental sync is not supported for Other Tables.

To learn more about sync intervals and how to adjust the default settings, please visit the Sync section of the Data Warehouse help article.

Direct Query

A direct query connection can be used to pull data into Grow. With abnormal usage, Direct Query can run into API limitations depending on the data source. For this reason, we recommend that you use Grow's Data Warehouse for a more performant, reliable experience.

Endpoints

Below is a list of the endpoints that the Grow/Shipstation integration offers, along with a description of the data each report provides.

• List of Orders: All orders matching the specified date range, including order ID, number, order date, created date, payment date, ship by date, status, customer ID, customer username, order total, amount paid, shipping amount, notes, payment method, carrier code, confirmation, ship date, hold until date, package details, insured value, tag IDs, user ID, item count, etc.
• Order Line Items: The items listed in each order, including name, picture, weight, price, product ID, and SKU.
• List of Products: All products, including product ID, SKU, name, price, cost, product category, product type, warehouse location, package code, customs info, country code, tags, etc.
• List of Customers: All customers, including customer ID, created date, modified date, name, company, contact info, and address.
• List of Shipments: All shipments matching the specified date range, including shipment ID, order key, contact info, order number, created date, ship date, shipment cost, insurance cost, tracking number, batch number, carrier code, confirmation, warehouse ID, item count, etc.
• Shipment Line Items: The items listed in each shipment, including name, picture, weight, price, product ID, and SKU.
• List of Carriers: All shipping partners, including name, code, account number, requires funded account , balance, nickname, shipping provider ID, and primary.
• List of Packages: All packages assigned to a specified carrier, including carrier code, package code, name, domestic, and international.
• List of Stores: All installed stores on your account, including ID, name, marketplace ID and name, account name, email, integration URL, active, company name, phone, public Email, website, refresh date, last refresh attempt, created date, modify date, and auto refresh.

FAQs + Tips and Tricks

Rate Limits

ShipStation has set specific rate limits in order to "ensure consistent application performance and increased scalability." The current Rate limit for each set of the API Key and Secret is 40 requests per minute. Once you have reached the limit for the minute, you won't be able to make more requests until the time resets at the beginning of the next 60 seconds.