Modern small and medium retail enterprises increasingly rely on digital information systems to streamline operational workflows and improve data accuracy. Toko Wijaya Baru previously conducted sales recording, inventory tracking, and financial reporting using conventional manual paper ledgers. This manual approach created substantial operational vulnerabilities, including calculation errors, delayed information retrieval, stock discrepancy risks, and potential data loss. This study aims to design, develop, and implement an integrated sales and inventory information system utilizing the AppSheet no-code platform to enhance operational efficiency, data reliability, and administrative accuracy. Data collection was conducted through qualitative observation, in-depth interviews, and document analysis, while the system development followed an iterative prototyping methodology to align functional modules with actual operational requirements. The system integrates an AppSheet user interface with Google Sheets as a cloud-based relational database backend, incorporating core features for master product management, sales transaction processing, restocking administration, automated real-time stock recalculation via dynamic formulas, and automated report generation. System validation through Black Box Testing demonstrated that all functional modules operate successfully without discrepancies. The post-implementation findings confirm that the system eliminates manual record redundancies, accelerates transaction throughput, prevents stock miscalculations, and provides structured sales visibility. Ultimately, this implementation demonstrates that an AppSheet-based no-code architecture serves as a practical, cost-effective, and scalable digital transformation solution for retail store management.
Copyrights © 2026