The Design And Implementation Of Inventory Management System Based On Flask Framework

Having a large amount of inventories to track, record, and manage, most of the current enterprises may use the traditional way which is using Excel to add, delete, and modify the records to manage inventories. Obviously, it has many disadvantages and makes the work complicated and easy to cause errors. So when the inventory takes quite a large proportion of the total physical property, inventory management becomes much more important for those enterprises, there is a need to use an inventory management system to better organize and manage the inventories.The inventory management system design and implemented in the paper is an online management system that is applied to the company for internal use, it is the information system which is to refine the traditional way of using Excel to manage inventories, and it is the information management system that can deal with the operations of requesting, returning, scrapping, transferring, editing and searching inventories, that supports Excel by importing and exporing Excel files, that will inform related users by online messages and mails when the state of inventory changes.The system uses three-layered structure of which the presentation layer uses HTML, CSS, JavaScript, JQuery, Bootstrap framework and Jinja2 template engine to support and the Ajax technique to improve the response speed, the logic layer uses python script language and Flask framework to implement the logical business process of the server side, and the data layer uses the SqlAlchemy tool which is the best suite for Flask to access and operate database. In the paper, the related technology, requirement, design and implementation of the inventory management system will be introduced in detail.