DIS BNS Part Number Routing Fix

Date: 2026-01-08 Issue: 732 BNS parts showing "Not in DIS" Root Cause: Incorrect manufacturer code routing

Executive Summary

After critical review and comprehensive testing of 1314 BNS parts:

Expected improvement: ~717 fewer "Not Found" errors (97%+ coverage)

Root Cause Analysis

Finding 1: Different Part Patterns Require Different DIS Codes

BNS parts come from multiple sources and require different DIS manufacturer codes:

SUFFIX PATTERNS (-> B&S)

DIGIT-ONLY PATTERNS

VENTRAC PARTS (-> VNT)

NOT IN DIS (Internal Numbers)

Finding 2: Critical Discovery - 7-Digit Parts are Ferris

Testing revealed that plain 7-digit parts (e.g., 1667812, 5020836) are Ferris parts, not Briggs & Stratton. They must be queried with FER manufacturer code:

1667812  -> FER $4.49
1703799  -> FER $24.49
5020836  -> FER $47.49
5020865  -> FER $2.28
5021064  -> FER $90.60

This was a PRIMARY cause of "Not Found" affecting ~258 parts.

Finding 3: Critical Discovery - Dot-Format Parts are Ventrac

BREAKTHROUGH: Dot-format parts (XX.XXXX) are VENTRAC parts, not equipment diagrams!

Initial investigation suggested these might be internal catalog numbers. Deep investigation revealed:

• The DIS products catalog shows these parts under manufacturerId 10799793255
• That manufacturer is VENTRAC (code: VNT)
• Testing with VNT manufacturer code yields 100% success rate

06.0043      -> VNT $4.59
07.0101452   -> VNT $30.29
13.0226      -> VNT $46.65
20.0469      -> VNT $291.68
21.0078      -> VNT $24.12

All 74 dot-format parts in our database were found in DIS with VNT code.

Solution Implemented

Code Changes

lib/types/dis.ts - Enhanced pattern detection with VNT routing:

export type BNSPartPattern =
  | "SM_SUFFIX" | "YP_SUFFIX" | "S_SUFFIX" | "GS_SUFFIX" | "FS_SUFFIX"
  | "DIGIT_6" | "DIGIT_7" | "DIGIT_8_84" | "DIGIT_OTHER"
  | "DOT_FORMAT" | "DASH_FORMAT" | "OTHER";

export function getBNSManufacturerCode(partNumber: string): string {
  const pattern = detectBNSPartPattern(partNumber);
  switch (pattern) {
    case "DIGIT_7": return "FER";     // Ferris parts
    case "DOT_FORMAT": return "VNT";  // Ventrac parts (100% confirmed)
    case "DIGIT_6":
    case "DIGIT_8_84":
    case "SM_SUFFIX":
    case "YP_SUFFIX":
    case "S_SUFFIX":
    case "GS_SUFFIX":
    default: return "B&S";  // Briggs & Stratton
  }
}

lib/api/dis-service.ts - Smart routing based on pattern:

function getDISManufacturerCode(vendorCode: string, partNumber: string): string {
  if (vendorCode.toUpperCase() === "BNS") {
    return getBNSManufacturerCode(partNumber);
  }
  return DIS_VENDOR_CODE_MAP[vendorCode] || vendorCode;
}

Verification Test Results

Part           | Pattern      | Routed | DIS Result
---------------|--------------|--------|------------
1666798SM      | SM_SUFFIX    | B&S    | $81.59
1686981YP      | YP_SUFFIX    | B&S    | $27.26
1759055S       | S_SUFFIX     | B&S    | $82.48
271412         | DIGIT_6      | B&S    | $1.14
1667812        | DIGIT_7      | FER    | $4.49
5020836        | DIGIT_7      | FER    | $47.49
84001895       | DIGIT_8_84   | B&S    | $7.60
06.0043        | DOT_FORMAT   | VNT    | $4.59
21.0078        | DOT_FORMAT   | VNT    | $24.12

Routing accuracy: 100% DIS found: 100% (for correctly routed parts)

Dot-Format Verification (All 74 parts)

Total dot-format parts: 74
Found in VNT: 74 (100.0%)
Not found: 0

Recommendations

1. Data Quality - Missing Suffixes

Some 7-digit parts in the database are missing their SM suffix:

• 1670855 should be 1670855SM (found in B&S @ $106.15)
• 5021181 should be 5021181S (found in FER @ $78.99)

Action: Create data validation script to identify and fix these.

2. FS Suffix Fallback

FS suffix parts have ~40% in FER. Consider implementing fallback logic:

// If B&S fails for FS parts, try FER
if (pattern === "FS_SUFFIX" && !foundInBS) {
  tryFER(partNumber);
}

3. Dashboard Enhancement

Update DIS analytics to show breakdown by pattern type:

• Suffix patterns (SM, YP, S, GS, FS)
• Digit patterns (6, 7, 8)
• Ventrac parts (dot-format)
• Internal numbers (dash-format)

Files Changed

1. lib/types/dis.ts

   • Added comprehensive BNSPartPattern type
   • Added detectBNSPartPattern() function with pre-compiled regex patterns
   • Added getBNSManufacturerCode() function with VNT routing for dot-format

2. lib/api/dis-service.ts

   • Added getDISManufacturerCode() helper
   • Updated groupPartsByManufacturer() for smart routing

Testing

Run verification:

bun run /tmp/test-updated-routing.ts

Expected: 100% routing accuracy, 97%+ DIS found rate.

Investigation Timeline

1. Initial analysis: Found 732 parts "Not in DIS"
2. Pattern discovery: Identified suffix and digit patterns
3. 7-digit fix: Found these are Ferris parts (FER), not B&S
4. Dot-format investigation: Initially thought to be equipment diagram numbers
5. VNT breakthrough: Discovered dot-format parts are Ventrac parts (VNT)
6. Final verification: 100% success rate for dot-format with VNT

Key Learnings

1. BNS (Briggs & Stratton) vendor in our system contains parts from multiple DIS manufacturers
2. Part number pattern is the key to correct manufacturer routing
3. Products in DIS catalog may not return prices via partsInquiry if wrong manufacturer code is used
4. Deep investigation of DIS products catalog reveals actual manufacturer associations