Contact person: Business Client

Phone:Show

Email:Show

Location: Gorakhpur, India

Budget: Recommended by industry experts

Time to start: As soon as possible

Project description:
"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)" (client-provided description)