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 and shop name
• Authenticated access scopes for Shopify's Admin API. For more information, see Shopify's documentation.
• You need to log in to your Shopify account before starting the setup process, if creating a connection via API.

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

Create custom app

Follow the instructions below to create a custom app in your Shopify account and get the Admin API access token required for Fivetran configuration.

1. Log in to your Shopify account.

2. On the left-hand navigation menu, click Apps, and then select App and sales channel settings.

   

3. Click Develop apps.

4. Click Create an app.

5. Enter an App name.

6. In the App developer drop-down menu, select the appropriate developer.

7. Click Create app.

   

8. Configure the following Admin API scopes:

   • read_analytics
   • read_assigned_fulfillment_orders
   • read_content
   • read_customers
   • read_discounts
   • read_draft_orders
   • read_files
   • read_fulfillments
   • read_inventory
   • read_inventory_transfers
   • read_locales
   • read_locations
   • read_marketing_events
   • read_markets
   • read_merchant_managed_fulfillment_orders
   • read_metaobject_definitions
   • read_metaobjects
   • read_orders
   • read_payment_terms
   • 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
   The read_gift_cards, read_gift_card_transactions, and read_users scopes are available only for Shopify Plus accounts. To sync data from the GIFT_CARD, GIFT_CARD_TRANSACTION, and USER tables, contact Shopify Support to enable these scopes for your account.

9. Click Install App.

10. On the API credentials page, make a note of the Admin API access token. You will need it to configure Fivetran.

Finish Fivetran configuration

1. In the connection setup form, enter your Destination schema name.
2. Enter your Shop name.
   You can find your shop name immediately before .myshopify.com in your Shopify URL. For example, if your URL is shopname.myshopify.com, then your shop name is shopname.

3. Enter the Admin API access token you found in Step 1.
4. 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.
5. Click Save & Test. Fivetran will take it from here and sync your data from your Shopify account.

Related articles

Connector Overview

Schema Information

Release Notes

API Connector Configuration

Documentation Home