Shopify Custom App
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 | False |
Shopify Custom App connectors support history tables, which can be enabled in the connector configuration settings. For more see history tables.
🔧 Setup Guide
Setup guide for our Shopify Custom App connector.
Attention! If you need to sync the Users table please use our Shopify Plus connector. It requires a Shopify Plus subscription.
Prerequisites
To connect your Shopify account to Weld, you need:
- Access to a Shopify store account.
Step 1 - Create a Shopify custom app
- Log in to your Shopify developer account
- On the top right corner click Create app
- Using the "Start from Dev Dashboard" option, name your app and click Create
- On the next screen set the scopes in the "Access" section. The tables that Weld syncs are all accessed through the "Admin API", so only scopes from that API are needed.
- After this, click Release. Optionally give a name and description to the version.
- Once the version is released, click on the Home tab on the left.
- Here, on the right side you will find an Install app button. Click it and follow the instructions.
- Once the app is installed, you are ready to connect it to Weld.
Step 2 - Connect to Weld
- In Weld, select the Shopify Custom App connector
- In the connector form add your Client ID, Secret and Store ID.
You can find the Client ID and Secret in the app's settings page on the dev dashboard.
The store ID must be for the store where you installed the app in the previous step. You can find it in the URL of the store admin page. It looks like the following:
https://admin.shopify.com/store/your_store_id/... - Click Connect
📊 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.