1. Introduction This Statement of Work (SOW) outlines the complete project scope, user flows, features, and deliverables for developing the Multi-Warehouse Inventory Management Platform, accessible via a responsive web application. The whole system will be mobile responsive. The system is designed based on the client’s updated requirements and supports multi-warehouse operations, inventory tracking, stock transfers, sales, returns, user-role based access, and detailed reporting. 2. Technology Stack Component Frontend Backend / Database Authentication Hosting Technology React.js Firebase Firestore Firebase Authentication Firebase Hosting No server or hosting cost is required from the client. 3. User Types 1. Admin (Web Panel) 2. Warehouse Manager (One per warehouse; Web Panel) 4. User-Based Workflow 4.1 Warehouse Manager The Warehouse Manager operates only within their assigned warehouse. All dashboard numbers, inventory, transactions, and reports belong only to that warehouse. 4.1.1 Dashboard (Warehouse Manager) The dashboard will show: Tabs 1. Inventory Tab (specific landing page) Shows: ○ Total Products ○ Total Inventory (current stock of all products in that warehouse) 2. Transactions Tab (specific landing page) Shows: ○ Total Number of Transactions ○ Total Sales (Sale entries count/value) 3. Reports Tab → Opens all available reports for the warehouse. Quick View Grids (with View All buttons) ● Last 5 Transactions ● Latest 5 Low Stock Products 4.1.2 Catalog & Inventory Management A. Category & Sub-Category Management (Global) ● Add / Edit Category ● Add / Edit Sub-category ● Fields: Name (Unique) ● Reflected across all warehouses. B. Product Management (Global) ● Add / Edit Product ● Fields: ○ Product Name (Unique) ○ Size (Optional) ○ Class (Optional) ○ Unit Price (Mandatory) Product catalog is same for all warehouses. Only Warehouse Manager can edit product info, as requested. C. All Products Grid (Warehouse-Specific Data Mixed With Global Fields) Columns shown: ● Product ID ● Product Name ● Created On (Date) ● Last Modified (Date) ● Category / Sub-category ● Size ● Class ● Unit Price ● Low Stock Threshold Qty (Warehouse-specific) ● Last Entry Date (Warehouse-specific) ● Last Entry Type (Warehouse-specific) ● Current Qty (Warehouse-specific) All columns are searchable & filterable. D. Warehouse-Level Quick Actions (Per Product Row) Actions affect only the logged-in warehouse: 1. Direct Add Inventory (Credit) 2. Direct Reduce Inventory (Debit) 3. Stock Transfer to Another Warehouse ○ Manager selects target warehouse ○ Enters transfer qty ○ Confirms via popup ○ Remarks optional E. Inventory Entry Log Every action creates a new entry. Deleting an entry also creates a “delete entry” record. Columns: ● Entry ID ● Product ID ● Product Name ● Category ● Entry Type: ○ Direct Added (Credited) ○ Direct Reduced (Debited) ○ Direct Deleted (Wrong Entry) ○ Stock Transfer to Other Warehouse (Debited) ○ Stock Received From Other Warehouse (Credited) ● Deleted Entry ID (if applicable) ● Date of Entry ● Qty After This Entry ● Quick Action Buttons (Add / Reduce / Delete) ● Remark Note: Each delete action logs itself as a new entry linked to original Entry ID. 4.1.3 Manage Transactions (Sales & Returns) A. Sale Entry (Two-Step UI) Step 1: ● Filters for category (optional) ● Product dropdown with search Step 2: ● Shows product details: ○ Unit Price ○ Available Qty ○ Low Stock Threshold Qty ● User enters sale quantity ● System shows total price (unit price * qty) on UI ● Apply Discount: ○ None ○ Fixed Amount ○ Percentage ● User clicks Sold (with/without remark) B. Transaction Entry Log Columns: ● Transaction ID ● Returned Sales Transaction ID (if return) ● Product ID ● Product Name ● Category ● Entry Type (Sale – Debited, Return – Credited) ● Date of Entry ● Amount Before Discount ● Discount Type (None, Fixed, Percent) ● Discount Value ● Final Sales Amount ● Remark Return Action ● Available on each sale row ● Creates a return entry (with/without remark) ● Uses same Sale ID for linking ● Return calculation as per partner’s definition (no extra rules added) 4.1.4 Reports (Warehouse Manager) Export Format: CSV Only (as per your confirmation) Reports: 1. Sales Report ○ Filter: Category, Sub-category, Product ○ Date / Date Range ○ Shows all columns of Sales entries ○ Includes Total Sales at bottom 2. Return Report ○ Filter: Category, Sub-category, Product ○ Date / Date Range ○ Includes Total Returned Qty & Amount 3. Low Stock Report ○ All or selected products 4. Available Stock Report ○ All or selected products 5. Inventory Delete Report ○ Category / Product Filters ○ Date / Date Range ○ Total Deleted Entries 4.2 Admin Admin has full access to all warehouses. Admin Capabilities A. Create / Edit Warehouse Fields: ● Warehouse Name ● Unique ID ● Password (Admin sets new password; existing password is not shown) ● Enable / Disable Status B. View All Warehouses Columns: ● Name ● ID ● Status (Enabled / Disabled) C. View All Reports (Global) Admin can view: ● Combined reports (all warehouses) ● Per-warehouse specific reports All exported in CSV format. Report types: 1. Sales Report 2. Return Report 3. Low Stock Report 4. Available Stock Report 5. Inventory Delete Report All support: ● Category / Product filters ● Date / Date Range ● Warehouse selection (single / all warehouses)