Team Name: Team Titans
Team Members: Arzoo Ahmadi, Le Doan, Eric Wong, Derek Sakasegawa, Andrew Pascual, Joshua Nguyen, Jack Tran, Mark Harland
Client: Drew Cameron - The Opened Box
Advisor: Prof. Jingwei Yang
The Opened Box is a company that buys returned computer hardware products from Amazon and resells them for an affordable price on eBay.
Design and implement an inventory management solution for The Opened Box to promote efficiency and growth in the business.
The inventory management solution will allow multiple users to easily track, edit and manage inventory.
The client currently has no way to store inventory short of an excel sheet. The main function of the program is to be able to import a shipment manifest,
the ability to cross-check inventory that actually arrived against that manifest, and the ability to visualize, search, and sort confirmed inventory.
Provide a modern, scalable and efficient website for managing inventory of The Opened Box.
As a team, we hope to gain experience with full stack development in working on the frontend and backend simultaneously.
Upload manifest onto web application and complete scanning at the same time before importing to the inventory database.
Provide cross-checking functionality to ensure accurate inventory between manifest and items.
Protect the inventory data with an authenticated login as well as manual and automatic log-out.
Enable searching and sorting to allow for easier manipulation of the inventory data.
Node.JS Web Application hosted on Heroku with a PostgreSQL database for inventory.
AuthPack API for login with a dashboard to manage user accounts and employee teams.
Inventory page with editable columns and the ability to save any changes and delete any item.
Scanning page that allows user to upload a manifest which displays into a table on the same page.
Incorporates barcode reading from client's barcode scanner.
Scanning items automatically increments quantity, color coding of rows to alert user of correct, fraud, and missing items after cross checking.
Sounds for successful and failed scans to provide auditory information to user, so they can scan without looking at the screen.
Pop up alerts to help ensure user wants to complete an action to help prevent accidental misclicks.
Importing corrected manifest will insert all corrected items into the backend database which will then be rendered on the inventory page.
End Product Delivery
Estimated about 880 hours (~110 hours per team member) of work, from business requirement gathering to go-live of web application.