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

- Open and activate an assembly and select PDMPublisher > BOM Manager.
- Choose BOM type and Column template at the top; use Columns to add properties.
- Narrow with Find, enter a Group by expression, or select Ignore Components to exclude rows by condition.
- Edit supported cells directly, or Export Excel, work in the workbook, and Import Excel.
- Select Apply to write the supported changes to the SOLIDWORKS documents, then save them.

Settings that matter
| Setting | What to put | Why |
|---|---|---|
| BOM type | Parts only for purchasing, Indented for structure | Quantities roll up or stay per level. |
| Column template | PartNumber, Description, Supplier, Quantity | The same columns ERP Sync can map. |
| Ignore Components | Category equals Reference, say | Reference geometry and fasteners drop out without suppressing them in the model. |
| Group by | {Material} | Rows collected per material for the stock order. |
| Excel workbook template | Your branded workbook with a BOM_Start marker | Exports land in the company format. |

Recipes
| You want | Set | You get |
|---|---|---|
| A purchasing parts list | Parts only; Purchasing template; Ignore Components: Category equals Reference; Export Excel | A flat, branded parts list with rolled-up quantities. |
| A raw material summary | Parts only; Group by {Material} | One row per material for the stock order. |
| A description review by the checker | Export Excel with thumbnails; edit Description cells; Import Excel; Apply | Corrected 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.