Automation 💎 Built for Sidekick ⚡ Sidekick does this for you
shopify sidekick automation draft-orders flow

Tag Stale Draft Orders for Follow-Up

Build a scheduled Flow that finds draft orders left open too long and tags them plus alerts sales to follow up or close them out.

đź“‹ Prompt
Run in Sidekick
Build a Shopify Flow that surfaces draft orders that have gone stale.

Trigger: Scheduled time — recurring, every [FREQUENCY] (e.g. daily).

Actions:

  Get draft order data — query: status is open (not completed/invoiced), created more than [STALE_THRESHOLD_DAYS] days ago (e.g. 7), up to 100 results, sorted oldest first.
  For each draft order in the results:
    
      Add draft order tags: “[STALE_TAG]” (e.g. “stale-draft”).
      Update draft order note appending: “Flagged stale — open [STALE_THRESHOLD_DAYS]+ days with no completed order.”
    
  
  Send internal email to [SALES_EMAIL] with subject “Stale draft orders: [COUNT]” listing each draft order number, customer, and total.


Before activating:

  Show me the exact query and confirm the staleness threshold.
  Confirm the schedule frequency and recipient.


After I confirm, create and turn on the Flow.

Note: this flags for a human follow-up call/email to the customer — Sidekick won’t send the draft order’s invoice or a reminder to the customer automatically, since that’s a customer-facing send that needs your review; use “Send draft order invoice” yourself, or ask me to draft the outreach copy separately, once you’ve decided which stale drafts are worth chasing.

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