Our customers use 3E Exchange to track a variety of data about their products and materials. You can customize what you see in your standard view using the BOM Template. Within the BOM Template, you can also change certain fields to only accept pre-defined values. Additionally, you can add custom columns to the tool to hold any data unique to your system.
​

The BOM Column Template works hand-in-hand with the BOM editor to define defaults for which columns you will see, their order, and their predefined values. You can also add custom columns for data you wish to capture but which isn't a column already available in 3E Exchange.

There are two ways to navigate to the BOM Column Template:

Once in the template, you can configure different BOM column views that can be used across your team to meet a variety of needs. You can add new views, delete views, and enable specific columns to match a report template (such as HPD) if desired. Each view can be customize by following these steps:

To add help text or a predefined value, click over to the "Edit Column Properties" view.
Click the edit button to adjust these settings.

When adding in help text or a predefined value, you will have these options:

In the BOM view, a set of predefined values will offer you a drop down list of choices. If you enter a value that does not match the available predefined values, 3E Exchange will report the issue when you validate the spreadsheet. 

Another setting that will make your BOM the easiest to use will be enabling the Summary Row data. We recommend this for anyone using linked materials, calculating recycled content, or using the summary data of a product for regulatory determinations. 

When you create a new BOM Column View, you can switch to it in a couple ways.

In the BOM Column Template, you can select "Done Editing" and it will apply for any new products created but not for any existing products. In that same view, you can select "Reset all Products/Materials to Match Template" which will have different impacts depending on if you are working on a team account or a Pro or below account. If you are working on a team account, the "Reset all" will update all the products to that view for only you. If you are working on a Pro or below account, the "Reset all" will update the product for everyone on that account.

When you leave the "BOM Column Template" area, make sure you leave the template you want to switch to selected. In an individual product, if you have that view select in BOM Column Template, when you click "Match to BOM Column Template" in the column selector, it will switch to that view. That works even if you didn't click either "Done Editing" or "Match all...". Similar to the above feature, that will update only in your view if you are working on a team account. However, if you are working on a Pro or below account that will update everyone's view.

There is no way to prevent a product's column view from being changed when you click "Match all...".

You can also add custom columns for any data you wish to enter into 3E Exchange but which does not have a standard column.

Custom columns come in three flavors:

To create a new custom column, simply enter a name and click "Add Custom Column" on the Edit Column Properties tab. Custom columns will appear at the bottom of your column list by default, but you can click-and-drag them to wherever they need to be.

To toggle the type of custom column and define predefined values or list filters, click the edit button for a row.

If your products and materials are using a custom column that you later choose to remove, that column's data will still be preserved and available whenever you edit or export your inventory.

Your template defines the expected columns in new products and materials that you create through an import. 

If you attempt to import a custom column not already added to your template, you will need to address the error during the import process and consider adding the new column to your template. Using the mapping you can choose to skip the column or add it as a new custom column in your template. 

If you have questions about using 3E Exchange or the material covered in this help article, reach out in chat in the bottom right-hand corner or email support@3eco.com.
​