International Journal Software Engineering and Computer Science (IJSECS)
Vol. 6 No. 3 (2026): DECEMBER 2026

Implementation of an AppSheet-Based Sales and Inventory Information System at Wijaya Baru Store

Sri Lestari (Sekolah Tinggi Ilmu Komputer Cipta Karya Informatika)
Yara Raslita (Sekolah Tinggi Ilmu Komputer Cipta Karya Informatika)
Mesra Betty Yel (Sekolah Tinggi Ilmu Komputer Cipta Karya Informatika)



Article Info

Publish Date
01 Dec 2026

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.

Copyrights © 2026






Journal Info

Abbrev

ijsecs

Publisher

Subject

Computer Science & IT

Description

IJSECS is committed to bridge the theory and practice of information technology and computer science. From innovative ideas to specific algorithms and full system implementations, IJSECS publishes original, peer-reviewed, and high quality articles in the areas of information technology and computer ...