Pos²: A Gui-Based Mini Point-of-Sale and Inventory Management System for a Mini Grocery Store

Manual sales and inventory management in mini grocery stores often results in inaccurate calculations, delayed transactions, inconsistent stock monitoring, missing records, and difficulty in generating sales reports. To address these challenges, this study developed POS²: A GUI-Based Mini Point-of-Sale and Inventory Management System for a Mini Grocery Store. The system was designed to automate sales transactions, inventory monitoring, refund processing, product record management, activity logging, and sales report generation. It was developed using Python as the main programming language, Tkinter for the graphical user interface, and SQLite as the database management system. The system includes essential features such as PIN authentication, sales and checkout processing, product adding, viewing, updating, and deleting, stock adjustment, refund handling, activity log monitoring, and report generation. The SQLite database stores important information such as administrator accounts, inventory records, sales history, and activity logs, allowing data to remain available even after the application is closed. Through its graphical interface, users can manage store operations more easily without relying on handwritten records or manual computations. Testing showed that the system successfully performed its major functions with proper database integration. Overall, POS² provides a simple, organized, and efficient system that can help mini grocery stores improve transaction accuracy, inventory reliability, and business record management.

Department of Computer Engineering, Eulogio “Amang” Rodriguez Institute of Science and Technology (EARIST) Nagtahan, Manila, Philippines

1. Dimentieva et al. (2026). Web-based POS and inventory management system using RAD and design thinking. Garados et al. (2026). POS impact on operational performance and financial success. [Google Scholar] [Crossref]

2. Ismail, M. F., Nasir, N., Rahaman, W. E. W. A., Rashid, A. A., & Rusli, M. H. M. (2024). InventsimQD: GUI-based teaching application for quantity discounts inventory models. MYJIEAS, 4(01), 332–339. [Google Scholar] [Crossref]

3. Madamidola, A., Daramola, O. A., Akintola, K. G., & Adeboje, O. T. (2024). A review of existing inventory management systems. IJRES, 12(9), 40–50. [Google Scholar] [Crossref]

4. Python Software Foundation. (n.d.). Python documentation. [Google Scholar] [Crossref]

5. Python Software Foundation. (n.d.). Tkinter — Python interface to Tcl/Tk. SQLite. (n.d.). SQLite documentation. [Google Scholar] [Crossref]

6. Suya et al. (2026). Smart inventory management for mini grocery stores. [Google Scholar] [Crossref]

7. Trappey, C. V., Trappey, A. J. C., & Hwang, S.-J. (1996). A computerized quality function deployment approach for retail services. Computers & Industrial Engineering, 30(4), 611–622. [Google Scholar] [Crossref]

• Enhancing Formation Control of Multi Agent Systems Using Ann Based Technique
• Improving Sliding Mode Control with Chattering Reduction using Fuzzy Based Technique
• Cooking Quality, Fasting Blood Glucose, Glycemic Index and Load of High–Fiber Noodles Made from Wheat, Tiger Nut Residue and Cassava Flour Blends
• Matrix Rhythm Therapy Versus Interferential Therapy Combined with Lumbar Stabilization Exercises in Chronic Non-Specific Low Back Pain: A Randomized Comparative Trial
• Formulation and Sensory Evaluation of Functional Cake Prepared from Sweet Potato Powder