Automation 💎 Built for Sidekick ⚡ Sidekick does this for you
shopify sidekick automation fulfillment flow

Escalate Delayed Fulfillments

Build a scheduled Flow that finds unfulfilled orders older than a set number of days and alerts the fulfillment team.

đź“‹ Prompt
Run in Sidekick
Build a Shopify Flow that catches orders sitting unfulfilled too long.

Trigger: Scheduled time — recurring, every [FREQUENCY] (e.g. once per day at 9am).

Actions:

  Get order data — query: paid orders, fulfillment status is unfulfilled or partially fulfilled, created more than [DELAY_THRESHOLD_DAYS] days ago (e.g. 3), up to 100 results, sorted oldest first.
  For each order in the results:
    
      Add order tags: “[DELAYED_TAG]” (e.g. “fulfillment-delayed”).
      Update order note appending: “Flagged as delayed — unfulfilled after [DELAY_THRESHOLD_DAYS] days.”
    
  
  Send internal email to [FULFILLMENT_MANAGER_EMAIL] with subject “Delayed fulfillments: [COUNT] orders” listing order numbers and how many days each has been open.


Before activating:

  Show me the exact query filters and confirm the delay threshold.
  Confirm the schedule frequency and time zone.


After I confirm, create and turn on the Flow.

Note: this reports up to 100 orders per run — if you regularly have more than 100 orders past the threshold, tell me and I’ll either tighten the threshold or run the schedule more often so the backlog doesn’t outrun the query limit. This Flow flags and reports; it doesn’t reassign staff or expedite shipping itself.

How to Use

  1. Copy the prompt above
  2. Open Shopify Sidekick in your Shopify admin
  3. Paste the prompt and replace the bracketed placeholders with your details
  4. Review Sidekick's response and apply the suggestions