Shopify Connector
Sync products, orders, and customers from a single Shopify store into your data warehouse with incremental sync and a read-only custom app token.
Evaluating against Fivetran? See how Supaflow handles Shopify pricing, connector quality, and Snowflake deployment side-by-side.
Supaflow vs FivetranWhy Supaflow
All connectors included
Every connector is available on every plan. Pricing does not increase with connector count.
Pay for compute, not rows
Credit-based pricing. Usage scales with your pipelines, not with row counts.
One platform
Ingestion, dbt Core transformation, reverse ETL, and orchestration in a single workspace.
Capabilities
Custom App Token Authentication
Connect with a Shopify custom app Admin API access token. The connector is read-only; required scopes are read_products, read_orders, read_all_orders, and read_customers. No OAuth flow, no public app to install.
Incremental Sync for Every Supported Object
Products, Orders, and Customers all sync incrementally. After the initial backfill, each run fetches only records that have changed since the last sync.
Control the Initial Backfill
Use Start Date to cap how far back the first sync reaches, or leave it blank to load all available history. Useful on stores with years of orders when you only need recent data.
Order Status Filter
Scope Orders to open, closed, cancelled, or all statuses without affecting Products or Customers. Right for teams that want operational orders in the warehouse but do not need cancelled history.
Built-in Rate Limit Handling
Shopify applies API rate limits to the Admin API. Supaflow handles transient rate limiting automatically with retry and backoff, so busy stores do not need a bespoke throttling setup.
Supported Objects
Incremental
Products
Product catalog records from your Shopify store.
Orders
Order records with order-level commerce data. Scoped by the Order Status Filter.
Customers
Customer records from your Shopify store.
Not yet supported
multiple stores per source, Shopify Partner API, inventory, collections, discounts, fulfillments as a separate object, metafields, locations, transactions, refunds as a separate object, gift cards, draft orders
Not exposed by the current connector. Email support@supa-flow.io with the objects you need -- expansion is prioritized by customer demand.
How It Works
Create a Shopify custom app
In your Shopify admin, go to Settings > Apps and sales channels > Develop apps and create a new custom app. Under Configuration > Admin API integration, grant read_products, read_orders, and read_customers. read_all_orders is a protected Shopify scope that requires additional approval before it becomes available on the app -- it is required to sync orders older than roughly 60 days, so request access early (see Shopify's API access scopes documentation at https://shopify.dev/docs/api/usage/access-scopes#orders-permissions for the current approval process). Once scopes are in place, install the app and copy the Admin API access token (starts with shpat_) -- Shopify shows it only once.
Find your *.myshopify.com URL
Supaflow requires the store's permanent *.myshopify.com URL, not a custom storefront domain and not an admin.shopify.com/store/... admin URL. You can find it in Shopify admin under Settings > Domains, listed as the default myshopify.com URL.
Enter the credentials in Supaflow
Create a new Shopify source and paste the *.myshopify.com URL and the Admin API access token. Optionally set Start Date to cap the initial backfill window, Order Status Filter to scope which orders to sync, and Items Per Page (up to 250) if you want to tune batch size.
Test and save
Click Test & Save. Supaflow validates the URL, token, and required scopes before the source is saved, so missing scopes surface immediately instead of as empty tables later.
Use Cases
Commerce reporting in the warehouse
Land Products, Orders, and Customers in your warehouse so finance and growth teams can build order volume, AOV, repeat-purchase, and cohort reports in SQL alongside data from the rest of the stack.
Customer 360 with marketing and support tools
Join Shopify customers and orders with data from marketing, billing, and support connectors in the warehouse. Build a single-customer view without relying on a vendor-hosted CDP.
Long-term order history for compliance and audit
Keep a warehouse copy of every order beyond Shopify's default order-history window, so finance and audit teams can run multi-year queries over commerce data.
Frequently Asked Questions
Can one source sync more than one Shopify store?
What goes in the Shop URL field?
Why does Supaflow need the read_all_orders scope?
Does the connector write back to Shopify?
Can I sync inventory, fulfillments, transactions, or refunds?
How does Supaflow handle Shopify rate limits?
Can I run the Shopify pipeline natively inside Snowflake?
Related Resources
Need a connector we don't support yet?
Build one with AI-powered Connector Dev Skills.
Learn More About the Connector SDK
