Vo, Tuyen. Lama, Sita. Upreti, Mokshada. Tran, Linh. Whatley, Greg.
Wine Inventory Management
Vision
Conceptual Design Phase
Background
Our main objective is to create an application that allows user to easily and accurately keep track of their wine inventory by using simple and user-friendly interface. Wine Inventory app is built to perform tasks such as scan and add the wine bottles into the inventory with a specific location provided by the user along with its descriptions: color, origin, winery, vintage/year produced, styles: read/ white/ rose/ sparking white/ sparking rose. Its condition: opened or sealed, opened date, is it full, half or almost consumed. The app will help to mitigate the problems with locating the wine or liquor bottle, its condition, check to see if the bottle is getting expired (if the bottle is opened)
Imagine that you are an avid wine lover, who is passionate about collecting different types of wine grapes from different regions. As the time goes by, the amount of wine bottles in your collection surprisingly�increases and it is frustrating that you can’t find the perfect bottle in your own cellar because you do not remember where the exact bottle is stored. Expensive wine end up going past prime, gifted wine bottles get put in random places. Similarly, if you own a small winery business, wine inventory management could be time consuming and requires a decent amount of manpower by manually counting how many bottles are left in stock, which one is running out or you want to check which bottles have been opened and put back in the cellars. That brings us the opportunity to work on solving such problem with managing the inventory with details of the bottles. It will provide a better experience in keeping track of wind bottles, finding them, checking its condition and consume it before it goes bad.
UI - FRONTEND�The UI frontend of the application allows users to sign up and create account. Once the account is created, it take users in the home page where they can search the list of bottles. The users can choose the specific bottle and find the details of bottle like origin, year, style, storage location, status of bottle, and pairing.
PHONE CAMERA - HARDWARE�The second layer contains the barcode scanner API. The user can scan the barcode of bottle using their phone camera to auto fill the information of bottle in the inventory. Users can also take picture of bottle using their phone camera. Barcode scanner API will have image of the bottle and it automatically register bottle information.
FIREBASE - BACKEND�Backend relies heavily on Firebase which is a platform developed by Google that integrates several services into one product. Firebase Realtime Database will handle storage and retrieval of user data such as bottle information. Realtime Database is a NoSQL database that stores data as JSON. The frontend will read and write data to/from the database. Firebase Storage will handle photo uploads for our users. Storage has a simple API that will allow our frontend to upload images (e.x. bottles or locations) and view them later. Firebase Authentication is used to let our users sign in either with email and password or with third-party authentication services (Google, Facebook, Sign in With Apple, etc). Authentication provides an API to create accounts and send password reset emails.
Detailed Design Phase
Prototype & Test
References
Conclusions
Wine Inventory app meets all the primary requirements given to us by the customer. Our application provides a better and effective way of managing the wine inventory and keeping track of their status. User can easily add wine bottles by simply scanning the barcode from our application. User can check the inventory or the condition of any wine bottle by simply logging to the app. We were also able to create a security system to prevent unauthorized person to access the stored data. In future, we would like to add some new features to this application to provide users even better experience while using the application. The features such as allowing user to search the wine bottles using voice command can help many users.
CSE Senior Design
2021 UTA College of Engineering Innovation Day DECEMBER 12, 2021