Shopify Setup Guide

Install Fivetran app

1. On the Fivetran app page, click Install.
2. Log in to your Shopify account.
3. In the Shopify App Store, select the store whose data you want to sync.
4. Depending on whether 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.
5. Once you have finished, you will be redirected back to Fivetran, and the Shop name will be automatically populated.

Finish Fivetran configuration

1. In the connection setup form, enter your chosen Destination schema name.
2. Select OAuth2.0 as your authentication method.
3. Click Continue Setup with Shopify. You will be redirected to the Shopify app store.
4. Click Authorize to allow Fivetran to access your Shopify account using OAuth.
5. 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.
6. Click Save & Test. Fivetran will take it from here and sync your Shopify data.

Create custom app

Follow the instructions below to create a custom app in your Shopify account and obtain the client ID and client secret required for Fivetran configuration.

1. Log in to your Shopify account.
2. Go to the dev dashboard
3. On the navigation menu, click Apps and then click Create app.
4. In the Start from Dev Dashboard section, enter an App name.
5. Click Create.
6. Selecting the 2025-10 Webhooks API version from the drop-down menu.
7. In the Scopes field in the Access section, enter the following scopes: read_analytics, read_assigned_fulfillment_orders, read_content, read_customers, read_discounts, read_draft_orders, read_files, read_fulfillments, read_gift_cards, read_inventory, read_locales, read_locations, read_marketing_events, read_merchant_managed_fulfillment_orders, read_orders, read_price_rules, read_product_listings, read_products, read_publications, read_reports, read_resource_feedbacks, read_returns, read_script_tags, read_shipping, read_shopify_payments_accounts, read_shopify_payments_disputes, read_shopify_payments_payouts, read_themes, read_third_party_fulfillment_orders, read_translations.
8. You can leave all other sections and fields unchanged, as they are not required for building or configuring a custom app.
9. Click Release.

Request API access

To add the following scopes for your custom app, ensure your Shopify account meets the following requirements. If you do not need these specific scopes, you may skip to step 3.

read_users scope

To use this scope, one of the following must be true:

• The app must be a finance embedded app.

• The app must be installed on a Shopify Plus or Advanced store.

read_all_orders scope

By default, you only have access to last 60 days' worth of orders for a store. To access all the orders, you need to request access to the read_all_orders scope from the Shopify Partners dashboard. You must explicitly request access from Shopify before installing the app. To do this, perform the following steps:

1. Go to the Shopify Partners dashboard.

2. Navigate to Apps and select your app.

3. Open the API access requests section.

4. In the Read all orders section, click Request access.

5. In the access request justification, specify that the app needs full read-only access to historical orders for long-term analytics, reconciliation, and reporting.

6. Submit the request and wait for Shopify approval.

After Shopify approves the request:

• You will then be able to add the read_all_orders scope in your app scope list.
• Install this new app version on the target store to sync all orders.

If the app was already installed before this permission was granted, you must uninstall and reinstall the app for the new scope to take effect.

Find client credentials

1. On the navigation menu in the Dev Dashboard, click your app name and select Home.
2. In the Distribution section, click Select distribution method.
3. Select the custom distribution option and click Select.
4. In the confirmation dialog box, click Select custom distribution.
5. In the Custom distribution section, enter the Store domain.
6. Click Generate link.
7. Copy the generated link and paste it into your browser. You will be redirected to your Shopify account, where you can select the store in which you want to install the custom app.
8. On the navigation menu in the Dev Dashboard, click your app name and select Settings.
9. In the Credentials section, make a note of the client ID and client secret.

Finish Fivetran configuration

1. In the connection setup form, enter your chosen Destination schema name.
2. Select Custom App as your authentication method.
3. Enter your Shop name.
   Find your shop name from your Shopify URL. For example, if your URL is shopname.myshopify.com, then your shop name is shopname.

4. Enter the Client ID and Client secret you found.
5. 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.
6. Click Save & Test. Fivetran will take it from here and sync your data from your Shopify account.