Kiokovi is an F&B micro-enterprise still relying on manual transaction recording, making it vulnerable to calculation errors and stock data inconsistencies. Previous studies on Point of Sale (POS) systems for MSMEs have often overlooked transactional integrity in data recovery functions (such as automatic stock rollback during cancellations). This study addresses this gap by implementing a web-based cashier application using PHP, JavaScript, and MySQL. The Waterfall method was utilized as a structured framework for the initial digitalization phase, strictly focusing on database integrity before future system expansion. The developed system, Kiokovi POS, applies CASCADE relations to automate stock adjustments and recovery. System validation involved Black Box Testing, encompassing boundary testing and error handling scenarios. The implementation yielded measurable efficiency: transaction processing time decreased from an average of 420 seconds to 45 seconds. Technically, the system achieved 100% automation in stock recovery during transaction modifications, secured user data via encryption, and ensured the accuracy of operational data for the owner.
Copyrights © 2026