Supplier Catalog Cleanup
Pricing
$0.25 / completed catalog
Normalize catalog titles, match reference products, flag duplicates and review uncertain matches with evidence. CSV or JSON input; JSON, CSV and HTML output.
Pricing
$0.25 / completed catalog
Rating
0.0
(0)
Developer
Gilad Ronen
Maintained by CommunityActor stats
0
Bookmarked
2
Total users
1
Monthly active users
16 hours ago
Last modified
Categories
Share
schemaVersion
Optional
Schema Version.
engineVersion
Optional
Engine Version.
catalogFingerprint
Optional
Catalog Fingerprint.
summary
Optional
Summary.
{ "total": 12, "matched": 3, "review": 5, "new": 3, "invalid": 1, "needsReview": 8, "duplicatePairs": 1, "classified": 7}referenceIssues
Optional
Reference Issues.
[]rows
Optional
Rows.
[ { "rowKey": "c:1", "rowNumber": 1, "id": "SUP-001", "originalTitle": "ACME Sparkling Water 0.5 L", "normalizedTitle": "acme sparkling water 500ml", "normalized": { "brand": "acme", "size": "500ml", "packSize": "1", "color": "", "gtin": "04006381333931" }, "status": "matched", "matchedReferenceId": "MASTER-WATER", "candidates": [ { "rowKey": "r:1", "id": "MASTER-WATER", "title": "ACME Sparkling Water 500 ml", "score": 1, "rule": "validated_gtin", "evidence": [ { "field": "brand", "catalogValue": "acme", "candidateValue": "acme", "reason": "Equal normalized values." }, { "field": "size", "catalogValue": "500ml", "candidateValue": "500ml", "reason": "Equal normalized values." }, { "field": "packSize", "catalogValue": "1", "candidateValue": "1", "reason": "Equal normalized values." }, { "field": "gtin", "catalogValue": "04006381333931", "candidateValue": "04006381333931", "reason": "Equal normalized values." }, { "field": "title", "catalogValue": "acme sparkling water 500ml", "candidateValue": "acme sparkling water 500ml", "reason": "100% token overlap (Dice similarity, not probability)." } ], "conflicts": [], "missingAttributes": [], "eligible": true } ], "candidateCount": 1, "duplicates": [ { "rowKey": "c:2", "id": "SUP-002", "title": "Sparkling Water ACME 500ml", "score": 1, "rule": "validated_gtin", "evidence": [ { "field": "brand", "catalogValue": "acme", "candidateValue": "acme", "reason": "Equal normalized values." }, { "field": "size", "catalogValue": "500ml", "candidateValue": "500ml", "reason": "Equal normalized values." }, { "field": "packSize", "catalogValue": "1", "candidateValue": "1", "reason": "Equal normalized values." }, { "field": "gtin", "catalogValue": "04006381333931", "candidateValue": "04006381333931", "reason": "Equal normalized values." }, { "field": "title", "catalogValue": "acme sparkling water 500ml", "candidateValue": "sparkling water acme 500ml", "reason": "100% token overlap (Dice similarity, not probability)." } ] } ], "duplicateCount": 1, "category": { "value": "Beverages > Water", "status": "reference", "evidence": [ "Category copied from the unambiguous reference match." ] }, "needsReview": true, "reviewReasons": [ "1 potential duplicate row(s); inspect before merging." ] }, { "rowKey": "c:2", "rowNumber": 2, "id": "SUP-002", "originalTitle": "Sparkling Water ACME 500ml", "normalizedTitle": "sparkling water acme 500ml", "normalized": { "brand": "acme", "size": "500ml", "packSize": "1", "color": "", "gtin": "04006381333931" }, "status": "matched", "matchedReferenceId": "MASTER-WATER", "candidates": [ { "rowKey": "r:1", "id": "MASTER-WATER", "title": "ACME Sparkling Water 500 ml", "score": 1, "rule": "validated_gtin", "evidence": [ { "field": "brand", "catalogValue": "acme", "candidateValue": "acme", "reason": "Equal normalized values." }, { "field": "size", "catalogValue": "500ml", "candidateValue": "500ml", "reason": "Equal normalized values." }, { "field": "packSize", "catalogValue": "1", "candidateValue": "1", "reason": "Equal normalized values." }, { "field": "gtin", "catalogValue": "04006381333931", "candidateValue": "04006381333931", "reason": "Equal normalized values." }, { "field": "title", "catalogValue": "sparkling water acme 500ml", "candidateValue": "acme sparkling water 500ml", "reason": "100% token overlap (Dice similarity, not probability)." } ], "conflicts": [], "missingAttributes": [], "eligible": true } ], "candidateCount": 1, "duplicates": [ { "rowKey": "c:1", "id": "SUP-001", "title": "ACME Sparkling Water 0.5 L", "score": 1, "rule": "validated_gtin", "evidence": [ { "field": "brand", "catalogValue": "acme", "candidateValue": "acme", "reason": "Equal normalized values." }, { "field": "size", "catalogValue": "500ml", "candidateValue": "500ml", "reason": "Equal normalized values." }, { "field": "packSize", "catalogValue": "1", "candidateValue": "1", "reason": "Equal normalized values." }, { "field": "gtin", "catalogValue": "04006381333931", "candidateValue": "04006381333931", "reason": "Equal normalized values." }, { "field": "title", "catalogValue": "sparkling water acme 500ml", "candidateValue": "acme sparkling water 500ml", "reason": "100% token overlap (Dice similarity, not probability)." } ] } ], "duplicateCount": 1, "category": { "value": "Beverages > Water", "status": "reference", "evidence": [ "Category copied from the unambiguous reference match." ] }, "needsReview": true, "reviewReasons": [ "1 potential duplicate row(s); inspect before merging." ] }, { "rowKey": "c:3", "rowNumber": 3, "id": "SUP-003", "originalTitle": "ACME Sparkling Water 6 x 500 ml", "normalizedTitle": "acme sparkling water 6 x 500ml", "normalized": { "brand": "acme", "size": "500ml", "packSize": "6", "color": "", "gtin": null }, "status": "review", "matchedReferenceId": null, "candidates": [ { "rowKey": "r:1", "id": "MASTER-WATER", "title": "ACME Sparkling Water 500 ml", "score": 0.72, "rule": "title_similarity", "evidence": [ { "field": "brand", "catalogValue": "acme", "candidateValue": "acme", "reason": "Equal normalized values." }, { "field": "size", "catalogValue": "500ml", "candidateValue": "500ml", "reason": "Equal normalized values." }, { "field": "title", "catalogValue": "acme sparkling water 6 x 500ml", "candidateValue": "acme sparkling water 500ml", "reason": "80% token overlap (Dice similarity, not probability)." } ], "conflicts": [ "packSize differs (6 vs 1).", "Numeric title tokens differ; possible model, size, or pack variant." ], "missingAttributes": [ "gtin" ], "eligible": false } ], "candidateCount": 1, "duplicates": [], "duplicateCount": 0, "category": { "value": null, "status": "unclassified", "evidence": [ "No supplied category, accepted reference category, or taxonomy keyword match." ] }, "needsReview": true, "reviewReasons": [ "packSize differs (6 vs 1).", "Numeric title tokens differ; possible model, size, or pack variant.", "Attributes missing on one side: gtin." ] }, { "rowKey": "c:4", "rowNumber": 4, "id": "SUP-004", "originalTitle": "ACME Sparkling Water 1 litre", "normalizedTitle": "acme sparkling water 1000ml", "normalized": { "brand": "acme", "size": "1000ml", "packSize": "1", "color": "", "gtin": null }, "status": "review", "matchedReferenceId": null, "candidates": [ { "rowKey": "r:1", "id": "MASTER-WATER", "title": "ACME Sparkling Water 500 ml", "score": 0.675, "rule": "title_similarity", "evidence": [ { "field": "brand", "catalogValue": "acme", "candidateValue": "acme", "reason": "Equal normalized values." }, { "field": "packSize", "catalogValue": "1", "candidateValue": "1", "reason": "Equal normalized values." }, { "field": "title", "catalogValue": "acme sparkling water 1000ml", "candidateValue": "acme sparkling water 500ml", "reason": "75% token overlap (Dice similarity, not probability)." } ], "conflicts": [ "size differs (1000ml vs 500ml).", "Numeric title tokens differ; possible model, size, or pack variant." ], "missingAttributes": [ "gtin" ], "eligible": false } ], "candidateCount": 1, "duplicates": [], "duplicateCount": 0, "category": { "value": null, "status": "unclassified", "evidence": [ "No supplied category, accepted reference category, or taxonomy keyword match." ] }, "needsReview": true, "reviewReasons": [ "size differs (1000ml vs 500ml).", "Numeric title tokens differ; possible model, size, or pack variant.", "Attributes missing on one side: gtin." ] }, { "rowKey": "c:5", "rowNumber": 5, "id": "SUP-005", "originalTitle": "Northstar USB-C Cable 1m black", "normalizedTitle": "northstar usb c cable 1000mm black", "normalized": { "brand": "northstar", "size": "1000mm", "packSize": "", "color": "black", "gtin": null }, "status": "matched", "matchedReferenceId": "MASTER-CABLE", "candidates": [ { "rowKey": "r:2", "id": "MASTER-CABLE", "title": "Northstar USB C Cable 100cm Black", "score": 0.99, "rule": "brand_and_mpn", "evidence": [ { "field": "brand", "catalogValue": "northstar", "candidateValue": "northstar", "reason": "Equal normalized values." }, { "field": "size", "catalogValue": "1000mm", "candidateValue": "1000mm", "reason": "Equal normalized values." }, { "field": "color", "catalogValue": "black", "candidateValue": "black", "reason": "Equal normalized values." }, { "field": "mpn", "catalogValue": "cab-10", "candidateValue": "cab-10", "reason": "Equal normalized values." }, { "field": "title", "catalogValue": "northstar usb c cable 1000mm black", "candidateValue": "northstar usb c cable 1000mm black", "reason": "100% token overlap (Dice similarity, not probability)." } ], "conflicts": [], "missingAttributes": [], "eligible": true } ], "candidateCount": 1, "duplicates": [], "duplicateCount": 0, "category": { "value": "Electronics > Cables", "status": "reference", "evidence": [ "Category copied from the unambiguous reference match." ] }, "needsReview": false, "reviewReasons": [] }, { "rowKey": "c:6", "rowNumber": 6, "id": "SUP-006", "originalTitle": "Northstar USB-C Cable 1m blue", "normalizedTitle": "northstar usb c cable 1000mm blue", "normalized": { "brand": "northstar", "size": "1000mm", "packSize": "", "color": "blue", "gtin": null }, "status": "review", "matchedReferenceId": null, "candidates": [ { "rowKey": "r:2", "id": "MASTER-CABLE", "title": "Northstar USB C Cable 100cm Black", "score": 0.99, "rule": "brand_and_mpn", "evidence": [ { "field": "brand", "catalogValue": "northstar", "candidateValue": "northstar", "reason": "Equal normalized values." }, { "field": "size", "catalogValue": "1000mm", "candidateValue": "1000mm", "reason": "Equal normalized values." }, { "field": "mpn", "catalogValue": "cab-10", "candidateValue": "cab-10", "reason": "Equal normalized values." }, { "field": "title", "catalogValue": "northstar usb c cable 1000mm blue", "candidateValue": "northstar usb c cable 1000mm black", "reason": "83% token overlap (Dice similarity, not probability)." } ], "conflicts": [ "color differs (blue vs black)." ], "missingAttributes": [], "eligible": false } ], "candidateCount": 1, "duplicates": [], "duplicateCount": 0, "category": { "value": null, "status": "unclassified", "evidence": [ "No supplied category, accepted reference category, or taxonomy keyword match." ] }, "needsReview": true, "reviewReasons": [ "color differs (blue vs black)." ] }, { "rowKey": "c:7", "rowNumber": 7, "id": "SUP-007", "originalTitle": "Lumo Adjustable Desk Lamp", "normalizedTitle": "lumo adjustable desk lamp", "normalized": { "brand": "lumo", "size": "", "packSize": "", "color": "", "gtin": null }, "status": "review", "matchedReferenceId": null, "candidates": [ { "rowKey": "r:3", "id": "MASTER-LAMP-A", "title": "Lumo Adjustable Desk Lamp", "score": 0.94, "rule": "same_title_tokens", "evidence": [ { "field": "brand", "catalogValue": "lumo", "candidateValue": "lumo", "reason": "Equal normalized values." }, { "field": "title", "catalogValue": "lumo adjustable desk lamp", "candidateValue": "lumo adjustable desk lamp", "reason": "100% token overlap (Dice similarity, not probability)." } ], "conflicts": [], "missingAttributes": [], "eligible": true }, { "rowKey": "r:4", "id": "MASTER-LAMP-B", "title": "Lumo Adjustable Desk Lamp", "score": 0.94, "rule": "same_title_tokens", "evidence": [ { "field": "brand", "catalogValue": "lumo", "candidateValue": "lumo", "reason": "Equal normalized values." }, { "field": "title", "catalogValue": "lumo adjustable desk lamp", "candidateValue": "lumo adjustable desk lamp", "reason": "100% token overlap (Dice similarity, not probability)." } ], "conflicts": [], "missingAttributes": [], "eligible": true } ], "candidateCount": 2, "duplicates": [], "duplicateCount": 0, "category": { "value": null, "status": "unclassified", "evidence": [ "No supplied category, accepted reference category, or taxonomy keyword match." ] }, "needsReview": true, "reviewReasons": [ "Multiple plausible reference matches." ] }, { "rowKey": "c:8", "rowNumber": 8, "id": "SUP-008", "originalTitle": "Leaf Organic Chamomile Tea 20 pack", "normalizedTitle": "leaf organic chamomile tea 20 pack", "normalized": { "brand": "leaf", "size": "", "packSize": "20", "color": "", "gtin": null }, "status": "new", "matchedReferenceId": null, "candidates": [], "candidateCount": 0, "duplicates": [], "duplicateCount": 0, "category": { "value": "Beverages > Tea", "status": "suggested", "evidence": [ "Title contains taxonomy keyword: tea", "Title contains taxonomy keyword: chamomile" ] }, "needsReview": false, "reviewReasons": [] }, { "rowKey": "c:9", "rowNumber": 9, "id": "SUP-009", "originalTitle": "Stainless steel mixing bowl", "normalizedTitle": "stainless steel mixing bowl", "normalized": { "brand": "kitchen works", "size": "", "packSize": "", "color": "", "gtin": null }, "status": "new", "matchedReferenceId": null, "candidates": [], "candidateCount": 0, "duplicates": [], "duplicateCount": 0, "category": { "value": "Kitchen > Cookware", "status": "suggested", "evidence": [ "Title contains taxonomy keyword: mixing bowl" ] }, "needsReview": false, "reviewReasons": [] }, { "rowKey": "c:10", "rowNumber": 10, "id": "SUP-010", "originalTitle": "", "normalizedTitle": "", "normalized": { "brand": "unknown", "size": "", "packSize": "", "color": "", "gtin": null }, "status": "invalid", "matchedReferenceId": null, "candidates": [], "candidateCount": 0, "duplicates": [], "duplicateCount": 0, "category": { "value": null, "status": "unclassified", "evidence": [ "No supplied category, accepted reference category, or taxonomy keyword match." ] }, "needsReview": true, "reviewReasons": [ "Missing product title." ] }, { "rowKey": "c:11", "rowNumber": 11, "id": "SUP-011", "originalTitle": "Garden cotton gloves", "normalizedTitle": "garden cotton gloves", "normalized": { "brand": "", "size": "", "packSize": "", "color": "", "gtin": null }, "status": "review", "matchedReferenceId": null, "candidates": [], "candidateCount": 0, "duplicates": [], "duplicateCount": 0, "category": { "value": "Garden > Accessories", "status": "suggested", "evidence": [ "Title contains taxonomy keyword: gloves", "Title contains taxonomy keyword: garden" ] }, "needsReview": true, "reviewReasons": [ "Invalid GTIN checksum or length; identifier excluded from matching." ] }, { "rowKey": "c:12", "rowNumber": 12, "id": "SUP-012", "originalTitle": "מחברת כחולה", "normalizedTitle": "מחברת כחולה", "normalized": { "brand": "paper house", "size": "", "packSize": "", "color": "", "gtin": null }, "status": "new", "matchedReferenceId": null, "candidates": [], "candidateCount": 0, "duplicates": [], "duplicateCount": 0, "category": { "value": "Office > Stationery", "status": "suggested", "evidence": [ "Title contains taxonomy keyword: מחברת" ] }, "needsReview": false, "reviewReasons": [] }]