Skip to main content
Shopify integration

Shopify data integration,
on autopilot.

Sync Shopify orders, products, customers, and inventory to any database, file store, or spreadsheet — in plain English. Live on rsync.ai Cloud, no per-row fees.

TL;DR

rsync.ai connects to Shopify via the Admin GraphQL API (v2024-10), auto-discovers your resources, and runs scheduled syncs (every minute, hour, or day — described in plain English). Customer PII is excluded from default queries. Works with Postgres, MySQL, Google Sheets, AWS S3, and cloud warehouses like BigQuery and Databricks.

  • Plain-English pipeline setup — no YAML, no DAGs
  • Auto schema discovery for orders, products, customers, collections, inventory
  • Self-host in your own VPC — coming soon (source-available, ELv2)
  • Live on rsync.ai Cloud today — sign up free, nothing to deploy
Start free

Pick your destination

Three of the most-requested Shopify sync destinations — live today.

Shopify → MySQL

Sync Shopify orders, products, customers, and inventory to MySQL on the schedule you describe. Auto schema discovery.

Shopify → PostgreSQL

Land Shopify data in Postgres. Tables live under a dedicated shopify schema. Upserts on the Shopify ID, so re-runs never duplicate rows.

Shopify → Google Sheets

Push Shopify orders into Google Sheets on a schedule — plain English setup, no Zapier task quotas, no scripts.

Shopify resources synced today

Schema for these is auto-discovered on connect via the Shopify Admin GraphQL API (v2024-10).

OrdersProductsProduct variantsCustomersInventory itemsInventory levelsCollectionsShop+ more on the roadmap (metafields, fulfillments, draft orders)

rsync.ai vs. the Shopify ETL alternatives

A quick honest comparison for syncing Shopify into your data stack.

Featurersync.aiyouFivetranAirbyteZapier
Plain-English pipeline creation
Scheduled Shopify → DB / Sheets sync
Self-host in your own VPC (coming soon)
Source-available connector code (coming soon)
Shopify customer PII excluded by default
No per-row / per-MAR pricing
Sync to Google Sheets natively

Shopify integration — frequently asked

What Shopify resources can rsync.ai sync today?

Six top-level resources, plus product variants and inventory levels: orders, products, customers, collections, inventory items, and shop — with product variants and inventory levels included alongside their parent. The MCP connector talks to the Shopify Admin GraphQL API (version 2024-10). Schema is discovered the moment you connect — you tick the resources you want to sync.

Is the Shopify sync real-time, or scheduled?

Scheduled batch today. You set the cadence in plain English — "every 5 minutes", "hourly", or "every day at 2am". Webhook-based real-time sync is on the roadmap. In practice, a 1–5 minute schedule feels real-time for any store under ~10k orders a day.

How does rsync.ai handle Shopify API rate limits?

Shopify throttles its GraphQL API on a server-side cost budget. The MCP connector paginates politely (up to 250 records per request) and backs off when Shopify says to slow down. If a sync interrupts, the next run resumes from the last saved cursor — no duplicate rows, no manual restart.

Does Shopify customer PII reach my destination?

By default, no. The MCP connector skips customer email, phone, and addresses on every query. Those fields are never fetched, so they can't reach your destination. That keeps you safely inside the Shopify Basic plan — no protected-customer-data approval needed. If you do need them, you'll be able to edit the GraphQL query in your self-hosted copy once self-hosting ships.

Can I sync from multiple Shopify stores into one destination?

Yes. Add each Shopify store as a separate connection. Each store's data lands in its own schema — `shopify_brand_a.orders`, `shopify_brand_b.orders`, and so on. No collisions, and you can join across them at query time.

What destinations does rsync.ai support for Shopify?

Built-in destinations today: PostgreSQL, MySQL, MariaDB, ClickHouse, Google Sheets, AWS S3, Google Cloud Storage, Azure Blob, and a Kafka sink for streaming, plus the BigQuery and Databricks warehouses (Snowflake and Redshift are in preview). Need something else? Point the AI Tool Generator at the destination's docs URL and it builds a working MCP connector.

How is the Shopify MCP connector licensed and priced?

rsync.ai Cloud is live today at app.rsync.ai — sign up free, nothing to deploy. Self-hosting is coming soon, when the source-available code (Elastic License 2.0) lets you run the full stack — including the Shopify MCP connector — in your own VPC, free to self-host but not resold as a managed service. No per-row, per-MAR, or per-connector fees either way.

Ship your Shopify pipeline today.

Pick a destination — MySQL, Postgres, or Google Sheets — and have data flowing in under 5 minutes.

Shopify → MySQLShopify → PostgreSQLShopify → Google Sheets