Hey all,
I’m trying to build a Shopify Flow that flags orders created 5–7+ days ago that are not delivered, then pushes those orders into a Google Sheet and alerts Gorgias for my team to act on.
Our setup is:
-
“Delivery Status” on the order = only Tracking added / Delivered
-
Fulfilment status moves from Unfulfilled to Fulfilled
-
We do not use “In progress” or “On hold”
The blocker is that Delivery Status is not available as a filter in Flow, and filtering by Fulfilment Status is not accurate, as many orders are fulfilled but still in transit.
What I need help with is:
-
Whether there is any way (native, API, or custom query) to reference “Delivered vs Tracking added” in Flow
-
Or an alternative logic to reliably identify “in transit too long” orders without relying on carrier reports.
EDIT: Apologies, I’ve just scrolled down and seen a dedicated ‘Shopify Flow’ section.