Did you find solution on this, if yes please share as this is a most common test case.
Topic summary
Core Issue:
Users need to retrieve daily sales reports (total sales, orders, gross sales, profit, discounts) via API but Shopify does not provide direct access to report results through their API. The previously available ShopifyQL API has been discontinued.
Current Workaround:
Developers must use the REST or GraphQL Admin API to pull raw order data and manually aggregate/calculate report metrics themselves. The Reports API resource only provides metadata about reports, not the actual report data.
Key Challenges:
- No official documentation or steps exist for matching Orders API data with Shopify’s native Sales Reports
- Calculations for total sales and refunds don’t align exactly with Shopify’s built-in reports
- Multiple users request basic Postman collections or step-by-step guides to calculate standard metrics
Alternative Solution:
CloudlabSam mentions their reporting app (Report Toaster) which offers 100+ templates, custom reports, scheduled reports, and calculated fields as a workaround.
Status:
The discussion remains unresolved with ongoing frustration about lack of official guidance. Several users echo the same need for basic documentation on replicating standard sales reports using the Orders API.