Simple Inventory Management System

Project Overview

Lightweight inventory management tool for small laptop retailers. Add products, track stock, get reorder alerts.

Core Features:

• CRUD products (name, SKU, price, quantity, image URL)
• Stock adjustments with reasons
• Visual labels: "In Stock" (green) / "Time to Order" (orange, ≤5 units)
• Search/filter by name, SKU, category
• Mobile-responsive dashboard

Tech Stack & Structure

• Frontend: React components, services, utils
• Backend: FastAPI routes, business logic, models (no authentication needed for now)
• Database: SQLite stored in /data folder as .db file

/frontend - React components, services, utils
/backend - FastAPI routes, business logic, models
/data - SQLite database file (.db)

Guidelines

• Reuse code - check existing before creating new
• Modular - single responsibility components
• Clean UI - professional theme, intuitive for non-tech users
• Mobile-first - responsive design

Color Palette

• Background: White (#FFFFFF), Light gray (#F5F5F5)
• Primary: Blue (#2563EB)
• Success: Green (#059669) - "In Stock" labels
• Warning: Orange (#D97706) - "Time to Order" labels
• Error: Red (#DC2626)
• Text: Dark gray (#111827), Medium gray (#6B7280)
• Borders: Light gray (#D1D5DB)

Sample Data

Auto-populate after development:

• Default image: https://png.pngtree.com/png-vector/20210123/ourmid/pngtree-wooden-doll-design-puppet-png-image_2787747.jpg
• Stock mix: Some "In Stock", some "Time to Order"
• SKUs: ELEC-001, CLOTH-001 pattern