Analytics page shows a report with following column headers:
`orders gross_sales discounts returns net_sales shipping taxes total_sales`
I should be able to recreate all of this data using Orders API but I am having trouble understanding how Shopify is counting orders for Analytics.
Analytics gives me X while Orders API gives me Y.
I am using this API call:
I have tried following multiple variations of following values to match it, but can't:
Timezones, status, financial_status, fulfillment_status, updated_at_min and max dates even.
There's a lot of logic behind our reports that will take some trial and error on your part if you want things to match up identically, I wouldn't be able to go through exactly how every one of them gets their numbers.
With that being said however, we do have a glossary of how some fields should be calculated in our documentation here that I think you'll find useful.
Hope it helps!
Hi Josh - Thanks for the link to documentation. It's really helpful.
I can do the trial and error to achieve the correct result. I have one question though:
What's the timezone that I should be using while querying? Is it the timezone setup in my Shopify account? Is it the timezone for which I am looking at my analytics report? Is it just GMT or some other fixed standard value?