Fishbowl Inventory Order of Imports

Creating a Spreadsheet on a LaptopIf you are using import files to create a new database in Fishbowl Inventory, you might be overwhelmed by the number of import files and you might not know where to begin.  We’ve listed the suggested order of imports below, with some tips, to help you get started on the right foot.

Suggested Order of Imports

Here’s a list, taken directly from the FishbowlInventory wiki page that gives a list of the order of imports:

  1. Units of Measure
  2. Unit of Measure Conversions
  3. Location Groups/Locations
  4. User/User Rights
  5. Payment Terms
  6. Carriers
  7. Custom Fields
  8. Vendors*
  9. Tax Rates
  10. Customers*
  11. Customer Group Relations
  12. Part Product And Vendor Pricing*
  13. Kit Items
  14. Default Locations
  15. Add Inventory*
  16. Bill of Materials*
  17. Product Tree Categories
  18. Product Tree
  19. Pricing Rules
  20. Sales Orders*
  21. Purchase Orders*

* This is essential data needed to utilize Fishbowl’s features.

The list above will help you set up a robust database that will unlock most of the features in Fishbowl.  However, what if you just want to do the basics?

The Bare Essentials

If you are in a rush to get started with Fishbowl Inventory, you can upload your Vendors, Customers, Parts, and Products.  That’s it.  You can add all of the other stuff later to make the database more robust.  This comes with a caveat, though.  For example, if your Vendors or Customers have special payment terms, you will need to bring in those payment terms before uploading your Customers or Vendors.

The same thing goes with your Parts and Products list (see this blog post for more information about the difference between Parts and Products).  If your Parts or Products use Units of Measure that don’t exist in the default list, you will need to add those Units of Measure first.

Here is a modified list that shows the basic information that you need to have in Fishbowl before being able to use the system:

  1. Units of Measure
  2. Unit of Measure Conversions
  3. Location Groups/Locations
  4. User/User Rights
  5. Payment Terms
  6. Carriers
  7. Custom Fields
  8. Vendors*
  9. Tax Rates
  10. Customers*
  11. Customer Group Relations
  12. Part Product And Vendor Pricing* (You can also use the individual Part and Product imports, if this one is too big to chew)
  13. Kit Items
  14. Default Locations
  15. Add Inventory*
  16. Bill of Materials*
  17. Product Tree Categories
  18. Product Tree
  19. Pricing Rules
  20. Sales Orders*
  21. Purchase Orders*

Additional Imports

These imports, that aren’t covered in the list provided on the Fishbowl Inventory wiki page, can also be helpful:

  1. Associated Pricing
  2. Country And State
  3. Currency
  4. Customer Parts
  5. Discounts
  6. Product Pricing
  7. QuickBooks Class
  8. Reorder Levels
  9. Vendor Cost Rules
  10. Vendor Parts

Please leave a comment if you have questions or experience using import files that could help others who are beginning their journey.

Leave a Reply

Your email address will not be published. Required fields are marked *