Part Number Discrepancy Analysis Report

Date: January 8, 2025 Purpose: Analysis of McHale part number mismatches between photo folders and DIS Status: ✅ ROOT CAUSE FOUND AND FIXED

Executive Summary

ROOT CAUSE IDENTIFIED AND FIXED

Problem: DIS manufacturer code was set to "MCHALE" instead of "MCH"

Fix Applied: Changed MCH: "MCHALE" → MCH: "MCH" in lib/types/dis.ts

Result After Fix:

• ✅ 57 / 62 parts found (91.9%)
• Total inventory value: $4,682.41

Remaining Issues (3 parts)

KUHN parts work correctly (162 parts, ~100% match rate).

Key Findings

✅ KUHN - Working Correctly

❌ McHale - Incorrect Format

Hypothesis Analysis

Hypothesis 1: McHale Spare Parts Category Codes (HIGH CONFIDENCE ⭐⭐⭐⭐⭐)

Evidence:

• Prefixes map to component categories confirmed in official McHale spare parts books
• Structure follows "intelligent" part numbering: [Category Prefix] + [Sequential Number]
• Same format found in McHale R6272/R6878 spare parts documentation

Conclusion: These are McHale's internal categorization codes used in spare parts books, NOT the retail/dealer part numbers used in DIS.

Hypothesis 2: Legacy/Superseded Part Numbers (MEDIUM CONFIDENCE ⭐⭐⭐)

Evidence:

• McHale may have changed numbering systems over time
• Some codes might be older format that DIS doesn't recognize
• Part 770159 (numeric only) found close match: 770103 in DIS

Supporting data:

Our code: 770159 (numeric, no prefix)
DIS near-match: 770103 - "BEARING BALL"
Difference: Last 2 digits (59 vs 03)

Conclusion: Some numeric codes may be legacy numbers with minor transcription errors.

Hypothesis 3: Regional/EU Part Numbers (MEDIUM CONFIDENCE ⭐⭐⭐)

Evidence:

• McHale is headquartered in Ireland
• Prefixes KG and KST suggest German/European origin
• KG = "Kilogramm" (German) or European code system
• Different format: 8 digits vs 5 digits for other prefixes

Conclusion: Some codes may be European variants that need translation to US/DIS format.

Hypothesis 4: Aftermarket Cross-Reference System (LOW-MEDIUM CONFIDENCE ⭐⭐)

Evidence:

• Parts distributors (Edney, Ag-Com) list parts with these codes
• May be an industry cross-reference standard
• Could map to multiple equivalent DIS numbers

Conclusion: Less likely as primary explanation, but some codes may have aftermarket origins.

Hypothesis 5: Clinton Tractor Internal Codes (LOW CONFIDENCE ⭐)

Evidence:

• User indicates this is unlikely
• Codes appear in official McHale documentation, not just Clinton systems
• Structure too consistent to be dealer-specific

Conclusion: Unlikely to be Clinton-specific, more likely McHale's own categorization system.

Part Number Mapping Analysis

Incorrect Part Numbers with Possible Correct Variants

DIS Category Distribution (5,000 sample)

Photo Folder Inventory

Location: /Users/john/crop_parts/ on Mac Studio

Complete McHale Code Inventory (66 folders)

By Prefix Category

CBR (Bearings) - 6 parts:

CBR00064, CBR00072, CBR00081, CBR00263, CBR00276, CBR00339

CEL (Electrical) - 20 parts:

CEL00010, CEL00031, CEL00059, CEL00154, CEL00164, CEL00727,
CEL00767, CEL00907, CEL00914, CEL01525, CELO1568

⚠️ Note: CELO1568 has typo (O instead of 0)

CFA (Fasteners) - 13 parts:

CFA00132, CFA00147, CFA00239, CFA00446, CFA00506, CFA00543,
CFA00544, CFA00545, CFA00549, CFA00681, CFA00682, CFA00683, CFA00878

CHY (Hydraulic) - 4 parts:

CHY01080, CHY01368, CHY02323, CHY02325

CSE (Seals) - 5 parts:

CSE00021, CSE00079, CSE00081, CSE00143, CSE00642

CSG (Springs) - 3 parts:

CSG00206, CSG00208, CSG00229

Other Prefixes:

ALA00005, ALA00177          (2 - Unknown)
CAX00011                    (1 - Unknown)
CKN00018                    (1 - Knives)
CMH00672, CMH01047          (2 - Misc Hardware)
CTN00008                    (1 - Unknown)
CTP00048, CTP00070          (2 - Unknown)
CVA00008, CVA00285, CVA06001 (3 - Variable Chamber?)
CXB00266                    (1 - Unknown)
CXT00185                    (1 - Unknown)
KG01799100, KG01801400      (2 - EU format?)
KST00058, KST00247          (2 - EU format?)
MT40255042                  (1 - Model/Type?)
770159                      (1 - Numeric only)

Recommended Actions

Priority 1: Immediate (This Week)

1. Get McHale Spare Parts Books

   • Download from: McHale Media Library
   • Models: Fusion 3, 998, 991L, R6272/R6878
   • Cross-reference our 66 codes to find DIS equivalents

2. Contact McHale Parts Department

   • Email: parts@mchale.net
   • Ask: "What are the retail part numbers for CBR00064, CEL00010, etc.?"
   • Provide: Full list of 66 codes for translation

3. Verify 770159 → 770103

   • Check physical part for actual number
   • May be transcription error (59 vs 03)

Priority 2: Short-term (This Month)

4. Manual Photo Review

   • Open each photo folder
   • Look for part number visible on the actual part
   • Create mapping spreadsheet

5. Contact Parts Distributors

   • Edney Distributing: 800-842-7467
   • Ask about CBR/CEL code → DIS number mapping

Priority 3: Process Improvement

6. Update Photography SOP
   • Require capturing the part number from the physical part
   • Use DIS format, not category codes
   • Add verification step before upload

Instructions for Photographer

Current Problem

The McHale folders use category codes (CBR00064) instead of manufacturer part numbers (770103).

What to Look For on Parts

McHale parts typically have numbers in these formats:

• Pure numeric: 770103, 50460, 84009095
• Alphanumeric: MT40377992, G10503MPP
• With dots: 55.0063, 8.711-180.0
• With dashes: F41-22570

DO NOT Use

• Category codes: CBR, CEL, CFA, CHY, CSE, CSG, etc.
• These are organizational codes, not part numbers

Compare: KUHN (Correct) vs McHale (Incorrect)

Appendix: DIS Test Results

KUHN - All Found

05901400: $40.49 | Qty: 4 | ✅ In Stock
80201240: $1.63  | Qty: 40 | ✅ In Stock
K1605230: $17.12 | Qty: 4 | ✅ In Stock
A4054094: $135.04 | Qty: 1 | ✅ In Stock
80253556: $4.84  | Qty: 2 | ✅ In Stock

McHale - None Found

CBR00064: ❌ Not found
CEL00010: ❌ Not found
CFA00446: ❌ Not found
770159:   ❌ Not found (but 770103 exists - possible typo?)

Sources

• McHale Spare Parts Books - Ag-Com
• McHale Media Library - Spare Parts
• R6272 & R6878 Spare Parts Book - McHale Persen
• DIS API - Clinton Tractor Quantum DMS

Document History