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 | True | |
| 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
Shopify connector also supports history tables which can be enabled in the connector confirguration. For more see the history tables.
🔧 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
View all →Aggregates orders, and combines order line details with various order-related information to calculate sales metrics such as gross sales, net sales, and total sales for Shopify order items.
Creates an order adjustment summary by combining data from Shopify's order adjustments, refunds, orders, and customers. It provides details such as order information, refund amounts, customer names, and customer types. The query also distinguishes between first-time and returning customers based on order numbers.
Aggregates order refund data from Shopify, linking it with customer, order, product, and variant details to provide a comprehensive view of refunds. It includes information such as refund amounts, customer details, product titles, and order statuses. Additionally, it categorizes customers as either first-time or returning based on their order history.
Consolidates sales, refunds, and adjustments from Shopify into a unified view by combining data from sales, refund, and adjustment sources. It includes additional fields to indicate whether a record represents a sale, refund, or adjustment and provides detailed order information such as customer details, product information, and financial status. The template uses union operations to merge data from different sources into a single dataset.
Changelog
RSSabandoned_checkout_historycollection_historycompany_historycustomer_historycustomer_metafield_historydiscount_code_historydraft_order_historyfulfillment_order_historyinventory_item_historyinventory_level_historyline_item_group_historyorder_historyorder_metafield_historyorder_return_historyprice_rule_historyproduct_historyproduct_image_historyproduct_metafield_historyproduct_variant_historycolumncolumncolumninventory_levelstransaction_feesproduct_variantsproduct_variantproduct_imagecompanyorder_agreementsline_item_group