Order Management
💎 Built for Sidekick
⚡ Sidekick does this for you
shopify
sidekick
order-management
fulfillment
Delivery Exception Alert Rules
Flag orders whose fulfillment has gone stale — no tracking update, no delivery scan — so staff can triage before customers complain.
📋 Prompt
I want to catch delivery exceptions (stuck in transit, no scan update) before customers have to email us about it. Here are the details: Store name: [YOUR STORE NAME] Expected transit time by shipping method: [e.g., Standard: 5 days, Express: 2 days] Stale threshold to flag: [e.g., no status update for 3 days past expected delivery] Please build: A Shopify Flow triggered on “Fulfillment updated” or on a daily schedule that checks fulfilled orders against their expected delivery window (order fulfillment date + expected transit time from my list) and tags orders that have exceeded it “Delivery-Exception”. An order note added at the same time recording the carrier, tracking number, and days overdue. A saved order filter (tag:Delivery-Exception) so staff see the full exception queue without hunting through all fulfilled orders. A triage checklist: check the carrier’s tracking page for the last scan, determine if it’s lost-in-transit vs. delayed, and decide between reshipping, refunding, or waiting per my policy thresholds. A resolution Flow: adding tag “Exception-Resolved” with a note on the outcome (delivered late, reshipped, refunded) closes the case for reporting. A weekly ShopifyQL report totaling exceptions by carrier and shipping method, so I can see which carrier is causing the most delivery problems. The goal is surfacing shipping problems from Shopify’s own fulfillment/tracking data before the customer has to reach out first.
How to Use
- Copy the prompt above
- Open Shopify Sidekick in your Shopify admin
- Paste the prompt and replace the bracketed placeholders with your details
- Review Sidekick's response and apply the suggestions