1.System Overview

The Inventory Management System (IMS) is designed around a transactional ledger architecture tied to structural classifications. Rather than simply modifying stock counts unpredictably, every inventory update is explicitly logged through an auditable pipeline. This ensures perfect operational transparency, exact chronological tracing, and immediate low-stock evaluation for warehouse managers.

2. The Diagram and How Everything Connects

The above diagram is a blueprint that shows how the inventory data is structured. It splits the system into two main areas: who things belong to (categories, suppliers) and what is happening to the stock (movements, reasons).

2.1 The Core Pieces

• Product : This is the center of the system. It keeps track of the item name, SKU, price, and how much stock is left.
• Category & SubCategory : Used to group items together (like Electronics ,Mobile Phones) so they are easy to find.
• Supplier: Keeps track of the company we buy the product from.
• StockMovement : This is the digital paper trail. Every time stock goes up or down, a new movement record is created.

2.2 The Rules of the Relationships

The lines and numbers between the boxes tell us how they are allowed to interact:

• Category to Product: Every product must belong to exactly one category. A category can have many products in it, or none at all.
• SubCategory to Product: Subcategories are optional. A product can have one, or skip it entirely.
• Product to StockMovement: A product can have a long history of many stock movements. A single stock movement log can only belong to one specific product.

2.3 Type and Reason Breakdowns

The arrows with hollow tips show options or sub-categories:

• Stock Movement Type: Stock can only move in two directions: IN (adding stock) or OUT (removing stock).
• Stock Movement Reason: Every movement must have an official explanation. It can only be a Sale (sold to customer), a Purchase (bought from supplier), or an Adjustment (manual fix for errors/damage).

3. The Dashboard Workspace

The Dashboard is the landing screen of the application. It gives managers an instant, high-level summary of what is happening in the warehouse.

It has three tabs (Dashboard,Products,Stock Movement)

3.1 Live Status Cards

Four distinct light-green cards line the top of the workspace to display high-level counts:

• Total Products: Shows the exact number of unique item variants currently registered in the database catalog (e.g., 7).
• Inventory Value : Displays the total calculated monetary value of all stock stored in the system (e.g., 8,296,060).
• Low Stock Warnings: Tracks the number of individual products that have dropped below their designated minimum safe limits (e.g., 3).
• Total Stock Movement: Represents the absolute lifetime tally of transactional logs committed to the ledger (e.g., 30).

3.2 Low Stock Products Panel (Left Table)

Positioned on the left side of the screen under the heading Low Stock Products, this clean two-column matrix lists every item currently demanding replacement attention:

• Name: Identifies the specific product (e.g., Hat, Iphone, F1 car).
• Current Stock: Displays the precise number of items remaining on the shelves.

3.3 Recent Stock Changes Panel (Right Table)

Positioned on the right side of the screen under the heading Recent Stock Changes, this four-column audit grid acts as a real-time historical ledger stream:

• Product: The name of the item that was modified.
• Quantity: The exact volume adjusted during the operation.
• Stock Movement: States the directional flow using crisp, bold text indicators—either IN (adding stock) or OUT (removing stock).
• Date: Tracks the exact execution day of the transaction (formatted as DD/MM/YYYY).

4. Products Tab Workspace

The PRODUCTS view serves as the central directory for organizing catalog profiles, setting baseline alerts, and monitoring item structures.

4.1 Search Controls & Data Utility Actions

The upper toolbelt provides interactive options to narrow down catalog logs and quickly extend data groupings:

• Filter Input: A text field that filters product entries by name or unique descriptive text.
• Stock Status Dropdown: A filter menu (defaulted to ALL) to quickly isolate items based on their structural safety thresholds.
• Add New Product (CTA): A bright green button to create a new profile from scratch.
• Structure Management Tools: Subtext links configured along a dedicated secondary row allow users to directly add entity metadata:
  • + ADD SUPPLIER
  • + ADD CATEGORY
  • + ADD SUB CATEGORY

4.2 All Products Master Directory Table

The main area lists full specifications inside a structured, multi-column directory matrix:

• Name: The item title registered within the inventory loop (e.g., F1 car, macbook neo).
• Description: Brief, helpful detail summaries logged alongside the profile (e.g., latest macbook, Marvel Toy).
• Current Stock: A tracking indicator showing the real-time physical unit counts sitting in stock.
• Min Stock Level: The designated target baseline count that triggers system notifications.
• SKU: The indexable, alpha-numeric model identification tracker (e.g., toy-103, laptop-101).
• Unit Price: The localized purchase value assigned to single pieces (e.g., 30, 2,000).
• Category: The high-level grouping designation assigned to sorting pipelines (e.g., Toys, Laptop, Phones).
• Sub Category: Extended classifications helping divide main segments (e.g., Boys Toys, Apple).
• Supplier: The specific vendor link assigned to restock orders (e.g., Naivasha, Jumia, toysareUS).

4.3 Low Stock Level Notification Check

To support rapid visual audits, rows automatically change color based on threshold calculations:

• Red Notification Rows: Any item whose Current Stock count drops strictly below its assigned Min Stock Level value turns a soft red/pink color across the grid line. This corresponds to the Low Stock Level indicator badge anchored directly above the table header.
• Standard White Rows: Items maintaining healthy volumes above their safety line display on standard white backgrounds.

5. Stock Movement Ledger Workspace

The STOCK MOVEMENT view acts as the definitive long-form historical audit workspace for the system. It records an immutable trace of every inventory modification to ensure accountability and track stock lifecycle patterns.

5.1 Search Filter & Auditing Toolbelt

The upper workspace control strip provides comprehensive drop-down query fields to filter historic logs:

• Filter Input: An interactive text lookup box used to filter transactions by a specific product name.
• Stock Direction Selector: A drop-down menu (defaulted to ALL) that filters history rows based on directional flow parameters (ALL, IN, or OUT).
• Stock Reason Selector: A drop-down categorization menu (defaulted to ALL) that narrows down log views strictly by workflow context definitions (such as Sale, Purchase, or Adjustment).

5.2 Search Result Master Audit Table

The main area outputs complete transactional parameters across a multi-column query ledger matrix:

• Name: The explicit designation title of the profile modified (e.g., macbook neo, F1 car, Hat).
• Quantity: The absolute positive integer volume added or subtracted during the workflow.
• Notes: Strategic operational subtext notes typed by managers to describe the baseline cause of the change (e.g., first sale, purchase, new stock, new hats, sale some buzz).
• Reason: The official operational context category tag mapping directly to system workflow classifications (Sale or Purchase).
• Direction: The specific mechanical flag dictating directional resource flows—either IN (increasing stock levels) or OUT (reducing stock levels).
• Movement Date: A highly accurate time stamp capturing the precise execution day and time down to the second (formatted as DD/MM/YYYY HH:MM:SS).

6. Forms and Pop-up Windows

The interface manages data alterations through interactive modal input windows initialized directly from the top navigation panel.

Stock In Modal Window

Clicking the green STOCK IN button opens a centralized modal window over the active workspace, providing a controlled entry pipeline for increasing inventory counts.

• Product Dropdown Selection: A searchable dropdown list used to select the specific item to be updated (e.g., Iphone).
• Quantity Entry Field: A numerical input box where users type the exact number of incoming items to add to the shelves.
• Notes Multi-line Text Area: A wide comment field for typing administrative details, references, or context regarding the stock drop (e.g., invoice tracking tokens).
• Stock Movement Reason Segment: Instead of choosing text fields, users designate the business workflow directly using contextual toggle action selectors:
  • PURCHASE: Selected for standard inventory restocks arriving from third-party wholesale suppliers.
  • ADJUSTMENT IN: Selected for manual corrections, such as correcting miscounts found during audits or returning items.
• Metadata Footprint Logs: The footer of the modal maps structural audit dates to track operational history:
  • Create Time: Displays the initial date stamp when the entry window is requested (formatted as DD/MM/YYYY).
  • Change Time: Tracks operational modifications.
  • Movement Date: Captures the transaction execution date mapped to the final log insertion.
  • Action Buttons: Complete processing relies on three distinct navigation triggers at the bottom:
    • SAVE: Commits and validates structural entry edits.
    • CANCEL: Dismisses the form without saving changes or altering stock.
    • OK: Finalizes and applies the stock transaction to the ledger.

Stock Out Modal Window

Clicking the red STOCK OUT button opens a matching modal entry sheet designed to securely deduct inventory values from the active system counts.

• Product Dropdown Selection: A dropdown menu used to specify the item being deducted from inventory storage (e.g., Product: Buzz Light).
• Quantity Entry Field: A dedicated numerical input box to record the exact volume of stock leaving the warehouse.
• Notes Multi-line Text Area: A description field provided for users to type manual transaction contexts, write-off claims, or invoice details.
• Stock Movement Reason Segment: Operators categorize the inventory reduction by selecting one of two specific action buttons:
  • SALE: Selected for typical outbound retail shipments or direct customer transactions.
  • ADJUSTMENT OUT: Selected for manual corrections, such as handling damaged goods, internal item shrinkage, or inventory count cleanups.
• Metadata Footprint Logs: The footer region tracks processing dates to ensure timeline compliance:
  • Create Time: Displays the generation timestamp when the pop-up window is loaded (formatted as DD/MM/YYYY).
  • Change Time: Monitored for layout modifications.
  • Movement Date: Logs the absolute tracking date attached to the final record entry.
• Action Triggers: Finalizing or exiting the form relies on three utility targets:
  • SAVE: Validates and stores individual field edits.
  • CANCEL: Closes the popup window instantly without altering database levels or writing logs.
  • OK: Submits the final layout data, processes validation, and updates the stock balances.