How do I export only the Shopify orders that were refunded since the last export?
EZ Exporter has a pre-computed field called "Last Refund Date" that we can use to filter the order data for this use case.
To export only orders that had a refund since the last export, you can configure the Filters and Custom Filters in the Data Settings as shown below:
The first setting is to set Filters > Payment status: Partially Refunded or Refunded to reduce the amount of data to request from the Shopify API and speed up the export process.
Then we want to also use the following Custom Filters:
Data must match: all conditions
- Last Refund Date is greater than or equal to {{ last_successful_run }}
- Last Refund Date is less than {{ current_task_start_time }}
The Custom Filters happen on our end and our app will then filter the data further to only include orders with a refund date greater than or equal to the last successful run date.
The second Custom Filter handles potential race conditions where an order is refunded while the export process is still running, so it's important to include that as well to prevent duplicates where an order might get included both in the current run and also the next run.
Related Articles:
- Date and Time Filtering in Custom Filters
- How can I filter my Shopify orders based on the refund date?
- How do I create an automated CSV export that only includes new orders?
- How do I export only new Shopify orders with a time offset to handle a buyer remorse period or post-purchase upsells?
- How do I export only Shopify orders that had a shipment delivered since the last export?
- How do I export only the new Shopify orders that were canceled since the last export?
- How do I export only the new Shopify orders that were fulfilled since the last export?
- How do I export only the new Shopify orders that were paid since the last export?
App: EZ Exporter
Tags: advanced features, refunds