Web-Based Point-of-Sale System with Inventory and Membership Management for KODAGAMA

Authors

  • Ridwan Cahya Gumilar Universitas Pamulang
  • Ananda Syafira Universitas Pamulang
  • Aditia Putra Universitas Pamulang
  • Wasis Haryono Universitas Pamulang

DOI:

https://doi.org/10.69693/jesa.v4i1.143

Keywords:

Black-Box Testing, Cooperative Retail, Inventory Management, Membership, Point Of Sale, White-Box Testing

Abstract

The KODAGAMA cooperative retail unit previously maintained inventory records separately from sales, requiring staff to reconcile products sold with stock balances. This study presents a web-based point-of-sale system that integrates product management, sales transactions, inventory, membership benefits, and sales reporting within a shared application. Development followed the Waterfall stages of requirements analysis, design, implementation, and verification, with requirements identified through observation, interviews, and review of existing records. The Laravel application records invoices and line items, supports cash and noncash payment methods, and associates eligible purchases with member points and discounts. Evaluation combined documented black-box test cases from the work-placement report with manual white-box tracing of selected source paths. Of 172 black-box cases, 170 were recorded as meeting the expected outputs and two did not, both concerning options on an earlier sign-in interface. All 15 selected manual traces matched their expected outcomes for transaction processing, payment confirmation, member points, and reporting. These traces were simulations of code paths rather than execution in the application or database. Source inspection identified a risk in noncash confirmation because payment status and stock updates were not enclosed in one explicit database transaction. Further verification should examine repeat confirmations, stock changes before settlement, and interrupted writes using paired invoice and inventory records. The findings describe the documented functional behavior and selected implementation risks of the system; improvements in operational time and stock accuracy were not measured.

Downloads

Download data is not yet available.

References

[1] N. DeHoratius and A. Raman, “Inventory record inaccuracy: An empirical analysis,” Management Science, vol. 54, no. 4, pp. 627–641, 2008, doi: 10.1287/mnsc.1070.0789.

[2] B. C. Hardgrave, J. A. Aloysius, and S. Goyal, “RFID-enabled visibility and retail inventory record inaccuracy: Experiments in the field,” Production and Operations Management, vol. 22, no. 4, pp. 843–856, 2013, doi: 10.1111/poms.12010.

[3] M. R. Hasibuan, F. Gultom, and M. B. K. Nasution, “PHP-based stationery sales information system at Ufaira Printing Sigambal, Labuhanbatu,” Journal of Engineering and Science Application, vol. 3, no. 2, pp. 190–197, 2026, doi: 10.69693/jesa.v3i2.57.

[4] C. C. Utami, R. I. Desanti, and F. A. Halim, “The development of web-based sales and inventory system for a stationary store,” Ultima InfoSys, vol. 14, no. 2, pp. 52–57, 2023, doi: 10.31937/si.v14i2.3358.

[5] F. Azizah, L. Novyanti, N. O. Amri, A. Oktaviani, and R. Nurfalah, “Perancangan aplikasi Point of Sale Pandita Coffee berbasis web dengan kombinasi model SDLC Waterfall,” Jurnal Sistem Informasi Kaputama, vol. 6, no. 1, pp. 69–74, 2022, doi: 10.59697/jsik.v6i1.184.

[6] S. Suprianto, M. Fadlan, and D. Prayogi, “Perancangan aplikasi Point of Sale berbasis web pada Toko Project Salfa Tarakan,” Sebatik, vol. 25, no. 2, pp. 624–631, 2021, doi: 10.46984/sebatik.v25i2.1519.

[7] I. D. G. A. Pandawana, B. P. P. Putra, I. P. G. Budayasa, I. D. M. A. B. Joni, and P. A. Permata Sari, “Pengembangan Point of Sale berbasis web untuk pengelolaan transaksi apotek,” Jurnal Ilmiah Teknik Universitas Mahasaraswati Denpasar, vol. 6, no. 1, pp. 59–64, 2026, doi: 10.36733/jitumas.v6i1.14027.

[8] H. Aliazki Pratama and B. Yulisa Geni, “Web-based POS system to support perfume sales transactions using the Waterfall model,” Journal of Information Systems and Technology Research, vol. 5, no. 3, pp. 343–355, 2026, doi: 10.55537/jistr.v5i3.1535.

[9] A. A. Amalia, E. Supriyati, and T. Listyorini, “Design of a web-based Point of Sale system for transaction recording at Sumber Rejeki Store,” SAGA: Journal of Technology and Information System, vol. 3, no. 3, 2025, doi: 10.58905/saga.v2025i3.547.

[10] P. Runeson and M. Höst, “Guidelines for conducting and reporting case study research in software engineering,” Empirical Software Engineering, vol. 14, pp. 131–164, 2009, doi: 10.1007/s10664-008-9102-8.

[11] W. W. Royce, “Managing the development of large software systems,” in Proc. IEEE WESCON, 1970, pp. 1–9. [Online]. Available: https://cse.msu.edu/~cse435/Homework/HW3/royce1970.pdf

[12] Object Management Group, OMG Unified Modeling Language, ver. 2.5.1, 2017. [Online]. Available: https://www.omg.org/spec/UML/2.5.1/

[13] Laravel, “Database: Getting started,” Laravel 12.x Documentation. [Online]. Available: https://laravel.com/docs/12.x/database

[14] Bank Indonesia, “Quick Response Code Indonesian Standard (QRIS).” [Online]. Available: https://www.bi.go.id/id/fungsi-utama/sistem-pembayaran/ritel/kanal-layanan/QRIS/default.aspx

[15] J. Gray, “The transaction concept: Virtues and limitations,” in Proc. 7th Int. Conf. Very Large Data Bases, 1981, pp. 144–154. [Online]. Available: https://www.vldb.org/conf/1981/P144.PDF

[16] Oracle, “START TRANSACTION, COMMIT, and ROLLBACK statements,” MySQL 8.4 Reference Manual. [Online]. Available: https://dev.mysql.com/doc/refman/8.4/en/commit.html

[17] ISTQB, Certified Tester Foundation Level Syllabus, ver. 4.0.1, 2024. [Online]. Available: https://istqb.org/wp-content/uploads/2024/11/ISTQB_CTFL_Syllabus_v4.0.1.pdf

[18] Software and systems engineering—Software testing—Part 4: Test techniques, ISO/IEC/IEEE 29119-4:2021, 2021.

[19] F. Dobslaw, R. Feldt, and F. Gomes de Oliveira Neto, “Automated black-box boundary value detection,” PeerJ Computer Science, vol. 9, Art. no. e1625, 2023, doi: 10.7717/peerj-cs.1625.

[20] A. Z. Rafif et al., “Functional testing of web-based input form using boundary value analysis technique: A case study on TemanTernak,” Jurnal Teknologi dan Open Source, vol. 8, no. 2, pp. 1064–1070, 2025, doi: 10.36378/jtos.v8i2.5084.

[21] A. Samdono, A. P. Sari, and F. P. Aditiawan, “Pengujian Black Box pada sistem informasi stok dan penjualan berbasis website menggunakan metode equivalence partitioning: Studi kasus CV. Algani Karya Mandiri,” JATI (Jurnal Mahasiswa Teknik Informatika), vol. 8, no. 1, 2024, doi: 10.36040/jati.v8i1.8893.

[22] M. Sutomo and F. E. B. Simamora, “Pengujian black box aplikasi inventaris dengan Boundary Value Analysis di PT Duo Roda Motor,” Device: Journal of Information System, Computer Science and Information Technology, vol. 5, no. 1, pp. 202–216, 2024, doi: 10.46576/device.v5i1.4557.

[23] H. Berenson, P. Bernstein, J. Gray, J. Melton, E. O’Neil, and P. O’Neil, “A critique of ANSI SQL isolation levels,” in Proc. ACM SIGMOD Int. Conf. Management of Data, 1995, pp. 1–10, doi: 10.1145/223784.223785.

[24] Oracle, “Locking reads,” MySQL 8.4 Reference Manual. [Online]. Available: https://dev.mysql.com/doc/refman/8.4/en/innodb-locking-reads.html

[25] Systems and software engineering—Systems and software Quality Requirements and Evaluation (SQuaRE)—Product quality model, ISO/IEC 25010:2023, 2023.

Downloads

Published

18-11-2026

How to Cite

Gumilar, R. C., Syafira, A., Putra, A., & Haryono, W. (2026). Web-Based Point-of-Sale System with Inventory and Membership Management for KODAGAMA. Journal of Engineering and Science Application, 4(1), 112–120. https://doi.org/10.69693/jesa.v4i1.143