· Szymon Berski · Portfolio · 2 min read
Garage Inventory Management System
A private warehouse management system for organizing garage and workshop inventory, featuring QR code scanning, location tracking, and e-commerce integration via REST API.
Private Garage & Workshop Management
I developed a comprehensive inventory management system to organize my garage and workshop. The system handles automotive parts, tools, and consumable materials with precise location tracking and QR code scanning capabilities.
Core Features
Multi-tier Inventory Organization
The system uses a hierarchical structure for precise item location:
- Locations - Physical spaces (shelves, wall mounts, floor areas) with capacity tracking
- Containers - Boxes, organizers, and bins assigned to locations
- Items - Products, tools, and materials stored in containers or directly at locations
Each level supports QR code generation and scanning, enabling quick inventory operations via mobile device.
QR Code Scanning System
Every entity (products, containers, locations, tools, materials) has a unique QR code for:
- Quick item lookup by scanning
- Bulk inventory operations
- Container content verification
- Location-based item search
- Mobile-friendly warehouse navigation
Public PWA Interface
A separate mobile-friendly web app allows browsing inventory without logging into the admin panel:
- QR code scanning for quick product/container/location lookup
- Grid and list views with stock status indicators
- Container and location overview pages with product listings
- Touch-optimized interface for warehouse use
Parts for Sale Integration
Items marked for sale are exposed via REST API and displayed on a separate Astro-based storefront. The system supports:
- Dual-language product descriptions (Polish/English)
- Automatic price conversion (PLN/EUR via NBP rates)
- Shop status tracking (available, reserved, sold)
- SEO-friendly slugs generation
- DeepL-powered automatic translations
Tools & Materials Management
Beyond car parts, the system tracks:
- Tools - Categorized workshop equipment (wrenches, pliers, power tools, measuring instruments)
- Materials - Consumables with expiry date tracking and low-stock alerts (adhesives, fluids, chemicals)
Technical Implementation
Transaction & Audit System
Every inventory movement is recorded:
- Receipt, issue, and transfer transactions
- Automatic quantity updates
- Location change history
- Complete audit trail via Spatie Activity Log
Admin Panel with FilamentPHP
The FilamentPHP-based dashboard provides:
- Grid and list views with advanced filtering
- Bulk operations (move items, change locations, toggle for-sale status)
- Excel exports with customizable filters
- Low stock alerts and expiry warnings
- Kanban board for task management
- Role-based access control
Used Technologies
Laravel
Backend framework providing REST API, database management, and business logic for inventory operations.
FilamentPHP
Admin panel framework with 10+ resources, custom widgets, QR scanning actions, and export functionality.
Livewire
Powers real-time interactions including QR code scanning, dynamic form updates, and instant search.
REST API
Exposes products for sale to external Astro storefront with caching and pagination support.
QR Code System
Generates and scans QR codes for products, containers, locations, tools, and materials for efficient warehouse operations.
Role-Based Access Control
User roles and permissions system for secure multi-user access with complete activity logging and audit trails.
This private project streamlined garage organization and enabled selling unused parts through automated e-commerce integration.
