How to Sync Shopify Data to Panoply

Syncing your Shopify data to Panoply is easy. In just 4 simple steps and a couple of minutes, you can set up a Panoply account and start syncing your Shopify data. Here’s how to do it:

4 Easy Steps

Step 1.

From the Panoply dashboard, search for Shopify or scroll down to browse all data sources. Click the Shopify icon.

A screenshot of an easy-to-use UI for connecting Shopify data to a data warehouse.

Step 2.

Enter your shop name and click Login. In the example below, the shop’s Shopify URL is https://realtrevor.myshopify.com/, so the shop name is “realtrevor”.

A screenshot showing how easy it is to connect Shopify to a data warehouse with Panoply's built-in ETL.

If you’re already logged into Shopify, Panoply will automatically connect to your store. If not, you’ll need to provide your login information.

Step 3.

Select the data you want to sync with Panoply. Click Select All or click the checkbox next to the options you want, such as Orders or Customers. Then click Save Changes.

A screenshot of the types of Shopify data available to sync with Panoply. Options include orders, customers, abandoned checkouts, metafields, smart collection, products, custom collection, and collects.

Step 4.

Once you’re happy with your selections, click Collect. Panoply will then begin syncing your Shopify data.

A screenshot highlighting the "Collect" button that will sync your Shopify data to Panoply.

Depending on the size of your store, it will take some time to sync your data. Don’t worry—when your data has successfully synced, you’ll be notified in Panoply and you’ll receive an email notification letting you know it’s ready to query.