Team Name
IT Squad
Timeline
Spring 2022 – Summer 2022
Students
- Prashant Khadka
- Suman Bagale
- Prabesh KC
- Rikesh Manandhar
- Govinda Raj Joshi
Abstract
OFFGRID INVENTORY is a web app built to address the need for a user-friendly inventory management system for convenience shops. This app will provide all the basic features that an inventory management system is supposed to have such as adding, editing, viewing, sorting, and deleting items based on the amount, expiration date, and name in their inventory. An online database (Firebase) will be used to store all the data and information of the items that are currently in the user’s inventory. It will also have some special features such as shopping list generation and expired items alert which will set aside the app from the existing inventory management systems.
Background
Before the invention of the software inventory system, for years, retailers have been manually keeping track of their retail inventory either handwritten or through bookkeeping tools like excel. For a small business, this seems a quick and easy method but as the business grows, this can become a troublesome practice. And not long ago, humans invented a software system that could perform all the inventory management tasks in an automated and convenient way. But, even after almost more than a decade of inventing these systems, they have hardly become any help for the store owners. Thus, a modern approach has to be taken to understand the need and the demand of the inventory management system.
Project Requirements
- Users must be able to create login credentials in the app
- Only users with valid email addresses shall be able to sign up for the app.
- User email verification must be sent to the user’s provided email.
- Users shall be able to reset the password using the “Forget password” button.
- Users must be able to use the basic functions of the inventory management system.
- Users must be able to create a shopping list of items that are low in stock.
- The application must give an alert about the items that are low in stock and that are expiring.
- Users must be able to look up an item using a barcode scanner.
- The application should run on devices with a web browser.
- The online Firebase Database must be operational at all times.
System Overview
This inventory management web app, OffGrid, would consist of four layers namely Login and Registration, Inventory, Shopping List, and Product Details. Pertaining to the log-in and Registration layer, first-time users should create an account before entering this application. Creating a new account re- quires various credentials like a full name that includes first, middle (if applicable), and last name, email address, password, phone number, and country of residence. The second layer is Inventory. To facilitate the centralized view of stocks, this layer comes up with various features like adding new items to the in- inventory, updating the existing items, or deleting them. The third layer Shopping List captures the items which are missing or low in stock to ensure that there will always be enough stock to fulfill customer needs. The fourth layer is Product Details, and this layer stores all details regarding the products like item category, the number of items, manufactured date, expiration date, item’s Universal Product Code (UPC), etc.
Results
Demo video (Link)
Future Work
Implementing a payment system through third-party applications such as Venmo or PayPal.
Implementing an image portal to upload pictures for the items in the inventory.
Enhance the Barcode scanner to show the product detail directly on the screen without having to choose the item.
Project Files
Project Charter (link)
System Requirements Specification (link)
Architectural Design Specification (link)
Detailed Design Specification (link)
Poster (link)
References
“Online Inventory Management Software: Zoho Inventory.” Online Inventory Management Software for Businesses in USA – Zoho Inventory, https://www.zoho.com/us/inventory/.
Kenneth S Rubin. Essential Scrum: A Practical Guide to the Most Popular Agile Process. AddisonWesley
Professional, 1st edition, 2012.
