Jerango Warehouse Manager: A Full-Stack Warehouse Management System for Streamlined Logistics
Developed a full-stack Warehouse Management System to streamline and automate complex logistical operations. The application architecture consists of a responsive React.js interface for seamless task execution and a robust Node.js server for handling business logic. Data integrity is maintained via Firebase, which powers the system’s core functionality: real-time inventory monitoring, automated threshold-based stock alerts, and an advanced reporting engine that generates performance analytics to maximize operational efficiency.
Overview
JeRango Warehouse Manager is an Inventory Software Management System (ISMS) built for CPE 2201, designed for warehouse managers to track dry goods and products. The system centralizes inventory operations, from cataloging items and logging orders to monitoring stock levels and flagging expiring products, into a single, manager-facing web application.
Features & Functionality
After authenticating through the login interface, the manager lands on the product database screen, the core of the system. The product catalog displays all items with searchable and sortable fields including serial number, product name, supplier, price, and expiration date. The order log tracks supplier orders chronologically, showing supplier name, ordered items, quantities, request date, and arrival date. Order status is updated via dropdown, and marking an order as "arrived" automatically accounts for the items in the product database. When inventory capacity is exceeded, excess stock is routed to a separate overflow inventory accessible from the order log screen. Upon login, a pop-up analysis report greets the manager with a snapshot of low-stock items, expiring products, and overall inventory count. A data backup and recovery system is also in place to prevent information loss.
Technical Implementation
The frontend is built with HTML and CSS following a neomorphic design convention. PHP handles server-side logic and bridges the frontend forms to the MySQL database. Firebase was also integrated as part of the data layer. The system is designed as a standalone desktop web application scoped for city-wide warehouse scale, with a single user role — the manager.
Reflection
This was a group project of four and one of the earlier systems I worked on at USC. The scope was intentionally limited to a single user role and local deployment — maintenance was handed over to the client after submission. Given more time and experience, I'd rebuild the backend with a proper REST API and add role-based access control for larger teams. Real-time inventory tracking via hardware integration was also identified as a future improvement in the original SRS.
Team
Tech Stack
Links