Shopify Partner
The Shopify Partner API gives Shopify app developers and agencies the data behind their Partner Dashboard: who installs and uninstalls their apps, the charges merchants accept, and the earnings Shopify pays out. With Weld you can sync it into your data warehouse to report on installs, churn, MRR and payouts per app and per merchant.
This is a different connector from Shopify, which syncs a single store's orders, products and customers.
Features
| Feature name | Supported | |
|---|---|---|
| Column Hashing | True | Column level |
| Blocking | True | Column level |
| Incremental | True | |
| Custom data | False | |
| History | True | |
| ReSync | True | Table level |
| Templates | False |
Data Schema
Setup Guide - ELT
Prerequisites
You need access to your organization's Shopify Partner account with permission to create Partner API clients. Weld only reads from Shopify — it never writes back.
Step 1 - Create a Partner API client
- In the Shopify Dev Dashboard, open your organization's settings and go to Users → Security → Partner API clients.
- Click Add Partner API client and give it a name, such as
Weld. - Grant the View financials permission (for the
transactionstable) and the Manage apps permission (for theappsandapp_eventstables). - Save the client and copy its access token. Shopify only shows it once.
Step 2 - Find your Partner ID and app IDs
- Your Partner ID is the number in your Partner Dashboard URL:
partners.shopify.com/<Partner ID>. The organization ID shown in the Dev Dashboard is a different number and will not work. - Each app ID is the number in that app's Partner Dashboard URL. You only need these if you want to sync your apps' installs, uninstalls and charges.
Step 3 - Create the connection
- In the Weld app, click Data Sources in the sidebar, then Add Data Source.
- Search for Shopify Partner, select it and choose Create new connection.
- Give the connection a Name.
- Enter your Partner ID and paste the Partner API client access token.
- Optionally, enter the App IDs of the apps you want to sync, separated by commas.
- Click Connect to validate the token and establish the connection.
Step 4 - Data To Sync
Select the tables you wish to include in the sync. You can view the schema, remove columns or hash sensitive information.
- Earnings —
transactions: every Partner transaction, covering app subscription, one-time and usage sales, sale adjustments and credits, service and theme sales, referral commissions, and tax. Each row has its transactiontype, the gross and net amounts, the Shopify fee, and the app and shop it relates to where there is one. - Apps —
apps: the name and API key of each app you entered. - App activity —
app_events: installs, uninstalls, subscription, one-time and usage charge events, and credits for each app you entered, with the shop they happened on.
Shopify does not offer a way to list an organization's apps, so apps and app_events are only available once you have entered at least one app ID on the connection. To add an app later, edit the connection and add its ID.
Step 5 - Configure sync
- Select how often you would like the data to sync.
- Optionally choose a start date to limit how far back the initial sync of
transactionsandapp_eventsgoes. Without one, Weld syncs all available history. - Check the Destination schema name, which is where the tables land in your warehouse, and click Start Initial Sync.
Weld will take over from here and commence syncing data from your Shopify Partner account.
Shopify provides Partner transaction data for analytics. Use your Partner Dashboard payouts for accounting.