Diamond Inventory Matching

Two messy datasets, one comparison

Matching sounds like a database join, and it would be if both sides were clean. They are not. On one side sits a sentence typed in a hurry, possibly in Hebrew, possibly abbreviated, often incomplete. On the other sits a spreadsheet whose columns, grade abbreviations and weight formats were decided by whoever built it years ago.

Useful matching is mostly the work of getting both sides into the same vocabulary before any comparison happens. Everything after that is straightforward.

The criteria that carry most requests

• Shape. Usually stated first and usually non-negotiable. A buyer asking for oval does not want a cushion.
• Weight range. Almost always a range rather than a point — 1.50–1.70 rather than exactly 1.55 — because buyers work to a budget and a look.
• Colour. Typically a lettered range, often open-ended upwards ("F and better").
• Clarity. Frequently a minimum acceptable grade rather than an exact one.
• Certificate. Many buyers restrict a request to specific laboratories, and some will accept none other.
• Quantity and context. Whether the buyer needs one stone, a matched pair, or a parcel changes what counts as a fit.

Ranges, not exact equality

Because most criteria arrive as ranges, matching is interval logic rather than equality checking. A stone qualifies when its weight falls inside the requested band, its colour sits at or above the requested floor, its clarity meets the stated minimum, and its certificate is one the buyer accepts.

Where a buyer said nothing, nothing is assumed. If a request omits clarity, BrilliantBot does not invent a clarity requirement — the criterion is simply absent, which widens the match set. That is deliberate: guessing on the buyer's behalf produces confident, wrong results.

Why inventory quality decides output quality

Only stones the platform knows about can be matched. That makes the stock list the single biggest lever a dealer controls. A list that is complete, correctly graded and current will produce noticeably better results than one uploaded once and left alone.

The common failure is stale inventory: stones sold, placed on memo or repriced without the list being updated. The system will match them faithfully, and the dealer will follow up on goods they no longer have. Nothing in the matching logic can detect this — it is an inventory hygiene problem, not a matching problem.

What a match is and is not

A match is evidence that a specific buyer asked, recently, for something you hold. It is not a sale, an offer, a commitment, or a guarantee that the buyer is still looking. BrilliantBot does not broker the deal, does not set price, does not hold funds and does not settle payment.

Read next

• Methodology — the end-to-end pipeline and its limits.
• Diamond buyer demand — where the requests come from.
• Find diamond buyers — applying this to stock that is not moving.
• Glossary — shape, carat, colour, clarity and certificate defined.