Shopify Plus
Shopify is a commerce platform that allows anyone to set up an online store and sell their products. This connector includes the tables only available in Shopify Plus as well as the standard tables.
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 Plus 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 Plus connector, including support for the Users Shopify Plus table.
Attention! If you do not need to sync the Users table, or you don't have a Shopify Plus subscription, please use our standard Shopify connector.
Prerequisites
To connect your Shopify account to Weld, you need:
- Access to a Shopify Plus store account.
Step 1 - Create a Shopify custom app
In order to be able to sync the Users table, you will need to contact the
Shopify Plus Support and ask them to enable the read_users access scope for
your app. They will assist you in this process. Once you have that granted,
you can configure the app and select that access scope as well.
- 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 Plus 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.