BOM Import

  Back to all categories

Plugins

  Training Videos

  3dcart

  Amazon

  Audit Trail

  Avalara

  BigCommerce

  BOM Import

  Data Import

  eBay

  Fishbowl Anywhere

  Fishbowl GO

  Fishbowl ShipExpress

  Fishbowl Time

  Forecast

  Magento

  QBO Browser

  Sales Data

  Salesforce

  ShipStation

  Shopify

  SPS

  Volusion

  WebShop Manager

  WooCommerce

  Xero Browser

  Zen Cart

  Zoho

The BOM Import module, located in the Integrations group, is an add-on module that can be installed from the 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.

Install

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

1. In any Fishbowl Client, open the Plugin module, located in the Integrations group.
2. Select the 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 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 User Group module

Import

1. Open the 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, the filename will be used as the bill of materials number.
   • Delete imported files - When selected, only existing finished and raw goods data will be updated. Otherwise the BOM will be overwritten.
5. Click the Active checkbox in the Schedule section. Click the Run Task button to run the import now, or select a schedule frequency.
   
6. Click the 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

2020.3.1 – April 15, 2020 - Fishbowl 2019.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