Reports API

Retired Boards Appdev Customers Discounts And Orders

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.

Summarized with AI on November 11. AI used: claude-sonnet-4-5-20250929.
3

So they do or don’t provide the ability to pull report information via the API? It’s not clear to me based on above. If they do provide via REST Admin API, which resource would you recommend? Because the Report Resources (this link) seem to give only information about the report, not the report data itself.

Thanks in advance.