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

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.

Mini grocery stores continue to rely heavily on manual inventory tracking

1. Berman, R. (2022). The value of descriptive analytics: Evidence from online retailers. Harvard Business School Working Paper No. 21-067. Retrieved from https://www.hbs.edu/ris/Publication%20Files/21-067_2c65c0b0-9f10-476f-8e4b-bbf5b56a57e0.pdf [Google Scholar] [Crossref]

2. Goyal, S. K., & Giri, B. C. (2001). Recent trends in modeling of deteriorating inventory. European Journal of Operational Research, 134(1), 1–16. https://doi.org/10.1016/S0377-2217(00)00248-4 [Google Scholar] [Crossref]

3. van Donselaar, K. H., van Woensel, T., Broekmeulen, R. A. C. M., & Fransoo, J. C. (2006). Inventory control of perishables in supermarkets. International Journal of Production Economics, 104(2), 462–472. https://doi.org/10.1016/j.ijpe.2004.10.019 [Google Scholar] [Crossref]

4. Adedeji, O. (2020). Fresh food products inventory control management (Master’s thesis). Mälardalen University. Retrieved from https://www.diva-portal.org/smash/get/diva2:1440421/FULLTEXT01.pdf [Google Scholar] [Crossref]

5. Qi, M. (2020). Data-driven research in retail operations: A review. Annual Review of Control, Robotics, and Autonomous Systems, 3, 97–121. https://doi.org/10.1146/annurev-control-101819-070058 [Google Scholar] [Crossref]

6. Singh, S., & Saha, A. (2021). Internet of Things for perishable inventory management systems. IEEE Access / PMC Article. Retrieved from https://www.ncbi.nlm.nih.gov/pmc/articles/PMC8494460/ [Google Scholar] [Crossref]

7. Dela Rosa, M. E. (2022). Implementation of a digital inventory system in sari-sari stores: A case study in Quezon City. Asia Pacific Journal of Multidisciplinary Research, 10(3). https://doi.org/10.5281/zenodo.6754219 [Google Scholar] [Crossref]

8. Flores, A. R., & Santos, R. C. (2021). User acceptance of web-based inventory systems among Filipino micro-retailers. Philippine Information Technology Journal, 14(2), 55–64. https://doi.org/10.5281/zenodo.5502331 [Google Scholar] [Crossref]

9. Beck, K., Beedle, M., van Bennekum, A., Cockburn, A., Cunningham, W., Fowler, M., Grenning, J., Highsmith, J., Hunt, A., Jeffries, R., Kern, J., Marick, B., Martin, R. C., Mellor, S., Schwaber, K., Sutherland, J., & Thomas, D. (2001). Manifesto for Agile Software Development. Agile Alliance. Retrieved from http://agilemanifesto.org/ [Google Scholar] [Crossref]

• LeafQuest: A Mobile-Based Augmented Reality for Plant Placement, Discovery, and Growth
• Participatory Ergonomic Intervention Approach on Musculoskeletal Disorder (MSD) in Construction Sectors: A Systematic Review
• Integrating GIS into Traffic Incident Management: A Web-Based System
• RideSmart: A Personalized Motorcycle Product Recommendation System Using TF-IDF and Descriptive Analytics for Javidson Motorshop
• Educational Technology Course Design in Pre-Service Teachers Education: A Bibliometric Review of the Research Landscape