How to import Bill of Materials (BOMs)

You have the option of importing both the parent BOM and the underlying components the BOM consists of.


  1. Select "Inventory" in the top bar
  2. Click "Bill of Materials" in the menu 
  3. Start by importing the overall BOM. Click on "Import" in the upper right corner
  4. You now have the option to download a sample file - which we recommend, to ensure that you include the correct data in the import 
    It is important that you save your file as a .csv file with utf-8 encoding before loading
  5. Remember to fill in the required fields: Product number, Group (enter group number, not group name), Item name, Cost price, Sales price and Unit
  6. Now you can import the underlying lines, click "Import lines" in the menu at the top of the image
  7. You now have the option to download a sample file - which we recommend, to ensure that you include the correct data in the import
    It is important that you save your file as a .csv file with utf-8 encoding before loading
  8. Remember to fill in the obligatory fields: BOM no., Line Item no. And Quantity
  9. You can now import the file
  10. If you use the sample file, it will automatically go in and map the matching columns. Otherwise, you map the columns in the field by simply pressing the headings to that field.
  11. If you want to remove a field, press “X”
  12. Click on "Import"