Certified SOLIDWORKS® Solution Partner|Built for SOLIDWORKS and SOLIDWORKS PDM Professional|Free Community Edition, no key needed

Product features

BOM Manager: Review, Group and Export SOLIDWORKS Assembly BOMs

BOM Manager in PDMPublisher for SOLIDWORKS shows indented, parts-only or top-level BOMs with property columns, grouping, exclusions and Excel import/export.

The bill of materials is usually built twice: once by SOLIDWORKS in a drawing table, once by hand in Excel because the table cannot be grouped, filtered or fixed without editing every part. BOM Manager reads the active assembly into a live grid, groups and excludes rows by rule, round-trips the data through your own Excel template, and writes supported edits back to the models.

In short

  • Open the assembly, select PDMPublisher > BOM Manager, pick a BOM type (Indented, Parts only, Top-level only) and a column template.
  • Group by material or supplier, exclude fasteners by condition without suppressing them, export to a branded Excel workbook.
  • Edit cells or import the corrected workbook and Apply to write the changes to the parts. Community Edition shows 10 rows; Premium has no limit.

How it works

BOM Manager window titled Bill of Materials with BOM type Indented and Column template Engineering, listing Frame.SLDASM with its Mounting bracket child, Base plate, Roller and M8 socket screw rows with Configuration, Quantity, Description and Material columns, and Import Excel, Export Excel and Apply buttons
An indented BOM with the Engineering column template: configuration, quantity and properties.
  1. Open and activate an assembly and select PDMPublisher > BOM Manager.
  2. Choose BOM type and Column template at the top; use Columns to add properties.
  3. Narrow with Find, enter a Group by expression, or select Ignore Components to exclude rows by condition.
  4. Edit supported cells directly, or Export Excel, work in the workbook, and Import Excel.
  5. Select Apply to write the supported changes to the SOLIDWORKS documents, then save them.
PDMPublisher Settings on the BOM Manager page showing Default column template Default, Default BOM display type Indented, an empty Group by field, the Ignore Components button, an Excel export group with a Workbook template path field, Browse button and Include thumbnail checked
BOM Manager defaults: column template, display type, grouping, exclusions and the Excel template.

Settings that matter

SettingWhat to putWhy
BOM typeParts only for purchasing, Indented for structureQuantities roll up or stay per level.
Column templatePartNumber, Description, Supplier, QuantityThe same columns ERP Sync can map.
Ignore ComponentsCategory equals Reference, sayReference geometry and fasteners drop out without suppressing them in the model.
Group by{Material}Rows collected per material for the stock order.
Excel workbook templateYour branded workbook with a BOM_Start markerExports land in the company format.
Ignore Components condition editor with Add condition and Remove buttons, a Match any condition (otherwise all) checkbox, and an empty grid with Check, Variable / property, Comparison and Value columns
The Ignore Components editor: all conditions must match unless Match any condition is selected.

Recipes

You wantSetYou get
A purchasing parts listParts only; Purchasing template; Ignore Components: Category equals Reference; Export ExcelA flat, branded parts list with rolled-up quantities.
A raw material summaryParts only; Group by {Material}One row per material for the stock order.
A description review by the checkerExport Excel with thumbnails; edit Description cells; Import Excel; ApplyCorrected descriptions written back into the part files.

If something looks wrong

  • The command is disabled: open the assembly itself, not its drawing.
  • Rows are missing: check the Ignore Components conditions, the Find filter and the BOM type.
  • Import does nothing: only workbooks exported by BOM Manager can be imported; keep the hidden identifiers under BOM_Start intact.
  • Apply skipped some cells: built-in columns (Item, Configuration, Quantity) and read-only documents are never changed.

Availability

BOM Manager is part of PDMPublisher for SOLIDWORKS, the add-in that runs inside SOLIDWORKS. It is not part of the PDM Professional task. The Community Edition displays and exports up to 10 rows; Premium has no row limit.

Keep going

Documentation

Frequently asked questions

Which BOM types does BOM Manager support?

Indented, Parts only and Top-level only, selected in the window or as the Default BOM display type in Settings.

Can I exclude fasteners or reference parts from the BOM without suppressing them?

Yes. Ignore Components defines property conditions; matching components are removed from the BOM membership only and stay untouched in the SOLIDWORKS assembly.

Can I export the BOM to my own Excel template?

Yes. Set Workbook template to an .xlsx or .xltx file with a cell named BOM_Start where the header goes; logo and headings go above it. Include thumbnail adds model previews.

Can edits made in Excel be written back to the parts?

Export Excel, edit the workbook, Import Excel, then Apply. Supported changes are written to the SOLIDWORKS documents; save them afterwards.

How do I group the BOM by material or supplier?

Enter a Group by expression such as {Material} using the placeholder menu. Leave it empty for a flat list.

How many rows does the Community Edition show?

Community displays and exports up to 10 rows. Premium removes the limit.

Where to next

PDMPublisher for SOLIDWORKS · PDMPublisher for PDM Professional · All features · Conversion guides · Pricing · Documentation · Contact

The SOLIDWORKS add-in is free to start as the Community Edition. The PDM Professional task comes with a 7-day trial. Download the add-in or start the task trial.