Implementation of an AppSheet-Based Sales and Inventory Information System at Wijaya Baru Store
DOI:
https://doi.org/10.35870/ijsecs.v6i3.8233Keywords:
Appsheet, Black Box Testing, Information System, Inventory Management, Prototyping, SalesAbstract
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.
Downloads
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
Downloads
Published
Issue
Section
License
Copyright (c) 2026 Sri Lestari, Yara Raslita, Mesra Betty Yel
This work is licensed under a Creative Commons Attribution 4.0 International License.
Authors who publish with this journal agree to the following terms:
1. Copyright Retention and Open Access License
Authors retain copyright of their work and grant the journal non-exclusive right of first publication under the Creative Commons Attribution 4.0 International License (CC BY 4.0).
This license allows unrestricted use, distribution, and reproduction in any medium, provided the original work is properly cited.
2. Rights Granted Under CC BY 4.0
Under this license, readers are free to:
- Share — copy and redistribute the material in any medium or format
- Adapt — remix, transform, and build upon the material for any purpose, including commercial use
- No additional restrictions — the licensor cannot revoke these freedoms as long as license terms are followed
3. Attribution Requirements
All uses must include:
- Proper citation of the original work
- Link to the Creative Commons license
- Indication if changes were made to the original work
- No suggestion that the licensor endorses the user or their use
4. Additional Distribution Rights
Authors may:
- Deposit the published version in institutional repositories
- Share through academic social networks
- Include in books, monographs, or other publications
- Post on personal or institutional websites
Requirement: All additional distributions must maintain the CC BY 4.0 license and proper attribution.
5. Self-Archiving and Pre-Print Sharing
Authors are encouraged to:
- Share pre-prints and post-prints online
- Deposit in subject-specific repositories (e.g., arXiv, bioRxiv)
- Engage in scholarly communication throughout the publication process
6. Open Access Commitment
This journal provides immediate open access to all content, supporting the global exchange of knowledge without financial, legal, or technical barriers.
