How do I export the Shipping Refund from a Shopify order?

You can select the following fields to export the shipping refund order adjustments (note that these values are negative):

  • refunds.order_adjustments.shipping_refund.total_amount - The total amount refunded for shipping (excludes taxes).
  • refunds.order_adjustments.shipping_refund.total_tax_amount - The total tax amount refunded for shipping.

You can add them together using Calculated Fields:

{{ refunds.order_adjustments.shipping_refund.total_amount }} + {{ refunds.order_adjustments.shipping_refund.total_tax_amount }}

If you want to convert the value to a positive number, simply multiply by -1:

({{ refunds.order_adjustments.shipping_refund.total_amount }} + {{ refunds.order_adjustments.shipping_refund.total_tax_amount }}) * -1

Related Articles:


App: EZ Exporter

Tags: shipping, refunds