Lager Guru - Product Overview

Enterprise-grade warehouse management and transport orchestration system with multi-tenant SaaS architecture.

What is Lager Guru?

Lager Guru is a comprehensive warehouse management system (WMS) designed for modern logistics operations. It provides real-time inventory tracking, intelligent routing, automated picking workflows, and complete visibility into warehouse operations.

Core Capabilities

🏢 Multi-Tenant SaaS Architecture

• Complete tenant isolation with Row-Level Security (RLS)
• Per-tenant configuration and branding
• Enterprise SSO integration (OIDC/SAML)
• Scalable architecture supporting unlimited tenants

📦 Inventory Management

• Real-time stock tracking with complete audit trail
• Zone-based inventory organization
• Low stock alerts and automated reordering
• Barcode scanning integration
• Stock movement history (inbound, outbound, transfer, adjustment)

📋 Pick & Pack Operations

• Automated pick list generation
• Optimal route calculation using zone coordinates
• Real-time picking progress tracking
• Pack session management
• Integration with inventory for automatic stock updates

🗺️ Warehouse Visualization

• Interactive SVG-based floor plan editor
• Real-time zone utilization heatmaps
• Driver and equipment location tracking
• Safety overlay visualization
• Pick route visualization

🤖 Intelligent Routing

• Distance-based zone routing
• Optimal path calculation (nearest-neighbor algorithm)
• Pre-computed pairwise zone distances
• Routing weight optimization
• Integration with driver auto-assignment

🧠 Slotting Optimization AI

• AI-driven zone placement recommendations
• Movement velocity analysis
• Turnover rate optimization
• Congestion factor calculation
• Heatmap-based zone utilization

🚚 Auto Assignment Engine

• Intelligent driver-to-shipment matching
• Multi-factor scoring (distance, capacity, availability)
• Zone-based assignment optimization
• Real-time assignment suggestions
• Manual override capabilities

🔧 Maintenance Management

• Equipment maintenance scheduling
• Task tracking and completion
• Maintenance history and analytics
• Preventive maintenance alerts
• Integration with equipment tracking

⚠️ Safety & Compliance

• Incident reporting and tracking
• Safety zone visualization
• Compliance checklist management
• Analytics and reporting
• Integration with warehouse map

📱 Equipment Tracking

• QR/RFID/manual equipment location tracking
• Real-time equipment status
• Location history
• Integration with floor plan visualization

Architecture Overview

graph TB
    subgraph "Frontend Layer"
        A[React PWA] --> B[Supabase Client]
    end
    
    subgraph "Backend Layer"
        B --> C[Supabase API]
        C --> D[PostgreSQL Database]
        C --> E[Row-Level Security]
        C --> F[Realtime Subscriptions]
    end
    
    subgraph "Services"
        G[Routing Engine] --> D
        H[Slotting AI] --> D
        I[Auto Assignment] --> D
    end
    
    subgraph "External"
        J[SSO Providers] --> C
        K[Barcode Scanners] --> A
    end
    
    E --> L[Tenant Isolation]
    F --> M[Live Updates]

Technology Stack

Layer	Technology
Frontend	React 18, TypeScript, Vite, Tailwind CSS, shadcn/ui
Backend	Supabase (PostgreSQL, Auth, Realtime, Storage)
Routing	React Router v6
State Management	React Context API, React Query
Build Tool	Vite
PWA	Workbox, Service Workers
Charts	Recharts
Maps	SVG-based custom renderer

User Roles

Role	Permissions	Access Level
Super Admin	Full system access, tenant management	All tenants
Tenant Admin	Full tenant access, user management	Single tenant
Tenant User	Standard operations, limited admin	Single tenant
Inventory Worker	Inventory, Pick & Pack, Floor Plan (view)	Single tenant
Maintenance Worker	Maintenance, Equipment Tracking	Single tenant
Driver	Shipment status, safety warnings	Single tenant

Key Features by Module

Inventory Module

• ✅ Master data management (SKU, name, description)
• ✅ Real-time quantity tracking
• ✅ Stock movement audit trail
• ✅ Low stock warnings
• ✅ Zone-based organization
• ✅ Barcode scanning

Pick & Pack Module

• ✅ Automated pick list generation
• ✅ Optimal route calculation
• ✅ Real-time picking progress
• ✅ Pack session tracking
• ✅ Integration with inventory

Routing Engine

• ✅ 3D coordinate system (X, Y, Z)
• ✅ Euclidean distance calculation
• ✅ Pre-computed pairwise distances
• ✅ Optimal path finding
• ✅ Routing weight optimization

Warehouse Map

• ✅ SVG-based floor plan editor
• ✅ Zone visualization
• ✅ Real-time heatmaps
• ✅ Driver/equipment tracking
• ✅ Safety overlay

Slotting AI

• ✅ Zone suitability scoring
• ✅ Movement velocity analysis
• ✅ Reorganization recommendations
• ✅ Heatmap generation
• ✅ Impact score calculation

Auto Assignment

• ✅ Multi-factor driver scoring
• ✅ Zone-based optimization
• ✅ Distance-based routing
• ✅ Capacity consideration
• ✅ Real-time suggestions

Maintenance

• ✅ Equipment maintenance tracking
• ✅ Scheduled tasks
• ✅ History and analytics
• ✅ Preventive alerts

Safety

• ✅ Incident reporting
• ✅ Safety zone visualization
• ✅ Compliance tracking
• ✅ Analytics

Equipment Tracking

• ✅ Location tracking (QR/RFID/manual)
• ✅ Real-time status
• ✅ History tracking
• ✅ Floor plan integration

Data Flow

sequenceDiagram
    participant User
    participant Frontend
    participant Supabase
    participant Database
    participant RLS
    
    User->>Frontend: Action (e.g., Create Pick List)
    Frontend->>Supabase: API Request
    Supabase->>RLS: Check Tenant Access
    RLS->>Database: Filter by tenant_id
    Database->>RLS: Return Filtered Data
    RLS->>Supabase: Authorized Data
    Supabase->>Frontend: Response
    Frontend->>User: Update UI

Security Model

• Row-Level Security (RLS): Database-level tenant isolation
• JWT Authentication: Secure token-based auth
• Tenant Context: Automatic tenant filtering
• Service Role: Secure backend operations only
• SSO Integration: Enterprise identity providers

Scalability

• Multi-Tenant: Unlimited tenants on single instance
• Horizontal Scaling: Supabase handles scaling
• Caching: Pre-computed distances and routes
• Optimization: Batch queries and efficient indexes

Integration Points

• SSO Providers: OIDC/SAML for enterprise auth
• Barcode Scanners: Web-based scanning API
• External APIs: RESTful API for integrations
• Webhooks: Event-driven integrations

Next Steps

• Architecture Documentation
• Module Documentation
• Developer Guide
• Multi-Tenant Guide
• API Reference