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
1.1. Select an application: Shopify
1.2. Enter your shop name
1.3. Paste your API key
How to generate your API key?
To generate an API key, please:
- Login to the Shopify Partners: https://accounts.shopify.com/lookup?rid=949888c3-1d23-4891-baa0-8a97b75423b1
- Navigate to your Stores list:
- Login to the needed Store:
- From your Shopify admin, go to Apps.
- Scroll down, click Manage private apps.
- Click Create a new private app.
If you never used private apps before - you need to enable the private app development:
Check all checkboxes and click "Enable private app development":
After this you will be able to create a new private app:
- In the App details section, enter a name for the private app and a contact email address. 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
- In the Admin API section, 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.
For more information, please read this guide.
1.4. Paste your API password
- After you generated the API key, copy the password and paste it into this field.
- You can always find it by opening the Private apps page and then selecting your private app.
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.