How To Get The Reports By API ?
I need daily basis reports data like total sales, total orders, gross sales, profit, discounts etc.
as per daily basis.
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.
Shopify does not allow access to these reports via API. They used to via ShopifyQL, but this API has been discontinued. The only alternative via the Shopify API is to use the REST or GraphQL API and aggregate the data yourself.
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.
They do not provide the ability to pull report results via the API. The only way to get that information via the API is to call the order API and add stuff up yourself.
1 Like
Makes sense, and this is helpful.
Have you been able to arrive at certain stock reports they provide through this method?
For example, using Orders data and merging/joining to recreate the Sales Attributed to Marketing Report?
Yes, we have gathered this data using the Admin REST API. But we have a reporting app in the Shopify App Store, so that’s what we do.
Can you please provide general steps to get Total Sales data for a date via Order or reports API. No where in Shopify document I can find this information. This is the most common test case most of our customer’s use.
Did you find solution on this, if yes please share as this is a most common test case.
You would need to use the Shopify admin API - either REST or GraphQL. https://shopify.dev/api/admin
We have a reporting app where you could get this info via API. Please let me know if you’d be interested in this as an option.
I would be interested in this option. Can you describe the Reporting App for me more?
Hi there - our app is called Report Toaster. It allows you choose from our 100+ report templates and make custom reports with any of your Shopify data. We also have a lot of features like scheduled reports, shared links and calculated fields. Feel free to check it out and let us know if we can help.
Got it, this is helpful. I might have some more questions @CloudlabSam but appreciate the help for now!
Anytime. Just message me if you need help.
Does this provide REST endpoints? IF not. Why are we providing these Apps,What purpose it solves ? we need REST API which is Orders API but nowhere there are steps on how to match with sales report…Strangely, Shopify is pointing to all these apps. All I wanted was how to get total sales and reports from Orders API. All you provide is OrdersAPI which does not match with total sales and refunds on the sales report. almost every Post is asking for it. how to get it via Order’s API? These are REST endpoints shouldn’t Shopify provide the steps to calculate
these? Instead, every time the answer is goto order API and figure it out yourself. Shouldn’t Shopify provide exact steps to use these API that matches the total sales and returns on the sales report ?
Just give us a POSTMAN collection of Total sales and return via Orders API instead of asking customers to figure out their own. Or at least provide basic steps ( Via Orders REST API).
Life will be much simpler if Shopify can provide a basic POSTMAN collection for their OWN Order API which does basic stuff i.e calculate the total sales and refunds for specific dates that will match the Sales report on Shopify. currently, I am getting close, but they are not an exact match.
thank you.
1 Like
did you solve this problem
Did you ever figure this out?
i am struggling with the same thing. i just need a postman collection to get started. there is no reason shopify should be keeping this from us. it would be so easy to share