MRO Parts Catalog Normalisation

Clean parts catalogs.ERP-ready.

Upload a messy MRO parts register CSV. Struktive standardises descriptions, resolves UOM variants, detects duplicates, and scores every row — returning clean, structured data ready for IBM Maximo, SAP MM, or any CMMS platform.

No login required to normalise. Upload, process, download.

Normalised 500 part records · 47 duplicates flagged
struktive / parts-results
Part No.UOMDescriptionLocationCategoryScore
BRG-6205-ZZEABearing, Deep Groove, 6205-2RS, 25×52×15mmWH1-A3-B12Mechanical96
SEAL-V-100pcsv seal 100mm viton shaftWH2-C1-S04
FILT-HYD-10eachhydraulic filter 10 micron return lineWH1-B2-F07
CB-3P-100Ano3 phase circuit breaker 100ampWH3-E1-C02
VALVE-SOL-24Vunitsolenoid valve 24vdc normally closedWH2-D4-V11
5 part records · standardising in real timeAI-assisted classification

Supplier aliases resolved automatically

SKFSKF
FAGSchaeffler / FAG
NSKNSK
3M3M
PARParker Hannifin
EATEaton
SCHSchneider
ABBABB
BOCBOC / Linde
GRAGrainger

+ Timken · NTN · INA · Rexnord · Danfoss · Emerson · Rockwell Automation · Siemens · and 200+ more

Exports to
IBM Maximo 7.6IBM MAS 8.xSAP ECC MMSAP S/4HANA
Maps to
ISO 55001ISO 14224ISO 8000GS1 UNSPSCNATO CAGE
Solutions by outcome

One normalisation engine. Four outcomes.

The same pipeline that standardises and classifies your parts produces different outputs depending on what you need to accomplish.

ERP / CMMS Import

From spreadsheet chaos to platform-ready in minutes

Upload any messy MRO parts register CSV. Struktive standardises descriptions, resolves UOM variants, classifies every part, and produces a validated import file for IBM Maximo Item Master or SAP Material Master. Pre-flight validation tells you exactly what will import cleanly before you touch your ERP.

  • 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
ERP / CMMS Import
Struktive output
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
Ready to download after normalisation
8
Part categories classified automatically
200+
UOM variants resolved to ISO standard
2
ERP platform export profiles (Maximo + SAP)
<90s
Average processing time per 500 records

A seven-stage pipeline that runs in seconds

Every record passes through the same deterministic pipeline. No black boxes — every transformation is logged.

CSV Pre-processing

Preamble detection, column mapping, resilient parsing. Handles real-world quoting, encoding, and mixed-format parts register exports from any ERP or spreadsheet.

Description Standardisation

8 transforms: abbreviation expansion, unit normalisation (mm/in/kg), noise removal, title case, separator standardisation, part number extraction, UOM resolution, dimension ordering.

Part Classification

8 categories: Mechanical, Electrical, Hydraulic, Pneumatic, Consumable, Safety, Instrumentation, Structural. Keyword rules handle 85% instantly; LLM fallback for edge cases.

Warehouse Location Parsing

Extracts WAREHOUSE → ZONE → AISLE → BIN from any free-text format. Handles WH1-A3-B12, Zone A / Shelf 3 / Bin 12, and custom location schemas.

Duplicate Detection

Fuzzy description matching (Levenshtein ≤ 2), part number normalisation (strips prefixes/dashes/zeros), cross-supplier alias resolution. Configurable thresholds.

UOM Normalisation

200+ UOM variants resolved to ISO standard: EA, KG, LTR, MTR, SET, PKT. Handles pcs/piece/pieces, each/ea/no, litre/liter/L, and all common abbreviations.

Quality Scoring

0–100 score per record across seven factors: description completeness, UOM validity, part number format, location depth, category confidence, duplicate flag, and data consistency.

Standards & framework alignment

Two pressures. One dataset.

Maintenance teams face both operational accuracy and audit compliance requirements simultaneously. Struktive maintains the parts data layer that both functions need.

Asset Management
ISO 55001 / ISO 14224 / ISO 8000

Structured parts catalogues with consistent descriptions, validated UOMs, and unique part identifiers are a core ISO 55001 and ISO 14224 requirement. Struktive produces a catalogue that satisfies data quality obligations out of the box.

ISO 55001ISO 14224ISO 8000GS1 UNSPSC
Inventory Accuracy & Audit
Internal audit / NATO CAGE / CAGE codes

Duplicate parts inflate inventory valuations and create procurement risk. Struktive's duplicate detection register provides auditable evidence of catalogue rationalisation, with full chain-of-custody metadata on every transformation.

NATO CAGECAGE CodesChain of CustodyAudit Trail

Ready to clean your parts catalogue?

Upload a CSV file. Get back clean, ERP-ready parts data in under 90 seconds. No account required to start.

First 50 records always free. No credit card required.

We use a single session cookie to keep you signed in. No advertising or tracking cookies. See our Privacy Policy for details.