The MRO parts normalisation engine
A seven-stage pipeline that transforms raw MRO parts catalogues into standardised, classified, duplicate-free, and scored records — ready for Maximo Item Master, SAP Material Master, or any ERP.
ERP export ready for
CSV Pre-processing
Struktive detects and skips preamble rows, maps non-standard column headers to canonical fields using an MRO-specific alias library, and handles real-world quoting and encoding issues common in ERP and CMMS catalogue exports.
- Preamble row detection (title rows, blank rows, metadata blocks)
- MRO alias coverage: 'item no', 'part no', 'stock code', 'material no', 'catalogue no'
- Multi-encoding detection (UTF-8, Latin-1, Windows-1252)
- Resilient CSV parsing with automatic delimiter detection
Description Standardisation
Raw part descriptions are standardised to a consistent noun-modifier format. Abbreviations are expanded, units of measure are normalised, and descriptions are trimmed to SAP's 40-character limit or Maximo's field constraints where required.
- Noun-modifier format: 'Bearing, Deep Groove, 6205-2RS, 25×52×15mm'
- UOM normalisation: EA, PCS, SET, M, L, KG — hundreds of variants resolved
- SAP 40-char description enforcement with intelligent truncation
- Abbreviation expansion: 'BRG' → 'Bearing', 'VLV' → 'Valve'
Supplier & Part Number Normalisation
Supplier name variations are resolved to canonical forms. Part numbers are normalised by stripping prefixes, dashes, and leading zeros to enable cross-supplier duplicate detection.
- Supplier alias resolution: same supplier, different name formats
- Part number normalisation: strips prefixes, dashes, leading zeros
- Cross-supplier alias resolution: same part, different supplier codes
- Confidence-scored output: exact match, fuzzy match, and unknown tiers
Parts Classification
Every part is classified into one of six categories: Mechanical, Electrical, Hydraulic, Pneumatic, Consumable, or Safety. Deterministic rules handle the majority of parts. Ambiguous items are resolved by AI inference with confidence scoring.
- 6 categories: Mechanical, Electrical, Hydraulic, Pneumatic, Consumable, Safety
- AI inference for ambiguous parts with confidence scoring
- Out-of-scope detection: non-MRO items flagged
- Classification confidence reported as High, Medium, or Low per record
Duplicate Detection
A multi-signal duplicate detector identifies likely duplicates using fuzzy description matching, part number normalisation, and cross-supplier alias resolution. The Duplicate Parts Report shows every cluster with a recommended master record.
- Fuzzy description matching (Levenshtein ≤ 2 after normalisation)
- Part number normalisation: strips prefixes, dashes, leading zeros
- Cross-supplier alias resolution: same part, different supplier codes
- Duplicate cluster report: master record recommendation per cluster
ERP Pre-flight Validation
Before export, every record is validated against the target platform's ingestion rules. Missing part numbers, invalid UOMs, description length violations, and missing required fields are flagged so you know exactly what will import cleanly.
- Maximo Item Master: ITEMNUM, DESCRIPTION, ITEMTYPE, ORDERUNIT, UNITCOST, ROTATING
- SAP Material Master: 40-char descriptions enforced, Base UOM, Plant, Storage Location
- Pre-flight: missing part numbers, invalid UOMs, description length violations flagged
- Quality score per record — flags records needing attention before import
Quality Scoring
Every part record receives a 0–100 quality score across description completeness, classification confidence, UOM validity, and data integrity signals. Records scoring 70 or above are considered ERP import-ready.
- Multi-factor scoring: description completeness, classification confidence, UOM validity
- Weighting reflects Maximo Item Master and SAP Material Master ingestion requirements
- Score thresholds: ≥85 Excellent · 70–84 Import-ready · <70 Needs review
- Duplicate flags applied as score penalties
Quality score factors
Each part record receives a score from 0 to 100 across description completeness, classification confidence, UOM validity, and data integrity signals. Records scoring 70 or above are considered ERP import-ready.
Column alias detection
Struktive maps non-standard column headers to canonical field names automatically. ERP and CMMS catalogue exports from Maximo, SAP, Pronto, and bespoke spreadsheets are all handled without renaming columns.
Request a sample report
Not ready to upload your own data? We'll run a representative MRO parts catalogue through the full pipeline and email you the complete output — including Maximo Item Master CSV, SAP Material Master export, and ISO 55001 compliance pack.