Hi
We are using the Orders API to fetch sales data from Shopify Basic stores within a specific data range.
The issue we have found is that if a refund, did not occur in the same date range, then it is completely missed. So for example, if a sale occured in February 2024, but a refund was issued in March 2024...then if we fetch all Orders Data for 2024-02-01 to 2024-02-29, then only the sale will show and the refund will be missed.
Ideally we would like to be able build a report similar to "Total Sales" on the shopify admin which shows all transactions within a date range, including all sales, discount and refunds applied to any orders from that store.
Is this possible? If so, what is the best way to do it?
Many Thanks for your help
Gurpreet
