Use Shopify as a data source

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 Connector Gallery 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.

  1. Enter your Shop Name and click Next Step.
  2. Choose a Shopify OAuth token or create a new OAuth token by clicking Connect an Account.
  3. If prompted, enter your email and password and click Next.
    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.
  4. Click Next Step 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 and get up to 10,000 responses.

Limits
Or, 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,

  1. At Method, select GET (or POST).
  2. Select Submit.
    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.
  3. If you are happy with the data, select Continue.
  4. Save your new data source.

Learn More

Have more questions? Submit a request