Inventory Management Guide
This comprehensive guide covers everything you need to know about managing inventory items in the University Inventory Management System.
Overview of Inventory Management
The inventory system allows you to:
Track all university assets and supplies
Monitor stock levels and movements
Organize items by categories
Generate reports and analytics
Maintain audit trails for accountability
Adding New Items
Creating Your First Item
Step-by-Step Process:
Click “Add Item” button
Fill out the item form with required information
Review details and click “Save”
Required Fields:
Item Name: Clear, descriptive name
SKU: Unique identifier (auto-generated if left blank)
Category: Select from existing categories
Current Stock: Number of units currently available
Minimum Stock: Threshold for low stock alerts
Unit Price: Cost per individual item
Optional Fields:
Description: Detailed item description
Location: Where item is stored
Supplier: Vendor information
Model Number: Manufacturer's model
Serial Numbers: For tracked items
Best Practices for Item Creation
Naming Conventions:
Use consistent, descriptive names
Include brand, model, and key specifications
Avoid abbreviations that aren’t widely understood
Good Examples: - “Dell OptiPlex 7090 Desktop Computer” - “Epson PowerLite 1781W Wireless Projector” - “HP LaserJet Pro M404n Printer”
Poor Examples: - “Computer” - “Proj #3” - “HP Thing”
SKU Best Practices:
SKUs should be: - Unique across your entire inventory - Meaningful to users - Consistent in format - Easy to type and remember
SKU Format Examples:
Pattern: [CATEGORY]-[BRAND]-[MODEL]-[VARIANT]
Examples:
DESK-DEL-OPT7090-i5 (Desktop, Dell, OptiPlex 7090, i5)
PROJ-EPS-PL1781-WIFI (Projector, Epson, PowerLite 1781, WiFi)
PRIN-HP-LJ404-BW (Printer, HP, LaserJet 404, Black/White)
Managing Stock Levels
Understanding Stock Status
Items have different stock status indicators:
Status Colors: - Green: Adequate stock (above minimum) - Yellow: Getting low (within 20% of minimum) - Red: Low stock (at or below minimum) - Gray: Out of stock (zero quantity)
Updating Stock Quantities
Stock In (Receiving Items):
Find the item in inventory list
Click “Stock” button or stock quantity
Select “Stock In”
Enter quantity received
Provide reason (e.g., “New shipment from vendor”)
Click “Update Stock”
Stock Out (Issuing Items):
Locate item to be issued
Click “Stock” button
Select “Stock Out”
Enter quantity being issued
Provide reason (e.g., “Deployed to Smith Hall Lab”)
Confirm the update
Stock Adjustment:
Use when correcting discrepancies or conducting physical counts:
Select “Adjustment” in stock dialog
Enter the correct total quantity
System calculates the adjustment automatically
Provide reason for adjustment
Save the change
Example Stock Movements:
Stock In Examples:
- "Received 10 units from Dell shipment #12345"
- "Found 2 additional units in storage room B"
- "Returned 1 unit from repair service"
Stock Out Examples:
- "Deployed 3 laptops to Computer Science Lab"
- "Loaned 1 projector to Professor Johnson"
- "Sent 2 units for repair/maintenance"
Adjustment Examples:
- "Physical count correction"
- "Reconciliation after audit"
- "Database correction"
Editing Item Information
Modifying Item Details
Who Can Edit: - Managers and Admins can edit all item fields - Users can view but not modify items
Editing Process:
Click on item name or “Edit” button
Modify fields as needed
Add notes about changes made
Save changes
Commonly Updated Fields:
Price: Update when costs change
Minimum Stock: Adjust based on usage patterns
Description: Add more details or specifications
Location: Update when items are moved
Supplier: Change vendor information
Change Tracking:
All edits are automatically tracked: - Who made the change - When the change was made - What fields were modified - Previous and new values
Searching and Filtering
Basic Search
Quick Search: - Type in the search box at the top - Searches across item names, SKUs, and descriptions - Results update as you type - Case-insensitive matching
Search Tips: - Use partial words: “proj” finds “projector” - Include model numbers: “XPS13” finds Dell XPS 13 laptops - Search by brand: “HP” shows all HP products
Advanced Filtering
Filter Options:
Category: Show items from specific categories
Stock Level: - Low stock items only - Out of stock items - Adequately stocked items
Price Range: Filter by unit price
Date Added: Recently added items
Supplier: Items from specific vendors
Combining Filters:
Create powerful searches by combining multiple filters:
Example: IT Equipment + Low Stock + Price > $500
Result: Expensive IT items that need restocking
Saved Searches:
Save frequently used filter combinations:
Set up your filters
Click “Save Search”
Give it a descriptive name
Access from “Saved Searches” dropdown
Bulk Operations
Bulk Updates
Selecting Multiple Items:
Use checkboxes to select items
“Select All” for entire page
“Select All Matching” for filtered results
Bulk Actions Available:
Category Change: Move items to different category
Price Update: Apply percentage increase/decrease
Minimum Stock: Update thresholds for multiple items
Export: Download selected items
Deactivate: Mark items as inactive
Example Bulk Operations:
Scenario: Annual price increase
1. Filter by supplier "Dell"
2. Select all Dell items
3. Apply 5% price increase
4. Review and confirm changes
CSV Bulk Import
The system provides a comprehensive CSV bulk import feature for efficiently adding multiple inventory items at once.
Accessing Bulk Import:
Navigate to Inventory page
Click “Bulk Import” button in the top toolbar
The import dialog will open
Step-by-Step Import Process:
Download CSV Template - Click “Download Template” to get the properly formatted CSV file - Template includes example data and correct column headers
Prepare Your Data - Open template in Excel, LibreOffice, or any spreadsheet application - Fill in your inventory data following the format
Upload CSV File - Click “Select CSV File” in the import dialog - Choose your completed CSV file - System validates file format automatically
Review Import Preview - Preview shows up to 10 items from your file - Displays items in £ pricing format - Shows any validation errors that need fixing
Complete Import - Click “Import X Items” to process all valid items - System reports success/failure counts - Failed items with specific error messages
CSV Template Format:
Required Columns:
name,sku,description,categoryName,price,currentStock,minimumStock
Example Data:
Example Laptop,SKU001,High-performance laptop,IT Equipment,999.99,10,5
Office Chair,SKU002,Ergonomic office chair,Furniture,299.99,15,3
Field Requirements:
name: Item name (required, descriptive)
sku: Unique identifier (required, must be unique)
description: Item details (optional, can be empty)
categoryName: Exact category name (required, case-insensitive)
price: Unit price in numbers (required, no currency symbols)
currentStock: Current quantity (required, whole numbers)
minimumStock: Low stock threshold (optional, defaults to 0)
Validation Rules:
The system validates each row for: - Required fields are not empty - Category names match existing categories - Price and stock values are valid numbers - SKU uniqueness across all items
Error Handling:
Common import errors and solutions:
Error: "Missing required columns"
Solution: Ensure CSV has all required column headers
Error: "Category 'XYZ' not found"
Solution: Use exact category names from Categories page
Error: "Invalid price or stock values"
Solution: Use numbers only, no currency symbols or text
Error: "Row X: Missing required fields"
Solution: Fill in all required columns for that row
Best Practices:
Prepare Categories First: Create all needed categories before importing
Validate Data: Check for typos in category names and numeric fields
Small Batches: Test with 5-10 items first, then import larger batches
Backup Data: Keep original spreadsheet as backup
Review Results: Check import summary and fix any failed items
Performance Notes:
Import processes items sequentially for data integrity
Large imports (100+ items) may take several minutes
System shows progress during import
Page refresh is safe - import continues in background
Post-Import Actions:
After successful import: - Items appear in inventory list immediately - Dashboard statistics update automatically - Stock movement records created for initial quantities - All items marked as active and available
Categories and Organization
Understanding Categories
Categories help organize your inventory into logical groups:
Default Categories: - IT Equipment - Office Supplies - Laboratory Equipment - Furniture - Medical Supplies - Audio/Visual Equipment
Category Properties: - Name and description - Color coding for visual identification - Icon for quick recognition - Access permissions
Working with Categories
Viewing by Category:
Use category filter in main inventory view
Click category cards on dashboard
Navigate to Categories section
Creating New Categories (Manager/Admin):
Go to Categories section
Click “Add Category”
Fill in details: - Name: Clear, descriptive title - Description: Purpose and contents - Icon: Choose from available icons - Color: Select distinct color
Best Practices: - Keep categories broad enough to be useful - Avoid too many subcategories - Use consistent naming conventions - Choose distinct colors for easy identification
Reports and Analytics
Inventory Reports
Available Report Types:
Inventory Summary: Complete item listing
Low Stock Report: Items needing attention
Category Analysis: Distribution by category
Value Report: Financial overview
Movement Report: Recent activity
Generating Reports:
Go to Reports section
Select report type
Choose date range and filters
Generate report
Export as PDF or CSV
Custom Reports:
Create specialized reports: - Filter by specific criteria - Choose which columns to include - Set automatic generation schedule - Share with team members
Troubleshooting Common Issues
Item Not Found
If you can’t locate an item:
Check search spelling
Try partial name search
Clear all filters
Search by SKU instead of name
Check if item is in different category
Verify item hasn’t been marked inactive
Stock Discrepancies
When stock numbers don’t match physical count:
Review recent stock movements
Check for pending transactions
Look for unreported movements
Perform physical count
Use stock adjustment to correct
Document the reason for discrepancy
Permission Issues
If you can’t perform an action:
Check your user role
Verify item permissions
Try logging out and back in
Contact your system administrator
Request role upgrade if needed
Mobile Inventory Management
Mobile Features
Available on Mobile: - View inventory items - Quick stock updates - Search and filtering - Basic item details - Stock movement history
Mobile Best Practices: - Use landscape mode for forms - Bookmark frequently accessed items - Enable notifications for alerts - Keep app updated
Limitations: - No bulk operations - Limited reporting features - No item creation (security) - Simplified interface
This comprehensive guide covers all aspects of inventory management. For additional help, refer to the troubleshooting section or contact your system administrator.