# 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 and setting default distributors, sign in (opens new window) or register (opens new window) for a free account.
To submit searches of up to 1,000 parts at a time, please see the header Extended BOM.
# 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:
- 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.
- 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
- In the Part Number column click the "+" button, then type or paste the part number in the Enter Part Number field.
- 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.
- 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).
- 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.
- 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
- 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.
- 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:
- Select the BOMs from the list by checking the corresponding boxes in the Name column.
- 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:
- Click CREATE A SHARABLE LINK to create a unique URL that can be copied and sent to another user.
- 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:
- 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.
- 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 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 icon after the owner's name.
- On the BOM tool, the shared BOM icon appears before the BOM title.
- Clicking the 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.
# Extended BOM
By default, the BOM Import/Export Part Search tool has a 100-part limit on searches. However, if you need to perform larger searches, you can request access to the Extended BOM. This feature allows approved users to submit searches of up to 1,000 parts at a time when using the BOM Import/Export Part Search tool.
# To Request Extended BOM Access from TrustedParts.com
# If you do not have a user account:
- Register (opens new window) for a new account and verify your email address.
- Follow the instructions below for those who already have a user account.
# If you have a user account:
- Sign in (opens new window) to your account. This takes you to the My Account page.
- Select the Additional Features tab.
- Under Features You May Request, click the Extended BOM link.
- Fill out and submit the request form.
An administrator will review your request and contact you regarding approval.
# After Extended BOM Access Has Been Approved
- Sign in (opens new window) to your account.
- Click on the link BOM Import/Export Part Search in the website header. This takes you to the Start A New BOM page.
- Start your new BOM by adding parts line-by-line, or uploading a file.