# BOM Multiple Import ![](https://hugeerp0.co.za/csp/webhelp/topics/images/new%20feature(1).jpg) Still coming or will be in new release **Bill of Materials (BOM) multiple import** This will allow for multiple BOM imports from one Excel sheet. Go to Inventory > Configuration > BOM setup Click on Print/ Export drop down and select Import BOMs ![](https://hugeerp0.co.za/csp/webhelp/topics/images/image(3062).png) Select your file for import, upload and import ![](https://hugeerp0.co.za/csp/webhelp/topics/images/image(3063).png) Exception report There will be an except report afterwards which will show what Bill of Materials have not imported due to the following:
1Bill of materials code is not unique, duplicate found
2Inventory line item does not exist, or is Not active
3Bill of materials result item does not exist
4Bill of materials result item is not marked as a BOM
**Excel file layout** Prepare the Excel file for import The file is prepared in a CSV file and separated by Semi colon.
BHBOM Header which stands for the BOM information
BLBOM Lines which make up the BOM or build inventory lines
CodeThis is unique and is the code of the BOM (Required)
DescriptionDescription of the BOM (Required)
Result itemis the code of the BOM inventory item which is flagged as a bill of materials item (Required)
BL
CodeInventory item code (Required)
DescriptionDescription of inventory item
QtyQuantity of BOM line which will make up one item (Required)
WarehouseStock item warehouse code (Required for stock items)
CostCost price of line
Stock items will get cost from system Service and custom items will update cost that is set here Note - if value is left blank for service and custom, this will bring in a cost of zero
BH Code Description Result item
BL Code Description QTY Warehouse Cost Stock Type
BL Code Description QTY Warehouse Cost Stock Type
BL Code Description QTY Warehouse Cost Stock Type
BH Code Description Result item
BL Code Description QTY Warehouse Cost Stock Type
BL Code Description QTY Warehouse Cost Stock Type
BL Code Description QTY Warehouse Cost Stock Type
BH PC/BOM/WSi3/01 PC BOM Workstation i3 XX/PC/BOM/WSi3
BL CAS/SIL/PS08 Silverstone case 1 MAST 50.00 Stock
BL POW/DES Power supply 1 MAST 85.00 Stock
BL MBD/H310M Motherboard 1 MAST 140.00 Custom
BL MEM/DES/DDR4/4Gig Power supply 4 MAST 45.00 Stock
BL LAB/LABSD Labour 2 90.00 Service
**Template** Import template can be found under System Configuration > Administration > Imports ![](https://hugeerp0.co.za/csp/webhelp/topics/images/image(3064).png)