Online Store Application in PHP, MySQL and Bootstrap
In this study, the developers develop an online store application that will minimize all the effort and time of the customer and to minimize roaming around as well. Therefore, it allows administrator to track the order of the customer so that they can prepare for it and deliver if needed. Furthermore, in this study, the developer shall create the system that is fully computerized, user-friendly, time effective and well-organized.
The purpose of the study is to design, develop, evaluate and implement the proposed system that will help the company in providing an increase of sales thru developing an online store application. The application presents a different aspect in terms of developing the study, including on how it will meet the expectations of the customer.
Current State of Transaction
The company used to have a process of manual ordering and purchasing where in the client/s asks for products they want through the help of a staff. If the client decided to purchase or buy the products then they will just pay it to the same person. The manual system, the level of service is dependent on individuals. It can also be too easy to accidentally switch details and end up with inconsistency in data entry or in hand written orders. It is also time consuming and costly to produce reports, duplication of data entry can’t be avoided and most of all it lacks security.
Online store application is one example of an e-business idea. Online shopping is not only about technology and making sales, nor is it of interest only to industries and businesses, but it is also about transforming the economy, within and across geographic areas, and changing old markets and creating new ones.
Features of the System:
- The system can automatically locate or provide the nearest branch of Savemore through the customer’s address.
- The customer can pay through credit card and Cash on Delivery.
- Customer can also choose pick-up or delivery
- The customer can easily search for the products and can add immediately to her/his shopping cart.
- The system can print the receipt of the customer’s order
- The system has email validation through gmail
- Customer can see the order details and the actions done to her/his orders.
- System has its inventory report and sales report.
- The customer can print her/his own receipt.
Entity Relationship Diagram
Beneficiaries of the Study and System
Online Store Application will be significant to the following:
CUSTOMER: The easiest way to reliable to the customer is to maintain an easy and simple image in the company’s website, with created positive web experience customer.
COMPANY: The Company’s website seems to have significant influence on sales and corporate image and is expected to contribute to overall customer satisfaction.
RESEARCHERS: Helps the researchers to develop their thesis writing skills, programming and analysis skills as well as their ability to give solution to a certain threat.
FUTURE RESEARCHER: Serves as basis for further study with regards to customer transparency.
Definition of Terms
E-cart: An electronic commerce tool (software or service) that is the user-interface for the customer to shop at online stores. It allows users to place items in a “shopping basket”, and the cart remembers these items for a predetermined length of time. Extra features such as different color or size options, quantity of order, and matching item links can be found linked from the shopping cart. Once a shopper inputs his shipping address, taxes and shipping costs can also be tallied from within the shopping cart. For the merchant, the shopping cart also provides important information, which is often transparent to the shopper including a cart number to track the order, and a cookie to provide you with some limited tracking details about your customer.
Security:This will have a three level of access: the Administrator, Member and the Guest. The administrator has the full access to the system. The User can view their account status, shopping cart and request for tracking status provided that they have purchased a product. The Guest can browse the available products but they will not be able proceed to the payment transaction unless they would sign in. They will then be redirected to the log-in page.
Ordering: Available products are all listed on Store page. In case the user finds the item they want, they may proceed to ordering by clicking “Add to Cart”. They will then be redirected to the Shopping cart page as long as the product available. If not available, the system will notify the user.
Mailing List: The system will automatically send updates to the email address of the registered users. These updates may be discount, promo and other business-related information. If the user does not prefer to receive updates, he/she has an option to turn it off into the setting page.
Tracking: This is only applicable to the customers who purchased a product. By entering a valid transaction ID, this module will provide a real-time status of the item whether it has been shipped or not.
Maintenance: Site configuration can be done by the admin such as editing the company address, contact number and shipping cost. This module also allows the admin to update, add, delete products, edit product description, image and price, block suspicious users, add or remove members.
System Module and User Interface
- Online Store Application Product Catalogue Module
The catalogue module of the application can be seen and browse in the frontend part of the web application. This module is where the products are shown and group according to their categories.
- Online Store Application Product Detail Module
The product detail module displays the information of a selected product by the user/customer. The user/customers can read the details of the product such as the price, description and many more. The image below shows the product detail module of the online store application.
- Online Store Application Shopping Cart Module
The shopping cart module contains the list of products that the user/customer has selected for purchase or checkout. The total amount of the users/customers order is also shown in this module.
- Online Store Application Checkout and Billing Information Module
Billing information module is where the users/customers enter their personal credentials such as the name, contact and address where the products are to be delivered.
- Online Store Application Product Management Module
The product management module is part of the backend module of the web application where the authorized users can only access this feature. In this module the authorized user can add and update the product information.
- Online Store Application List of Customer Orders Module
List of customer orders is also on the backend part of the application, in here, the management can view all the orders from their customers. The orders are group into unpaid orders, delivered orders and paid orders.
- Online Store Application Customer Information and Order Details Module
The order details module is where the management can review the orders before it will be delivered to the customers.
Online applications are very helpful not just only in the company’s side but it brings convenient experience to the customers as well. The researchers/developers strongly recommend the implementation of the online store application for it will make the transactions easier and more organize.
You may visit our facebook page for more information, inquiries and comments.
Hire our team to do the project.