How can I filter my Shopify orders based on the refund date?

Since it's possible for a Shopify order to have multiple refund transactions, this gets a bit more complicated as we'll need to parse a list of transactions and pull out the most recent refund transaction.

To make this easier, what we did with EZ Exporter is we provided a pre-set field that already applied this logic called Last Refund Date which we can then filter by just like a standard date/time field.

In the Filters section, you'd want to first set these primary filters:

  • Payment status: Partially Refunded or Refunded
  • Created: Any

Then in the Custom Filters, you can add a filter like this to filter the data further based on the last refund date:

  • Last Refund Date is greater than or equal to 2021-06-15

Here's a screenshot of what this looks like in the app:

Filter Shopify orders by refund date


Related Articles:


App: EZ Exporter

Tags: advanced features, refunds