DESIGN AND IMPLEMENTATION OF AN ONLINE STORE MANAGEMENT SYSTEM
ABSTRACT
The research work “Store Management System” includes ales, stock keeping, warehouse management, staff update, vendors update and management, clients management and point of sales (POS). This work was done as a result to solve the problems usually encountered in most companies. The Store Management System was achieved using two programming environment: PHP and MYSQL, with php as front-end and mysql as the backend database. The system can be entered using a username and password. It is accessible either by an administrator or staffs. The interface is very user-friendly. protected for personal use and the data processing is very fast.
CHAPTER ONE
INTRODUCTION
1.1 GENERAL INTRODUCTION
Store management system like central supermarket store, Jane Store, Shoprite Store enterprise and Springlight supermarket etc., these establishments require efficient and brilliant technique and flexible system for proper management of all their goods, clients, staff, stocks, warehouse and services. Their main objective is to offer quality services in sales, stock keeping,warehouse management, staff update, vendors update and management, clients management and point of sales(POS).
1.2 INTRODUCTION
Chapter one introduces the research work and the problem definition of the research, and to know the aim of this research work, research justification tells us why it is important to research on this topic; it also covers areas like scope and limitation of study which entails the boundary of this work. Definition of terms gives summarize what each chapter entails.
1.3 PROBLEM DEFINITION
This research work was undertaken to uncover some of the problems with conventional way of managing store and warehouse. Where products and are written on paper these document are only access by one person at a time and is prone to human errors. Using these conventional method pose lots of constraint on sales manager, warehouse manager, store manager as well as the overall manager of the establishment as each section has to compare records from time to time thereby slowing the growth of the establishment.
1.4 OBJECTIVE OF STUDY
In view of the problems mentioned above, this project is aimed at implementing a Store and warehouse management system which will exclusively: ·
– Automate every sales of all product in stock
– Manage different products and category in store
– Manage different store own by the establishment
– Mange warehouse and vendors
– Manage every client details
– Product daily and monthly report
– Manage every users of the system
1.5 RESEARCH JUSTIFICATION
This research work will provide a reliable way of handling all stores and warehouse own by an establishment also incorporate is the point-of-sales system which will aid in sales management and also eliminate the lag time in file. Furthermore, it will aids structural document representation and eliminates the tedium of performing monotonous transaction. This research will also contribute to existing literature in this area and will serve as a guild or blueprint for an undergraduate student.
1.6 RESEARCH METHODOLOGY
This research work “design and implementation of a store and “warehouse management system” will be a web-based application and will be implemented on a relational database system(MySQL). Html(hypertext markup language), CSS (Cascading Style Sheet) and JQuery will be used to design the web-user interface, PHP (hypertext preprocessor) will be used as the serve- side script language to link the interface and the database.
1.7 SCOPE AND LIMITATION OF STUDY
This research work is to develop a system capable of stores and warehouse task such as sales, stock keeping, warehouse management, staff update, vendors update and management, clients management and point of sales (POS). The system will not incorporate in its development all the functions of a store and ware house management system but will focus only on the aforementioned functionalities. The system will not be responsible for any loss of data if its environment (network/system installed on) is corrupt.
SOFTWARE DESCRIPTION
Programming Language: PHP
Programming Environment: Windows XP, Windows Vista, Windows 7, Windows 8
Software Requirement: Wamp Server