Desarrollo de una aplicación móvil con base de datos local para la gestión de ventas e inventario de la "Tienda Genesis"

Abstract

In Tienda Génesis, located in the Los Andes community (Cotundo, Napo), the manual recording of sales and inventory in notebooks led to information loss, calculation errors, poor stock control, and delays in customer service. Therefore, the objective of this project was to develop an offline mobile application to automate sales and inventory management and provide reliable information for decision-making. A mixed-method approach was applied: information was gathered through interviews with the owner and staff, as well as direct observation of the operational process. The solution was then designed using a SQLite database, MVVM architecture, and interface prototypes in Figma; development was carried out using the Scrum agile methodology in sprints with Flutter (Dart). Finally, the system was validated through module-based test cases, integration testing, and user acceptance/usability validation with the end user. The results showed that the system correctly records and stores data in SQLite, generates invoices and PDF reports, maintains consistency between sales, inventory, and reports, and improves service times by reducing errors associated with manual calculations.