How to join two excel product catalogs without matching skus using fuzzy product names
- Step 1Prepare both catalogs — Download supplier price list (product_name, price, supplier_sku) and your internal product master (internal_name, internal_sku).
- Step 2Upload to Fuzzy Merger — File A = internal product master. File B = supplier price list.
- Step 3Configure join — Left column: internal_name. Right column: product_name (supplier). Threshold: 78%.
- Step 4Review and clean — Download merged file. Manually verify low-confidence matches (score < 85%). Update your product master with matched supplier data.
Frequently asked questions
What if one product in the internal catalog matches multiple supplier products?+
Only the single highest-scoring supplier match is returned per internal product row. Review the __match_score — if two products score similarly, consider lowering the threshold to see both candidates.
Can Fuzzy Merger handle 10,000+ product catalog rows?+
Yes with Developer tier — the algorithm compares every row in File A against every row in File B. For very large catalogs (50K+ rows), expect 1–2 minutes of processing time.
Privacy first
Every JAD Excel tool runs entirely in your browser using SheetJS and ExcelJS. Your spreadsheets, formulas, and data never leave your device — verified by zero outbound network requests during processing.