Goal: notify the fulfillment team about unfulfilled orders aged 5–90 days.
Issue: the Flow filter (date range + fulfillment_status:unfulfilled + NOT cancelled) also captures in-store pickup orders that are already marked “ready for pickup.” These remain technically unfulfilled, and there is no apparent status to exclude them.
Finding: this appears to be a Shopify platform limitation; the “ready for pickup” state isn’t available as a filterable condition in search/Flow.
Workaround/Decision: add a Flow that tags orders when they become ready for pickup (e.g., “Ready for Pickup”), then update the search criteria to exclude that tag (tag_not:“Ready for Pickup”). This keeps only unfulfilled, non-cancelled orders within the 5–90 day window that still require action.
Status: effectively resolved via tagging workaround; no native filter for “ready for pickup” was identified.
It looks like this is a limitation on the Shopify platform. I’m getting around the issue by having a flow add an order tag when the order is ready for pickup, then excluding the order tag:
created_at:<='{{ scheduledAt | date_minus: "5 days" }}' AND
created_at:>='{{ scheduledAt | date_minus: "90 days" }}'
fulfillment_status:unfulfilled AND NOT status:cancelled AND
tag_not:"Ready for Pickup"