Team Name
Coding Avengers
Timeline
Summer 2021 – Fall 2021
Students
- Tuyen Vo
- Linh Tran
- Sita Lama
- Mokshada Upreti
- Greg Whatley
Abstract
Every single business has some type of inventory. It is essential in order to be able to sell and make a profit. The better organized a business is, the more likely it is to be successful. Taking inventory is necessary for managing costs and making sure there is no theft or loss. Just as businesses manage inventory, so do regular people with wine cellars and extensive liquor collections. Our Wine Inventory app is designed to simplify the process of managing inventory for wine sellers and enthusiasts alike.
Background
With our beverage inventory app, a user would easily be able to keep track of what’s in stock, what needs to be ordered, and so much more, all in the palm of their hand. There are a multitude of reasons why manually keeping track of inventory is inferior to doing so digitally. Doing inventory manually can be immensely time consuming, financially wasteful, and even be done inaccurately. A person could take hours counting each bottle/case, they could make a mistake while counting, or their physical inventory sheet could get damaged. The biggest benefit of an inventory management app is saving time, and time is money. Any business that sells wine and liquor and any person with a collection can benefit from this app. A user would easily save money in hours by no longer needing someone to manually count and keep track of their stock. Along with saving time and money, the inventory management app would also provide convenience. Users can easily access the app on their phone, users can check the status of the inventory without even having to physically be at their place of business or home, and even be able to receive alerts when an item is running low. As with any invention, ideas arise out of need. Businesses strive to make every operation as efficient as possible to maximize their profits.
Inventory management is necessary for all businesses so creating an app to improve this process would attract many clients. Home users would benefit from this inventory management app by knowing where each of their items are being stored, which bottles are open, and if any are on the verge of going bad. To create the most efficient beverage inventory management app for any user, it needs to be compatible to a user’s mobile device and be user friendly.
Project Requirements
Some of our core requirements are listed below. Our total list of requirements is available in our System Requirements Specification under Project Files.
- Users must be able to create an account and log in
- Users must be able to add bottles to their inventory
- Users can enter bottle information manually
- Or using the built-in barcode scanner
- Users must be able to favorite or unfavorite wines
- Users must be able to mark a bottle as opened
System Overview
Our wine inventory management app is divided into 3 distinct layers: the UI (frontend), the database (backend), and the camera (hardware). The user’s first interaction with our app is the frontend. The frontend is what our user can see, from how a screen is formatted to how a button reacts when being clicked. The backend will mostly be how our database interacts with the app, what is stored, what is deleted, etc. The backend will also include the actual functionalities of our app and the API for the barcode scanner. Users can use their phone cameras to scan a bottle’s barcode for an easier way to register a bottle.
Results
Our demo video is available here: (link)
Future Work
Due to time constraints, we were unable to finish implementing bottle editing or deletion. In addition, the barcode scanner works by checking a list of predefined wines in our database. For the barcode scanner to be more useful, more wines would need to be recorded in our database. We also did not publish our app to the App Store or Google Play Store.
Project Files
- Project charter: (link)
- System requirements specification: (link)
- Architectural design specification: (link)
- Detailed design specification: (link)
- Project poster: (link)
- Source code: (link)
References
[1] “How to pick the best beverage inventory software (10 reviews),” Dec 2019.
[2] “Partender: Bar inventory in 15 min.” 2021.
[3] T. Eicher, “The best way to keep track of your liquor inventory on iphone, ipad or ipod touch,” 2004.
