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

Shopify Plus

Topic summary

A user wants to create a Shopify Flow automation for two scenarios:

  1. Alert for stalled shipments: Email when an order has a tracking number but hasn’t shown “In Transit” status after 48 hours
  2. Alert for delayed deliveries: Email when orders remain in transit beyond 7 days without delivery

Current limitation identified:

Shopify’s API does not support querying orders by:

  • Tracking number
  • Shipment/delivery status (including “in transit”)
  • Duration in transit

The API has minimal delivery status data available.

Suggested workaround:

Use a time-based approach instead:

  • Trigger: “Order fulfilled”
  • Action: “Wait 7 days”
  • Then send notification

Note: “Fulfilled” typically means shipped, though it doesn’t guarantee the package has physically left the facility. This approximation won’t perfectly match the original requirements but may be the only feasible solution within Flow’s current capabilities.

Summarized with AI on October 31. AI used: claude-sonnet-4-5-20250929.
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).