PROMPT BRO
Sales desk

Updated price list with revision checks

New price list sent. One dealer still has the PDF from last April.

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

By hand1–2 days
With AI2 hrs
Each time · estimate
Easier on your office computer.Send to my computer
I usePick yours. We'll show the right steps.

Get the current price list

Use SKU, current price before GST and approved percentage revision. Mark missing approval; don't invent rates.

First time? Try it on fake data first:

Confirm effective date

Use approved date and rounding rule; existing orders handled only as instructed.

Privacy Remove phone numbers, email IDs and payment details where not needed. Use only approved business names and facts.

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

I'm attaching current prices and approved revisions. Effective [Effective date]. Rounding: [Rounding rule]. Terms: [Approved announcement terms]. A. Per SKU calculate new price = current × (1 + revision%/100), round as specified, difference. Hold missing revision or approval not Yes; don't invent a new price. B. Count revised/held rows, show old and new prices side by side; no sum of unit prices as revenue. C. Draft short (up to 6 lines) dealer and customer notices with approved date and terms only; attach final list locally after review. 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.

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)
3revised SKUs
2held SKUs
₹1,100P1 new price
  • P110% increase. ₹1,000 to ₹1,100.
  • P3Revision missing. Keep held; ask pricing owner.
  • P4Approval pending. 5% proposal not approved; no new price.
Before you trust it

Then send this: Recalculate each approved new price and difference; confirm held rows and date. Remove any unapproved rate or term.

If it goes wrong
It applies missing rate as 0

Reply: "Hold missing revision."

It includes pending approval

Reply: "Only Yes rows get a new price."

It promises existing orders unchanged

Reply: "Use my supplied terms only."

Sir ne bola urgent. Ab bolo: ho gaya.

Did it work?