ShipStation

ShipStation is a cloud platform that allows private individuals and companies to accept payments over the Internet.

Data integration: Skyvia supports importing data to and from ShipStation, exporting ShipStation data to CSV files, replicating ShipStation data to relational databases, and synchronizing ShipStation data with other cloud apps and relational databases.

Backup: Skyvia Backup supports ShipStation backup.

Query: Skyvia Query supports ShipStation.

Establishing Connection

To create a connection to ShipStation, specify an API Key and API Secret.

Getting Credentials

To locate API key and API Secret, do the following:

  1. Go to your ShipStation account.
  2. Click the gear icon in the upper left corner.
  3. Click API Settings -> Generate API Keys.

    Connection Editor window

  4. Copy the generated API Key and API Secret.

Creating Connection

To connect to ShipStation, enter the obtained API Key and API Secret to the corresponding boxes in the Connection Editor.

Connection Editor window

Connector Specifics

Object Peculiarities

Orders

For better query performance, use filters by the CreateDateStart, CreateDateEnd, OrderDateStart, OrderDateEnd, ModifyDateStart, ModifyDateEnd, PaymentDateStart, and PaymentDateEnd fields with the = operator for this object in your queries and integrations. These fields are designed for filtering only, they return empty results when querying.

OrderItems

The Orders object has a complex structure. Its Items field contains the nested array storing order details. For user convenience, we created a separate OrderItems object storing the Items field content in user-friendly format.

Incremental Replication and Synchronization

Skyvia supports Incremental Replication for the following ShipStation objects: Customers, Fulfillments, OrderItems, Orders, Products, Shipments, Stores, Warehouses. Skyvia can track only new records for the Fulfillments, Shipments, and Warehouses objects.

Skyvia supports Synchronization for the Orders and Warehouses objects. Skyvia can track only new records for the Warehouses object

Supported Actions

Skyvia supports all the common actions for ShipStation