Design and Implementation of the Sayaka Group E-Commerce Website Using the Waterfall Method Based on Laravel

Abstract

Dependence on third-party marketplaces limits a company's ability to manage customer and transaction data and to build its brand identity independently. Sayaka Group, a multi-brand consumer goods company, still sells its products through Shopee and TikTok Shop. This study aims to design and implement a Laravel-based e-commerce website as an independent sales channel that integrates a multi-brand and multi-variant catalog, Midtrans Snap automated payment, customer–admin live chat, and warehouse inventory management in a single system. Data were collected through observation during an internship, interviews, and a literature review. The system was developed using the Waterfall method with UML, ERD, and LRS modeling, a Model View Controller (MVC) architecture, and a MySQL database, and serves four user levels (visitor, customer, admin, and super admin) over 14 data entities. Black Box Testing of 32 scenarios, including five invalid-input scenarios, showed that all scenarios produced the expected results. The discussion shows that database-transaction-based checkout, signature validation of payment notifications, and the separation of warehouse stock from sellable stock preserve data consistency, and that this combination of features was not found in the prior studies reviewed. The system currently runs on a local server with Midtrans in simulation mode; testing in a production environment and measuring the impact on sales remain future work.