Shopify data source

Learn how to set up a Shopify data source and then move this data to one of the supported by Coupler.io data destinations.

The 2 steps to complete the setup

  1. Set up your data source.
  2. Set up your data destination.

1. Set up your data source

1.1. Select an application: Shopify

1.2. Enter your shop name

1.3. Get API key or API token

API key is needed for private apps created before January 2022.

API token is needed for custom apps created after January 2022.

1.3.1. How to get your API key?

  • Click "Develop apps for your store"
  • Open previously created Private app 
  • Copy API Key
1.3.2. To generate an API token, please:

  • Scroll down, click Develop apps for your store.
  • Click "Allow custom app development".
  • Click Create an app.

  • In the App details section, enter a name for the private app and select App developer. Shopify uses the email address to contact the developer if there is an issue with the private app, such as when an API change might break it.

Provide needed consents for the key

  • Click "Configure Admin API scopes", select the areas of your store that you want to import to Google Sheets. 
To make sure you can pull all data entities that Coupler.io supports, select Customers, Inventory, Orders, and Products, providing “Read access” level to all of them.
  • Save changes.
  • Install App.
  • Copy Admin access token, and  store it as it is visible only 1 time.

Paste API Key or API token to the "API key / API token" field:

In case you use the custom app with API token - leave the API password field empty.

1.4 Get API password for a private app created before January 2022

How to get your API password?
  • After you got the API Key -> copy the Password value from the Private app settings page.

Paste generated password to the "API password" field:

1.5. Select a data entity to import

One can pick either:

  • Customers - to pull customer first and last names, email, total spent per customer, product ID, last order ID, and other information.
  • Products - to import product ID, product title, product vendor, product published and updated dates, product variation IDs and their titles, price, SKU, and other information.
  • Orders - order ID, email, order creation and update date, order number, token, total price, total weight, total tax, currency, financial status, and other information. 
  • Orders with line items - order ID, email address, token, total price, total weight, total tax, financial status, total discounts, total line items, order status, line item’s id, line item’s title, line item’s variant ID, line item’s variant title, and other information.
Note: if you want to pull your summarized Order data, then pick “Orders”. If you want to pull your Order’s data with all line items included, then select “Orders with line items”.
In this case Coupler.io will create a new row for every separate line item in your order.

1.6. Fill out these fields (optional)

  • Filter after ID: specify the ID of your selected data entity (be it an Order’s ID, Customer’s ID or Product’s ID) that you want to use as a starting point for your imported data set. Coupler.io will pull all data that was created after the specified data entity ID.

  • Created before / after date: specify the timeframe for your data entity’s creation date that you want to import to Google Sheets. 
If you sets this parameter after 2020-12-01 and before 2020-12-31, it will fetch data between 2020-12-01 00:00:00 UTC +0 and 2020-12-31 00:00:00 UTC +0
If you want to fetch data for 1 day, you need to specify after 2020-12-01 and before 2020-12-02.
These fields support macro. Learn more.

  • Changed before / after date: specify the timeframe when your data entity was last changed. These fields support macro. Learn more.

  • Order status: specify the status of orders to pull from Shopify. This filter only applies to the Orders data entity.

  • Orders financial status: specify the financial status of orders to pull from Shopify. This filter only applies to the Orders data entity.

  • Orders fulfillment status: specify the fulfillment status of orders to pull from Shopify. This filter only applies to the Orders data entity.

  • Products status: specify the status of products to pull from Shopify. This filter only applies to the Products data entity.

  • Fields: specify a comma-separated list of fields to be imported to Google Sheets (e.g. created_at, id).

2. Set up your data destination

Continue setting up the integration depending on the system where you want to import data to. See full list of supported data destinations and follow set up guide for chosen one.

Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.