# 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.
- URL: https://spoko.space/garage-inventory-system/
- Published: 2025-10-19
- Tags: laravel, filament, livewire, rest-api, qr-code
---## 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

This private project streamlined garage organization and enabled selling unused parts through automated e-commerce integration.