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 nameSupported
Column HashingTrueField level
BlockingTrueField level
IncrementalTrue
Custom dataFalse
HistoryFalse
ReSyncTrueTable level
TemplatesFalse

πŸ”§ 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

  1. Log in to your Shopify store account
  2. On the left side panel select Apps
  3. The search bar will pop up, click App and sales channel settings
  4. On the top click Develop apps
  5. Click Create an App, give your app a name and click Create app
  6. Go to the Configuration tab and click Configure next to Admin API integration
  7. You will need to select the Admin API Access scopes that you would like to assign to the app. You can select only the ones that you need, but in order to use Weld to it's full extent select all read scopes. Once you selected the scopes click Save on top of the page.
  8. 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.
  9. Install the app by clicking Install app on the top of the page.
  10. On the next page you can view your Admin API access token. Copy and store this in a secure place. You will only be able to see this once, after that you will need to remove and re-install the app to get a new one.

Step 2 - Connect to Weld

  1. In Weld, select the Shopify Plus connector
  2. In the connector form add your Admin API access token and Store ID. You can find your store id in the Shopify admin URL. It looks like the following: https://admin.shopify.com/store/your_store_id
  3. Click Connect

πŸ“Š SQL Templates

Get started with Shopify SQL Templates

Get inspiration on how to model your data, with our collection of foundational SQL templates we have battle-tested at Weld. All the templates work out of the gate with the Weld data integrations for Shopify.

Was this page helpful?