Replicating Shopify Analytics Reports with REST API

Replicating Shopify Analytics Reports with REST API

ceydadrn
Tourist
8 0 2

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.

 
Replies 2 (2)

mattread6
Shopify Partner
3 0 0

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.

ceydadrn
Tourist
8 0 2

Hi,

 

Using  `OrderAgreement` object in GraphQL for order edits was helpful for me, you can check it out as well.