Shopify
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:
Go to Apps > App and Sales Channel Settings > Private Apps. Then click Develop Apps and Allow Custom App Development
Click Create an app and name it "Freshpaint"
Click Configure Admin API Scopes and give the app read permission for the objects you want to pull into Freshpaint
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
Last updated