I want to understand how Shopify calculates gross sales in its analytics reports, especially when orders are edited. I'm trying to replicate this using the Shopify REST API, but there are discrepancies, and I can't match the numbers from the analytics reports.
Just want to add my two sense here as well. Have been trying the same thing. Have used REST (which did not work since there was no presence of an order edit date and adjustments were attributed to order creation date) and having a similar issue with ShopifyQL Query on GraphQL (Shopify QL Notebooks and Admin UI Analytics are different)
Looking to find a method to extract essentially the Total Sales/Net Sales/ Gross Sales/ Refunds/ Orders fields and more from the Total Sales Report into my Warehouse but cannot align the discrepancies. Our shop modifies a lot of orders after order creation dates which result in additional sales and refunds.
Dive into the world of Print-on-Demand and discover how it can transform your online busin...By Imogen Feb 19, 2024
Discover how to transform your online store into a delightful shopping destination. Learn ...By Ollie Feb 13, 2024