Tell whether two product records are the same item
Compares a seller offer with a product page: same product, related offer or different, with brand, model and variant checks. Code compares the sizes.
Try it on this example
Incoming offer, each column as column: value: title: ORLUND stand mixer SM480 5 speed 4.8L tilt head - sage (renewed) brand: Orlund model: SM480 colour: Sage condition: Refurbished seller_notes: Refurbished by the manufacturer and fully tested. 12 month warranty. Comes with flat beater and dough hook. Whisk and splash guard not included. Box may show signs of handling. price: 189.00
Existing product page, each column as column: value
- Do both records say enough about the product to judge whether they match?Yes96%
- How closely do the two records match under the matching rules?Related offer100%
- Do the two records name the same brand?Same brand100%
- Do the two records name the same model or product line?Same model98%
- Do the two records describe the same variant of the product?Same variant100%
- Does one record describe a used, refurbished or open-box item and the other a new one?Yes99%
- Does one record include an item or accessory that the other says is left out?Yes98%
These are real answers stored from one run on this example.
The prism behind it
Tell whether two product records are the same item
Fields
- Incoming offer, each column as column: value
- Existing product page, each column as column: value
Context
Offer matching for the catalogue team of Tradewick, an online marketplace for home and kitchen goods. Sellers list offers, and each offer should sit on the right product page so shoppers compare like with like. Code first finds candidate pairs: an incoming seller offer (record A) and an existing product page (record B) that share a brand or several words. This check says whether the two records describe the same product. Code compares every number itself: size, capacity, weight, wattage, pack count and price. A person on the catalogue team decides every pair the answers leave in doubt; nothing is merged or unlisted on these answers alone. Our matching rules: - Same product: the same brand, the same model or product line, the same variant (colour, flavour, finish, edition or style), new condition, and the same contents in the box. Differences in wording, word order, capital letters, abbreviations or a brand prefix on the model code do not matter. - Related offer: the same brand and model or line, but a different variant, a used, refurbished or open-box item, or different contents, such as a missing accessory or an added bundle. A related offer gets its own product page, linked to the main one. - Different products: a different brand, or a different model or line. Leave numbers out of every answer; code adds its own comparison of them.
Questions
Do both records say enough about the product to judge whether they match? Yes / No
Read both records. Yes: Each record names the product clearly enough, through its title, brand, model or description, to compare it with the other. No: One record is empty, a placeholder, or too vague to tell what product it is, such as a title that is only a category name.
How closely do the two records match under the matching rules? Scale
Read both records and the matching rules in the context. Judge brand, model, variant, condition and contents. Leave numbers out: code compares size, capacity, weight, wattage, pack count and price.
Do the two records name the same brand? Choice
Compare the brand or maker each record names, in any column.
Do the two records name the same model or product line? Choice
Compare the model codes and product line names in both records, in any column.
Do the two records describe the same variant of the product? Choice
Compare the colour, flavour, finish, edition or style each record gives. Names that mean the same shade or style, such as "navy" and "navy blue", are the same.
Does one record describe a used, refurbished or open-box item and the other a new one? Yes / No
Read the condition, title and notes of both records. Yes: One record describes the item as used, refurbished, renewed, open-box or ex-display, and the other as new. No: Both records describe the same condition, or neither says.
Does one record include an item or accessory that the other says is left out? Yes / No
Read what each record says is in the box, included or not included. Yes: One record lists an accessory, part or extra product that the other says is missing, not included or sold separately, or one is sold as a bundle or set with an item the other plainly lacks. No: The records describe the same contents, or neither says what is included, or one simply lists less detail without saying anything is left out. Different words for the same part, such as "paddle" and "flat beater", are the same part.
Lens columns
enough_information, enough_information_probability, match_level, match_level_average, brand_match, brand_match_probability, model_match, model_match_probability, variant_match, variant_match_probability, condition_differs, condition_differs_probability, bundle_differs, bundle_differs_probability
Run it on your own text
Add this prism in the app, change any question, and test it on a file of your own.