integrated-inventory

An integrated inventory management system for the LEI (Leading Edge Innovations) chemical distribution warehouse.

---

General:

---

Languages/Technologies Used:

• Frontend: React Native, HTML/CSS/Javascript
• Backend: PHP, phpMyAdmin
• Windows as Subsystem for Linux [Ubuntu 18.04] (for development/testing/compilation)

---

Codebase Links/Logins:

---

App Development:

• https://github.com/HansSimon212/integrated-inventory.git

Databases:

• Database UI: https://wilczakindustrialparts.com/LEI/Multi/inventory.php

---

Inventory system: Old vs. New

---

Flaws of the old system:

• Highly inefficient:
  • Paper-based communication of inventory transactions
  • Google Sheets used as main database
  • Relocation of items required manual entry of new location (employees had to walk to the office space in the warehouse and enter new location by hand)
• Error-prone:
  • Items missing from filled purchase orders
  • Incorrect items sent to customers
  • Inconsistent/inaccurate quantities of goods in database.