Reports API

kamesh087
Shopify Partner
1 0 0

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.

Replies 5 (5)
CloudlabSam
Shopify Partner
233 20 23

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.

frog-dev
Shopify Partner
6 0 0

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.

CloudlabSam
Shopify Partner
233 20 23

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. 

frog-dev
Shopify Partner
6 0 0

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?

CloudlabSam
Shopify Partner
233 20 23

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.