College for Research and Technology of Cabanatuan
Burgos Avenue, Cabanatuan City 3100
Tel. 463-2735 e-mail:
[email protected] Implementing Inventory System Milktea Project
using PHP and My SQL
Sarsate, Nesty Y., Sombito, Van Rudolph D., Dorigo Jr., George G.
As the technology arises, it has become necessary to propose a system that can
meet the changing requirements like item scheme generator with inventory management.
Implementing Inventory System Milktea Project is very special especially to those
who have large businesses. It can do things automatically like inserting and deleting
products or item which were not available.
Computerization is a control system that manages the process of recording
items/products. It reduces human errors and processing time; thus, it can boost
productivity and result into high quality. This results in system with well integrated
process that can perform much faster and more accurate the manual system.
Recording is the process of entering and verifying data of an item or product done
by stock management in a particular business. Different interrelated processes build up
inventory procedures called inventory system. Implementing Inventory System Milktea
Project is used particularly to add, delete, and update information about an item or
product. Tracking the availability of an item is also some of the main features of an
Inventory System. This can lessen human error and consuming time.
Conceptual Framework
This study describes the design and implementation of inventory management
system for large businesses like Friendship Supermarket and Save More. Inventory
System sets out for managing and accounting for every department. It can also be used to
sort out
Implementing Inventory System in Milktea Project using PHP and MYSQL | 1
College for Research and Technology of Cabanatuan
Burgos Avenue, Cabanatuan City 3100
Tel. 463-2735 e-mail:
[email protected] every item or product through their usage. It can also serve as a record in order to monitor
the availability and stock of a particular product.
Stock Purchasing
Details Details
Supply
Record 0.0
Admin Inventory Customer Info Admin
Management
System
Stock
List
Sales. / Purchase List Payment
Details
Figure 1: Context Diagram of Inventory System
1.2 Statement of the Problem
This study sought to address the common problems in recording and updating
their data in their businesses:
1. Inventory System is being done manually by the one in-charge in monitoring
the stocks and availability of each items/products.
2. It will become a big problem for them when they need to update their stocks.
3. It takes a lot of time and very inconvenient.
1.3 Objectives
General Objectives
Implementing Inventory System in Milktea Project using PHP and MYSQL | 2
College for Research and Technology of Cabanatuan
Burgos Avenue, Cabanatuan City 3100
Tel. 463-2735 e-mail:
[email protected] The main objective of this study is to create a computerized Inventory
System that helps the one managing stocks and also the customers.
Specific Objectives
The proponents create the following objectives about the study:
1. to be able to know how the system works ;
2. to be able to create a recommendation and conclusion about the
system; and
3. To be able to know how the created system changes the manual
Inventory System.
1.4 Scope and Limitation
The study is focused on managing and filing the inventory of stocks. The interface
of this system also provides the administrator and users in managing records.
However, inventory system can’t process payroll for clerks. It also cannot retrieve
data once it’s deleted. It also cannot print receipt as for the record.
Implementing Inventory System in Milktea Project using PHP and MYSQL | 3
