Bill-of-Materials (BOM) importer updated
Mar 14, 2025
Jimmy Byrum
The updated Bill-of-Materials (BOM) importer can now handle two types of multi-level BOMs:
1) Hierarchy coded with level column
The first type typically has a "level" column where something that is level 2 is the child of whatever is above it at level 1. The ordering of the lines matters for these BOMs. In this example, the main item being created is a Fancy Chair that has 3 line items: Wood Arm, Seat. and Wood Leg. Padded Board is part of the Seat model.
Level | Part ID | Part Name | Quantity |
|---|---|---|---|
0 | FC123 | Fancy Chair | 1 |
1 | WA1 | Wood Arm | 2 |
1 | S1 | Seat | 1 |
2 | PB1 | Padded Board | 1 |
1 | WL1 | Wood Leg | 4 |
2) Hierarchy coded with parent reference
The second type has a reference to the parent line. This is more reliable since the ordering of the lines is not important.
Part ID | Parent ID | Item | Quantity |
|---|---|---|---|
FC123 | Fancy Chair | 1 | |
WA1 | FC123 | Wood Arm | 2 |
S1 | FC123 | Seat | 1 |
PB1 | S1 | Padded Board | 1 |
WL1 | FC123 | Wood Leg | 4 |
The BOM importer will create a Product for the main item (BOM level 0 or a line with no Parent ID) and Material Elements for each line. Both of the examples above would result in the following:
