# BOM Tool

The TrustedParts.com BOM Import/Export Part Search tool allows you to retrieve pricing and inventory availability for up to 100 part numbers using one simple search. For more features, including saving your BOMs, setting default distributors, or working with BOMs with more than 100 parts, sign in or register for an account.

# Start a New BOM

# Add Part Numbers Line by Line

Click the Add parts line by line button. See Manage Your BOMs for how to use the tool from there.

# Upload a File (Supported formats: CSV, TSV, Excel)

Upload a file by dragging it to the field provided or selecting it from a list. After your file is uploaded, follow these steps:

  1. If required, map the fields of the file to the BOM by dragging the applicable column header tags (from the Available Fields group) up to the corresponding field provided. For example, drag the Part Number tag up to the part number field.
  2. Click the button Import the BOM.

See the heading Manage Your BOMs.

# Manage Your BOMs

After creating a BOM, you can name it, add more part numbers, edit and sort the part numbers, and edit and sort the list of authorized distributors.

# Name Your BOM

Click on "Untitled BOM" to activate the field and assign your BOM a custom name.

# Add Part Numbers

  1. In the Part Number column click the "+" button, then type or paste the part number in the Enter Part Number field.
  2. If applicable, edit the part's internal reference number. Note: This field is immediately below the manufacturer part number and is visible only when a BOM is created from an upload file and internal part numbers were supplied during the upload.
  3. Add the desired quantity in the Qty column. Note: Adjusting this value may affect the quantity of results previously selected for purchase (see the heading Select Results for Purchase).
  4. Some parts may require you to choose a specific manufacturer. If so, you may choose from the Select a Manufacturer drop-down menu in the Manufacturer column.
  5. As needed, repeat the above steps with additional part numbers.

# Edit and Sort the List of Part Numbers

  • Sort the order of part numbers by clicking the Sort By drop-down menu in the table header, or by clicking and dragging a part in the Part Number column.
  • Filter by a specific part number or prefix by entering one in the Filter part number text box.
  • If a part line requires you to select a specific manufacturer, choose one from the Select a Manufacturer drop-down menu in the Manufacturer column.
  • Filter by a specific manufacturer name or prefix by entering one in the Filter manufacturers text box.
  • Remove parts that do not exist or should otherwise be excluded from the BOM by clicking the "-" button in the Part Number column.

# Edit and Sort the List of Authorized Distributors

  • Delete a distributor's results by clicking the "-" button next to that distributor name.
  • Sort the order of distributor columns by clicking and dragging the column.
  • Click the Add or Remove Distributor button to do the following:
    • Add distributors to the Selected Distributors list by clicking the "+" button.
    • Remove distributors from the Selected Distributors list by clicking the "-" button.
    • Sort the order of displayed results by clicking and dragging distributor columns.
    • Sort available distributors by BOM coverage.
  • Order the BOM coverage of distributors from greatest to least by clicking the Sort by % Coverage button.

# Export the BOM to an Excel File

  1. Click the gearbox icon next to the Export button at the top of the BOM to open the Edit Export Fields pop-up.
    • Select the fields you want to appear on your exported file.
    • Sort the order of the fields by clicking and dragging the selections to the desired positions.
    • The Part Number, Quantity, and Manufacturer fields are all pre-selected and will automatically be included on the export. If you uploaded values for Internal Reference Number, that field will also be included.
    • If you have signed up for an account, your custom settings will apply to all of your BOMs on all devices. If you do not have an account, the custom settings will apply anytime you use the same device and web browser.
  2. Press the Export button at the top of the BOM to export an Excel file.

# Additional Features

  • Click the "i" icon in the Part Number column to access the following:
    • Part image
    • Link to the datasheet
    • Link to the TrustedParts.com part detail page
  • Click the bell icon* in the Part Number column to open the Stock and Price Alerts form.
  • Check the box Hide Parts Not Available to quickly hide all parts where our distributors do not have any inventory..
  • Click Show All Price Breaks to view all price breaks. (By default, the BOM tool will only show the price break for the quantity you enter.)

*This feature may not be available for all parts.

# Select Results for Purchase

Check the box(es) of in-stock distributor results that you would like to purchase. Click View Selected to open the Selected Items pop-up.

# Selected Items Pop-Up

This pop-up displays a list of the results you have selected for purchase. You can also adjust the quantity of parts and quickly access the authorized distributor's web site.

  • Click ">" to expand the view of a distributor's selected results.
    • Adjust the part quantity for that distributor by clicking the edit icon. Note: Changing this quantity does not affect the original BOM quantity entered.
    • De-select a result by clicking the delete icon.
    • Some distributors display a Buy or Get Quote from [distributor name] button. Click this to open their web site in a new tab. The selected results and purchase quantities will be automatically populated in the shopping cart or another feature of the distributor's site. Other distributors display a Visit [distributor name] button. Click this to open their web site in a new tab.

# Share Your BOMs

BOMs that you own (created) can be shared with other users. Conversely, other BOM owners can share their BOMs with you.

# To Share a Single BOM

  • From the BOM tool, select the Share button that appears at the top of the BOM. This opens the Share BOM pop-up.

# To Share Multiple BOMs

From the Saved BOMs tab of the My Account page:

  1. Select the BOMs from the list by checking the corresponding boxes in the Name column.
  2. Press the Share button. This opens the Share BOM pop-up.

# The Share BOM Pop-Up

On the Share BOM pop-up, you can copy a sharable link, or share the BOM with other users. You may also view, add, and delete BOM recipients and change user permissions.

To Create a Sharable Link:

  1. Click CREATE A SHARABLE LINK to create a unique URL that can be copied and sent to another user.
  2. Click Copy Link to copy to your clipboard.

Note: BOMs shared with a link are view-only and cannot be edited by the recipient.

To Share a BOM with Other Users:

  1. Type or paste an email address in the Enter email addresses... field. Please note:
    • Additional email addresses may be entered one at a time.
    • By default, email recipients will be given editing rights (Can edit). To give just view rights, use the dropdown to select Can view.
    • If a recipient does not have an TrustedParts.com account, they will need to create one.
  2. Click Send.

To Manage Shared BOMs

To manage a BOM already shared, access the Share BOM pop-up by selecting the [person] icon of the shared BOM.

  • To Add More Users: Enter another email address in the Enter Email Addresses field. Click Send.

  • To Change Editing Rights: For either new or current users, select Can Edit or Can View from the drop-down.

  • To Delete User Access: Click the trash icon in the email address line.

# Additional Notes

  • If a shared BOM recipient is not yet registered with TrustedParts.com, they will be invited to sign up.
  • On the Saved BOMs tab of the My Account page, shared BOMs are indicated by the Shared icon after the owner's name.
    • Example: Name/icon
  • On the BOM tool, the shared BOM icon appears before the BOM title.
    • Example: Icon/title
  • Clicking the Shared icon opens the Share BOM pop-up.
  • Only one user at a time can edit a shared BOM. While a user is editing a shared BOM, other users will have view rights. About 5 minutes after the editor finishes (by navigating away from the BOM or signing out of TrustedParts.com) another user may begin editing.