Shopify Flow Email Summary for Unfulfilled Orders -- In Store Pickup

[JaRet_Watkins]

I want to notify my fulfillment team of old orders that require action on their part. I've created a flow to identify orders that are unfulfilled between 5-90 days ago:

created_at:<='{{ scheduledAt | date_minus: "5 days" }}' AND 
created_at:>='{{ scheduledAt | date_minus: "90 days" }}' 
fulfillment_status:unfulfilled AND NOT status:cancelled

This does the job but also includes a number of orders that are in store pickup and marked as ready for pickup. Since these orders are still technically unfulfilled, they qualify for this filter. I want to exclude orders that have been marked as ready for pickup, as these orders do not require action on the part of my fulfillment team, but can't find the correct status to exclude them from this filter.

[JaRet_Watkins · Accepted solution]

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"