How do I export the Shipping Refund from a Shopify order?
You can use the formulas below in the Calculated Fields to export the total shipping refund amount and refund tax amount from an order:
Refund Amount
get_total([oa.amount for oa in load_json_data(flatten_list([i.order_adjustments for i in load_json_data({{ refunds }})])) if oa.kind == "shipping_refund"])
Refund Tax Amount
get_total([oa.tax_amount for oa in load_json_data(flatten_list([i.order_adjustments for i in load_json_data({{ refunds }})])) if oa.kind == "shipping_refund"])
Refund Amount + Tax
get_total([oa.amount for oa in load_json_data(flatten_list([i.order_adjustments for i in load_json_data({{ refunds }})])) if oa.kind == "shipping_refund"]) + get_total([oa.tax_amount for oa in load_json_data(flatten_list([i.order_adjustments for i in load_json_data({{ refunds }})])) if oa.kind == "shipping_refund"])
This will parse the refunds > order_adjustments
subfield and filter the values to only include those where the "kind" is "shipping_refund".
The value will be a negative number. To make it a positive number, we can simply multiply by -1 like this:
(get_total([oa.amount for oa in load_json_data(flatten_list([i.order_adjustments for i in load_json_data({{ refunds }})])) if oa.kind == "shipping_refund"]) + get_total([oa.tax_amount for oa in load_json_data(flatten_list([i.order_adjustments for i in load_json_data({{ refunds }})])) if oa.kind == "shipping_refund"])) * -1
App: EZ Exporter
Tags: refunds