Re: Get Gross Returns, Discount Returned, Net Returns, etc from API

Get Gross Returns, Discount Returned, Net Returns, etc from API

dcassel
Visitor
2 0 0

Hi, 

Our company has a data warehouse that pulls in data from Shopify's various APIs (Orders, Refunds, Transactions, etc)

We are attempting to create a view in our database that requires information that is available in Shopify Admin > Analytics >  Reports > Finances Summary > Sales > Returns (example at bottom)

This report breaks down all refunds on orders by line item and shipping line. It has the following columns we are interested in: Gross returns, Discount returned, Net returns, Taxes returned, Shipping returned, Total returns. 

The problem is that these fields are not readily available for calls on any Shopify API. They will need to be calculated by various fields from what I can tell.

Does anyone know how Shopify calculates these fields?

Thank you! 🙂

Capture.PNG

Replies 6 (6)

Matt_Roy
Visitor
1 0 0

Our company is also trying to do the same thing and having some difficulty. Hopefully Shopify support responds soon!

shinono
Shopify Partner
7 0 0

@Matt_Roy did you get it run? perhaps you can share you result ? 

 

shinono
Shopify Partner
7 0 0

@dcassel some update regarding your request, i think a lot of people looking for this. but no one share some code or request to get this information like the report. perhaps you have something in place which works fine 

 

CloudlabSam
Shopify Partner
567 46 93

You'd be better off using one of the reporting apps. They've already done all of this work for you.

shinono
Shopify Partner
7 0 0

@CloudlabSam yes sure, but not practical when you need some automatic workflow. is it not possible to provide the right graph ql for this from shopify?

 

CloudlabSam
Shopify Partner
567 46 93

There is no specific GraphQL for this. You need all of the order, refund, discount, shipping and other information. Then you need to account for different dates and refund situations. Then you need to determine if taxes are included. 

 

Most of the Reporting apps can help accommodate workflow as well.