Pending orders and customer status messages
Customer asks you. You ask dispatch. Dispatch asks stores. Stores is at lunch.
Tested Claude Opus 5.5, medium effort · 15 Nov 2026 · on the practice files
Get the pending order export
Use order ref, customer, ordered qty, dispatched qty, verified stage and confirmed delivery date if any. Include order line ref, SKU, unit, actual dispatch ref and whether a confirmed date is dispatch or delivery.
Check with the responsible team
Use the latest production or stores update; missing dates stay unconfirmed.
Privacy Remove phone numbers, email IDs and payment details where not needed. Use only approved business names and facts.
Whenever I send pending orders as on [As on date], prepare status updates. Sign off: [Sign off]. A. Per unique sales order line (order ref + line ref + SKU), validate matching unit and numeric nonnegative ordered/dispatched qty. Hold duplicate or incomplete lines and negative remaining (over-dispatch); calculate remaining qty = ordered minus dispatched. Show confirmed dispatch or delivery date only with its explicit type; flag pending past confirmed date. Do not confuse dispatch with delivery or treat physical dispatch as billing approval. B. Count pending, completed and invalid order lines; list overdue and missing dates separately. Roll up orders only after checking all lines: an order is completed only when every valid line has no remaining quantity and no held line. Do not sum quantities across different SKUs or units. Give a copyable handoff table with order ref, line ref, SKU, unit, dispatched qty, remaining qty, actual stage, hold/approval status carried from earlier steps (e.g. rate held) and supporting dispatch ref if supplied; mark missing ref [confirm]. C. Draft one short (up to 6 lines) customer update per order using verified line-level stage/remaining and confirmed date/type only; if none, say date to confirm. Internal queries for invalid rows; do not claim invoice or payment is due. Use only supplied facts. Never invent customer names, testimonials, urgency, prices, discounts, delivery dates or credit terms. A person reviews before sending or deciding. Line limits count body lines only, not subject, greeting or sign-off. Keep every required fact; if they do not fit, say so instead of dropping one.
Set it up once. Save the pending-order format. Pick your tool at the top to see how.
What is that?
A Project is a folder in ChatGPT that keeps your instructions and files for every chat inside it. It's on the free plan too. Checked 14 Nov 2026.
What is that?
A Project in Claude is a workspace with its own instructions and files that every chat inside it uses. Checked 14 Nov 2026.
What is that?
A Gem is a custom Gemini that loads your instructions before every chat. Free on every plan; you create it on a computer. Checked 14 Nov 2026.
What is that?
Signed in with a work account, Microsoft's Copilot Chat applies enterprise data protection: your prompts aren't used to train its models. Checked 14 Nov 2026.
After that, each time: send the latest verified order and dispatch status.
First time? Try it in a normal chat: paste and send.
Which model? Use your tool's strongest model with thinking turned on.
In your AI tool: attach the files with the + button, paste, send.
Keep the actual records in your own Excel workbook; share only headings and rules.
Excel A:F order, customer, ordered qty, dispatched qty, stage, confirmed date. As on [As on date]. Give formulas for remaining qty, invalid negative/missing, completed/pending, overdue if pending and confirmed date before as-on, and missing confirmed date. Count each status. No new promised dates. Tell me where to paste formulas or how to set up the local steps; use fictional examples only, no actual records.
Run locally, verify flagged rows against your source and have the responsible person approve any action.
- O25 pending, late. 10 ordered, 5 dispatched; confirmed date 12 Nov.
- O3Date missing. 8 pending; date to confirm.
- O5Over-dispatched. 6 dispatched vs 5 ordered; check stores.
Then send this: Recheck qty and date comparisons, count groups, ensure customer messages match source and no invented date. Reconcile every order line, confirm units and date type, and do not mark an order completed if any line remains or is held.
It promises a new date
Reply: "Use confirmed date only or to confirm."
It sets negative balance to zero
Reply: "Flag invalid; check stores."
It says completed when partial
Reply: "Remaining positive means pending."
Sir ne bola urgent. Ab bolo: ho gaya.
Did it work?
If your whole team does this, we'll set it up for all of them in one session.