Use cases

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

Example · A refurbished mixer offer without its whisk against the new product page

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

title: Orlund Artisan 5-Speed Tilt-Head Stand Mixer, 4.8 L Stainless Steel Bowl, Sage Green brand: Orlund model: OR-SM480 colour: Sage green condition: New in_the_box: Mixer, 4.8 L bowl, flat beater, dough hook, wire whisk, pouring shield bullet_points: 5 speeds and pulse; 1000 W motor; tilt-head design; dishwasher-safe bowl and tools price: 329.00
  1. Do both records say enough about the product to judge whether they match?Yes96%
  2. How closely do the two records match under the matching rules?Related offer100%
  3. Do the two records name the same brand?Same brand100%
  4. Do the two records name the same model or product line?Same model98%
  5. Do the two records describe the same variant of the product?Same variant100%
  6. Does one record describe a used, refurbished or open-box item and the other a new one?Yes99%
  7. 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 item7 questions

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

  1. 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.

  2. 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.

    • Different products A different brand, or a different model or product line.
    • Related offer The same brand and model or line, but a different variant, condition or contents.
    • Same product The same brand, model or line, variant, condition and contents, however they are worded.
  3. Do the two records name the same brand? Choice

    Compare the brand or maker each record names, in any column.

    • Same brand Both records name the same brand or maker, however it is written, such as with "and" for "&" or in capitals.
    • Different brands The records name different brands or makers.
    • Not stated At least one record names no brand or maker.
  4. 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.

    • Same model The same model code or product line, ignoring spacing, capitals, hyphens and a brand prefix on the code.
    • Different model Different model codes or lines, including a different generation or version of the same line.
    • Not stated At least one record gives no model code or product line.
  5. 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.

    • Same variant Both records give the same colour, flavour, finish, edition or style.
    • Different variant The records give a different colour, flavour, finish, edition or style.
    • Not stated At least one record gives no variant.
  6. 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.

  7. 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.

Ask for an invite