As of the February 2026 patch Bommer for Autodesk Fusion now supports data importing into your bill of materials. Making it easy to bring external data into your Bommer bill of materials with just a few clicks. Read on to find out more…

Saving your file

Before an export template can be made you will have to save your file so Fusion has a version of this that will not change its component ID. This will allow you to export a Bommer BOM Template that can then be modified and imported.

Creating the import template

Before you can import your data into Bommer you have to prepare the import template. This is the vehicle through which your external data gets read into the right properties within Bommer.

Creating the Component ID property

To make sure the data is properly inserted into Bommer for Fusion you need a special built in property in your BOM called Component ID. You can find more information on how to create custom properties in the settings menu here.

Once this property is created, press OK and you should be able to see it in your edit bill of materials table.

Exporting the BOM template

Once you have your component property now you have to export your bill of materials as normal. For this process only export the properties you want to make changes to. The important items here are the component IDs and the properties which will be the headers in the excel export.

Importing your data into Bommer for Fusion

Edit your BOM template

Once you have your BOM template you can copy and paste the relevant data into the proper cells. This data can come from anywhere, whether its your sales team or an ERP system. Just make sure the component id for the items you are editing are correct.

Where is the import button?

To import your data you need to press the import button located in the edit bill of materials table.

The Bommer classic table

The button is located on the bottom of the window. It says “Click to select file”

The new Bommer table

The button is located in the top right of the window between the Filter and Settings buttons

Importing your data

Press the button to select your edited import template. When you first press the warning the following warning will appear.

From the Old Table

Pressing the button will have the following pop up appear

Press OK and then find the proper file and select it. If the process was successful then you will see the following pop up appear.

From the New Table

Once you press the Button navigate down to From Bommer Export

This will open up the file selector and allow you to pick your BOM to import. You will then see the following pop up appear

Can I tell what has changed?

In the new Bommer table the cells that have been edited will also have an orange outline showcasing which items have been modified.

In the above example I have changed the description of one item and deleted several of the values in the Make/Buy column except for one.

Your Bommer data has now been imported. Make sure to press OK on the table as well to confirm and save the changes, but after that you are good to go.

If you have any questions, feedback, or suggestions please send us an email to support@bommer.io