Data-Driven Point-of-Sale and Inventory System for Pastil Sa Tabi: Integrating Sales Forecasting Algorithms and Predictive Analytics

Developing a web-based system to automate sales and inventory management procedures for small food enterprises is the main goal of "Data-Driven Point-of-Sale and Inventory System for Pastil sa Tabi: Integrating Sales Forecasting Algorithms with Predictive Analytics." The system, developed using PHP, MySQL, HTML, CSS, and JavaScript under the Waterfall SDLC approach, integrates transaction processing, inventory management, and sales forecasting to address inefficiencies caused by manual processes. It predicts product demand using forecasting algorithms, helping the business minimize waste, prevent shortages, and improve ingredient procurement.
Fifty (50) respondents, including thirty (30) users and twenty (20) technical experts, evaluated the system using ISO/IEC 25010 software quality standards. They rated it highly for functionality and usability and suggested improvements in performance and reliability. The system improved operational speed, accuracy, and decision-making while providing real-time analytics on inventory and sales trends.
Results show that both technical and user respondents agreed the system achieved its objectives by enhancing customer service, updating inventory reliably, and automating business processes efficiently. The system’s ability to record transactions and generate reports precisely improved accuracy and user satisfaction. Although reliability and performance efficiency were slightly lower, they remained favorable, highlighting the need for further optimization during high-traffic operations.
The study concludes that incorporating automation and forecasting technologies in small food businesses like “Pastil sa Tabi” enhances decision-making and sustainability. Regular system updates, better multi-user optimization, and future features such as offline and mobile access are recommended. Expanding scalability for multi-branch use and adopting machine learning-based forecasting can further improve performance. Overall, the system demonstrates how digital transformation guided by quality standards enables small businesses to operate efficiently in a data-driven economy.

Data Analytics, Predictive Algorithm, Point-of-Sale System

1. Aguilar, M., & Mendoza, R. (2020). User-friendly digital systems for sari-sari store management: Enhancing adoption in micro-enterprises.* Philippine Journal of Information Systems, 12(2), 55–68. [Google Scholar] [Crossref]

2. Bautista, L., & Ramos, J. (2023). *Role-based access control in point-of-sale systems for small food stalls.* International Journal of Computing and Business Applications, 18(1), 44–59. [Google Scholar] [Crossref]

3. Bermudez, C., & Tolentino, P. (2023). *Improving workflow and security through role-based POS systems in food microbusinesses.* Asia-Pacific Journal of Information Security, 9(2), 101–116. [Google Scholar] [Crossref]

4. Brown, T., & Jenkins, K. (2018). *Predictive POS systems for food trucks: Enhancing profits through forecasting and inventory synchronization.* Journal of Mobile Commerce, 7(3), 88–102. [Google Scholar] [Crossref]

5. Chowdhury, R., & Amin, S. (2023). *Analytics dashboards in POS systems: Improving decision-making for small businesses.* International Journal of Data Analytics in Business, 21(4), 150–167. [Google Scholar] [Crossref]

6. Cruz, J., & Villanueva, A. (2022). *Digital POS solutions for school cafeterias: Reducing wait times and errors.* Philippine Computing Research Journal, 14(1), 65–79. [Google Scholar] [Crossref]

7. Del Rosario, K., & Santos, V. (2021). *Real-time inventory monitoring system for local eateries.* Philippine Journal of Software Development, 8(2), 120–135. [Google Scholar] [Crossref]

8. Francisco, R., & Mercado, L. (2021). *Customer analytics in POS systems: A case study of milk tea shops.* Journal of Philippine Information Technology, 11(3), 212–226. [Google Scholar] [Crossref]

9. Gomez, H., & Tan, S. (2020). *Designing POS solutions for micro-kiosks: Lessons from Quezon City.* Philippine Journal of Computer Science, 16(2), 89–103. [Google Scholar] [Crossref]

10. Hassan, A., & Ali, M. (2021). *Cloud-based POS systems in Egypt: Leveraging dashboards and remote access.* Middle East Journal of Information Systems, 14(2), 75–90. [Google Scholar] [Crossref]

11. Hernandez, F., Alvarez, R., & Torres, P. (2022). *Adoption of cloud-based POS systems in Latin America: Benefits and challenges.* Latin American Journal of Business Technology, 9(1), 33–50. [Google Scholar] [Crossref]

12. Lim, C., & Robles, A. (2020). *Food cart inventory applications: Addressing manpower limitations with mobile systems.* Philippine Journal of Mobile Computing, 13(1), 56–71. [Google Scholar] [Crossref]

13. Lopez, D., & Branson, G. (2020). *Inventory forecasting in small food enterprises using ARIMA and exponential smoothing.* International Journal of Forecasting and Operations, 28(3), 141–157. [Google Scholar] [Crossref]

14. Nguyen, H., & Tran, Q. (2022). *Customer analytics in POS systems: Case of a Vietnamese noodle shop.* Journal of Southeast Asian Business Technology, 10(4), 188–201. [Google Scholar] [Crossref]

15. Park, J., & Liu, Y. (2019). *Point-of-sale data and customer behavior analysis in food businesses.* International Journal of Retail & Distribution Management, 47(6), 621–637. [Google Scholar] [Crossref]

16. Rahman, S., Idris, N., & Ahmad, F. (2020). *Smart POS implementation for Malaysian food stalls: Real-time monitoring and automatic stock deduction.* Malaysian Journal of Information Systems, 15(2), 90–108. [Google Scholar] [Crossref]

17. Reyes, C., Domingo, M., & Cruz, R. (2019). *Analytics-based POS systems for bakeries: Aligning production with demand.* Philippine Journal of Computing, 17(1), 45–60. [Google Scholar] [Crossref]

18. Reynoso, A., & De Guzman, P. (2019). *Statistical forecasting for small bakeshops: Reducing spoilage through predictive POS systems.* Journal of Philippine Applied Statistics, 22(3), 78–95. [Google Scholar] [Crossref]

19. Rodriguez, L., Garcia, M., & Fernandez, A. (2023). *Digital POS systems with forecasting and analytics in Spain: Efficiency and delay reduction.* European Journal of Business Information Systems, 19(2), 134–150. [Google Scholar] [Crossref]

20. Santos, J., & Dela Cruz, E. (2021). *POS and inventory solutions for carinderias in Metro Manila.* Philippine Journal of Enterprise Systems, 10(2), 99–114. [Google Scholar] [Crossref]

21. Thompson, R., & Rajan, P. (2018). *The impact of intuitive interfaces in POS systems: Reducing training time and transaction errors.* International Journal of Human-Computer Interaction, 34(9), 800–815. [Google Scholar] [Crossref]

22. Villanueva, D., & Mercado, K. (2022). *Predictive inventory models for small eateries: Linear regression approaches.* Philippine Journal of Operations Research, 6(2), 87–102. [Google Scholar] [Crossref]

23. Wijaya, A., & Hartono, S. (2019). *Sales prediction systems using historical data in Indonesian restaurants.* Indonesian Journal of Computing and Information Technology, 12(4), 55–72. [Google Scholar] [Crossref]

24. Zhang, Y., & Kim, S. (2021). *Intelligent POS systems for small food businesses: Enhancing efficiency with predictive analytics.* Journal of Business Technology, 15(3), 112–128. [Google Scholar] [Crossref]

• Smart Iot Device for Weather And Health
• Merlarchive: A Web-Based Academic Hub for UDM With AI-Powered Natural Language Processing
• Enhanced Social Network Security System: Integrating Biometric Authentication for Improved User Verification and Privacy Protection
• Smart Budget Allocation in Public Policy: A Data-Driven Approach for Equitable Resource Distribution
• Decision Support System for Faculty Selection, Promotion, and Reclassification Using Predictive Analytics