PROMPT BRO
Purchase desk

Item master duplicate candidates and gaps

Same item, five spellings, six codes.

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

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

Export a safe item list

Use item code, name, spec, unit and category. No supplier banking or personal details.

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)
item-master.xlsx

Review rule: [Review rule] Approved naming format: [Approved naming format] I'm attaching item-master.xlsx. A. Group possible duplicates; list codes and reason, never merge. B. Flag missing spec/unit and propose names only for complete rows. C. Questions for stores to verify transactions and approved master before changes. 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? The free one in any tool is fine.

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

What you'll get back (example, from the practice files)
5items
1duplicate group
4flagged codes
  • P1/P2Same spec/unit. Possible duplicate panel.
  • P3Spec missing. Confirm before naming.
  • P4Unit missing. Confirm unit.
Before you trust it

Then send this: Recount flagged codes and groups; no confirmed duplicate without verification.

If it goes wrong
Merges items

Reply: "Candidates only."

Invents spec

Reply: "Leave unknown."

Uses name alone

Reply: "Check spec and unit."

Sir ne bola urgent. Ab bolo: ho gaya.

Did it work?