How It Started

Before transitioning to web development, Popomart POS System served as my introduction to database-driven applications. I took on the role of Lead Developer for a four-member team, taking direct responsibility for designing the relational schema and implementing the system's core transaction mechanics.

We built the system using VB.NET and a MySQL database to as an academic project based on the workflow of a local convenience store. The goal was to replace manual storefront operations with a centralized digital solution while demonstrating practical database design and transaction management.

Building the System

The main objective of the project was to tie product registers, inventory adjustments, user accounts, and financial transactions into a single cohesive network using MySQL.

One of the main features of the system was the Point-of-Sale Checkout feature of with real-time total computation inside the cart. As the cashier added more products, the backend dynamically calculates the running total in real time. The system also handles the change computation on checkout.

We configured the checkout system to automatically trigger immediate deductions from the current stock while mapping individual items to permanent sales logs.

We also aded role-based access control to keep daily storefront operations secure. Administrative tasks like product and inventory management were locked behind separate account permission tiers.

Key Features

• Point-of-Sale Checkout with real-time grid and transaction processing
• Automatic Change Computation based on incoming tender amounts
• Custom Receipt Generation mapped directly to finalized store logs
• Dynamic Inventory Control featuring low-stock warning alerts
• Role-Based Access Security separating cashier lanes from admin tools
• Sales Analytics Dashboard for tracking store revenue performance
• Low Stock Warning Indicators to alert the user to restock the product.

Outcome

Our team successfully completed the project and demonstrated a fully functional prototype capable of handling the core operations of a convenience store, including sales, inventory management, employee administration, and receipt generation.

Looking back, the project reflects my early experience with desktop application development. We designed the interface around a fixed-size desktop layout, which limited flexibility compared to modern responsive applications.

Despite that, this project became an important milestone in my development journey. It taught me how to design relational databases, implement transactional workflows, build role-based access control, and develop business-oriented software—foundational skills that continue to influence how I architect backend systems today.