How can I export the exchange rate used for refund transactions from a Shopify order?

For the "Shopify Payments" gateway, the exchange is stored under refunds > transactions > balance_transaction > exchange_rate.

You can use the formula below in the Caculated Fields to extract this value:

get_attribute_value({{ refunds }}, "exchange_rate")

Note that if there are mulfiple refund transactions, it will export multiple exchange rates separated by a comma.


Related Articles:


App: EZ Exporter

Tags: refunds