
www.rsisinternational.org
INTERNATIONAL JOURNAL OF LATEST TECHNOLOGY IN ENGINEERING,
MANAGEMENT & APPLIED SCIENCE (IJLTEMAS)
ISSN 2278-2540 | DOI: 10.51583/IJLTEMAS | Volume XV, Issue VI, June 2026
This chapter presents the relevant theories, studies, and literature that support the development of POS²: A
GUI-Based Mini Point-of-Sale and Inventory Management System for a Mini Grocery Store. It
discusses concepts related to point-of-sale systems, inventory management, computerized sales processing,
database management, graphical user interface design, Python programming, SQLite database integration,
PIN authentication, refund processing, activity logging, and related systems. These concepts provide the
foundation for understanding the importance of developing a computerized system for managing sales and
inventory in a mini grocery store.
Point-of-Sale System
A Point-of-Sale system, commonly known as POS, is a computerized system used to process sales
transactions, compute totals, record purchases, and manage business records. In retail stores and grocery
stores, POS systems are important because they help cashiers process customer purchases faster and more
accurately. Instead of manually writing sales in notebooks and using calculators, a POS system
automatically computes the total amount of selected items and records the transaction. In mini grocery
stores, a POS system is useful because it supports the daily operation of selling products, monitoring sales,
and updating inventory. When a product is sold, the system can automatically deduct the quantity from the
available stock. This helps store owners determine which products are still available and which items need
restocking.
POS² was developed to provide a simple point-of-sale solution for a mini grocery store. It includes sales
transaction processing, checkout, refund handling, report generation, and inventory monitoring. These
features help improve store operations by reducing manual work and minimizing errors in sales
computation.
Inventory Management System
Inventory management is the process of monitoring, organizing, and controlling product stocks. It helps
store owners know the quantity of available items, the products that need to be restocked, and the items that
are frequently sold. Proper inventory management is important in grocery stores because products must
always be available for customers.
Manual inventory tracking can lead to inaccurate stock counts, missing records, overstocking, or running
out of important items. In small stores, owners often rely on notebooks or handwritten lists to track products.
However, this method becomes difficult when there are many items and daily transactions.
A computerized inventory management system helps solve these problems by storing product details in a
database. In POS², the inventory table stores the product name, price, and stock quantity. The system allows
users to add, view, update, and delete products. It also updates stock levels whenever a sale or refund is
processed. This makes inventory monitoring faster, more organized, and more accurate.
Computerized Sales and Inventory Management
Computerized sales and inventory management systems provide a better alternative to manual business
records. Manual systems often depend on paper records, calculators, and handwritten notes. These methods
are prone to human error, missing entries, inaccurate computations, and delayed reporting.
A computerized system improves store operations by automating important tasks. It can calculate
transaction totals, update stock, save sales history, process refunds, and generate reports. This helps store
owners and employees save time and reduce mistakes.
In POS², computerized processing is applied through the sales, inventory, refund, and report modules. The
Sales module handles customer purchases and updates stock. The Inventory module manages product
records. The Refund module processes returned items and restores stock. The Report module displays sales,