Try the demo — no signup
Menu
Products
BOM Health CheckCheck a single export for data quality issuesBOM CompareCompare revised BOMs and material exportsMaterial DeltaEstimate the cost impact of revision changesPrice DeltaTrack price movement, quote exposure, and approved alternate pricingQuote CompareValidate supplier quotes against your BOMPrice List CheckFreeCompare two price lists instantlyMaterial Export CleanerFreeFlag spreadsheet junk before handoffDuplicate Part FinderFreeFind repeated part numbers before handoff
Solutions
PrefabricationVDC / BIMProcurementMechanical & FPDistributionNew
Pricing
Resources
Sample reportsBuyer packetSecuritySupport
Log inTry the demo — no signup

BOM data quality

How to check duplicate part numbers in a BOM

Duplicate part numbers are not always wrong. In a fabrication BOM or material list, the same part can appear across areas, floors, work packages, or assemblies. The risk is not the duplicate itself. The risk is not knowing whether it is a normal detail row, a quantity split, or a conflict that will confuse purchasing.

Who this helps: For prefab coordinators, VDC/BIM teams, purchasing, fabrication, estimating, and anyone handing a material spreadsheet downstream.

Start with the part number column

Use the real part number, item number, SKU, material number, manufacturer part, or vendor part number column. Do not use description as the first choice when a part code exists, because descriptions are often edited by hand and can vary between exports.

  • Preserve leading zeros.
  • Keep hyphens, slashes, dots, and suffixes unless your team has a confirmed alias rule.
  • Treat blank part numbers as rows needing review, not as one shared duplicate group.

Separate normal duplicates from conflicts

A part repeated across Level 1, Level 2, and Level 3 may be normal. A part repeated twice in the same area with different descriptions, units, or quantities may need review before purchasing or fabrication.

  • Same part, same unit, different breakdowns: usually a normal cross-breakdown duplicate.
  • Same part, different units: block consolidation until reviewed.
  • Same part, different descriptions: flag as a possible conflict.

Preview consolidation without changing the file

The safest workflow is to preview what the total would be if the duplicate rows represent the same part, while keeping the original source rows visible. That gives purchasing a total without hiding the evidence.

Checklist

Duplicate part number checklist

  1. 1Confirm the part number column is mapped correctly.
  2. 2Check whether duplicates are across different breakdowns or repeated in the same context.
  3. 3Review unit conflicts before trusting totals.
  4. 4Review description conflicts before consolidation.
  5. 5Exclude missing or invalid quantities from trusted totals.
  6. 6Export a report that keeps rows needing review visible.

Watchouts

Common mistakes

Removing duplicates automatically

Removing rows can erase legitimate material split by area, floor, phase, or work package.

Adding quantities when units differ

Ten EA and ten BOX should not become twenty of anything until the unit issue is resolved.

Treating missing quantity as zero

A blank quantity is incomplete data. It should be fixed or marked for review.

Free browser-local workflow

Run the free tool

Use Duplicate Part Finder to test the workflow on your own material file. Raw files are not stored by default.

Run the free tool