Why matching commercial vehicle OEM part numbers in SQL is messy (and how we open-sourced our parser)

Описание и применение

В автомобильной индустрии часть с одинаковым номером OEM представлена в разных форматах, что затрудняет поиск в SQL. Решением стало открытое TypeScript‑библиотека @crazypartsnatcher/oem-normalizer, которая нормализует номера, генерирует варианты поиска и определяет формат производителя, улучшая точность сопоставления.

Задача

Inconsistent OEM and OES part numbers across supplier feeds make SQL matching unreliable, causing missed offers in a commercial vehicle price comparison engine.

Результат

The open‑source normalizer library resolved the part number mismatch issue, enabling accurate matching across supplier feeds and improving the reliability of the price comparison engine.

Рабочий процесс

• 1. Install the package via npm: npm install @crazypartsnatcher/oem-normalizer
• 2. Import functions in Node.js/TypeScript: import { normalizeOem, generateSearchVariants, detectManufacturerFormat, buildPartSearchUrl } from '@crazypartsnatcher/oem-normalizer';
• 3. Normalize raw input: const cleanKey = normalizeOem(rawInput);
• 4. Generate search variants: const variants = generateSearchVariants(rawInput);
• 5. Detect manufacturer format: const formats = detectManufacturerFormat(rawInput);
• 6. Build comparison URL: const comparisonUrl = buildPartSearchUrl(cleanKey);
• 7. Use normalized key for SQL/MariaDB lookups and variants for fuzzy search queries.

Доказательства

When building an automotive or commercial vehicle price comparison engine, the biggest data bottleneck isn't scraping or API rate limits—it's inconsistent OEM and OES part numbers across different supplier feeds.

Источник

We extracted it into a lightweight, zero-dependency TypeScript/JavaScript package and published it on npm and GitHub.

Источник

It handles four core tasks out of the box: normalizeOem, generateSearchVariants, detectManufacturerFormat, buildPartSearchUrl.

Источник

Install via npm: npm install @crazypartsnatcher/oem-normalizer

Источник