Linking ShipStation as a source
Let AI connect your sources for you
Skip the manual setup — run this in your project and the wizard auto-detects your databases and APIs and connects them to PostHog.
Contents
The ShipStation connector syncs your order, shipment, fulfillment, product, customer, store, warehouse, user, service, package, and marketplace data into PostHog.
Adding a data source
Go to the sources tab of the data pipeline section in PostHog.
Click + New source and then click Link next to ShipStation.
You need an API key and API secret from ShipStation. In your ShipStation dashboard, go to Settings > Account > API Settings (or go directly to API Settings). Copy the API Key and API Secret values.
Note: API access requires a ShipStation plan tier that includes it. If you don't see the API Settings page, your plan may not support API access.
Back in PostHog, paste your API key and API secret into the corresponding fields and click Next.
Set up the schemas you want to sync and choose the sync method and frequency for each. Click Import when done.
Once the syncs complete, you can query your ShipStation data in PostHog.
Available tables
| Table | Description | Sync method |
|---|---|---|
customers | Customer records aggregated from orders | Full refresh |
fulfillments | Fulfillment records for orders shipped outside ShipStation | Incremental |
marketplaces | Marketplaces that can connect to ShipStation (v1 API only) | Full refresh |
orders | Customer orders imported from connected selling channels | Incremental |
packages | Package types supported by carriers connected to the account | Full refresh |
products | Products in the ShipStation catalog | Full refresh |
services | Shipping services available from carriers connected to the account | Full refresh |
shipments | Shipments created for orders, including tracking and cost details | Incremental |
stores | Connected selling channels that orders are imported from | Full refresh |
users | Users of the ShipStation account | Full refresh |
warehouses | Ship-from locations configured in ShipStation | Full refresh |
Incremental tables sync only new or updated records on each run. Full refresh tables reload all data on each sync.
For incremental tables, you can choose which cursor field to use:
- orders -
modifyDate(recommended, captures updates) orcreateDate - shipments -
createDate - fulfillments -
createDate
Configuration
| Option | Type | Required |
|---|---|---|
API key | password | Yes |
API secret (v1 only) | password | No |
Supported tables
| Table | Description | Sync method | Incremental field | Primary key |
|---|---|---|---|---|
shipments | A shipment created in ShipStation for an order, including tracking and cost details. | Incremental, Full refresh | modified_at, created_at | — |
labels | — | Incremental, Full refresh | created_at | — |
batches | — | Incremental, Full refresh | created_at | — |
manifests | — | Incremental, Full refresh | created_at | — |
pickups | — | Incremental, Full refresh | created_at | — |
carriers | — | Full refresh | — | — |
warehouses | A ship-from location (warehouse) configured in ShipStation. | Full refresh | — | — |
tags | — | Full refresh | — | — |
users | A user of the ShipStation account. | Full refresh | — | — |
services | A shipping service available from a carrier connected to the account. | Full refresh | — | — |
packages | A package type supported by a carrier connected to the account. | Full refresh | — | — |
Timestamps and timezone
ShipStation's v1 API returns all DateTime values in US Pacific time, not UTC. PostHog handles this conversion automatically during sync, but be aware of it when querying raw timestamp fields.
Troubleshooting
Authentication errors
If you see an "authentication failed" error, double-check your API key and API secret in ShipStation API Settings. Regenerating the credentials and re-entering them in PostHog can resolve stale key issues.
Access denied errors
A "denied access" error typically means your ShipStation plan doesn't include API access. Check your plan tier or contact ShipStation support.
Rate limits
ShipStation enforces a rate limit of 40 requests per minute. PostHog automatically retries rate-limited requests with backoff, so syncs may slow down but should complete without intervention.