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.
App: EZ Exporter
Tags: refunds