🥳 Introducing our new Flex Connector! 👉 Learn more Introducing our new Flex Connector!

Sync, store and access your Shopify data

It's easier than ever to access your Shopify data with Panoply's Shopify Snap Connector. Consolidate Shopify, plus all other business data, in a secure data warehouse for a single source of truth. Explore it with our SQL workbench, in-product graphs and charts, or connect your favorite BI tools for advanced reporting and analysis.

Sync Shopify data

Some of the available tables Panoply can collect from Shopify include:
Orders
An order is a customer's completed request to purchase one or more products from a shop. An order is created when a customer completes the checkout process, during which time they provide an email address or phone number, billing address, and payment information.
Customers
The Customer resource stores information about a shop's customers, such as their contact details, their order history, and whether they've agreed to receive email marketing. The Customer resource also holds information on the status of a customer's account.
Products
The Product resource lets you update and create products in a merchant's store. You can use product variants with the Product resource to create or update different versions of the same product. You can also add or update product images.
Abandoned Checkouts
You can query the Checkout resource to return abandoned checkouts. A checkout is considered abandoned when a customer leaves the checkout after the first page without completing their purchase.
Custom Collection
A custom collection is a grouping of products that a merchant can create to make their store easier to browse. The merchant creates a custom collection and then selects the products that will go into it.
Metafields
The Metafield resource allows you to add additional information to other Admin API resources. Metafields can be used in several ways, such as to add a summary to a blog post or to share information with other Shopify apps.
Collects
The Collect resource connects a product to a custom collection. Collects are meant for managing the relationship between products and custom collections. For every product in a custom collection, there is a collect that tracks the ID of both product and custom collection.

Sync Shopify data with multiple sources in Panoply, then access it via your BI tool

Shopify + AdRoll
AdRoll
Ads
Shopify + AfterShip
AfterShip
Retail
Shopify + Alteryx
Alteryx
ETL
Shopify + Amazon Ads
Amazon Ads
Ads
Shopify + Amazon Aurora PostgreSQL
Amazon Aurora PostgreSQL
Databases
Shopify + Amazon Cloudfront
Amazon Cloudfront
Services
Shopify + Amazon DynamoDB
Amazon DynamoDB
Databases
Shopify + Amazon Kinesis Firehose
Amazon Kinesis Firehose
Services
Shopify + Amazon Marketplace
Amazon Marketplace
E-commerce
Shopify + Amazon QuickSight
Amazon QuickSight
BI Tools
Shopify + Amazon S3
Amazon S3
Services
Shopify + Amazon Seller
Amazon Seller
Retail
Shopify + Apache Superset
Apache Superset
BI Tools
Shopify + Apache Zeppelin
Apache Zeppelin
BI Tools
Shopify + Apple App Store
Apple App Store
Mobile
Shopify + Apple Search Ads
Apple Search Ads
Ads
Shopify + AppsFlyer
AppsFlyer
Mobile
Shopify + Asana
Asana
Project Management
Shopify + Attunity
Attunity
ETL
Shopify + Autopilot
Autopilot
Marketing Automation
Shopify + Azure Blob Storage
Azure Blob Storage
Cloud Storage
Shopify + BigCommerce
BigCommerce
E-commerce
Shopify + BigQuery
BigQuery
Data Warehouses
Shopify + Bing Ads
Bing Ads
Ads
Shopify + Birst
Birst
BI Tools
Shopify + Braintree Payments
Braintree Payments
Payment Processing
Shopify + Branch
Branch
Analytics
Shopify + BranchTrack
BranchTrack
Sales
Shopify + Campaign Monitor
Campaign Monitor
Marketing Automation
Shopify + CaptivateIQ
CaptivateIQ
Sales
Shopify + CARTO
CARTO
BI Tools
Shopify + Chargebee
Chargebee
Accounting
Shopify + Clari
Clari
Sales
Shopify + Close
Close
Sales
Shopify + Codat
Codat
Accounting
Shopify + Contact Pigeon
Contact Pigeon
Marketing Automation
Shopify + Contentful
Contentful
Services
Shopify + Count
Count
BI Tools
Shopify + Crashlytics
Crashlytics
Developer Tools
Shopify + Criteo
Criteo
Retail
Shopify + CSV
CSV
Files
Shopify + Customer.io
Customer.io
Marketing Automation
Shopify + Databricks
Databricks
BI Tools
Shopify + Delighted
Delighted
Customer Support
Shopify + Desk
Desk
Sales
Shopify + Domo
Domo
BI Tools
Shopify + Draxlr
Draxlr
BI Tools
Shopify + Drip
Drip
E-commerce
Shopify + Dropbox
Dropbox
Files
Shopify + EasyPayDirect
EasyPayDirect
Payment Processing
Shopify + Elasticsearch
Elasticsearch
Databases
Shopify + Eloqua
Eloqua
Marketing Automation
Shopify + Enchant
Enchant
Customer Support
Shopify + etleap
etleap
ETL
Shopify + Facebook Ads
Facebook Ads
Ads
Shopify + Facebook Pages
Facebook Pages
Social
Shopify + Facebook Posts
Facebook Posts
Social
Shopify + Fivetran
Fivetran
ETL
Shopify + FormKeep
FormKeep
Marketing Automation
Shopify + Freshdesk
Freshdesk
Customer Support
Shopify + Front
Front
Project Management
Shopify + GitHub
GitHub
Developer Tools
Shopify + GitLab
GitLab
Developer Tools
Shopify + GoodData
GoodData
BI Tools
Shopify + Google Ads
Google Ads
Ads
Shopify + Google Analytics
Google Analytics
Analytics
Shopify + Google Analytics Ecommerce
Google Analytics Ecommerce
E-commerce
Shopify + Google Cloud SQL MySQL
Google Cloud SQL MySQL
Databases
Shopify + Google Cloud SQL Postgres
Google Cloud SQL Postgres
Cloud Storage
Shopify + Google Cloud Storage
Google Cloud Storage
Cloud Storage
Shopify + Google Drive
Google Drive
Files
Shopify + Google Search Console
Google Search Console
Analytics
Shopify + Google Sheets
Google Sheets
Files
Shopify + Grafana
Grafana
BI Tools
Shopify + Grin
Grin
Services
Shopify + Harvest
Harvest
Project Management
Shopify + Harvest Forecast
Harvest Forecast
Project Management
Shopify + Help Scout
Help Scout
Customer Support
Shopify + Heroku Postgres
Heroku Postgres
Databases
Shopify + Holistics
Holistics
BI Tools
Shopify + HubSpot
HubSpot
CRM
Shopify + IBM Cognos
IBM Cognos
BI Tools
Shopify + IBM DB2
IBM DB2
Developer Tools
Shopify + Informatica PowerCenter
Informatica PowerCenter
ETL
Shopify + Instagram for Business
Instagram for Business
Social
Shopify + Intercom
Intercom
Sales
Shopify + Invoiced
Invoiced
Services
Shopify + Iterable
Iterable
Marketing Automation
Shopify + Jira
Jira
Project Management
Shopify + JSON
JSON
Files
Shopify + Julia
Julia
BI Tools
Shopify + Jupyter
Jupyter
BI Tools
Shopify + Kandji
Kandji
Security
Shopify + Klaviyo
Klaviyo
E-commerce
Shopify + Klipfolio
Klipfolio
BI Tools
Shopify + KNIME
KNIME
BI Tools
Shopify + LeafLink
LeafLink
Retail
Shopify + Lever
Lever
CRM
Shopify + LinkedIn Ads
LinkedIn Ads
Ads
Shopify + Looker
Looker
BI Tools
Shopify + Looker Studio
Looker Studio
BI Tools
Shopify + Luzmo
Luzmo
BI Tools
Shopify + Magento
Magento
E-commerce
Shopify + MailChimp
MailChimp
Marketing Automation
Shopify + Mailjet
Mailjet
Marketing Automation
Shopify + MariaDB
MariaDB
Databases
Shopify + Marketo
Marketo
Marketing Automation
Shopify + Matillion
Matillion
ETL
Shopify + Mavenlink
Mavenlink
Project Management
Shopify + Maverick Payments
Maverick Payments
Payment Processing
Shopify + Maxio
Maxio
Accounting
Shopify + Metabase
Metabase
BI Tools
Shopify + Microsoft Excel
Microsoft Excel
Files
Shopify + Microsoft OneDrive
Microsoft OneDrive
Cloud Storage
Shopify + Microsoft SQL Server
Microsoft SQL Server
Databases
Shopify + MicroStrategy
MicroStrategy
BI Tools
Shopify + Mode Analytics
Mode Analytics
BI Tools
Shopify + MongoDB
MongoDB
Databases
Shopify + MySQL
MySQL
Databases
Shopify + NetSuite
NetSuite
Accounting
Shopify + Optimizely
Optimizely
Marketing Automation
Shopify + Oracle Database
Oracle Database
Databases
Shopify + Pandas
Pandas
BI Tools
Shopify + Panintelligence
Panintelligence
BI Tools
Shopify + Pardot
Pardot
CRM
Shopify + Particle
Particle
Services
Shopify + Payline
Payline
E-commerce
Shopify + PayPal
PayPal
E-commerce
Shopify + Pentaho
Pentaho
BI Tools
Shopify + Pinterest
Pinterest
Social
Shopify + Pipedrive
Pipedrive
Sales
Shopify + Pivotal Tracker
Pivotal Tracker
Project Management
Shopify + Plotly
Plotly
BI Tools
Shopify + PopSQL
PopSQL
BI Tools
Shopify + PostgreSQL
PostgreSQL
Databases
Shopify + Power BI
Power BI
BI Tools
Shopify + Python
Python
BI Tools
Shopify + Qlik
Qlik
BI Tools
Shopify + QuickBase
QuickBase
Developer Tools
Shopify + Quickbooks
Quickbooks
Accounting
Shopify + R
R
BI Tools
Shopify + Rakuten
Rakuten
Services
Shopify + Recharge
Recharge
Payment Processing
Shopify + Recurly
Recurly
Payment Processing
Shopify + Redash
Redash
BI Tools
Shopify + Reddit
Reddit
Social
Shopify + Redshift
Redshift
Data Warehouses
Shopify + Referral SaasQuatch
Referral SaasQuatch
Marketing Automation
Shopify + RingCentral
RingCentral
Shopify + Rivery
Rivery
ETL
Shopify + Sailthru
Sailthru
Marketing Automation
Shopify + Salesforce
Salesforce
CRM
Shopify + Salesforce Marketing Cloud
Salesforce Marketing Cloud
Marketing Automation
Shopify + SeekWell
SeekWell
BI Tools
Shopify + Segment
Segment
Analytics
Shopify + Selligent
Selligent
Marketing Automation
Shopify + SendGrid
SendGrid
Marketing Automation
Shopify + Sendwithus
Sendwithus
Marketing Automation
Shopify + SentinelOne
SentinelOne
Security
Shopify + SFTP
SFTP
Services
Shopify + Shiny
Shiny
BI Tools
Shopify + Shippo
Shippo
E-commerce
Shopify + Singer
Singer
ETL
Shopify + Skyvia
Skyvia
ETL
Shopify + SnapLogic
SnapLogic
ETL
Shopify + Sparkpost
Sparkpost
Marketing Automation
Shopify + SphereWMS
SphereWMS
Services
Shopify + Spree Commerce
Spree Commerce
E-commerce
Shopify + SQL
SQL
BI Tools
Shopify + Square
Square
Payment Processing
Shopify + Stitch
Stitch
ETL
Shopify + Stripe
Stripe
Payment Processing
Shopify + Sybase
Sybase
ETL
Shopify + Tableau
Tableau
BI Tools
Shopify + Taboola
Taboola
Ads
Shopify + Talend
Talend
ETL
Shopify + Teachable
Teachable
Services
Shopify + ThoughtSpot
ThoughtSpot
BI Tools
Shopify + TIBCO Spotfire X
TIBCO Spotfire X
BI Tools
Shopify + TikTok
TikTok
Social
Shopify + Tray.io
Tray.io
Services
Shopify + Trello
Trello
Project Management
Shopify + Trevor.io
Trevor.io
BI Tools
Shopify + Twilio
Twilio
Developer Tools
Shopify + Twitter
Twitter
Social
Shopify + Twitter Ads
Twitter Ads
Ads
Shopify + Typeform
Typeform
Services
Shopify + Upload Data
Upload Data
Files
Shopify + Urban Airship
Urban Airship
Services
Shopify + Vero
Vero
Social
Shopify + Webhooks
Webhooks
Developer Tools
Shopify + WeInfuse
WeInfuse
Services
Shopify + WooCommerce
WooCommerce
E-commerce
Shopify + Wordpress
Wordpress
Databases
Shopify + Xero
Xero
Accounting
Shopify + Xplenty
Xplenty
ETL
Shopify + Yellowfin
Yellowfin
BI Tools
Shopify + Zapier
Zapier
Services
Shopify + Zendesk
Zendesk
Customer Support
Shopify + Zendesk Chat
Zendesk Chat
Customer Support
Shopify + Zendesk Sell
Zendesk Sell
CRM
Shopify + Zoho Analytics
Zoho Analytics
BI Tools
Shopify + Zoho CRM
Zoho CRM
CRM
Shopify + Zoom
Zoom
Services
Shopify + Zuora
Zuora
Services
“ Panoply has given us drastic improvements in query speed and brought all our data in one place. Our visualizations in Looker are much more fast and efficient.
John Wessel - Freshwater Systems