QR ERP is a product demo for a cloud based QR scanning system. Small manufacturing facilities need an inventory tracking solution that is lightweight, fast, and accessible without all the expensive bells and whistles that large ERPs typically come with. With our setup, small manufacturing factories can print QRcodes as action modules and auto-increment inventory, reconcillate warehouse stock, and create full builds via Bill of Materials with their phone! The Azure SQL solution also makes it easy to maintain and keep track of existing tables to update future functionality. This provides an end-to-end inventory, warehouse, and logistics solution within a single hosted azure app (Figure 1)
Figure 1: End to End Inventory flow
These QR Codes can then be pasted within the workshop floor as seen in Figure 2 and allow ease of access to different manufacturing options
Figure 2: QR Codes at Factory Floor Level
At it's core, QR ERP comes with the following set of features:
* Backend Azure System with different Azure SQL tables
* Front-end triggerable stored procs to manipulate Azure SQL tables
* Auto QR generation to trigger front-end app for incrementing inventory
* DataFeed into excel to see on-hand inventory
To run the flask app, clone the repo and run app.py inside the main App folder.
Repo: https://github.com/IamJasonBian/QR_ERP
Demo Site (Please wait 60 seconds for it to load as we are using a small VM to host demo labs): https://qr-app-test.azurewebsites.net
Demo Slide: https://github.com/IamJasonBian/QR_ERP/blob/master/QR-ERP-Manufacturing%20Implementation.pptx