Send data from Shopify to your destinations through Freshpaint

What you'll need

  • A Shopify account

How this works

With the Shopify source, Freshpaint can sync the data from your Shopify store into Freshpaint's SQL Engine. All of this data will be made available as SQL tables.
With that data, you can:
  • Send to your destinations on a schedule with our Scheduled Events, keeping them in sync with Shopify
  • Send data as properties of your tracked events with SQL Transformations
  • Query the data with our SQL Editor to see what you have and test that your source is working
  • Combine your Shopify data with that of any other source

Connect to Shopify

First you will need to generate an Access Token Freshpaint can use to pull data from Shopify. To generate an Access Token you will need to create a custom app. To do so:
  1. 1.
    Go to Apps > App and Sales Channel Settings > Private Apps. Then click Develop Apps and Allow Custom App Development
  2. 2.
    Click Create an app and name it "Freshpaint"
  3. 3.
    Click Configure Admin API Scopes and give the app read permission for the objects you want to pull into Freshpaint
  4. 4.
    Click Install App. You'll then be shown your Admin API Access Token which you will need to provide to Freshpaint
Once you have the Access Token, to configure the Shopify source, go to the Shopify Source in Freshpaint. To configure the source, you'll need to provide your Shopify store id, your access token, and the date from which you want to start syncing data. Then you can configure the specific tables you want to sync from Shopify. Once you do so, you should see something like this:

Working with Shopify Data

With the Shopify source, you can sync the following objects:
  • Abandoned Checkouts
  • Articles
  • Balance Transactions
  • Blogs
  • Collections
  • Collects
  • Custom Collections
  • Customers
  • Discount Codes
  • Draft Orders
  • Fulfillment Orders
  • Fulfillments
  • Inventory Items
  • Inventory Levels
  • Locations
  • Metafields
  • Order Refunds
  • Order Risks
  • Orders
  • Pages
  • Price Rules
  • Product Images
  • Product Variants
  • Products
  • Shop
  • Smart Collections
  • Tender Transactions
  • Transactions

Use Cases

Upload customers to your destinations

This SQL query can be used as a Scheduled Identify query to push your customers to your destinations
SELECT email AS user_id, *
FROM customers;