Shopify Integration and Expected Data

How to Setup Shopify Integration

This integration will allow you to connect with your Shopify data and start receiving events for your shop, products, and orders. Once you connect your Shopify data it is much easier to feed your BI, your data warehouse, or your custom analytics stack.

Here are the steps involved:

Connecting Shopify
Set the Replication Frequency
Load your Shopify data into your data warehouse
Shopify expected Data Model and schema
Shopify Integration FAQ

Getting Started – Setup Shopify integration at Blendo

1. To add this integration, go to Blendo dashboard. Click Add a Source.

Connect to Shopify
2. At the Shop text box, you will need to write the subdomain of your Shopify URL.

In our example the full URL is https://drizzt.myshopify.com. We are going to need the part drizzt.

Click Connect with Shopify.

Connect to Shopify API
3. A new window will open.

You will be prompted to authorize Blendo to connect with your Shopify store. Review the text and click Install app.

Connect to Shopify API

5. In the new window, check if everything looks as it should be and click Verify & Save.

6. Then you will return back to the home dashboard. Click on your new Shopify data source.

Set the Replication Frequency

This configuration controls how often Blendo will pull data from your Shopify integration. Loading to your data warehouse could take a little bit longer.

7. If you want to change the replication schedule go to the Schedule section and click on Reschedule.

8. In the next pop-up select one of the options available and click Apply.

Load your Shopify data into your data warehouse

Here is how to start loading your Shopify data into your data warehouse:

Shopify Data Model & Schema Information

Blendo will now connect to your Shopify data source. It will sync your historical data and all the future updates into your destination data warehouse. You will get analytics ready tables and syncs that make sure you will get recent and consistent data.

Let’s see:

How Blendo syncs Shopify data
The tables with Shopify data that we create in your destination data warehouse

How Blendo syncs Shopify data

Historical Data

When Blendo first connects to Shopify Data source, will pull all your historical data.

Sync Schedule

Blendo syncs Shopify data based on the schedule and frequency you choose. The default setting is every 1 hour but is configurable from inside the app.

Replication Process

The first time Blendo syncs your Shopify data performs a full replication. Then your Shopify data is replicated incrementally. Note that Blendo will only read your data.

After you finish the integration with Shopify, you might see its status as Importing from source, Exporting to the destination, or Completed.

What Shopify data do I have available?

Blendo creates analytics ready tables with recent and consistent data. Bellow is a diagram of the schema and you may also find a CSV with all the columns and fields in more detail.