Shopify Integration – Intersect Labs

This integration allows you to connect and pull data from your Shopify store into your data notebooks.

In this guide:

Prerequisites
Connecting Shopify
Pulling data from Shopify

Prerequisites

To connect Shopify with your data notebooks you need to have the following:

Shopify account
Generated private app on Shopify with the appropriate permissions
Intersect account and owner access level

Connecting your Shopify account

You can add the Shopify integration from the Dashboard > Integrations > Add integrations > Add Shopify section.

One-click on the Shopify box and the connection portal will open. These are the fields that are required for the connection to be successful:

Integration name
API Key
Password
Example URL

To access these parameters, you need to create a private app on your Shopify store account. You should be able to do it on your own, by following the official Shopify documentation. If you set up the private app successfully, Shopify will provide the API key, Password, and Example URL (as shown in the image below) directly in your Admin API.

You can then proceed to fill the connection portal in Intersect. If the connection is successful, you should be able to see your new Shopify integration on your Integrations page.

Pull data from Shopify

Open your data app where you wish to pull data from your newly connected Shopify database. Then, you can add a Shopify step from Import data > E-Commerce data > Read from Shopify (Add).

Once you select the integration, a new “Read from Shopify” step will be added to your data notebook. To successfully pull data you will need to select the store that you've connected (in our case it’s called: Shopify store). Then, from the dropdown, you can select the type of data that you'll want to pull.

Remember: While you configure your API access in Shopify, you are able to give access to what types of data this private app will be able to collect. In our case, we've enabled customers, orders, and inventory.

If the step is successfully configured you will see an output with your sourced data.

If you wish to preview the table you can expand the Output step, which will preview the table that was sourced.