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
Export a safe item list
Use item code, name, spec, unit and category. No supplier banking or personal details.
Privacy Remove bank account numbers, PAN, personal phone numbers and emails. Use vendor business names or codes, item codes and approved commercial details.
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.
Keep your actual records in your own workbook; ask AI for the local method using headings and rules only.
Excel A:E code, name, spec, unit, category. Rule [Review rule], naming format [Approved naming format]. Give local formulas to normalise spaces/case, find repeated spec+unit and near-name candidates, flag missing spec/unit and propose a standard name only for complete rows. No automatic merge or deletion. Tell me exactly where to paste formulas or set up the local steps. Use fictional examples only; do not ask for actual company records.
Run the method locally; check every exception against physical stock, contracts or source records as applicable, and obtain approval before acting.
- P1/P2Same spec/unit. Possible duplicate panel.
- P3Spec missing. Confirm before naming.
- P4Unit missing. Confirm unit.
Then send this: Recount flagged codes and groups; no confirmed duplicate without verification.
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?
If your whole team does this, we'll set it up for all of them in one session.