Filter By Year

1945 2024


Found 1 documents
Search 10.35870/ijsecs.v6i3.8233 , by doi

Implementation of an AppSheet-Based Sales and Inventory Information System at Wijaya Baru Store Sri Lestari; Yara Raslita; Mesra Betty Yel
International Journal Software Engineering and Computer Science (IJSECS) Vol. 6 No. 3 (2026): DECEMBER 2026
Publisher : Lembaga Komunitas Informasi Teknologi Aceh (KITA), Indonesia

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.35870/ijsecs.v6i3.8233

Abstract

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.

Page 1 of 1 | Total Record : 1