BOM Structurer

The web tool runs entirely in your browser — nothing is sent to a server.

Getting Started

1. Create a workspace — Name it, name your top-level assembly, and set your hierarchy depth (2–10 levels). Each level can be renamed to match your industry language.
2. Build your Parts Master — Switch to the Parts Master tab and add your leaf-level components — purchased parts, raw materials, hardware. Each gets a unique internal part number and optional vendor PN, expected quantities, and enrichment data.
3. Structure your assemblies — Switch to BOM Structure and build your hierarchy. When adding children, type a part number to autocomplete from your Parts Master. Set quantities per assembly. The same part can appear under multiple parents.
4. Export, enrich, and iterate — Export a multi-sheet XLSX with XLOOKUP formulas. Fill in pricing and suppliers in Excel or Sheets, then import the XLSX back — the tool becomes your single source of truth.

Data saves to your browser's local storage.

Two Views, One BOM

• Parts Master — A flat table of your leaf-level components. Each part gets a unique internal part number, name, description, optional vendor PN, and expected quantity. This is your single source of truth for components.
• BOM Structure — A visual tree of your assembly hierarchy. Assemblies get their own PNs. Children reference parts from the Parts Master via autocomplete — type a PN and select from the dropdown.
• Part Number Autocomplete — When adding items to an assembly, start typing a part number. The tool searches your Parts Master and shows matching entries. Select one to auto-fill name and description.
• PN Validation — Three checks in one click: duplicate PNs in Parts Master, duplicate assembly PNs (with structural fingerprinting — identical sub-assemblies sharing a PN are fine), and stale PNs in the tree that no longer exist in Parts Master.
• Expected Qty & Delta — Set expected quantities in the Parts Master. The structure tab shows a live delta between actual BOM usage and expected — green check when matched, red/yellow when off. Catches quantity mistakes before they reach production.
• Shared Components — The same part can appear under multiple assemblies — a common fastener used in three different sub-assemblies shows up in each one. The Parts Master stays deduplicated.

Built for Difficult BOMs

This isn't a toy. Truckhouse used it to structure a BOM with over 2,700 part numbers.

• Flag for Review — Click the flag icon on any item to mark it for your own review. Flagged items get a red highlight, saved in this browser only. When branches are collapsed, a red badge bubbles up showing how many flagged items are nested inside — drill down without expanding everything.
• Smart Search — Search by part number, name, or description. Matches highlight in red and collapsed branches auto-expand to reveal results. Your expand/collapse state is restored when you clear the search.
• PN Rename Across BOM — Changed a part number? One click updates every instance across the entire tree. No manual find-and-replace. Undoable.
• Dynamic Part Names — Rename a part in the Parts Master and it updates everywhere — tree display, search results, edit modals, and exports. The Parts Master is the single source of truth for component data.
• Multiple Product Lines — One workspace can hold multiple top-level assemblies. Build your product platform, options packages, and accessory lines as separate trees sharing the same Parts Master.

Building Your Tree

• Add & Bulk Add — Click + to add a single child with Part Number autocomplete from the Parts Master. Or use bulk add — paste part numbers one per line and names auto-fill. Tab-delimited paste also supported for Excel/Sheets.
• Edit, Duplicate, Move, Flag — Edit any node inline. Duplicate branches for repeating sub-assemblies (only the parent gets renamed). Move items with a collapsible tree picker + search. Flag items for your own review.
• Drag to Reorder — Grip handle (six dots) to reorder items within the same parent. Drag and drop — no cutting and pasting.
• Undo — Ctrl+Z or click the undo button. 10 levels of history. Delete something by accident? Undo brings the whole branch back.

Multi-Sheet XLSX with XLOOKUPs

One click generates a professionally formatted Excel workbook — branded headers, color-coded assembly rows, auto-filters, frozen panes, and XLOOKUP formulas that cascade quantity changes dynamically. Four linked sheets including an Instructions tab.

• Sheet 1: BOM Structure — Full hierarchy with level columns, part numbers, parent PNs, effective quantities (cascading through parents), and type (Assembly/Part). XLOOKUP columns pull attributes from Parts Master with bounded ranges for fast recalculation.
• Sheet 2: Parts Master — Your leaf-level components with all stored data pre-filled and a dynamic Total Qty Used column (SUMIF formula). Empty cells highlighted yellow for easy filling. UOM and Make/Buy columns have dropdown validation.
• Sheet 3: BOM Lines — Every parent-to-child relationship as a flat row — the ERP recipe format. 100% formula-driven: PNs, names, quantities, unit prices, and line totals all reference the other sheets. Change anything upstream and BOM Lines updates automatically.

Import & Backup

• XLSX Round-Trip — Export your BOM as XLSX, fill in pricing and suppliers in Excel or Sheets, then import it back. The tool merges all enrichment data — no re-entry on the next export.
• CSV Import — Import multi-level columns (L0 Name, L1 Name, ...) or flat format with Level and Item Name. Detects Qty and Vendor PN columns automatically.
• JSON Backup — Full export of your BOM tree, Parts Master, level names, and Qty Audit dismissals as JSON. Use JSON Import to restore, or transfer your work to another browser.

Workspace & Navigation

• Level Configuration — Click Levels in the toolbar to set hierarchy depth (2–10) and rename each level to match your product structure. Changes apply immediately to the entire tree.
• Expand / Collapse — Click the chevron on any parent, or use toolbar buttons to expand/collapse the entire tree.
• Light & Dark Mode — Toggle the sun/moon icon in the top right. Your preference is remembered between sessions.
• Keyboard Shortcuts — Ctrl+Z to undo, Ctrl+F to focus search. More shortcuts coming.

Get the Most Out of It

• Build the Parts Master first. Get your leaf-level components defined before building assemblies. It's faster to autocomplete from a populated Parts Master than to type everything manually.
• Use bulk add for hardware. If you have a list of 50 fasteners going into an assembly, paste them all at once from Excel (tab-delimited: Name, PN, Description, Qty, Vendor PN).
• Set expected quantities early. Enter expected quantities in the Parts Master before your BOM is complete. The delta indicator catches mistakes as you build — not after export.
• Flag before meetings. Use the flag-for-review feature to mark items that need team discussion. Flags bubble up through collapsed branches so nothing gets missed.
• Round-trip your data. Export the XLSX, fill in pricing and suppliers in Excel, then import it back. The tool remembers everything. Next time you export, all your data comes with it.