Liquor Store Inventory Lists: How to Get One

Liquor Store Inventory List

If you are getting a point of sale software, whether it is a new store, upgrading from a cash register, or switching software, you will need an inventory list for your database. Depending on your current setup, there are a few ways you can get inventory into your new liquor store software. Below are a few common ways we help our clients build and create their database. As the database is the most important thing, to be able to not only run the store but to order product correctly, it is very important to take care and do the due-diligence needed for great data.

Pre-Loaded Database

If you are a new store, or one with a cash register, this is a good start to your database. Pre-loaded databases typically have your item name, description, size, UPC, and sometimes information such as appellation.

The downside to pre-loaded databases is there may be many items you are not selling within your store that you need to remove. You will also have to add your pricing and vendors within the database.

mpowertabletliquorpos

Database from Vendor Purchase Orders

Next to the pre-loaded database, this is another great option. You can easily use your purchase orders from vendors (Excel lists work best) to create your database. These Excel files can be put into the needed template. Depending on what information your vendor provides, you will need to add your retail and possibly cost.

Import of Current Database

If you are currently using a point of sale system, you can usually export your current database. Your mPower project manager will then clean it up and put it into our database format. After we have cleaned it up, we will send it back to you to fix anything that may be missing.

Additionally, using this method we can typically extract customer information and sales history. This will allow you to keep valuable data that have you already have.

Self-Created Database

Sometimes, those who want to start completely fresh and not want to use any type of database, will input all information themselves. This method is more tedious and time consuming. It requires you to add items as you receive them into the store; or doing a full inventory count while added items into the system. It is not the first choice we recommend, but it is a possibility.

Conclusion

There are many ways to get your database setup for a new point of sale. It sounds hard and tedious, but it can actually be quite simple. Especially with mPower, as your project manager will do as much of the heavy lifting as possible. And if there is anything that needs to be corrected, it will be highlighted so you don’t have to search for it.

To learn more about mPower Beverage, click here to see our features.

Additional mPower Blog Posts: