Design and development of an online ordering system for Iloilo Supermart

Abstract

The study is designed to create an Online Ordering System for Iloilo Supermart. The system will automate the day-to-day transactions and solve certain problems regarding the business techniques of Iloilo Supermart with use of today’s business technology.

It is focused in the following objectives: To create a search module that will display related significant product; to formulate a module that is capable of showing the availability status of the product; to design a module that will display a statistical analysis of frequently purchased product; to create a module that will provide customer feedbacks, comments, and suggestions related to the product; an d to create a module that will monitor the delivered items.

The methodology used for the development of the system was the V Model System Development Life Cycle which had the following phases: Requirements Analysis, System Design, High Level Design, Detailed Design/Program Specification, Coding, Unit Testing, Integration Testing, System Testing and User Acceptance Testing.

The result showed that the Online Ordering System became very beneficial to Iloilo Supermart. Records were kept in the database to ensure that physical damage was impossible and retrieval of data was easy and fast. The website could accept orders through the merchandiser with the use of internet. It also provide a user-friendly graphical interface, allow the manager of the branch to view all the status of the deliveries, generate delivery invoice, and generate monthly sales and sales history. Lastly properly manage the inventory of products, packages and services.