I am currently working on a project where it is necessary to duplicate the data from the Sales Report from the exported .csv from the Orders tab in the Shopify Web Client.
I have tried using the calculations found here: https://help.shopify.com/en/manual/reports-and-analytics/shopify-reports/report-types/sales-report
They are not matching correctly.
I need to know which columns to use from the orders .csv to match Gross Sales, Discounts, and Returns in order to accomplish this.
I would appreciate any advice or tutorials on how to accomplish this.