Shopify
Send data from Shopify to your destinations through Freshpaint
- A Shopify account
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
- Combine your Shopify data with that of any other source
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.Go to Apps > App and Sales Channel Settings > Private Apps. Then click Develop Apps and Allow Custom App Development
- 2.Click Create an app and name it "Freshpaint"
- 3.Click Configure Admin API Scopes and give the app read permission for the objects you want to pull into Freshpaint
- 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:

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
This SQL query can be used as a
Scheduled Identify
query to push your customers to your destinationsSELECT email AS user_id, *
FROM customers;
Last modified 7mo ago