📊 Product Fix Stock – Comprehensive Inventory Overview #
1. Navigate to “Product Stock Details” #
- Log in to your restaurant management system.
- In the sidebar, click Inventory.
- Under Inventory, select Fix Stock or Product Stock Details.
- The product stock details page will open showing:
- A Filters section for searching products and selecting business locations.
- Product search functionality with barcode scanning capability.
- Location selection dropdown with multiple location options.
- A comprehensive data table showing detailed stock information for all products.
- Bulk selection options with “Select All” and “Fix All” buttons.
2. Understanding Product Stock Details #
This page provides a comprehensive view of inventory across all products and locations. It serves multiple purposes:
- Inventory Overview – Complete snapshot of stock levels across all products and locations.
- Stock Discrepancy Detection – Identify products with incorrect stock calculations or negative inventory.
- Multi-Location Management – View and manage inventory across different restaurant branches.
- Production Planning – Monitor ingredient availability for menu items and production schedules.
- Financial Valuation – Track total inventory value and cost implications.
- Reorder Management – Identify products that need restocking based on current levels.
Key Feature: The “Fix” functionality allows you to correct stock discrepancies and synchronize inventory calculations across the system.
3. Use Search and Filter Options #
- Search Product:
- Enter product name, SKU, or scan barcode in the search field.
- Use the dropdown to select search criteria (Product name/SKU/Scan bar code).
- System will filter results to show matching products only.
- Business Location:
- Select “Please Select” to view all locations.
- Choose specific locations like “Restaurant (R-0001)”, “Store (R-0002)”, “Indian Restaurant (R-0003)”.
- Filter results to show inventory for selected location only.
- Click the Search button to apply filters and refresh the data table.
- Clear Filters – Remove search criteria to view all products again.
4. Understanding Table Columns #
| Column | Description | Purpose |
|---|---|---|
| ☑️ Checkbox | Select individual products for bulk actions | Enable bulk operations like “Fix All” |
| Product | Product name in multiple languages (Arabic/English) | Identify specific inventory items |
| Opening Stock | Initial inventory quantity at period start | Track starting inventory levels |
| Total Purchase | Total quantity purchased during period | Monitor procurement and restocking |
| Total Purchase Return | Quantity returned to suppliers | Track returns and supplier issues |
| Total Stock Adjustment | Net adjustments made to inventory | Monitor corrections and discrepancies |
| Total Sold | Quantity sold to customers | Track product movement and demand |
| Total Used For Production | Quantity consumed in recipe production | Monitor ingredient usage in manufacturing |
| Current Stock | Calculated current inventory level | Real-time stock availability |
| Incorrect Stock | Discrepancies in stock calculations | Identify calculation errors needing correction |
| Fix | Action button to correct stock discrepancies | Resolve inventory calculation issues |
5. Bulk Selection and Actions #
- Select All:
- Click the “Select All” checkbox to select all visible products.
- Useful for bulk operations across multiple products.
- Selection applies only to currently displayed products (respects pagination).
- Individual Selection:
- Click individual checkboxes to select specific products.
- Hold Ctrl/Cmd to select multiple non-consecutive items.
- Selected items are highlighted for easy identification.
- Fix All:
- Purple “Fix All” button becomes active when products are selected.
- Applies stock correction to all selected products simultaneously.
- Recalculates inventory based on transactions and adjustments.
6. Individual Product Actions #
Each product row provides detailed information and actions:
- View Stock Details – Click on product name to see detailed transaction history.
- Fix Individual Stock – Use the purple “Fix” button to correct specific product discrepancies.
- Monitor Stock Levels – Review current stock against opening stock and transactions.
- Identify Issues – Look for negative values or unexpected discrepancies in calculations.
- Track Usage Patterns – Analyze sold quantities vs. production usage for demand planning.
7. Stock Calculation Logic #
Stock Calculation Formula:
Current Stock = Opening Stock + Total Purchase – Total Purchase Return + Total Stock Adjustment – Total Sold – Total Used For Production
Current Stock = Opening Stock + Total Purchase – Total Purchase Return + Total Stock Adjustment – Total Sold – Total Used For Production
- Opening Stock – Starting inventory at beginning of period.
- Add Purchases – Increase inventory from supplier deliveries.
- Subtract Returns – Decrease for items returned to suppliers.
- Apply Adjustments – Add/subtract manual inventory corrections.
- Subtract Sales – Decrease for items sold to customers.
- Subtract Production Usage – Decrease for ingredients used in recipes.
- Result – Calculated current stock level.
8. Identifying and Fixing Stock Issues #
| Issue Type | Symptoms | Fix Action |
|---|---|---|
| Negative Stock | Current stock shows negative values | Use Fix button to recalculate or create adjustment |
| Calculation Error | Current stock doesn’t match manual calculation | Fix individual product or use Fix All for bulk correction |
| Missing Transactions | Stock levels don’t reflect recent activities | Verify transaction recording, then fix stock |
| Incorrect Opening Stock | Starting values don’t match physical count | Create stock adjustment for opening balance correction |
| Production Discrepancies | Production usage doesn’t match recipe consumption | Review recipe configurations and fix calculations |
9. Multi-Location Stock Management #
- Location-Specific View:
- Select specific location to view inventory for that branch only.
- Compare stock levels across different restaurant locations.
- Identify locations with stock shortages or overages.
- Cross-Location Analysis:
- View “Please Select” to see combined inventory across all locations.
- Identify opportunities for stock transfers between locations.
- Monitor total company inventory investment.
- Location-Specific Fixes:
- Fix stock issues at individual locations without affecting others.
- Maintain accurate inventory records for each business unit.
10. Best Practices for Stock Management #
- Regular Monitoring – Review stock details weekly to identify and resolve discrepancies quickly.
- Systematic Fixes – Use Fix All functionality during off-peak hours to avoid system conflicts.
- Transaction Verification – Ensure all purchases, sales, and production activities are properly recorded.
- Physical Counts – Perform regular physical inventory counts to validate system calculations.
- Recipe Accuracy – Maintain accurate recipe configurations to ensure proper production usage calculations.
- Staff Training – Train staff on proper transaction recording to minimize calculation errors.
- Backup Procedures – Backup data before performing bulk fix operations.
- Documentation – Document reasons for stock fixes and maintain audit trails.
11. Troubleshooting Common Issues #
| Problem | Possible Cause | Solution |
|---|---|---|
| Fix button not working | System permissions or data conflicts | Check user permissions, try individual fixes first |
| Stock still incorrect after fix | Ongoing transaction recording issues | Investigate recent transactions, fix underlying processes |
| Slow page loading | Large dataset or system performance | Use location filters to reduce data load |
| Missing products in list | Product inactive or location restrictions | Check product status and location assignments |
| Calculation discrepancies persist | System configuration or data integrity issues | Contact system administrator for deeper investigation |
12. Reporting and Analysis #
- Inventory Valuation – Calculate total inventory value across all products and locations.
- Stock Movement Analysis – Track product velocity and identify fast/slow-moving items.
- Discrepancy Reporting – Monitor frequency and patterns of stock calculation errors.
- Location Performance – Compare inventory accuracy across different restaurant branches.
- Production Efficiency – Analyze ingredient usage patterns for recipe optimization.
- Reorder Planning – Use current stock levels to plan procurement activities.
13. Integration with Other Systems #
Important: Stock fixes affect multiple system components. Ensure all integrations are functioning properly before performing bulk operations.
- POS Integration – Fixed stock levels immediately update product availability in point-of-sale systems.
- Accounting Integration – Stock corrections affect inventory valuation and cost of goods sold calculations.
- Production Planning – Updated ingredient levels impact production scheduling and recipe availability.
- Procurement Systems – Current stock levels influence automatic reorder points and purchase recommendations.
- Reporting Systems – Corrected inventory data feeds into financial and operational reports.
14. Done! 🎉 #
You can now effectively monitor and manage product stock details across all locations, identify and fix inventory discrepancies, and maintain accurate inventory records for optimal restaurant operations!
