Resources

Data Source Type	Shopify
Authentication	OAuthToken Authentication
Sample Query	`https://<yourShopName>.myshopify.com/admin/<data_you_want>.json`
API Documentation	Shopify API documentation

Step-by-Step

Creating a data source using Shopify

To create a data source using Shopify, you need to accomplish 3 tasks:

Start the data source creation process.
Authenticate with Shopify.
Write a query and enter it in Klipfolio.

Step 1: Start the data source creation process

To create a data source using Shopify, go to the Service Connectors page in Klipfolio and select Shopify.

Step 2: Authenticate with Shopify

Note: Klipfolio will soon be listed on Shopify’s App Store, but good things take time! You may be redirected to Shopify before you can continue authenticating. If the message This app isn’t listed on the App Store displays, scroll down and click the Install unlisted app button.

To authenticate with Shopify:

Enter your Shop Name and click Continue.
Choose a Shopify OAuth token or create a new OAuth token by clicking Connect an account.
If prompted, enter your email and password and click Log in.
Note: If you are redirected to Shopify and the message This app isn’t listed on the App Store displays, scroll down and click the Install unlisted app button.
Click Continue to save your OAuth Credentials.

Step 3: Write the query and enter it in Klipfolio

Refer to the Shopify API Documentation as you are writing a query. There are many query options available in the Shopify API documentation, however, here are some sample queries to get you started:

For orders
https://<yourShopName>.myshopify.com/admin/orders.json

For products
https://<yourShopName>.myshopify.com/admin/products.json

For shop information
https://<yourShopName>.myshopify.com/admin/shop.json

For countries
https://<yourShopName>.myshopify.com/admin/countries.json

Managing the number of query responses

To manage your query response, you can paginate your response, add limits to your query, or let Klipfolio manage the number of responses.

Pagination
To get the most data, select Paginate.

Note: Shopify has replaced page-based pagination with cursor-based pagination. If the end-point in your URL includes a Shopify API version that doesn’t support cursor-based pagination (for example, https://<yourshopname>.myshopify.com/admin/api/2019-07/order.json) your query will only return 50 records. To fix this issue, change the API version in your query to one that supports cursor-based pagination (for example, https://<yourshopname>.myshopify.com/admin/api/2019-10/order.json). To learn more about these API changes, go here and here.

Limits
To get a specific number of responses, add a limits parameter to your query.
For example, https://<yourShopName>.myshopify.com/admin/orders.json?limit=100.
Note: Make sure Paginate is not selected because it overrides limits.

No Pagination or Limits
If you do not select Paginate or add limits, Klipfolio will return 50 responses.

Complete the data source creation process

Now that you have written your query,

At Method, select GET (or POST).
Select Get data.
Note: In addition to your unmodelled data source, you can create a modelled version of your data source at this stage. To create a modelled data source, ensure that the checkbox next to Model this data source is selected before clicking Continue.
To learn more about creating a modelled data source, click here.
If you are happy with the data, select Continue.
Save your new data source.

Learn More

How can we help?

Use Shopify as a data source