Want to do more with your service desk data? Join our experts live August 6. Register now
Power BI Connector for Shopify

How to replicate Sales Report from Shopify Analytics with the exported raw data?


📘 According to Shopify Analytics → Sales report definitions page, the total sales formula is as follows:

Gross sales - Discounts - Returns + Taxes + Duties + Shipping charges + Fees:

  1. Gross sales - Discounts - Returns + Taxes: take “Orders / Current total price set“

  2. Duties: “Orders / Current total duties set” table → “presentmentMoneyAmount“ field

  3. Shipping charges: “Orders / Total shipping price set” table → “presentmentMoneyAmount“ field

  4. Fees: “Orders / Total tip received set“ → “presentmentMoneyAmount“ field

Additional fees may vary depending on your store's configuration.