EZ Exporter has a pre-computed field called "Last Delivered Fulfillment Event Date" that we can use to filter the order data for this use case.

Note that depending on the shipping carrier, this information might not be available in Shopify. So this will only work for those shipping carriers where Shopify tracks the shipping status.

You can set these settings in the Data Settings.

First, set Filters > Created to something like "Last 30 Days".

This will reduce the amount of data to request from the API and speed up the export.   If orders in your store can take longer than 30 days to get delivered (from order creation), adjust this filter to cover a longer order history.

Under Custom Filters, add the following filters:

Data must match: all conditions

• Last Delivered Fulfillment Event Date is greater than or equal to {{ last_successful_run }}
• Last Delivered Fulfillment Event Date is less than {{ current_task_start_time }}

Below is a screenshot of what these settings look like in the app.