DATA · ITEM MASTER

DataCleanAssist — Item Master

Diagnose broken item master data across four layers of checks, and export ERP-ready output.

← All guides Zero data egress

Upload any item master, review structural, business-logic, statistical and AI findings on-device, then export in the exact format your ERP expects.

Stage 1 of 3 · Per file

Item Ingestor — upload your master file

Any format, any ERP source. Xls, xlsx and csv are all handled.

What you see

  • A drop zone and file picker
  • An optional UNSPSC taxonomy toggle
  • An ERP dropdown: SAP, Oracle, Infor, D365

What you do

  1. Pick your target ERP (once)
  2. Enable UNSPSC taxonomy if you want it
  3. Upload your item master file

What you get

  • The file parsed and staged locally
  • Column mapping auto-detected
  • Ready for the Steward
Stage 2 of 3 · Ongoing

Item Steward — four layers of quality checks

Structural, business-logic, statistical and AI checks, running entirely on-device.

What you see

  • Layer 1: structural findings (S01–S10)
  • Layer 2: business logic (B01–B16)
  • Layer 3: statistical outliers (IQR, UOM frequency)
  • Layer 4: AI checks (A01–A06) — semantic dedup, UNSPSC classification, UOM plausibility

What you do

  1. Review each finding one at a time
  2. Accept, reject or reclassify AI proposals
  3. Bulk-select and delegate to a colleague
  4. Search and filter by item code or description

What you get

  • A cleansed item master with an audit trail
  • Every decision recorded
  • Ready for ERP-formatted export
Stage 3 of 3 · Per release

Export Console — ERP-formatted output

Deliver the cleansed master in the exact format your target ERP expects.

What you see

  • An ERP format selector
  • Excel / CSV / Parquet options
  • A PDF audit-report option

What you do

  1. Choose format and destination
  2. Click Export

What you get

  • A file your ERP integration can consume
  • A PDF audit report showing every decision made
  • Full traceability from raw to cleansed