Storage (Sub-Module)

- What Is the Storage Section?
 

The Storage section displays all products physically stored in warehouses, along with:
 

• Inventory quantities

• Sold quantities

• Damaged quantities

• Category & sub-category

• Cost price (permission-based)
   

Each row represents a product in a specific storage location.

 

---

 

- What Storage Is Used For
 

- Inventory Control
 

• View real-time stock

• Track available quantities

• Monitor sold & damaged units
   

- Multi-Storage Tracking
 

• Same product in multiple storages

• Central + branch warehouses

• Sub-storage inclusion
   

- Reporting & Export
 

• Export inventory to Excel

• Category-wise stock analysis

• Storage utilization review
   

---

- Storage Interface – How It Works
 

Top Bar:
[ Select Storage ▼ ]   [ Search Product ]   [ Export File ]

Table Columns:
# | SKU | Product | Supplier | Category | Cost | Sold | Inventory | Action
 

Storage Selector
 

• All → Shows products from all storages

• Specific Storage → Shows products from that storage + its sub-storages

 

---

 

? Filtering & Search
 

• ? Search by product name or SKU

• ? Filter by category

• ? Filter by sub-category

• All filters work together in real time
   

---

➕ Adding Products to Storage
 

Add Flow

1. Click green “+” icon

2. Select storage

3. Enter stock quantity

4. Optional: damaged units & notes

5. Save → inventory updates instantly
    

---

✏️ Editing Inventory
 

• Edit stock quantity

• Adjust damaged count

• Inventory auto-recalculates

• Changes reflect across reports
   

---

? Exporting Inventory
 

• Click Export File

• Excel downloads

• Respects filters (storage, category, search)
   

---

? Inventory Calculation Logic
 

Available Inventory =
stock
- sold
- damaged
- moved_from_storage
+ moved_to_storage

✔ Automatic
✔ No manual recalculation
✔ Always consistent
 

Product Movement & Storage Request 
 

? What Is the Request Section?
 

The Request section manages how products move:
 

• Between storages

• From suppliers into storage
   

Every request creates a controlled, auditable workflow.
 

---

? Request Use Cases
 

? Storage-to-Storage Transfer
 

• Move stock from one warehouse to another

• Track outgoing & incoming quantities
   

? Supplier Orders
 

• Order products from suppliers

• Receive inventory into storage
   

? Documentation
 

• Generate PDF transfer / order documents

• Maintain audit trail
   

---

? Request Interface Overview
 

Table Columns:
Request ID | User | Date | Type | From | To | Qty | Notes | Status | Actions

Request Types
 

• Moving Request – Storage → Storage

• Supplier Order – Supplier → Storage
   

---

➕ Creating a Request
 

Step-by-Step
 

1. Click Add Request

2. Select request type

3. Choose:

   • From storage

   • To storage OR supplier

4. Add products & quantities

5. Optional: save as Draft

6. Submit
    

✔ Supports multiple products
✔ Single request = multiple items
 

---

✅ Approve / ❌ Reject / ? Receive
 

• Approve → authorizes movement

• Reject → cancels request

• Receive → updates inventory automatically
   

Inventory updates happen only on Receive.
 

---

? PDF Generation
 

• One-click PDF

• Includes:

  • Storage details

  • Products & quantities

  • Notes

  • Request metadata
     

---

? How Storage & Request Work Together

 

Supplier / Storage
       ↓
    Request
       ↓
   Approval
       ↓
   Receive
       ↓
Inventory Updated

✔ Zero manual stock edits
✔ Full traceability
✔ Clean audit trail
 

? Permissions & Control
 

Storage Permissions
 

• View inventory

• Edit inventory

• View cost & sold

• Delete inventory entries
   

Request Permissions
 

• Create requests

• Approve / reject

• Edit drafts

• Receive inventory
   

All permissions controlled via role-based JSON config.
 

?️ Database Integrity (Conceptual)
 

• storage_products → inventory truth

• storage_request → movement log

• ec_product → aggregated stock

• JSON used for flexibility & scale
   

✔ No duplication
✔ No race conditions
✔ Always consistent

? Final Summary
 

Storage & Request Module =
✔ Physical inventory control
✔ Multi-warehouse support
✔ Secure movement workflow
✔ Supplier integration
✔ Automatic stock calculation
✔ PDF documentation
✔ Enterprise-ready design