Shopify Flow: Email Notifications for orders that are in transit longer for 7 days

Shopify Plus
1

I’m trying to set up a Shopify Flow automation that triggers an email in the following cases:

  1. Orders that have been fulfilled and have a tracking number, but the shipment status has not updated to “In Transit. after 48 hours”
  2. Orders that have been in transit for more than 7 days without being delivered.

Has anyone successfully built a Flow for this? What conditions and triggers should I use to track these cases?

2

You cannot query orders by tracking number or whatever shipment status would include “in transit after 48 days”. List of query filters the API supports: https://shopify.dev/docs/api/admin-graphql/2025-01/queries/orders#argument-query-filter-default

You also cannot query by orders in transit or how long they have been in transit.

Overall the API does not include much data around delivery status.

You might be able to approximate these things by instead using a wait step. Something like “Order fulfilled → Wait 7 days days”. Fulfilled = shipped (although it does not always mean it left a location yet).