Shopify Source Connector

The Shopify source connector lets DataSync retrieve data from Shopify for loading or synchronizing into your data warehouse. It connects through Shopify's GraphQL Admin API, giving you access to store data including products, orders, and customers.

Shopify releases a new API version each quarter and the connector is updated accordingly. DataSync supports two authentication modes: Personal Access Token and OAuth 2.0.

Once your source connection is ready, configure your destination connection to finish the setup.

Bulk operations

Use bulk operations is recommended for large datasets. Without it, the Shopify API limits how much data can be retrieved per request, which can slow down or interrupt your sync. Run only one bulk operation at a time to prevent synchronization issues.

Step 1: Configure a custom app in Shopify

To connect DataSync to Shopify, you must create a custom Shopify app. Refer to Shopify’s Build and Custom Apps documentation for full details.

1. In the upper‑right corner of Shopify, select your name.
2. Select Go to admin.
3. Click Settings, then Apps and sales channels.
4. Select Develop apps.
5. Click Create a custom app.
6. Enter a name for your app.
7. Select an App developer (owner or staff account).
8. Click Create app.

Step 2: Create the source connection in DataSync

1. Log in to DataSync.
2. From the welcome screen, select Connections.
3. Next to Source Connections, click New.
4. Select Shopify.
5. Enter all required connection properties.
6. (Optional) In the Additional Connection Properties panel, click Add property and enter any extra parameters you need.
7. Configure the advanced settings to match your environment, including Tracking Type.
8. Click Save.

Connection properties

Property	What to enter
Description	Unique name for the connection. Example: Shopify.
Shopify URL	Full URL of the Shopify store. Example: https://mystore.myshopify.com.
API Version	Shopify API version to use. Allowed values: 2023‑04, 2023‑07, 2023‑10, 2024‑01, 2024‑04, 2024‑07, 2024‑10, 2025‑01, 2025‑04, 2025‑07.
Authentication Mode	Choose the mode that matches how your Shopify app was created. OAuth2 for apps created in the Shopify Partner Dashboard. PersonalAccessToken for apps created in the Shopify Admin.
Callback URL	OAuth 2.0 only URL automatically generated by DataSync after authentication. Must be added to the Callback URLs list in the app's Configuration section in Shopify.
Client ID	OAuth 2.0 only Application identifier assigned during registration. Found in the app’s Overview section in the Partner Dashboard. Example: 1234567890abcdef.
Client Secret	OAuth 2.0 only Confidential value known only to the app owner and Shopify. Example: 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.
Scope	OAuth 2.0 only List of Shopify API access scopes requested by the connector. Default scopes are preselected. Some endpoints may require adding extra scopes.
Personal Access Token	Personal Access Token only Token generated when creating an app in the Shopify Admin. Displayed only once, so save it securely before closing the page. Grants Admin API access to your store data. Example: shpat_abc123def456ghi789jkl012mno345pq.
Use bulk operations	Enables Shopify bulk operations for GraphQL data retrieval. Recommended for large datasets. Bulk queries are created automatically. Keep parallel bulk operations to a single active job at a time.
Has Shopify Plus account	Indicates the app is installed on a Shopify Plus account. Adds columns and tables specific to Plus features.
Verbosity	Controls how much detail the connector writes to the log. Each level includes everything from the level below it, plus additional detail. 1 logs queries, row counts, execution start and end times, and errors. 2 adds cache queries and HTTP headers. 3 adds request and response bodies. 4 adds transport-level communication. 5 adds all interface commands.
Timeout	Time in seconds to wait before a connection attempt or query execution times out.

Additional connection properties

Use this panel to enter connection string properties not available in the Connection Properties panel. For sensitive values such as passwords, set the type to Encrypted. The value is hidden in the interface and stored encrypted in the back end.

Property	What to enter
Property	Connection string property that defines the action or behavior. Example: ReadOnly.
Value	Value for the property. Example: True.
Type	Visibility settings: Visible or Encrypted.

Advanced settings

These settings control how the connector tracks data changes, handles time and regional configuration, and processes records during extraction. Configure them to match your Shopify environment so that results stay accurate and consistent.

Setting	What to select
Tracking Type	Method for tracking data changes: None or Date.
Region	Region setting for the connector, if required by your setup.
Time Zone	Time zone matching your Shopify environment.
Time Offset	Refresh offset in seconds to compensate for timing issues in record selection. Minimum 0, maximum 3600.
Batch Size	Number of records processed per batch during extraction. Larger batches can improve performance but use more memory. Default is 2000, maximum is 10000. Adjust based on your network speed and disk performance. The default works well in most cases.

Personal Access Token example setup

Completed Shopify Personal Access Token source connection in DataSync, with all properties and settings filled in.

OAuth 2.0 example setup

Completed Shopify OAuth 2.0 source connection in DataSync, with all properties and settings filled in.