FROM CACHE - en_header

Shopify - Refunds: Mapping required for refunded_amount

SindhurRao
New Member
5 0 0

We are trying to ingest Refunds data into Azure SQL DB and the "refunded_amount" is currently mapped to orders>refunds>transactions>receipt>amount. Can you please confirm if this mapping is accurate?

 

If not, please help us with the exact mapping.

Reply 1 (1)
Josh
Shopify Staff
Shopify Staff
1134 84 226

Hello @SindhurRao , 

 

Your mapping is not incorrect, but I do think that there is an easier way to do this. 

 

Instead of looking at receipt, which is going to have an amount without decimals, you could use orders>refunds>transactions>amount and skip the receipt portion entirely. This will provide you with the exact amount including the decimal places so you won't have to alter the value provided to simplify the process a little bit. 

Josh | Shopify 
 - Was my reply helpful? Click Like to let me know! 
 - Was your question answered? Mark it as an Accepted Solution
 - To learn more visit the Shopify Help Center or the Shopify Blog