Sort Out: A Smart Inventory Management System Using Descriptive Analytics and Rule-Based Algorithm for Mini Grocery Stores

Abstract

This research introduces Sort Out, an Intelligent Inventory Management System tailored to tackle the persistent issues of manual inventory tracking and product management in small grocery stores. Numerous small retailers encounter difficulties like excessive inventory, stockouts, erroneous recordkeeping, and slow reactions to changes in stock levels. To address these challenges, the system combines Descriptive Analytics with a Rule-Based Algorithm to automate essential tasks like product tracking, expiration monitoring, and report creation. The system's design is created according to the System Development Life Cycle (SDLC) approach. Information is collected from chosen mini grocery stores via interviews and observations to identify user needs. The development process employed PHP, MySQL, and XAMPP as main tools, with the interface design refined for ease of use and accessibility.