January 06, 2021 11:42

Shopify Integration

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.

Overview

Authentication: App Credentials

Settings: Historical Date selection

Schema type: Fixed

Update Type: Full import and incremental

Authentication

First, you have to specify the subdomain of your Shopify store, e.g. "yourshopname" for a Shopify store that has the domain "http://yourshopname.shopify.com/"

The app authentication for Shopify uses a Admin API token from the custom app that you have created in Shopify. This custom app is strictly isolated to the Shopify 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 custom apps in Shopify, please go here.

Watch the following video for a step-by-step guide to create a custom app in Shopify for Y42:

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. Please note that the initial import of historical order data can only include 1 year. Therefore, please trigger another incremental import after the initial import to get all order data.

Schema

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 import 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:

Your Shop’s Name (the name before ".myshopify.com" in your Shopify URL. Example, if your URL is "yourshopname.myshopify.com", then your shop name is "yourshopname" .
The Admin API access token from the custom app you have created before in custom apps in Shopify:

Bildschirmfoto_2022-03-18_um_00.03.34.png

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

Bildschirmfoto_2022-03-18_um_00.06.06.png

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