Line items and refunds
Order lines as their own table, plus refunds, not just order headers.
Shopify
Polytomic connects Shopify to your data warehouse, databases, and SaaS tools for ecommerce ETL. Replicate orders, line items, refunds, customers, products, and inventory into your data warehouse and other systems so commerce data can be joined to marketing spend and support, without writing code.
Inventory by location
Inventory items and levels alongside locations for stock analysis.
Version pinned and watched
A fixed API version, with deprecation warnings actively monitored.
Example workflows
Replicate Shopify orders and customers into your data warehouse
What you can sync
Shopify is supported as a source. Read orders, customers, products, and inventory, then land them in your data warehouse, databases, or SaaS tools.
From Shopify
Orders, order line items, and order refunds
Transactions and payouts
Customers, customer metafields, and abandoned checkouts
Products, custom collections, and collects
Inventory items, inventory levels, locations, and events
To your destinations
Data warehouses including Snowflake, BigQuery, and Databricks
Databases including PostgreSQL and MySQL
Cloud storage including Amazon S3 and Google Cloud Storage
SaaS tools including Salesforce, HubSpot, and Klaviyo
How it works
Connect Shopify and Polytomic reads your commerce data into your data warehouse: orders with their line items and refunds, transactions and payouts, customers, products and collections, and inventory across locations.
Order line items arriving as their own table is what makes real analysis possible. Order headers tell you revenue; line items tell you which products drove it, which is the difference between a sales number and a margin model.
- Connect Shopify to your store
- Read orders along with their line items and refunds
- Read transactions and payouts for reconciliation
- Read customers, metafields, and abandoned checkouts
- Read products, collections, inventory items, levels, and locations
- Monitor sync health, record volume, and failures from one interface
How to set up
Once the store is connected, the order, customer, product, and inventory objects appear for selection and can be pointed at any destination.
How to get connected
- 1In Polytomic, navigate to Connections, then Add Connection, then Shopify
- 2Authorize Polytomic against your store
- 3Test the connection
- 4Select orders, line items, refunds, customers, products, and inventory
- 5Choose a destination data warehouse or database
- 6Set a schedule and click Save
See the documentation for full setup details.
Frequently asked questions
Why teams choose Polytomic
No engineering required
Set up and manage syncs without writing code.
Flexible data modeling
Use SQL to define exactly what data gets synced.
Handles scale automatically
Supports large datasets with incremental syncs and bulk APIs.
Start syncing your data with Shopify in minutes
No credit card required. Free trial available.