Shopify
Shopify is a commerce platform that allows anyone to set up an online store and sell their products.
Features
| Feature name | Supported | |
|---|---|---|
| Column Hashing | True | Field level |
| Blocking | True | Field level |
| Incremental | True | |
| Custom data | False | |
| History | False | |
| ReSync | True | Table level |
| Templates | True |
Data Schema
Shopify API Admin Scopes
The Weld App asks for the following scopes when setting up the integration:
- read_customers
- read_content
- read_themes
- read_products
- read_orders
- read_all_orders
- read_draft_orders
- read_locations
- read_inventory
- read_fulfillments
- read_assigned_fulfillment_orders
- read_merchant_managed_fulfillment_orders
- read_third_party_fulfillment_orders
- read_shipping
- read_gift_cards read_checkouts
- read_reports read_price_rules
- read_discounts
- read_marketing_events
- read_resource_feedbacks
- read_shopify_payments_payouts
- read_shopify_payments_disputes
- read_translations read_locales
🔧 Setup Guide
Prerequisites
To connect your Shopify account to Weld, you need:
- Access to a Shopify account.
- Authenticated access scopes for Shopify's Admin API. For more information, see Shopify's documentation.
Attention! If you need to sync the Users table please use our Shopify Plus connector. It requires a Shopify Plus subscription.
Step 1 - Begin Configuration
- In the connector setup form, enter the destination schema name of your choice.
- Click Authorize. You will be redirected to Shopify's login page.
Step 2 - Configure and finalize
- Log in to your Shopify account. You will be redirected to the Shopify admin UI, which will prompt you to install the Weld app.
- Click Install unlisted app. This will install the Weld app with the required access scopes. When authorization is complete, you will be redirected back to the Weld connections overview. The configuration is complete.
Step 3 - Data To Sync
- Select the pre-built reports you wish to include in the sync.
You can view the schema, remove columns or hash sensitive information.
Step 4 - Configure Sync
- Select how often you would like the data to sync.
- Provide a unique destination table name.
Weld will take over from here and commence syncing data from your Shopify account. \
Important - If you need to add Weld to multiple stores the following applies:
When clicking Authorize you'll be redirected to the Shopify App listing of Weld. Here you need to log out if logged in to be able to choose the correct store.
- Click Log out on the top left corner
- After logging out click Add app
- Log in to the account that holds the store
- You'll have a popup asking you to choose the store, here you can select the one you'd like to connect to
- Complete the authorization
📊 SQL Templates
Get started with Shopify SQL Templates
Get inspiration on how to model your data, with our collection of foundational SQL templates we have battle-tested at Weld. All the templates work out of the gate with the Weld data integrations for Shopify.