BOM Builder & Validator

The problem this kills

Your bill of materials lives in a spreadsheet before it ever reaches the ERP - rows of parent SKU, child SKU, find number, quantity, and unit of measure that someone typed, copied, or exported from another system. It looks fine. Then a child part turns out not to exist in the part master, the same find number is listed twice with different quantities, a quantity is zero or blank, the same unit of measure is "EA" in one row and "EACH" in another, or - worst of all - an assembly quietly lists itself somewhere down its own tree and creates an infinite loop.

None of these errors announce themselves. They surface weeks later as a line-down shortage, a wrong build, a planning run that explodes into nonsense, or an ERP import that silently drops rows. By then the cost is real and the trail is cold.

This tool catches every one of those errors at the spreadsheet stage - before the BOM is ever committed - and makes a human engineer sign off on the clean version before anything is exported.

What you'll build

A private web app, just for your team, that:

• Lets you upload your BOM spreadsheet (or paste a Google Sheet link) and map your own column names.
• Explodes the flat parent/child rows into a proper level-indented multi-level BOM tree.
• Validates every line: quantity greater than zero, consistent unit of measure per child part, every child present in the part master, no duplicate parent + find number, and no part listed as its own ancestor (cycle detection).
• Shows you a flagged-error report - every problem with a plain-English reason - alongside the rebuilt indented tree.
• Makes the engineer fix or accept each issue and explicitly approve the clean version before anything leaves the tool.
• Exports an ERP-ready indented BOM CSV in exactly the columns your system expects.

What's inside the Implementation Plan

The plan is a single file you paste into an AI coding agent (Claude Code). It walks the agent through building the whole tool, step by step, with a ready-to-copy prompt at the end of each step.

It opens by interviewing you about your business - your current process, the ERP or system of record you feed, the exact field names and SKU/find-number conventions in your data, your typical and peak BOM sizes, and your messy edge cases (phantom assemblies, reference designators, alternate units). It reflects a short tailored spec back to you and waits for your thumbs-up. The data model, the validations, and the export columns are all shaped by your answers - this is not a generic template you have to bend to fit.

You also get: the indented-tree explosion logic, the full validation engine, the human approval gate, the audit trail, and the CSV-export fallback so the tool works today even with no ERP integration.

The governance it includes (this is the point)

• Login so only your team can open the tool.
• Row-level security so each organization only ever sees its own BOMs and part master.
• A complete audit trail - who uploaded, who reviewed, who approved or overrode each flagged error, and when.
• A hard human-in-the-loop approval gate - the tool flags and drafts the clean BOM, but nothing is exported or marked ERP-ready until an engineer reviews every error and explicitly approves.
• Duplicate guards - the same parent SKU + find number can't slip through twice, and the same upload can't be processed twice.

Who it's for

Manufacturing engineers, BOM administrators, and production planners who own master data and are tired of chasing build errors back to a bad row in a spreadsheet. If you can fill in a spreadsheet, you can build this.

You've got this - paste the first prompt and let the agent interview you.