How do I export only the new Shopify orders that were fulfilled since the last export?

The Shopify API doesn't have a "Fulfilled At" field that we can simply filter by. But a potential workaround in EZ Exporter is to look at the successful fulfillment dates and set the settings like this (the logic here is if the order is currently in "Fulfilled" status, then the last successful fulfillment date would be the "Fulfilled At" date):

The first setting is to set Filters > Created to some reasonable date range to reduce the amount of data to request from Shopify and speed up the export process. For example, if it will never take more than 14 days for an order to get fulfilled, then setting this filter to "Last 14 Days" would work.

Then we want to also use the following Custom Filters:

Data must match: all conditions

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

The Custom Filters happen on our side and our app will then filter the data further to only include orders where the last successful fulfillment is greater than or equal to the last successful run date.

The second Custom Filter handles potential race conditions when an order is fulfilled 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:


App: EZ Exporter

Tags: shopify, advanced features, shopify orders