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
Get the current price list
Use SKU, current price before GST and approved percentage revision. Mark missing approval; don't invent rates.
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.
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.
Keep the actual price list in Excel.
Excel A:D = SKU, current price, revision as number %, approval. Rounding [Rounding rule]. Write formulas for E ready/hold (only numeric revision and approval Yes), F revised price if ready, G difference. Leave held new price blank. Tell me where to paste.
Fill down, check each approved revision and get final sign-off before circulation.
- P110% increase. ₹1,000 to ₹1,100.
- P3Revision missing. Keep held; ask pricing owner.
- P4Approval pending. 5% proposal not approved; no new price.
Then send this: Recalculate each approved new price and difference; confirm held rows and date. Remove any unapproved rate or term.
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?
Doing this every week? Save it once.
Save the prompt in your AI tool, so next time you only drop the files in. 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.
If your whole team does this, we'll set it up for all of them in one session.