Setting up a new database in Fishbowl Inventory can be a big task. In our last post, we discussed the options available to you when setting up a Fishbowl database. For some of you brave souls out there, one of the options was to do the setup on your own. Our hope is that this post will help you with the database portion of your Fishbowl Inventory implementation.
Create a New Database
When Fishbowl is first installed on your server computer, an example database is included with the installation. You will need to create a new database into which you will begin setting up your information. Visit Fishbowl Inventory’s wiki page for step-by-step instructions on creating a new database.
Input Your Data
Once you have created your database, you need to then add data to your database. This comes in the form of Customers, Vendors, Parts, Products, Bills of Materials, Inventory, etc. This must be done in an orderly fashion, which we will explain in next week’s post. For now, be aware that this is the most time-consuming, and probably the most difficult, portion of your Fishbowl Inventory Implementation.
Set up Your Integrations
Fishbowl Inventory can be a stand-alone software. However, there are many other pieces of software that can be integrated with Fishbowl Inventory to make your life easier. Some examples include QuickBooks (which is the most common integration, and the reason Fishbowl is such a popular inventory solution for QuickBooks users), UPS Worldship, FedEx Shipstation, LilyPad products, etc. Some of these integrations come in the form of standard Fishbowl Inventory plugins. Others, such as custom shopping cart integrations, take longer to program, and will require installation by the developers. In either case, these integrations can impact your business in a way that will improve your efficiency and accuracy.