Development of TrackPOS-IN: A Digital Solution for Managing Operations of Small Stalls and Mobile Food Businesses
DOI:
https://doi.org/10.65141/ject.v3i1.n4Keywords:
point-of-sale, offline-first system, inventory management, micro food enterprise, GPS monitoringAbstract
Micro food enterprises often operate in places with intermittent or unreliable internet access, and some combine a fixed stall with mobile selling units. In these settings, sales and inventory are commonly recorded through handwritten logs and informal messaging, which can lead to fragmented records, delayed reconciliation, and weak traceability. Aligned with Sustainable Development Goals 8 and 9, this study developed TrackPOS-IN (Tracking and Point-of-Sale with Inventory), an integrated web-and-mobile platform for stall-plus-mobile operations. Using a design-and-development approach with iterative prototyping, the system was built and piloted with Kuya Siomai in Isabela, Philippines. The prototype includes an Android POS with local data storage and synchronization when connectivity returns, centralized inventory with adjustment logging and low-stock alerts, consolidated dashboards, GPS monitoring for mobile sellers, and embedded CCTV viewing for restricted monitoring. Feasibility was examined through functional testing and task-based user acceptance with the owner, co-owner, stall seller, and mobile seller, using ISO/IEC 25010 quality dimensions. Results showed reliable offline transaction capture, support for more timely reconciliation in the pilot setting, and high user acceptance. TrackPOS-IN presents an offline-resilient operational design for microenterprise settings and points to future work on stronger privacy-by-design controls, cashless payment support, and multi-site evaluation. In this single-enterprise pilot test, all seven representative functional test cases passed, and the task-based user acceptance result reached a grand mean of 4.68. The highest-rated areas were security, performance efficiency, usability, privacy, and portability (M = 4.75).
References
[1] Android Developers. (2025). Offline-first. https://developer.android.com/topic/architecture/data-layer/offline-first
[2] Andutan, T. A. P., & Ucat, R. C. (2022). Design and development for a vehicle tracking system. International Journal of Advanced Computer Science and Applications, 13(3). https://thesai.org/Publications/ViewPaper?Volume=13&Issue=3&Code=IJACSA&SerialNo=23
[3] Bacalso, E. A., Pleto, L. V. Z., Fernandez, R. J. P., & Jain, A. M. (2024). Integration of process monitoring in procurement management system for Bureau of Fire Protection CALABARZON. Isabela State University Linker: Journal of Engineering, Computing and Technology, 1(1), 115–125. https://doi.org/10.65141/ject.v1i1.n9
[4] Baltazar, J. R. S., Estacio, M. B., & Bautista, R. G. (2025). Entrepreneurial innovation, competitive advantage, and profitability of rolling food cart business in Santiago City. Journal of Business and Management Sciences, 13(3), 43–47. https://pubs.sciepub.com/jbms/13/3/1
[5] Bluenviron. (n.d.). MediaMTX documentation. GitHub. https://github.com/bluenviron/mediamtx
[6] Burka, D., Gupta, R., Moran, A. E., Cohn, J., Choudhury, S. R., Cheadle, T., Mullick, R., & Frieden, T. R. (2023). Keep it simple: Designing a user-centred digital information system to support chronic disease management in low/middle-income countries. BMJ Health & Care Informatics, 30(1), 1–4. https://doi.org/10.1136/bmjhci-2022-100641
[7] Canlas, J. M. (2019). Influence of point of sale system in supply chain management. University of La Salette, Inc. https://urdc.usl.edu.ph/papers/abar/abar_vol6_s2019_p1.pdf
[8] Cloudflare. (n.d.). Cloudflare Tunnel documentation. https://developers.cloudflare.com/cloudflare-one/networks/connectors/cloudflare-tunnel/
[9] Conlu, L. J. Z., & Tarun, I. M. (2025). From manual to digital: Investigating reporting barriers and exploring pathways to a smart digital platform for urban infrastructure and services. Isabela State University Linker: Journal of Engineering, Computing and Technology, 2(2), 110–125. https://doi.org/10.65141/ject.v2i2.n7
[10] Department of Trade and Industry. (2022). e-Commerce Philippines 2022 roadmap. https://ecommerce.dti.gov.ph/madali/images/eCommerce_Philippines_Roadmap_2022.pdf
[11] Ignacio, J. B., Millo, M. P., Vicente, R. Y., & Tennom, J. M. A. (2025). Development of an Internet of Things (IoT)-based real-time public transport passenger tracking system. Isabela State University Linker: Journal of Engineering, Computing and Technology, 2(2), 39–51. https://doi.org/10.65141/ject.v2i2.n3
[12] International Organization for Standardization. (2023). Systems and software engineering—Systems and software quality requirements and evaluation (SQuaRE)—Product quality model (ISO/IEC Standard No. 25010:2023). https://www.iso.org/standard/78176.html
[13] Mangmang, G. B. (2018). Development and implementation of point of sale system (POS): Profitability measurement for retail business. Journal of Educational and Human Resource Development, 6(1), 220–226. https://doi.org/10.61569/5tc08q53
[14] Menes, C. C., Japitana, M. A. F., Chua, J. G. D., Dico, M. R., Jr., Parcon, A. M. D., & Makilan, R. E. (2019). Street food: Stories and insights on production and operations, marketing strategies, and vending. Philippine Journal of Hospitality and Tourism Management, 1(1), 42–69. https://www.scribd.com/document/730509306/03-Street-Food-Stories-and-Insights-on-Production-and-Operations-Marketing-Strategies-Vending
[15] Mia, I. B., Jimenez, S., Habaradas, R., Ranieses, J. J., Javier, C., & Enriquez, J. (2024). Digital technology adoption among Philippine micro-, small-, and medium-sized enterprises: Barriers, enablers, and challenges during COVID-19. Journal of Business, Ethics and Society, 4(1), 1–17. https://doi.org/10.61781/4-1I2024/1bmlm
[16] Mission, R. S. (2020). Online support management system for University of Antique. Journal of Innovative Technology Convergence, 2(2), 39–52. https://doi.org/10.69478/JITC2020v2n2a05
[17] Moreno, J., Juanitas, J. A., Montales, F. M., & Bauzon, E. (2025). Challenges and perception on the adoption of point-of-sale system among micro and small enterprises in Tacurong City. Psychology and Education: A Multidisciplinary Journal, 35(5), 584–598. https://doi.org/10.70838/pemj.350508
[18] National Privacy Commission. (2012). Republic Act 10173 - Data Privacy Act of 2012. National Privacy Commission. https://privacy.gov.ph/data-privacy-act/
[19] National Privacy Commission. (2024). NPC Circular No. 2024-02: CCTV systems. https://privacy.gov.ph/wp-content/uploads/2024/08/NPC-Circular-No.-2024-02-CCTV-Systems.pdf
[20] Sison, P., Oreiro, K., Camalit, J., & Ng, G. (2019). A problem-oriented approach to implementing an inventory and point-of-sale system for Company KCP. Innovatus, 2(1), 95–100. https://doi.org/10.5281/zenodo.4484959
[21] Tanaman, M. T., Baylosis, J. L. A., Abiles, B. J. A., Catungal, M. L. P., & Encarnacion, P. C. (2023). Web-based inventory management system. International Journal of Science and Applied Information Technology, 12(5), 44–48. https://doi.org/10.30534/ijsait/2023/021252023
