Project Name

Inventory Management System

Prerequesties

• MySQL
• Python
• Flask

Installation

1. Open Command Prompt and install flask

   pip install flask

2. Then install Mysql

   pip install mysql-connector-python

Procedure

1. Creating DataBase

• Create Database for the data storage and crete some table
  • Product -> To store the details of Products
  • Location -> To store the details of Location
  • Movement -> To store the movement of product in the table like(product_id, from_location_id, to_location_id, quantity)
  • Stock -> To store the product quantity details by their places and we can transport the product quantity to other place

2. Connecting DB

• This is the connecting procedure to connect DB

  def get_db_connection():
    connection = mysql.connector.connect(
        host='localhost',
        user='root',
        password='yourpassword',
        database='databasename'
    )
    return connection

• This is the query executing process

  connection=get_db_connection()
  cur=connection.cursor()
  cur.execute() # This is the query executing function we have give query here
  connection.commit()
  cur.close()
  connection.close()

3. Web Page

• Using HTML code we can design the pages we want
  • index.html -> This page is an initial page which has lot of options in this page
  • add_product.html -> This page contains form which is help to get the product name and price
  • view_product.html -> This page contains table which has product details with an option of EDIT
  • edit_product.html -> This is page for edit the add product in the table, this is not availale in the options in the index.html. This only in the view_product.html
  • add_location.html -> This page contains form which is help to get location name
  • view_location.html -> This page contains table which has location name
  • add_movement.html -> This page contains form of getting product name, from location, to location, quantity and date&time
  • product_movement.html -> This page contains two table one for history of product movement another one has quantity of product in certain location

6. File Structure

Inventory
├──templates
      ├──index.html
      ├──add_product.html
      ├──view_product.html
      ├──edit_product.html
      ├──add_location.html
      ├──view_location.html
      ├──add_movement.html
      ├──product_movement.html
├──app.py
├──Demo Video.mp4

5. Execute

1. Open command prompt and type

   python app.py

2. Press the Ctrl+ click on this link http://127.0.0.1:5000

Demo Video

https://drive.google.com/file/d/1dgN_tJDx-th9yVcs3KhsveS-56ZzaZci/view?usp=sharing