Please take a look at our Data Studio Connector for Shopify. It allows you to create and share Data Studio reports for your Shopify store. Our connector ships with this beautiful template:

ds_template

To get started, please create a private app in your Shopify admin. You’ll need set read access to Orders and Products.

data_studio_connector

You’ll need the API key and Password when you set up the connector, along with your Shopify Store URL. Next, get the connector by clicking here:

Get the Shopify API Connector

 

Set up the Shopify Connector

Enter the info you got when you set up your private app. The options for Limit and Sleep Time are used to control the amount of data and how fast the Shopify API is called. If you have a lot of orders and get errors, you may have to reconnect and increase Limit and Sleep Times.

Other details:

  • In order to get the data from the Shopify API in the right format, it has to be flattened, like a csv file. Since an order can contain multiple items, each line item will be associated with the same order id, name and other data points. For this reason I did not include Order Total as a metric since it would be associated with each line item and summing it would not make sense.
  • What does get summed and aggregated is Item Revenue, which is the product of Item Quantity and Item Price. The Item Revenue is likely different than order total because it does not include taxes and shipping costs.
  • Many data points are not yet included, so if an important metric or dimension is missing, please let me know.
  • Caching is implemented for product images and icons, but not order data in general.
  • Sensitive information such as API keys, passwords and order data is never logged.
  • This connector is not yet published in the gallery.
Get the Shopify API Connector