BOM Upload Requirements

Uploading your BOM (Bill of Materials) into Cofactr is quick and straightforward. Cofactr accepts standard file formats. The only data Cofactr needs to source your parts is the MPN (Manufacturer Part Number), the manufacturer, and either the quantity or the reference designators, which would tell us the quantity inherently.

The system automatically maps and validates your data, so you don’t have to spend time cleaning or reformatting spreadsheets - making it easy to go from upload to actionable insights in just a few clicks.

Below are lists of accepted file types and recommended column names to make your BOM upload process easier.

Bill of Material (BOM) Accepted File Types

• CSV

• XLS

• XLSX

Column Names

You can name your columns anything you would like, but to automatically match during the BOM upload process, the columns you are importing must use one of the following names.

Line Number:

• line number

• line

• number

• num

• item

Reference Designators:

• reference designator

• refdes

• designator

• references

• reference

Quantity:

• quantity

• quant

• qty

Manufacturer:

• manufacturer

• mfg

• manufacturer 1

Manufacturer Part Number:

• manufacturer part number

• mpn

• part number

• part

• pn

• device

• p/n

• manufacturer part no

• part number 1

• manufacturer part

Custom/Internal Part Number:

• custom part number

• ipn

• internal

Custom Part:

• custom

• manufactured

• custom part

Alternative Parts:

• alternatives

• alts

• alt mpns

Do Not Place:

• place

• dnp

• populate

• fitted

If you run into an issue as you are uploading your BOM, please reach out to your Cofactr team for guidance!

Written by Matthew Haber