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:
Related Articles:
App: EZ Exporter
Tags: advanced features, refunds