A very simple way to set up the digital twin of your product in Makersite is to upload a BOM. Uploading your BOM will automatically provide you with the model for your product including compliance, cost and sustainability data.
During the implementation project of Makersite, we will establish part and material matching to the product models within Makersite and ensure that the BOM format of your enterprise flawless imports into Makersite and all results are auto populated.
However, it is good to understand how BOM files need to be prepared for the import into the system.
An import file template can be downloaded by clicking here.
BOM file requirements
In general, we are providing a very flexible and strong BOM import tool. It tries to automatically understand the structure of your BOM file to reduce manual effort to a minimum.
However, there are uncountable approaches to the layout and structure of BOM files. Before we import a BOM file, we just need to do a few adaptions the file.
In the screenshot below, you can see a structure of an example BOM (Note: The order of columns is not relevant).
Please consider the following:
- All BOM levels are to be filled out for each part of the BOM as this defines the hierarchy in the model in Makersite. We start with level 0 for the final part. The next level is level 1 and so on.
- Enter a name for each material also for your final BOM part. These names will be transferred into the Mattermaps.
- Enter an amount and the unit for each material or part. We are supporting common unit systems. In the case the unit is not existing in our unit system you will receive a notification during the import, and you can adapt the unit.
- You can add as many columns with any other additional information to the BOM. It will all be imported and stored in the system, no information will be lost during the import.
- One limitation is that the importer cannot read across multiple columns. Meaning information belonging to one headline should always be in the same column and not be distributed across several ones. Avoid merged cells or columns.
- There is a naming convention: Keep the column level named Level, part name should be named Name, the Amount and the Unit columns should be named as such. The system can use several other names for these columns but to be sure use the suggested names.
- If you have entered CAS numbers into the BOM, Makersite will double check that these numbers are correct and automatically collect all relevant properties from online sources and match it to the relevant regulatory data and add substances into the system.
Exercise: Prepare the example "Ball Pen" BOM for the import into Makersite.
- Download the Ball Pen BOM here: (will be available soon)
- Open the excel file and look at the BOM and check the file for completeness and correctness.
Following results can be found:
a) All relevant columns (Level, Name, Amount, Unit) are available in the BOM.
b) Additional information is included in the BOM, which will flawless import into Makersite and doesn't require any further action.
c) All Materials on the lowest levels have information about the material. This can be of help at a later stage in the process.
d) The red marked information is missing and needs to be filled in: All materials need a level, an amount and a unit. If these information is missing, it will lead to errors in the digital twin and the results.
3. Please see the corrected result below.
Save the BOM on your Desktop, so that in the next step we can import it into Makersite.