How to use the Bill of Materials Cleaner.
A bill of materials cleanup should preserve part identity and quantity meaning. Normalize formatting, but do not merge different revisions or units simply because descriptions look similar.
Make the workflow fit your task.
Normalize formatting while preserving part number, revision, unit and source-row identity. Group potential duplicates only under an agreed key and report conflicting quantities or descriptions. Keep engineering equivalence decisions separate from text cleanup.
- What you provide
- Supplied component list and normalization rules.
- What you get
- Consistent parts, units and quantities with duplicates flagged.
See the input and the result.
Illustrative input and output · a teaching example, not a live WebAct run
Example input
BOM input rows: A-10, rev 1, 2 ea; A-10, rev 2, 3 each. Normalize unit spelling to each, preserving revision identity.
Completed example
part,revision,quantity,unit A-10,1,2,each A-10,2,3,each Two revision-specific rows retained. Total listed quantity is 5 across distinct revisions, not an authorization to substitute one revision for another.
Load this input into the prompt, then copy it to WebAct to try the task. Your result may differ from the illustration.
Decisions and troubleshooting.
Should two revisions of the same part number be combined automatically?
No. Revisions may not be interchangeable. Preserve them until an authorized source confirms how they should be treated.
Why does cleanup change the total required quantity unexpectedly?
Units, pack sizes or duplicate rules may have been mixed. Reconcile quantities using the original records and declared identity key.
Try it with your own source.
Replace the example with your material in the task prompt. Keep the requirements you need, then copy the task into WebAct.
Customize and copy the task ↑