Shopify

Prev Next

Shopify is an e-commerce platform that allows businesses to create online stores and sell products or services. It provides a range of tools and features for inventory management, order processing, payment integration, and website customization, enabling businesses to easily set up and operate their online storefronts.

Refer to our website for the list of metrics and attributes available in Dataddo.

Refer to Shopify's official documentation to see all available endpoints from the Shopify API.

Authorize Connection to Shopify

In Shopify

To authorize your Shopify account, you will need your API access token.

Create an App

  1. Make sure you are logged in to your Shopify account and navigate to the Developer Dashboard page.
  2. In the top-right corner, click Create app.
    Shopify 1 - Create App
  3. Name your app and click Create.
  4. On the Create a version page, scroll down to Access to add the following admin API scopes. You can copy paste the following list or select it from the Select scopes menu.
    read_assigned_fulfillment_orders, read_customers,read_fulfillments, read_merchant_managed_fulfillment_orders, read_orders, read_products, read_third_party_fulfillment_orders
    
    Shopify 2 - Edit scopes
  5. Click Release to save the app version with updated scopes.
  6. On the Home tab, click Install app. Select which Shopify store you want to install the app to. Click Install.
    Shopify 3 - Install App
  7. Back in your Developer Dashboard, select the newly created app and navigate to the Settings page.
  8. From the Credentials section, copy your Client ID and Client Secret. These will be used to retrieve your access token.
    Shopify 4 - Obtain Account Credentials

Obtain Your Access Token

Exchange your client credentials for an access token to authenticate your API requests. This is a server-to-server request.

  • Endpoint: POST https://{shop}.myshopify.com/admin/oauth/access_token
  • Headers: Content-Type: application/x-www-form-urlencoded
  • Body Parameters
Parameter Value Description
client_id string Your app's client ID found in the Developer Dashboard.
client_secret string Your app's client Secret.
grant_type string Must be set to client_credentials.

Copy the access token from the response. You will need this token for account authorization in Dataddo:

{
    "access_token": "shpat_a1b2c3d4f5g6h7j8k9l10",
    "scope": "read_assigned_fulfillment_orders,read_customers,read_fulfillments,read_merchant_managed_fulfillment_orders,read_orders,read_products,read_third_party_fulfillment_orders",
    "expires_in": 86399
}

In Dataddo

  1. On the Authorizers page, click on Authorize New Service and select Shopify.
  2. Fill in the following fields:
    1. Subdomain: Shopify subdomain name, aka the name of your shop=. E.g. agencyname from agencyname.myshopify.com.
    2. Access Token: Your Shopify API access token.
  3. Rename your authorizer for easier identification and click on Save.

How to Create a New Shopify Data Source

  1. On the Sources page, click on the Create Source button and select the connector from the list.
  2. Select your dataset and click on Next to continue.
    DATADDO TIP

    If you are not sure which dataset you need but know the metrics and attributes, use the Search by Name or Attribute function.

    Source creation using a fixed-schema connector.
  3. From the drop-down menu, select your authorizer.
    Didn't find your authorizer?

    Click on Add new Account at the bottom of the drop-down and follow the on-screen prompts. You can also go to the Authorizers tab and click on Add New Service.

  4. Name your data source and select your metrics and attributes. Keep in mind that metrics and attributes depend on the selected dataset.
  5. Configure your sync frequency or the exact synchronization time under Show advanced settings.
    DATADDO TIP

    If you need to load historical data, please refer to the Data Backfilling article.

  6. Preview your data by clicking on the Test Data button in the top right corner. You can adjust the date range for a more specific time frame.
  7. Click on Save and congratulations, your new data source is ready!


Limitations

Multi-Account Extraction

If you have multiple Shopify accounts and would like to extract the same data from all of them, you can do it via data union.

Troubleshooting

Data Preview Unavailable

No data preview when you click on Test Data might be caused by an issue with your source configuration. The most common causes are:

  • Date range: Try a smaller date range. You can load the rest of your data afterward via manual data load.
  • Insufficient permissions: Please make sure your authorized account has at least admin-level permissions.

Insufficient Scopes Error

ERROR MESSAGE
Cannot Access Data: Insufficient Scopes

If you cannot access some of your data, please double-check which permissions you've given to Dataddo. In majority of cases, you will need to add additional permissions to your account.

Example
To gain access to the fulfillmentOrders field from the Orders dataset, give Dataddo at least one of the following scopes:

  • read_assigned_fulfillment_orders
  • read_merchant_managed_fulfillment_orders
  • read_third_party_fulfillment_orders

Related Articles

Now that you have successfully created a data source, see how you can connect your data to a dashboarding app or a data storage.

Sending Data to Dashboarding Apps

Sending Data to Data Storages

Other Resources