Setting up a New Fishbowl Inventory Database

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.

Database Creation

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.

LilyPad Commerce–Empowering Small and Medium Businesses

If you run a small- or medium-sized business, you know how important it is to stay competitive.  However, sometimes the thought of taking your products to the Online world can seem daunting.  Luckily, the folks at Sharpe Concepts–the makers of LilyPad products–have come up with a solution to get you Online without having to pay the costs of a custom website, and without all of the fuss.

Commerce Home Page

Introducing LilyPad Commerce

LilyPad Commerce connects directly to your Fishbowl Inventory server and pulls all of your products, categories, prices, images, etc. into an eCommerce platform that will get you selling online within minutes, instead of months.  So, not only do you get a fully-functional eCommerce site quickly and easily, it’s also a fraction of the cost of a custom website.

As soon as an order is placed in LilyPad Commerce, the information is sent directly to your Fishbowl database and is ready for you to begin processing.  Of course, credit card payments will also be processed and will hit your account within moments, giving you the freedom to worry about other things, such as growing your business.

Don’t forget that LilyPad Commerce scales to fit the smallest, or largest, of screens.  Quick and easy navigation will allow your customers to create and place orders within minutes…and best of all, LilyPad Commerce never sleeps.

Amazing features of LilyPad Commerce

Check out this list of features that will give you the Online edge you’ve been looking for:

List of amazing features in LilyPad Commerce

As always, feel free to contact us with your questions and to learn more about our other LilyPad products.


Introducing LilyPad Service Manager

Dispatch, Schedule, and Invoice service customers directly from your Fishbowl Inventory software with
LilyPad Service Manager

 Image of multiple devices used for LilyPad Service Manager
With LilyPad Service Manager:
  • Schedule service appointments
  • Add labor charges, inventory, and time to service calls
  • Accept immediate payments
  • Capture approval signatures
  • Create the service ticket automatically as a Fishbowl sales order
Your Remote Technicians Can:
  • See their schedule remotely
  • Pull up addresses, service history, and existing equipment at site
  • Document activities completed and parts used
  • Schedule follow-up calls
  • Accept payments
  • See inventory availability across locations
Easy-to-use features:
  • Drag-and-drop calendar scheduling
  • Linked directly to Google Maps
  • Runs on computers, tablets, or phones
  • Integrates with remote printers

Contact us for more information, or to schedule a demo!

Introducing LilyPad Vortex

Vortex Home with discounts

LilyPad Vortex is the first Fishbowl add-on sales software built specifically for small and medium-sized B2B companies, their customers, and their sales team. A one-stop resource for today’s sales process at a price that fits your budget.

As a Fishbowl User:

  • Instantly create a fully-functioning customer portal to expand your sales to 24 hours a day, 7 days a week
  • Allow outside salespeople to place orders directly into Fishbowl
  • Put your business on your customers’ phone, tablet, laptop and desktop for ease of order placement


  • Perfect for Route Sales, Trade Shows, or 3PL applications
  • Users log in and see their specific Pricing from your Fishbowl Pricing Rules
  • Allow users to shop by category–controlled directly from your Fishbowl Product Tree
  • Create “Punch Out” sites where users see only the Products or Categories you want them to see
  • Highlight “Featured” or “Sale” products
  • Process payments directly for Customers without Terms

Contact us for more information, or to schedule a demo!

Saying Farewell to 2016

As we come to the end of the year, it’s customary to look back a little. Sometimes it is hard to do in a business which is always looking forward.

However, when you get a chance, the things that stick out are the people. Although the products and places are important, it’s the people that make the difference.

Celebrating The Past

This year we celebrated our 10th year of partnership with Fishbowl. I remember vividly being at a Client and having them show us this software called Fishbowl which they had just bought. At the time, we were working with other software solutions and were impressed enough by what we saw to give them a call. They told us what a big company they were and we said the same. Both of us stretched the truth a bit. We went to partner training that April which Fishbowl had conveniently scheduled for the same time as the Brigham Young University and Utah Valley State College (now Utah Valley University) commencements, so the nearest hotel rooms were 50 miles away. First discovery: Utah has traffic. Second discovery: outstanding people and a great product.  A lot has changed since then but the basis of the relationship has never faltered – trust and respect. Thanks for 10 great years and many more.


Celebrating The Present

Another thing we celebrate is how cool our clients are. We have the most interesting people use our products and services.  It is amazing.  From day to day, week to week, we “work” for distributors and manufacturers who make and sell just about anything you can imagine, and some you can’t (believe me). Just getting to interact with all these people and their businesses, through Fishbowl Inventory Training, and other exciting interactions, makes this the greatest job in the world This year we learned about whoopee cushions, organic goat feed, custom 4-wheel drive vehicles, gluing guns, and wine bottles (empty, unfortunately) to name a few.  In blogs to come, we’ll introduce you to some of them.

Celebrating The Future


This year we also expanded in other ways, adding people and even a new office in sunny Florida. This is either to service our growing client base in the Southeast or to give us a respite from the Northern winters – you guess. Our team continues to grow with talented, committed teammates offering the best service and smarts in the business.

And of course, we have a new website with a blog which will remind us to share with you and thank you more often. That may turn out to be the best development of all of them.

Sharpe Concepts and LilyPad Applications release LilyPad Mobile Warehouse 3.0

Pick in LMW

LilyPad Applications have released our next leap forward with LilyPad Mobile Warehouse. Master Pack functionality now gives the user more data input options by utilizing Outer Box (Master Pack) and Inner Box (Inner Pack) UPC codes, and associated quantity calculations, to identify picking, packing, and receiving in bulk. The Master Pack functionality is also utilized in nearly all LilyPad Mobile Warehouse modules.

Master Pack functionality is only available in LilyPad Mobile Warehouse, solidifying LilyPad Applications’ top leader standing as THE Fishbowl Premier Partner!

But wait, there’s more!!!

LilyPad Mobile Warehouse now allows the user to Apply Payments to Sales Order creation including taking credit card payments through a third party gateway platform built into LilyPad Mobile Warehouse.

Check out our Release Notes for more information or click here to Get Involved with LilyPad today!