Using Python, Flask, SQL Alchemy, and SQLlite 3, I have made a Inventory Management System that allows users to create and manage product inventories and assign them to various locations (user created).
- Developed on Python and Flask
- Libraries used include SQL Alchemy
- Create products and assign inventory levels based on locations
- Create Locations and manage induvidual inventory levels
- Database on SQllite 3
- Overview dashboard to get a quick glance at important info
- Features a CRUD functionality
The program has a few key pages. Starting of with Home page. It displays key info such as total number of products currently being managed and number of warehouses/locations. There are also a few recommended quick actions.
Click on Create Product from Home page or the nav bar. Note: you can only add one location while creating the product. To assign product inventory to ther locations, after creating the product, it can be done under View and Manage Products by clicking on Edit. To create a product atleast one location must be available.
Click on Add Warehouse to create a new location by giving it a name and an address.
You can view and edit all products under View and Manage Products menu.
You can edit any product by clicking edit. You can also add inventory for the selected product at other locations.
You can view all locations under View and Manage Locations
You can edit any warehouse by clicking edit. Along with name and address, you can edit the product qty at that warehouse.
