Shopify

Shopify is a commerce platform that allows anyone to set up an online store and sell their products. 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 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 - ELT

Step 1 — Select Data Source

1. In Weld, navigate to Connectors → Add Connector.
2. Search for Shopify and select it.

Step 2 — Connection Settings

1. Enter a name for your connection (e.g. shopify).
2. Click Authorize. This will take you to Shopify's authorization flow, where you can grant access to your data.
3. Log in to your Shopify account and click Install unlisted app to install the Weld app with the required access scopes.

Once authorized, you can optionally configure additional settings:

• Include contextual pricing — get product prices in the context of different countries.
• Include translatable resource — sync translations of certain resources in selected languages.
• Include history tables — add additional tables with the history of certain resources.
• Limit historical data — only sync data after a selected date.

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.

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.

1. Click Log out on the top left corner
2. After logging out click Add app
3. Log in to the account that holds the store
4. You'll have a popup asking you to choose the store, here you can select the one you'd like to connect to
5. Complete the authorization

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 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 or metafield).

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