Source connector

Shopify connector

Shopify integration for databases, warehouses and BI tools

E-commerce platform for orders, catalog, and customer data. Datrise captures Shopify entities such as orders, products, customers, inventory levels, and fulfillment events, then lands normalized and typed models for warehouse reporting, attribution, and AI workflows.

The Shopify Admin API 2026-07 (REST, legacy since Oct 2024; GraphQL is the current recommended style) authenticates with OAuth 2.0, API key, incremental runs key on updated_at field (REST updated_at_min/updated_at_max params; GraphQL updated_at:> search filter), or Bulk Operations, and Shopify caps calls at REST: 40-request leaky bucket at 2 requests/second on standard stores (400 requests / 20 requests/second on Shopify Plus); GraphQL: cost-based throttling at 100 points/second on standard stores (1,000 points/second on Plus), single query capped at 1,000 points.

Of the 5 objects, 4 sync as upserts keyed on the primary key and 1 as append-only streams, so each incremental run moves only what changed since the last watermark. Every object lands in its own table (for example `shopify_orders`) with a schema derived from the Shopify API rather than a flattened CSV, in any of the 43 supported destinations.

Datrise is in early access: pick a destination below to open the Shopify pipeline page, and join the waitlist to get the Shopify connector (ERP) with guided onboarding.

Incremental syncSchema-aware mapping43 destinations available

What Shopify data Datrise extracts

Each object lands in its own typed table. Sync mode is derived from the object: history-style objects append, everything else upserts.

Object	Landing table	Sync mode
orders	shopify_orders	Upsert by primary key, incremental on updated-at
products	shopify_products	Upsert by primary key, incremental on updated-at
customers	shopify_customers	Upsert by primary key, incremental on updated-at
inventory levels	shopify_inventory_levels	Upsert by primary key, incremental on updated-at
fulfillment events	shopify_fulfillment_events	Append-only, incremental by timestamp

Shopify API: setup facts for the connector

Verified against the vendor documentation on 2026-09-02. Unknown values are left blank rather than guessed.

API	Shopify Admin API 2026-07 (REST, legacy since Oct 2024; GraphQL is the current recommended style)
Authentication	OAuth 2.0, API key — Custom apps use a pre-generated Admin API access token (shpat_) in the X-Shopify-Access-Token header; public/embedded apps obtain offline or online tokens via OAuth 2.0.
Pagination	link_header — REST paginates via an opaque page_info cursor returned in the response Link header (limit default 50, max 250); GraphQL uses Relay-style cursor connections instead.
Rate limit	REST: 40-request leaky bucket at 2 requests/second on standard stores (400 requests / 20 requests/second on Shopify Plus); GraphQL: cost-based throttling at 100 points/second on standard stores (1,000 points/second on Plus), single query capped at 1,000 points
Incremental cursor	updated_at field (REST updated_at_min/updated_at_max params; GraphQL updated_at:> search filter), or Bulk Operations — updated_at filters have been reported to behave inconsistently in some bulk-query contexts, so webhooks are the more reliable mechanism for real-time change capture.
Webhooks	Yes — Admin API webhooks (HMAC-verified, per-topic subscriptions)
Bulk export	Yes — Bulk Operations API (bulkOperationRunQuery, JSONL output)
Deletes detectable	Yes — Dedicated deletion webhook topics per resource, e.g. products/delete, orders/delete, customers/delete

Official API reference

What bites when replicating Shopify

REST Admin API leaky bucket is 40 requests with a 2 requests/second leak rate on standard stores (400 requests / 20 requests/second on Plus); exceeding it returns HTTP 429 with a Retry-After header.
GraphQL Admin API throttles by query cost at 100 points/second (standard) or 1,000 points/second (Plus), and no single query may exceed 1,000 points regardless of plan.
REST Admin API has been legacy since October 1, 2024, and since April 1, 2025 all new public apps must be built on GraphQL.
Bulk Operations output is JSONL with an injected __parentId field on child rows, and the signed download URL expires after 1 week; only 5 concurrent bulk operations are allowed per app per shop.

Compare this against every other documented API

Popular destinations for Shopify

Choose a destination below to open the ready pipeline page.

A
Airtable
Relational spreadsheet destination for ops and go-to-market teams.
View pipeline
A
Amazon Athena
Serverless SQL over S3 data lake tables.
View pipeline
A
Amazon DynamoDB
Serverless key-value and document store on AWS.
View pipeline
A
Amazon QuickSight
AWS serverless BI with SPICE and embedded analytics.
View pipeline
A
Amazon Redshift
AWS petabyte-scale warehouse with Spectrum.
View pipeline
A
Amazon S3 Data Lake
Object storage landing zone for parquet and snapshots.
View pipeline
A
Apache Superset
Open-source BI for SQL exploration, charts, and dashboard publishing.
View pipeline
A
Azure Data Lake Storage
ADLS Gen2 object storage for analytics workloads.
View pipeline
A
Azure Synapse
Microsoft analytics workspace with SQL pools.
View pipeline

Shopify connector FAQ

What Shopify data does the connector extract?: 5 objects: orders, products, customers, inventory levels and fulfillment events. Each lands in its own table with types preserved; history-style objects (1: fulfillment events) load as append-only streams.
Is the Shopify integration incremental?: Yes. After the initial full load, every run reads only records changed since the last watermark (updated-at or event timestamp) and applies an upsert or an append depending on the object.
Where can I load Shopify data?: Into 43 destinations: relational databases, cloud warehouses, data lakes, spreadsheets and BI tools. Each Shopify → destination pair has its own page with the object-to-table mapping.

Related ERP sources

Other sources in the same category, each with its own connector page.

Early access

Launch your Shopify pipeline with guided onboarding

Join the waitlist to get priority access for Shopify integrations with guided setup, schema-aware mapping, and production-grade incremental sync.