Design And Implementation Of An Online Store Management System

Project and Seminar Material for Computer Science and Computer Engineering

Abstract

The research work Online 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 Background of the Study

Store management system like central supermarket store, Jane Store, Shoprite Store enterprise and spring light 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). 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.2 Statement of the Problem

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.3 Objective of the 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.4 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.5 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.6 Scope and Limitation of the 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 warehouse 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.

1.7 Chapter Layout

This section was put in place to explain what each chapter does, chapter one introduces the project to the reader by explaining the problems the project is supposed to solve, objective of the study and research justification is to describe to the reader the purpose and the importance of researching on this topic, research methodology is all about the method used in implementing the research work, scope and limitation describes the boundary of the research work and where the project work can be put into use.

Chapter two deals with the literature review and state-of-the-art.
This chapter discusses literature review, what people have published related to this research work and their shortcoming, how this present research can improve their shortcomings.
Chapter three deals with the system design methodology i.e. collection of tools methods and practices for achieving a task; the requirement specification states the expectation of the system analysis, and design which is the blueprint of what the system would carry out.
Chapter four has to do with the implementation, system testing strategies, target computer system requirement, software maintenance etc.
Chapter five discusses the recommendations and conclusion part of the research work and how this work can be applied to the problem domain.

Chapter Five

Summary, Conclusion and Recommendation

5.1 Summary

The aim of this research is to create a store and warehouse management system which will make Stores and warehouse management in organization more flexible and reliable. The existing types of stores and warehouse management were discussed and it was narrowed down to sales, stock keeping, warehouse management, staff update, vendors update and management, clients management and point of sales (POS)which is the main thrust of this project. The history of warehouse management where highlighted. Principles of project were outlined. The system design was made suitable to the system requirements. Embedded in the system design is activity diagram which shows the activities and actions in the system. The implementation of the software was successful.

5.2 Conclusion

Stores and warehouse management System improves business activities in large, medium and small enterprise.

Hence it is advised that all companies that deals with goods and services in Nigeria should adopt a Stores and warehouse management system which is more reliable, flexible and result oriented.

The resulting software would be of benefit to individuals who which to manages Shop, supermarket, stores and warehouse. The software has been able to meet its objectives and will make project management. Stores and warehouse management more successful.

5.3 Recommendation

The software developed for the implementation of this research can be used by any company that deals with goods and services. The following recommendations are proposed:

Admin should ensure to update prizes of product daily to avoid lost in profit.
Admin should create passwords with long characters so as to make password hacking difficult.
System users should ensure safekeeping of password since it provides access to the system.

Project Material Download