Shopify

Dataddo Shopify connector enables simple API data extraction without writing a single line of code.

Available data

Dataddo Simplicate connector can extract all the data available through the official API. You can find the full list of available data here.

Subdomain

While configuring a Shopify connection, enter only the subdomain name without the ".myshopify.com" following.

Example:

If your organization's Shopify subdomain is 'coolagency.myshopify.com' you would enter 'coolagency' in the Subdomain field while configuring your Shopify connection on Dataddo.

Multi-account extraction

You cannot extract data from multiple accounts across domains (different stores, different URLs). You can, however, connect the same data from various stores via Flow, when you add more sources into the destination.

How to create a Shopify Data Source

   
Number 1

Sign in to your Dataddo account and click on Sources at the top of the page. Home Page - Data Source

Number 2

Click on Create Source in the top right corner.Data Sources - Create Source

Number 3 From the list of sources, choose Shopify. You can type the name of the connector into the search bar to find it faster.
Shopify - step 3
Number 4

First, select the required Dataset and click on Next.

NOTE: If you are not sure which Dataset you need, but you know which Metrics and Attributes you are looking for, you can use the Search by name or attribute function or you can browse through all the possible Attributes and Metrics for each Dataset by clicking on the specific Dataset.
Shopify - step 4

Number 5 From the drop-down menu, choose your Shopify Account connected to Dataddo, and then select Shop subdomain. Click on Next to continue with the setup. Shopify - step 5
a)

Add new account
If you want to connect a new Shopify Account that is not on the list, click on Add Account. You will be redirected to the Shopify Sign In page to confirm the right account.
Shopify - step 5 add new account

Type in the Subdomain and click on Save. Once you confirm, you will be redirected back to the Dataddo app.
Shopify - step 5 sign in

b) Authorize Your Account
If you have not authorized your Shopify Account with Dataddo, click on Authorize and you will be redirected to your account to log in.
Shopify - step 5 authorize
After you log in and give Dataddo the necessary permissions to access your data, you will be redirected back to the connector.
Number 6

Choose a Name for your Data Source and select the Metrics and Attributes. To continue to the next page, click Next.

NOTE: The Metrics and Attributes depend on the Dataset you selected in the previous step. If you need different Metrics and Attributes, go back two steps and change the Dataset.

Shopify - step 6

Number 7

On the Storage selection page, you can set up the destination configuration. To help you with the snapshot mapping, we make it easier for you to create a connection to the destination based on your preference.

  • A) Click on the option Dashboarding App if you want your data to connect to applications such as Google Data Studio, Power BI, or Tableau.
  • B) Click on the option Data Warehouse, if you want your data to be sent to warehouse storage, e.g., MySQL, Big Query, or PostgreSQL.
Shopify - step 7
Number 8

Configure your snapshotting preferences by choosing your Data range, Sync type, Snapshotting frequency, Time, and Timezone. Confirm your setup by clicking on Next.

NOTE: If you need to load historical data, check our guide.
Shopify - step 8

Number 9 In the last step, you can preview your data. Click on Save and your new Data Source is ready.
Shopify - step 9 preview
* Broken view / Error message
If you cannot see a preview of your data, go back a few steps and check your setup. The most common causes are:
  • Date range - we recommend a smaller date range. If you need to load historical data, check our guide.
  • Invalid metrics, attributes or breakdowns, or their combination - you may not have any values for them.
Shopify - step 9 broken view

Congratulations, your new Data Source is ready!


Need assistance?

Feel free to contact us or create a ticket and we will help you set up the Data Source.