BOM import and multi-level bill of materials

We turn the bill-of-materials sheets a manufacturer already keeps in Excel into a structured, multi-level BOM: lines are categorised against the item catalogue, typos are suggested only for narrowly trusted shapes, and one confirmed correction is remembered for every later import. Releases are frozen as snapshots.

Who it's for: Manufacturers whose BOMs live in Excel files that every department copies and edits, so nobody is sure which version Procurement is buying from.

How it works

1. 01 Upload the BOM sheet you already keep in Excel.
2. 02 Lines are matched to your item catalogue and grouped into systems and sub-assemblies.
3. 03 Typos are suggested only in trusted shapes, and one confirmed correction is remembered.
4. 04 A released BOM is frozen as a snapshot that Procurement and Stores work from.

The numbers

Real client BOM files imported through the UI

6

Confirmations needed to learn a correction

1

Built for

A boiler and pressure-vessel manufacturer

What to require from any vendor for this: 3 lines on the ERP requirements checklist, each with the test to ask for in a demo.

Questions buyers ask

Do we have to retype our BOMs?

No. The system reads the sheets you already have; six real client BOM files have gone through it.

What happens to a typo like PALTE?

A correction is suggested only for a one-character slip or two swapped letters, and remembered after one confirmation. A looser rule was rejected because it matched PALTE to VALVE as readily as to PLATE.

Which version is Procurement buying from?

The released one. Each release is frozen as a snapshot, so later edits don't change what was sent out to buy.