Shopify Custom App

Shopify is a commerce platform that allows anyone to set up an online store and sell their products. The Custom App connector uses your own Shopify app credentials for authentication, giving you full control over API scopes. Weld syncs your Shopify data into your data warehouse and supports Reverse ETL to push customers and metafields back to Shopify.

Features

Data Schema

Shopify Custom App connectors support history tables, which can be enabled in the connector configuration settings. For more see history tables.

Setup Guide - ELT

Setup guide for our Shopify Custom App connector.

Step 1 — Create a Shopify Custom App

1. Log in to your Shopify developer account
2. On the top right corner click Create app
3. Using the "Start from Dev Dashboard" option, name your app and click Create
4. 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.
5. After this, click Release. Optionally give a name and description to the version.
6. Once the version is released, click on the Home tab on the left.
7. Here, on the right side you will find an Install app button. Click it and follow the instructions.
8. Once the app is installed, you are ready to connect it to Weld.

Step 2 — Connect to Weld

1. In Weld, select the Shopify Custom App connector
2. 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/...
3. Click Connect

Step 3 — Data to Sync

1. Select the tables you want to sync. All available tables are listed with their sync mode (incremental where supported).
2. You can view the schema, remove columns, or hash sensitive information.
3. Click Next to continue.

Step 4 — Configure Sync

1. Choose a schedule type (Independent or Orchestration).
2. Select how often you would like the data to sync.
3. Click Start Initial Sync to begin syncing.

Custom Reports (ShopifyQL)

Custom reports let you define your own queries using ShopifyQL — Shopify's commerce-specific query language — and sync the results as a table in your data warehouse. This is similar to Shopify's built-in Reports module but gives you full control over the query, letting you pull exactly the metrics and dimensions you need into your warehouse.

The screenshot above shows Shopify's native Reports editor — the same ShopifyQL syntax you write there works directly in Weld's custom report setup. The difference is that Weld syncs the query results into your data warehouse on a schedule, so you can join Shopify report data with the rest of your analytics stack.

You can create up to 20 custom reports per Shopify connection. Each report becomes its own table with incremental sync support.

Step 1 — Add a Custom Report

1. Navigate to your Shopify connector's Configuration page.
2. Scroll down to Custom reports and click Add custom report.

Step 2 — Write Your ShopifyQL Query

1. Give your report a Name — this becomes the table name in your warehouse.
2. Write a ShopifyQL Query. ShopifyQL uses a SQL-like syntax with Shopify-specific extensions like TIMESERIES, WITH TOTALS, and commerce-aware functions.
3. Click Validate report to verify the query and preview the output columns.

The validation result shows all columns that will be synced, including their data types. If you use WITH TOTALS, Weld also syncs the totals columns (suffixed with _totals).

4. Once validation passes and you see the green Report is valid confirmation, the report is ready to save.

Example: Sessions Report

FROM sessions
SHOW online_store_visitors, sessions, average_session_duration,
added_to_cart_rate, reached_checkout_rate, conversion_rate, bounce_rate
WHERE human_or_bot_session IN ('human')
GROUP BY day WITH TOTALS
TIMESERIES day

This query pulls daily session metrics filtered to human traffic only, grouped by day with running totals — equivalent to the "Sessions over time" report in Shopify's Analytics section.

Step 3 — Select Columns

Once saved, the custom report appears as a new table in your connector's data selection. You can select or deselect individual columns, just like any other table.

Step 4 — Configure Incremental Sync

Custom reports support incremental sync. Click the sync mode badge to configure:

• Mode: MERGE (recommended) — only changed and new rows are updated on subsequent syncs.
• Primary key: The time dimension from your TIMESERIES clause (e.g. day).
• Cursor: Set to since — Weld uses this to track the last synced timestamp.

With incremental sync enabled, only new or updated rows are fetched on each sync run, keeping sync times fast even as your data grows.

Setup Guide - Reverse ETL

Shopify Reverse ETL allows you to sync data on a schedule from your warehouse into Shopify. You can sync data from your SQL models, dbt models, or raw warehouse tables to the following Shopify objects:

Step 1 — Choose Destination

1. Navigate to Reverse ETL in the sidebar and click + New.
2. Search for Shopify and select your connected Shopify Custom App account.

Step 2 — Map Data

1. Select your source — a SQL model, dbt model, or raw table/view from your warehouse.
2. Select your destination object (customer, metafield, or product_variant).

3. Sync mode is set to Upsert — if a matching record is found in Shopify it will be updated, otherwise a new record will be created.
4. Set up the identifier — choose which source column matches the Shopify id field.
5. Map the columns from your source to the corresponding fields in Shopify.

Step 3 — Schedule Sync

1. Choose a schedule type (Independent or Orchestration).
2. Select the sync frequency.
3. Click Start Sync to begin.

SQL Templates

View all →

Order Items Sales

Order Items Adjustmens

Order Items Refunds

Order Master