Open Access
Articles
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.
Article Details
How to Cite
Citation FormatLestari, S., Raslita, Y., & Betty Yel, M. (2026). Implementation of an AppSheet-Based Sales and Inventory Information System at Wijaya Baru Store. International Journal Software Engineering and Computer Science (IJSECS), 6(3), 916-924. https://doi.org/10.35870/ijsecs.v6i3.8233
References
22 References- AppSheet Help. (2024). AppSheet help center: Build and customize apps. Google LLC. https://support.google.com/appsheet
- Assauri, S. (2016). Manajemen produksi dan operasi. Lembaga Penerbit Fakultas Ekonomi Universitas Indonesia.
- Brooke, J. (1996). SUS-A quick and dirty usability scale. Usability Evaluation in Industry, 189(194), 4–7.
- Chopra, S., & Meindl, P. (2016). Supply chain management: Strategy, planning, and operation. Pearson Education. https://doi.org/10.1007/978-3-319-24264-4_1
- Dennis, A., Wixom, B. H., & Tegarden, D. (2021). Systems analysis and design: An object-oriented approach with UML. John Wiley & Sons. https://doi.org/10.1002/9781119560852
- Google Cloud. (2023). AppSheet overview: Build apps with no code. Google Cloud Documentation. https://cloud.google.com/appsheet
- Heizer, J., Render, B., & Munson, C. (2020). Operations management: Sustainability and supply chain management. Pearson. https://doi.org/10.1080/00207543.2020.1802102
- Kadir, A. (2014). Pengenalan sistem informasi. Andi Offset.
- Laudon, K. C., & Laudon, J. P. (2020). Management information systems: Managing the digital firm. Pearson. https://doi.org/10.1080/08874417.2020.1788776
- Lewis, J. R. (2018). The System Usability Scale: Past, present, and future. International Journal of Human–Computer Interaction, 34(7), 577–590. https://doi.org/10.1080/10447318.2018.1455307
- Muller, M. (2019). Essentials of inventory management. HarperCollins Leadership. https://doi.org/10.1002/9781119559382
- Myers, G. J., Sandler, C., & Badgett, T. (2011). The art of software testing. John Wiley & Sons. https://doi.org/10.1002/9781119202486
- Nidhra, S., & Dhiman, J. (2012). Black box and white box testing techniques: A literature review. International Journal of Embedded Systems and Applications (IJESA), 2(2), 29–50. https://doi.org/10.5121/ijesa.2012.2204
- O'Brien, J. A., & Marakas, G. M. (2017). Management information systems. McGraw-Hill Education. https://doi.org/10.1108/eb055462
- Pressman, R. S., & Maxim, B. R. (2020). Software engineering: A practitioner's approach. McGraw-Hill Education. https://doi.org/10.1049/pbpc019e
- Rosa, A. S., & Shalahuddin, M. (2018). Rekayasa perangkat lunak terstruktur dan berorientasi objek. Informatika Bandung.
- Sanchis, R., García-Perales, Ó., Fraile, F., & Poler, R. (2020). Low-code as an enabler of digital transformation in manufacturing SMEs. Applied Sciences, 10(1), 12. https://doi.org/10.3390/app10010012
- Silver, E. A., Pyke, D. F., & Thomas, D. J. (2016). Inventory and production management in supply chains. CRC Press. https://doi.org/10.1201/9781315374406
- Sommerville, I. (2016). Software engineering. Pearson. https://doi.org/10.1002/spe.4380120610
- Stair, R., & Reynolds, G. (2018). Principles of information systems. Cengage Learning. https://doi.org/10.1080/01972240802701725
- Tarutė, A., & Gatautis, R. (2014). ICT impact on SMEs performance. Procedia - Social and Behavioral Sciences, 110, 1218–1225. https://doi.org/10.1016/j.sbspro.2013.12.968
- Undang-Undang Republik Indonesia Nomor 20 Tahun 2008 tentang Usaha Mikro, Kecil, dan Menengah. (2008). Lembaran Negara Republik Indonesia Tahun 2008 Nomor 93. https://peraturan.bpk.go.id/details/39653/uu-no-20-tahun-2008
License
Copyright (c) 2026 Sri Lestari, Yara Raslita, Mesra Betty Yel
This work is licensed under a Creative Commons Attribution 4.0 International License.
This is an open-access journal distributed under the Creative Commons Attribution 4.0 International License (CC BY 4.0), which permits unrestricted use, distribution, reproduction, and adaptation in any medium (even commercially), provided appropriate credit is given to the original author(s), a link to the license is provided, and any changes made are indicated. Authors retain copyright without restrictions and grant the journal the right of first publication as well as non-exclusive publishing rights for archiving, indexing, and scholarly dissemination.
Downloads
OJS UsageStats Plugin
Download data is not yet available.
Most read articles by the same author(s)
- Comparative Analysis of Apriori and FP-Growth for Order Pattern Analysis to Support Sales Strategy at Buya Aqiqah Mulia AdiJaya, Untung Surapati, Mesra Betty Yel · Vol. 6 No. 3 (2026): DECEMBER 2026
- Implementation of a Web-Based Sales Information System for Culinary MSMEs: A Case Study of Bakmi Jogja and Mie Ayam Bangka Alya Kamila, Fatchurrachman Fatchurrachman, Mesra Betty Yel · Vol. 6 No. 3 (2026): DECEMBER 2026
- Design of a Web-Based Attendance System Using the Agile Method at biMBA AIUEO Klender Unit Dedi Wijaya, Dwi Swasono Rachmad, Mesra Betty Yel · Vol. 6 No. 3 (2026): DECEMBER 2026
- Implementation of a Website-Based QR Menu and Self-Ordering System at Warkop Abas Romi Naufal Salam, Nova Dahliyanti, Mesra Betty Yel · Vol. 6 No. 3 (2026): DECEMBER 2026
- Customer Segmentation Analysis Using the K-Means Method on Order Data from Aisyah Catering MSME Aisha Yulia, Sri Lestari, Mesra Betty Yel · Vol. 6 No. 3 (2026): DECEMBER 2026
Contrimetric