How to create the Sales by product report similar to the Shopify UI?

This guide will demonstrate how to create a table imitating the Shopify UI view. The specific table is for Sales by product -report. Path to report in the Shopify admin view: Analytics -> Reports -> Sales by product (Under Sales header).

URL for the report

https://<your_store_name>.myshopify.com/admin/reports/sales_by_product_name?since=-28d&until=today


  1. Choose dimensions

    1. Product title

    2. Vendor

    3. Type

  2. Choose metrics

    1. Items

    2. Gross sales

    3. Discounts

    4. Returns

    5. Net sales

    6. Tax

    7. Total sales

  3. Add two filters with OR

    1. Line item type EQUALS product

    2. Line item type EQUALS refund


Choose order by Total sales, and make the order Descending.


Shopify UI

https://<your_store_name>.myshopify.com/admin/reports/sales_by_product_name?since=-28d&until=today



Supermetrics in Data Studio


Dashboard view


Filters for the table


Supermetrics in Google Sheets


Dashboard view

Filters for the table



Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.