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

This Documentation Has Moved!

How to replicate Sales Report from Shopify Analitics 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.