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

Feature nameSupported
Column HashingTrueField level
BlockingTrueField level
IncrementalTrue
Custom dataFalse
HistoryTrue
ReSyncTrueTable level
TemplatesFalse

Data Schema

T
- Table
S
- Sub table
React Flow

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.

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

  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.

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:

customer19 fields · 1 required
upsert
FieldType
Emailrequired
STRING
Phone
STRING
First Name
STRING
Last Name
STRING
Address 1
STRING
Address 2
STRING
Address First Name
STRING
Address Last Name
STRING
Address Phone
STRING
City
STRING
Company
STRING
Country Code
STRING
Province Code
STRING
Zip
STRING
Tags
STRING[]
Note
STRING
Tax Exempt
BOOLEAN
Tax Exemptions
STRING[]
Locale
STRING
metafield5 fields · 5 required
upsert
FieldType
Owner IDrequired
STRING
Namespacerequired
STRING
Keyrequired
STRING
Typerequired
STRING
Valuerequired
STRING

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.
Choose Shopify as the Reverse ETL destination

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).
Select destination object (customer or metafield)
  1. 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.
  2. Set up the identifier — choose which source column matches the Shopify id field.
  3. Map the columns from your source to the corresponding fields in Shopify.
Configure sync mode, identifier, and field mapping

Your source should have one row per object for Reverse ETL. For example if you are performing a reverse ETL to the customer object then you should have one row per unique customer. Requires Primary key.

Step 3 — Schedule Sync

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

SQL Templates

View all →

Was this page helpful?