Inventory Management System

Overview #Personal Development

A web-based business operations system that centrally manages products, inventory quantities, inbound/outbound shipments, inventory transfers, stock counts, suppliers, locations, and storage areas for companies and stores. Beyond simply displaying current inventory, it enables tracking of "when, who, which product, and why inventory changed" through inventory ledgers and audit logs.

A demo is provided that allows access to key features from /demo without registration. Demo changes are saved to the browser's localStorage and do not modify shared data on Firebase.

Main Features

• Dashboard: Visualizes inventory quantities, inventory value, items requiring orders, stockouts, overstock, inbound/outbound trends, and items requiring attention
• Product & Inventory Management: Product registration, balance management across multiple locations, search by product name/SKU/JAN code, compound filtering
• Inventory Operations: Inbound, outbound (sales, usage, disposal, etc.), inter-location transfers, automatic rejection of outbound shipments exceeding available inventory
• Stock Counts & Adjustments: Stock counts by location/storage area, manager approval of discrepancies, inventory adjustments
• History & Audit: Records inbound/outbound, transfers, stock counts, and adjustments in a single ledger; tracking by product, transaction type, and date range
• Permission Management: Four roles (administrator, manager, general user, view-only) controlled by organizational scope
• CSV Features: Bulk product registration, initial inventory addition, various data exports, formula injection prevention
• Analytics: Inventory value by product/category, inventory by location, 12-week inbound/outbound trends, simplified inventory turnover rate

Target Users

Retail stores, e-commerce businesses, restaurants, beauty salons, medical/care facilities, warehouses, small to mid-sized enterprises with multiple locations that manage products, locations, and storage areas.

Problems Solved

• Lack of distinction between current inventory and available inventory, resulting in stockouts and overstock
• No record of inbound/outbound reasons, making it impossible to track inventory discrepancies
• Inventory scattered across multiple locations, making it difficult to compare totals and breakdowns
• Only one side of inventory transfers updated, causing balances and history to become inconsistent
• Stock count discrepancies reflected before approval, losing auditability
• Repeated manual Excel work for initial inventory registration and analysis