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.