How do I calculate Net Sales from an exported orders .csv file to match a Sales Report?

tasc_api_guy
New Member
1 0 0

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.

0 Likes