Skip to content
Book a demoStart free
Connectors

ShipStation connector

Set up the ShipStation connector in Kaivo: authentication, configuration, the 11 BigQuery tables it syncs, and answers to common questions.

ShipStation connector pricing, tier and credits on kaivo.io

Kaivo is a fully managed data platform that syncs your ShipStation data into a Google BigQuery warehouse and keeps it up to date automatically. There is no pipeline to build and no infrastructure to run, so you can spend your time analysing your e-commerce data instead of moving it.

Sync your ShipStation data into BigQuery with Kaivo to analyse orders, fulfilment, and shipping across your stores.

CategoryE-commerce
AuthenticationAPI key
SetupSelf-service

Getting started with the ShipStation connector

Section titled “Getting started with the ShipStation connector”
  1. Sign up for Kaivo and create a workspace.
  2. Connect your ShipStation account.
  3. Choose which tables to sync.
  4. Wait for the initial sync to finish.
  5. Query your data in BigQuery or your favourite AI or BI tool.

Authenticate with your API Secret.

Field Description
API Secret

When you set up the connector, you provide:

Field Description
API Key
Start Date
Any data before this date will not be fetched.

|

Tables and columns synced from ShipStation

Section titled “Tables and columns synced from ShipStation”

Kaivo syncs 11 tables from ShipStation into a dedicated dataset in your BigQuery warehouse. Click any table to see its columns and types.

carriers (10 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
code STRING
name STRING
balance FLOAT64
primary BOOL
nickname STRING
account_number STRING
shipping_provider_id FLOAT64
requires_funded_account BOOL
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
customers (16 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
city STRING
name STRING
email STRING
phone STRING
state STRING
company STRING
street1 STRING
street2 STRING
create_date STRING
customer_id FLOAT64
modify_date STRING
postal_code STRING
country_code STRING
address_verified STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: customers__marketplace_usernames

Section titled “Subtable: customers__marketplace_usernames”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
username STRING
create_date STRING
customer_id FLOAT64
modify_date STRING
marketplace STRING
marketplace_id FLOAT64
customer_user_id FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
fulfillments (28 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
ship_to__city STRING
ship_to__name STRING
ship_to__phone STRING
ship_to__state STRING
ship_to__company STRING
ship_to__country STRING
ship_to__street1 STRING
ship_to__street2 STRING
ship_to__postal_code STRING
user_id STRING
voided BOOL
order_id FLOAT64
ship_date STRING
void_date STRING
create_date STRING
carrier_code STRING
order_number STRING
delivery_date STRING
customer_email STRING
fulfillment_id FLOAT64
void_requested BOOL
fulfillment_fee FLOAT64
tracking_number STRING
marketplace_notified BOOL
fulfillment_service_code STRING
fulfillment_provider_code STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
marketplaces (8 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
name STRING
can_refresh BOOL
marketplace_id FLOAT64
can_confirm_shipments BOOL
supports_custom_mappings BOOL
supports_custom_statuses BOOL
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
orders (66 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
gift BOOL
bill_to__name STRING
bill_to__company STRING
ship_to__city STRING
ship_to__name STRING
ship_to__phone STRING
ship_to__state STRING
ship_to__company STRING
ship_to__country STRING
ship_to__street1 STRING
ship_to__street2 STRING
ship_to__street3 STRING
ship_to__postal_code STRING
ship_to__residential BOOL
ship_to__address_verified STRING
weight__units STRING
weight__value FLOAT64
weight__weight_units FLOAT64
order_id FLOAT64
order_key STRING
ship_date STRING
order_date STRING
tax_amount FLOAT64
amount_paid FLOAT64
create_date STRING
customer_id FLOAT64
dimensions__units STRING
dimensions__width FLOAT64
dimensions__height FLOAT64
dimensions__length FLOAT64
modify_date STRING
order_total FLOAT64
carrier_code STRING
gift_message STRING
order_number STRING
order_status STRING
package_code STRING
payment_date STRING
service_code STRING
confirmation STRING
customer_email STRING
customer_notes STRING
hold_until_date STRING
internal_notes STRING
shipping_amount FLOAT64
advanced_options__store_id FLOAT64
advanced_options__bill_to_party STRING
advanced_options__warehouse_id FLOAT64
advanced_options__custom_field1 STRING
advanced_options__custom_field2 STRING
advanced_options__merged_or_split BOOL
advanced_options__non_machinable BOOL
advanced_options__contains_alcohol BOOL
advanced_options__saturday_delivery BOOL
advanced_options__bill_to_country_code STRING
customer_username STRING
insurance_options__provider STRING
insurance_options__insured_value FLOAT64
insurance_options__insure_shipment BOOL
externally_fulfilled BOOL
international_options__contents STRING
international_options__non_delivery STRING
externally_fulfilled_by STRING
requested_shipping_service STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
sku STRING
upc STRING
name STRING
weight__units STRING
weight__value FLOAT64
weight__weight_units FLOAT64
image_url STRING
quantity FLOAT64
product_id FLOAT64
unit_price FLOAT64
adjustment BOOL
create_date STRING
modify_date STRING
order_item_id FLOAT64
fulfillment_sku STRING
warehouse_location STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: orders__advanced_options__merged_ids

Section titled “Subtable: orders__advanced_options__merged_ids”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: orders__international_options__customs_items

Section titled “Subtable: orders__international_options__customs_items”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
value FLOAT64
quantity FLOAT64
customs_item_id FLOAT64
country_of_origin STRING
harmonized_tariff_code STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
products (8 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
sku STRING
name STRING
price FLOAT64
active BOOL
product_id FLOAT64
create_date STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
shipments (45 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
ship_to__city STRING
ship_to__name STRING
ship_to__phone STRING
ship_to__state STRING
ship_to__company STRING
ship_to__country STRING
ship_to__street1 STRING
ship_to__street2 STRING
ship_to__postal_code STRING
user_id STRING
voided BOOL
weight__units STRING
weight__value FLOAT64
weight__weight_units FLOAT64
order_id FLOAT64
order_key STRING
ship_date STRING
void_date STRING
create_date STRING
dimensions__units STRING
dimensions__width FLOAT64
dimensions__height FLOAT64
dimensions__length FLOAT64
shipment_id FLOAT64
batch_number STRING
carrier_code STRING
order_number STRING
package_code STRING
service_code STRING
warehouse_id FLOAT64
confirmation STRING
shipment_cost FLOAT64
customer_email STRING
insurance_cost FLOAT64
is_return_label BOOL
tracking_number STRING
advanced_options__store_id FLOAT64
advanced_options__bill_to_country_code STRING
insurance_options__provider STRING
insurance_options__insured_value FLOAT64
insurance_options__insure_shipment BOOL
notify_error_message STRING
marketplace_notified BOOL
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
sku STRING
name STRING
weight__units STRING
weight__value FLOAT64
weight__weight_units FLOAT64
image_url STRING
quantity FLOAT64
product_id FLOAT64
tax_amount FLOAT64
unit_price FLOAT64
adjustment BOOL
create_date STRING
modify_date STRING
line_item_key STRING
order_item_id FLOAT64
shipping_amount FLOAT64
warehouse_location STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: shipments__shipment_items__options

Section titled “Subtable: shipments__shipment_items__options”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
name STRING
value STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
stores (18 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
phone STRING
active BOOL
store_id FLOAT64
website STRING
store_name STRING
create_date STRING
modify_date STRING
account_name STRING
auto_refresh BOOL
company_name STRING
public_email STRING
refresh_date STRING
marketplace_id FLOAT64
integration_url STRING
marketplace_name STRING
last_refresh_attempt STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
status_key STRING
order_status STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
users (5 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
name STRING
user_id STRING
user_name STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
warehouses (27 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
is_default BOOL
create_date STRING
warehouse_id FLOAT64
origin_address__city STRING
origin_address__name STRING
origin_address__phone STRING
origin_address__state STRING
origin_address__company STRING
origin_address__country STRING
origin_address__street1 STRING
origin_address__street2 STRING
origin_address__street3 STRING
origin_address__postal_code STRING
origin_address__residential BOOL
return_address__city STRING
return_address__name STRING
return_address__phone STRING
return_address__state STRING
return_address__company STRING
return_address__country STRING
return_address__street1 STRING
return_address__street2 STRING
return_address__street3 STRING
return_address__postal_code STRING
warehouse_name STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
webhooks (10 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
url STRING
name STRING
active BOOL
hook_type STRING
seller_id FLOAT64
web_hook_id FLOAT64
message_format STRING
is_label_api_hook BOOL
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

After the first load, Kaivo keeps your BigQuery warehouse up to date for you. Where ShipStation supports it, each sync pulls only new and changed records so it stays fast; otherwise it refreshes the whole table. Every record keeps its original ID, so you won’t get duplicate rows.

How long does the initial sync take for ShipStation?

Section titled “How long does the initial sync take for ShipStation?”

It depends on how much history is in your ShipStation account. Most initial syncs finish within minutes, while large accounts can take a few hours. After that, syncs only fetch new and changed records, so they’re much faster.

Yes. You pick which tables to sync when you set up the connection and can change the selection later. Tables you don’t select are never copied to your warehouse.

What happens when ShipStation’s schema changes?

Section titled “What happens when ShipStation’s schema changes?”

New fields are never added automatically. You choose which fields to sync, so data you haven’t selected (sensitive personal data, for example) never lands in your warehouse. When a new field appears, it becomes available for you to add. What happens to removed or renamed fields depends on a table’s sync mode: full-refresh tables always match what’s currently in ShipStation, so dropped fields disappear, while incremental tables keep their existing columns and history, so an old field stays and newly added fields fill in over time.

How do I handle GDPR or data deletion requests?

Section titled “How do I handle GDPR or data deletion requests?”

Your data lives in your own Kaivo-managed BigQuery warehouse, so the most direct option is to delete or anonymise specific records right in BigQuery. If you delete data in ShipStation instead, full-refresh tables drop it on the next sync, while incremental tables keep it, so you would remove the row in BigQuery or ask us to run a full refresh. To remove everything, delete the ShipStation connector in Kaivo and all of its synced data is deleted with it.

Use orders and fulfillments to track fulfilment volume and speed over time.

Join shipments with carriers to analyse shipping spend by carrier.

Use stores and marketplaces to compare fulfilment across sales channels.

Use ShipStation data in your AI and BI tools

Section titled “Use ShipStation data in your AI and BI tools”

Once ShipStation data lands in your Kaivo-managed BigQuery warehouse, you can explore it with AI tools or any BI tool that connects to BigQuery. Here’s how the most common destinations work with ShipStation data.

Use Kaivo’s MCP server to give Claude secure, workspace-scoped access to your data. Setup guide →

Microsoft’s BI tool with a native BigQuery connector. Supports direct query and scheduled refresh. Setup guide →

Free Google BI tool with native BigQuery support. One-click connection to your Kaivo warehouse; great for SMB teams on Google Workspace. Setup guide →

The premium analytics standard, with native BigQuery integration. Setup guide →

Use Connected Sheets to query BigQuery directly from a spreadsheet, with no SQL. Setup guide →

Connect via Power Query’s BigQuery connector. Setup guide →

Open-source BI tool with strong BigQuery support. Setup guide →

See our pricing page for ShipStation connector pricing and plan details.