PROMPT BRO
Purchase desk

Slow stock list by last movement

₹18 lakh of stock nobody remembers ordering

Tested Claude Opus 5.5, medium effort · 15 Nov 2026 · on the practice files

By handRarely done
With AI20 min
Each time · estimate
Easier on your office computer.Send to my computer
I usePick yours. We'll show the right steps.

Get stock ageing inputs

Use SKU, available qty, last movement date and approved unit value. Missing date stays unknown.

First time? Try it on fake data first:

Privacy Remove bank account numbers, PAN, personal phone numbers and emails. Use vendor business names or codes, item codes and approved commercial details.

Fill the orange boxes
You send (the "prompt": the message you paste into your AI tool)
slow-stock.xlsx

As on: [As on] Review age at least days: [Review age at least days] I'm attaching slow-stock.xlsx. A. Calculate days since last movement and stock value; flag age threshold and missing date/value. B. Sum known stock value and slow stock value; count unknown separately. C. Suggested questions for buyer and stores, no write-off or disposal decision. Use only supplied facts, quotes and approved terms. Flag missing GST, freight, payment days or delivery instead of assuming. Check stock against physical count or software before ordering. A person checks before sending, ordering, paying or posting.

Which model? Use your tool's strongest model with thinking turned on.

In your AI tool: attach the files with the + button, paste, send.

What you'll get back (example, from the practice files)
2slow SKUs
₹25,000slow value
1date missing
  • P1197 days. 100 × ₹100 = ₹10,000.
  • P2227 days. 50 × ₹300 = ₹15,000.
  • P4Date missing. Check movement history.
Before you trust it

Then send this: Recheck ages, values and flags; unknown date not assumed old.

If it goes wrong
Assumes dead stock

Reply: "Age flag only."

Missing date old

Reply: "Unknown."

Invents value

Reply: "Use approved unit value."

Sir ne bola urgent. Ab bolo: ho gaya.

Did it work?