BOM Import

From Fishbowl
Jump to navigation Jump to search

Icon.BOM Import.png The BOM Import module, located in the Integrations group, is an add-on module that can be installed from the Icon.Plugin.png Plugin module. After installing the plugin, a new module is added that allows the user to import files (csv, xlsx, xls), create a mapping, and import the needed parts, products, and BOMs. The mapping can be unique for each folder selected. The import can be run manually or imported automatically on a schedule.


The documentation on this page is for the most recent version of the Icon.BOM Import.png BOM Import plugin. To get the most recent version, Update Fishbowl.

  1. In any Fishbowl Client, open the Icon.Plugin.png Plugin module, located in the Integrations group.
  2. Select the Icon.BOM Import.png BOM Import plugin and click Install.
  3. Completely close all Fishbowl Clients.
  4. Exit the Fishbowl Server by right-clicking the Fishbowl Server tray icon and selecting Exit.
  5. After re-opening the Fishbowl Server, the admin user can access the Icon.BOM Import.png BOM Import module from any Fishbowl Client by opening the Integrations group.
  6. To grant access to additional users, assign the BOM Import-View access right to the appropriate groups in the Icon.User Group.png User Group module


BOM Import Fields.png
  1. Open the Icon.Bill of Materials.png Bill of Materials module and click the BOM Import Button.png BOM Import button at the top of the module.
    BOM import.png
    Note: BOMs can also be imported by opening the Icon.BOM Import.png BOM Import module, located in the Integrations group.
  2. Select the folder where the files are located and click the dropdown next to the Fishbowl fields to match them with the fields from the file.
  3. If the file is missing values, the default values from the bottom section will be used.
  4. Review the import options at the bottom.
    • Only import parts - When selected, only parts will be imported into Fishbowl. No BOMs will be created.
    • Use filename as BOM number - When selected, the filename will be used as the bill of materials number.
    • Update BOM data - When selected, only existing finished and raw goods data will be updated. Otherwise the BOM will be overwritten.
    • Delete imported files - When selected, successfully imported files will be deleted.
  5. Click the Checked.png Active checkbox in the Schedule section. Click the Run Icon Button.png Run Task button to run the import now, or select a schedule frequency.
    BOM Import Schedule.png
  6. Click the Save Button.png Save button at the top of the module.
  7. To map another folder, click the Select Folder button. The mapping for each folder will be saved separately and can be modified by selecting the folder again.

Release Notes

2021.5.X - 05-13-2021 - Fishbowl 2021.5
  • BOM Import now properly adds and removes items on BOM update
2020.7.X - July 9, 2020 - Fishbowl 2020.7
  • Fixed cost field mapping
  • Fixed bug setting import to other item types not working. Only inventory type worked previously
2020.3.1 - April 15, 2020 - Fishbowl 2020.3
  • Improved functionality on import which allows you to update existing BOM's with added or removed parts
2019.11.0X - 11-21-2019 - Fishbowl 2019.11
  • Fishbowl compatibility release
2019.10.0X - 11/7/2019 - Fishbowl 2019.10
  • Compatible with Fishbowl version 2019.10 and higher