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
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
- 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