Inventory System
User Requirements: To create a web application using Flask framework to manage inventory of a list of products in respective warehouses. Imaging this application will be used in a shop or a warehouse that needs to keep track of various products and various locations.
Inventory Management Web Application :
In the inventory Shop it contains product,location and product movements and show the Transactions Report.
• I Had Successfully created the product.html page in that the user can add product name and Quantity if they wants to modify they can do in that pages.
• In Location page as successfully add their Location and modify in the Locations in Location.html
• I had created product movement.html for showcasing the Transactions and Transaction history in that page.
Features I’m Added:
• Login and Signup(By Hashing technique)
• Search in Transactions by product name or Warehouse.
• Easy Navigations
• Using Sqlite Database.
• Can easily Modify The Product Details and Location Details.
• Bootstrap Styles are Used in Web pages.
File Paths:
Steps To Run the Application:
Step1: Extract the Zip File
Step2: Migrate the Sqlite Database in Your System
• flask --app aerele db init
• flask --app aerele db migrate -m "Initial migration"
• flask --app aerele db upgrade
Step 3: Import the Necessary Flask files in cmd.
Step 4: Run the Application • python appname.py(python app.py)
Screenshots:
- First it Ask the User Details to Allow in Inventory Shop.
2.If the user details Are correct it will navigate to Base.html File
3.After that we can add the products in product.html
4.In sidebar if we click the Location It will navigate to the Location page and show the Available Locations I we need to Add Any new Locations.
It Successfully Added the New Location Thiruvannamalai
5.Products Movements (Make Transactions and Available balances in Hub and Transaction History)
There are three type Of Transactions
1.Unknown to Hub (it reduces the Original product Quantity)
Example: I’m entered tomato As 100 Quantity
I am moving 50 Quantity in(unknown to Hub) Transaction
It successfully Transferred to Hub And shown in product balances and updated in Transaction history.
It also updated Remaining Available Quantity in product page I moved 50 quantity the Remaining will be updated successfully.
Type 2:(Hub to Hub)
In Hyderabad hub contains 50 quantity I move the 25 quantity to Coimbatore Hub.
it successfully transferred Hyderabad hub to Coimbatore hub.
Type 3:(Hub to Consumer)
The Coimbatore hub Contains 25 quantity I want to sell 20 Quantity to consumer .
It successfully updated Coimbatore hub quantity as 5 and the product is selled in Coimbatore.
If we want to search the transaction history by product or Ware House:
Example :in search box I’ll entered “Tom” and click entered the result page will show like this.
Hence all the Actions are done in the given Requirements and I add the few more features for user Flexibility .
Referances:
1.Bootsrap Styles – For user interface and styling.
2.For Developing This Application – WaterFall model in (OOSE-CCS356 (Anna University))
• This model the Development starts Requirements gathering phase.
• Then process analysis,design,coding,testing and Maintenance.