In this article, we’ll integrate a Shopify data source with Y42.

Shopify integration replicates data via the Shopify API. You can find the full list of available objects and tables you are able to import to your Y42 instance on Shopify's API documentation.

A guide on how to best understand and use the data from the API is available here on the Shopify Raw Data Guide.


Authentication: App Credentials
Settings: Historical Date selection
Schema type: Fixed
Update Type: Full import and incremental


First, you have to specify the subdomain of your Shopify store, e.g. "yourshopname" for a Shopify store that has the domain ""
The App authentication for Shopify uses a password from the private app that you have created within your system. This private app is strictly isolated to the environment in which it was created and can only be used to access data from the account in which they were created. 
To read more about how to create a private app in Shopify, please go here.
And here you can find a list of available access scopes for the Shopify API.
Our recommendation is to select, or start, with the following scopes: read_products, read_product_listings, read_customers, read_orders, read_all_orders, read_analytics, read_reports, read_price_rules, read_discounts, read_shopify_payments_payouts, read_shopify_payments_disputes.

Import Settings

By default, the historical date will be set to one year ago. Refer to your own store to decide from which exact date you would want to retrieve data.



You can find the full list of available reports and their columns/dimensions/metrics you are able to import to your Y42 instance on Shopify's API documentation.


Updating your data

Shopify has an incremental import that uses the column updated_at. This means your incremental import will also update already existing items. There is no need to regularly schedule a full import for updates.

When you set a schedule for Shopify, the first time Y42 will do a full historic import but each time afterward an incremental one. 


Shopify Setup Guide:

  1. On Integrate, click on "Add..." to search for Shopify and select it.

  2. Name your integration.

  3. Sign in with your Shopify credentials in the new window that opens.

    : To link Shopify with Y42, the following are required:

    • Your Shop’s Name (the name before in your Shopify URL. Example, if your URL is, then your shop name is Y42shop.)

    • Your Private App Password
      (Here's a step by step guide on how to generate the Private App Password for Shopify.

    • Choose from which date onwards you want to sync your data

    • Press Connect and you are good to go

  4. Once you have connected your Shopify account with Y42, you can start importing your tables.


  5. Select the tables you need and click import. You can access the tables once the status is “Ready”.

Note: You can always import and reimport other tables as well, or delete them.

Was this article helpful?
0 out of 0 found this helpful



Please sign in to leave a comment.