Shopify Setup Guide
Follow our setup guide to connect Shopify to Fivetran.
Prerequisites
To connect your Shopify account to Fivetran, you need:
- Access to a Shopify account
- A shop
- You need to log in to your Shopify account before starting the setup process, if creating a connection via API.
Only use an HTTPS URL with TLS version 1.2 or above.
Schema version
If the GraphQL Schema toggle is available in the connection setup form for you, use it to choose between the Legacy and GraphQL schema for Shopify. Fivetran accounts created on or after August 1, 2025 by default and do not see the toggle. For more information, see our GraphQL vs Legacy schema documentation.
Setup instructions
Begin Fivetran configuration
- In the connection setup form, enter your chosen Destination schema name.
- Click Continue Setup with Shopify. You will be redirected to the Shopify app store.
Install Fivetran app
- On the Fivetran app page, click Log in to install.
- Log in to your Shopify account.
- In the Shopify App Store, select the store whose data you want to sync.
- Depending on whether or not your application is already installed in your Shopify account, do one of the following:
- If the app is not installed, click Install.
- If the app is already installed, click Update.
- Once you have finished, you will be redirected back to Fivetran, and the Shop name will be automatically populated.
Finish Fivetran configuration
- Click Authorize to allow Fivetran to access your Shopify account using OAuth.
- In the Historical Sync Time Frame drop-down menu, select the amount of historical data you want to include in your initial sync:
- Select Sync all historical data to sync all available historical data from your source.
- Select Sync data from selected date and choose a date in the Historical Sync Start Date field to limit the historical data synced for certain tables. This speeds up the initial sync. For a list of affected tables, see our Shopify connector historical sync time frame documentation.
- Click Save & Test. Fivetran will take it from here and sync your Shopify data.
We recommend that you create only one connection for each Shopify store.