IMS / CIMS — Inventory & Management
Enterprise Inventory & Management Information System with QR Code Tracking
Project Overview
Manufacturing, engineering assembly, and warehouse operations require strict tracking of hardware components, raw materials, sub-assemblies, and tools across multiple stages of quality control.
IMS / CIMS is an internal web-based enterprise management system built using Python and Django. It centralizes real-time inventory records, automates QR code and serial number generation for physical parts, manages departmental handoffs, and enforces role-based access security across technicians, warehouse personnel, and administrators.
The Engineering Problem
Spreadsheet-based and disconnected tracking workflows present critical vulnerabilities:
- Component counts drift due to unlogged stock withdrawals and manual data entry errors.
- Physical items on warehouse shelves lack quick digital identification, slowing down assembly picking.
- Quality inspection approvals lack an immutable digital paper trail.
- Different departments require strictly scoped permissions (e.g., technicians should not be able to modify procurement pricing).
The Solution Built
Engineered a normalized relational data model in Django ORM with atomic transactions. Integrated automated QR code generation libraries (qrcode), real-time stock threshold alerts, CSV/PDF inventory report exporters, and Django's robust authentication layer.
System Architecture
↓
Django Authentication & RBAC Layer (Permission Verification)
↓
Inventory Business Logic Engine (Stock Reorder Alerts • Batch Movements)
↓
QR Code Pipeline (Automatic SVG/PNG Label Generation • Scanner Ingest)
↓
Relational Database Layer (Django ORM • SQLite Development / MySQL Production)
Key Capabilities
- Live Inventory Dashboard: Real-time overview of total item quantities, low-stock notifications, and pending orders.
- Dynamic QR Code Generation: Automatically assigns unique alphanumeric serials and QR codes printable directly onto part bins.
- Role-Based Access Control (RBAC): Granular permissions for Administrators, Warehouse Managers, Quality Officers, and Technicians.
- Quality Inspection Routing: Built-in inspection status transitions (Pending → Passed → Rejected) before items enter general stock.
- Movement Audit Trail: Logs every stock intake, transfer, checkout, and scrap event with user IDs and timestamps.
- Export & Reporting: Generates CSV spreadsheets and PDF summaries for periodic management audits.
Key Technical Challenges
select_for_update() database locks inside atomic blocks.