This guide will walk you through how to solve issues with Shopify permissions when pulling data from it into Supermetrics.
Make sure you review the permissions the store owner has to grant a collaborator account before it can connect.
Open Shopify and select Shopify Partners.
Select the store you want to connect with Supermetrics and click Log in.
Open the destination you want Supermetrics to pull data to — either Google Sheets or Looker Studio (formerly Data Studio).
Select Shopify as a data source from the Supermetrics for Google Sheets side panel or in the Supermetrics Looker Studio connector gallery, and add the store name (in URL format) in the "Store name" screen.
Click Start.
- Log in to Shopify Partners.
- Find the store you want to add. At the far right of its row, click Log in.
- Open the Supermetrics sidebar in Google Sheets, and select Shopify as your data source.
- Click + Add new user.
- Enter the name of the store you just logged in to on Shopify Partners in URL format. (This is the first part of the store's URL — so for mystorename.myshopify.com, for example, the store name would be mystorename.)
- Log in to Shopify Partners.
- Find the store you want to add. At the far right of its row, click Log in.
In the Supermetrics for Looker Studio connector gallery, select Shopify and click Try.
- In the data source settings, click the link after View & manage your connections.
Click + Add new connection.
Troubleshooting
In the first step of the authentication process, you'll need to enter the name of the store you want to log in to. This is the first part of the store's URL — so for mystorename.myshopify.com, for example, the store name would be mystorename.
The 403 Forbidden error occurs when any periods or empty spaces (sometimes called whitespace) are added to the store name when you log in.
To fix this, reauthenticate your connection to Shopify, this time using a store name without any extra characters.
Occasionally, the Shopify app might fail to authenticate. If you encounter the ‘Authentication failed’ message after you've reauthenticated, resetting the connection completely should solve the problem.
To do this:
- Log in to Shopify.
- Navigate to Apps.
- Delete the Supermetrics app.
- Log out the Shopify data source.
- Remove the Shopify data source from Looker Studio.
- Reauthenticate Shopify in Supermetrics to re-establish the connection.
