Smart Inventory Control, Valuations & Restock Intelligence
Real-time stock valuation, 30-day sales velocity burn rates, automated PO reorder planner, and enterprise audit logging
The Dedicated Inventory Hub (`/products/inventory`)
Effective stock management is the lifeblood of profitable e-commerce. Running out of best-selling products forfeits revenue and damages customer trust, while tying up excess operating capital in stagnant, slow-moving inventory constrains operational cash flow.
Teyweb features a dedicated, high-performance Inventory Management & Stock Control Hub accessible via Products > Inventory (`/products/inventory`) in your merchant dashboard. The hub unifies all catalog items—both simple single-SKU listings and complex multi-variant matrices (Size, Color, Material)—into an interactive control grid equipped with live stock statuses, sales burn rates, financial metrics, and bulk management controls.
Key Takeaways
- Unified Catalog Grid: Inspect stock levels across standalone products and nested variant options simultaneously.
- Inline Instant Adjustments: Tap (+) or (-) spinners or enter numbers directly to update stock with optimistic UI updates and instant toast confirmation.
- Smart Color-Coded Statuses: Instantly identify Healthy, Low Stock, Critical Runway, Out of Stock, Overstocked, and Dead Stock items.
- Zero-Lag Telemetry: Queries actual customer checkout deductions and restored returns in real time.
Real-Time Inventory Valuations & Health Score
At the top of your Inventory Hub, an executive financial summary bar automatically calculates your store's current asset posture:
1. Total Stock Units: Total count of physically available units across your active and archived catalog.
2. Retail Inventory Value: The gross sales valuation of your inventory if sold at current listing prices in your base store currency (e.g., ₦12,450,000).
3. Capital Invested (COGS): The actual wholesale acquisition cost of your available stock based on your configured Cost Prices (e.g., ₦7,200,000).
4. Projected Gross Margin: The total gross profit you will capture once current inventory is sold (e.g., ₦5,250,000 / 42.1% margin).
5. Inventory Health Score (0-100%): An automated algorithmic benchmark that evaluates store stock availability, low-stock risk concentration, out-of-stock frequency, and the percentage of capital trapped in dormant merchandise.
30-Day Sales Velocity & Runway Forecasting
Rather than guessing when to place replenishment orders with suppliers, Teyweb's forecasting engine analyzes actual customer order fulfillment data over the trailing 30 days to compute your Daily Sales Velocity (units sold per day):
`Daily Sales Velocity = Total Units Sold (Past 30 Days) / 30`
Dividing your current available stock by this burn rate yields your estimated Days of Stock Remaining (Runway):
| Runway Status | Criteria & Threshold | Operational Risk & Recommended Action |
|---|---|---|
| 🔥 Critical Runway | <= 3 days of stock remaining | Extreme sellout danger. Product will stock out within 72 hours. Trigger an emergency purchase order immediately. |
| ⚠️ Low Stock Warning | 4 to 14 days of stock (or below store threshold) | Impending stockout. Prepare purchase order and contact suppliers for scheduled replenishment. |
| 🟢 Healthy Runway | 15 to 90 days of stock remaining | Balanced stock turnover. Working capital is utilized efficiently without stockout risk. |
| 📦 Overstocked | > 90 days of stock with high units | Excess capital allocation. Consider running discount promotions, bundles, or marketing broadcasts to unlock liquidity. |
| 💤 Dead Stock | >= 30 days old with 0 sales in past 60 days | Stagnant inventory. Review listing images, adjust retail price, bundle with cash cows, or liquidate. |
The Automated Restock Planner & Purchase Order Sheet
Planning purchase orders across dozens of vendors and hundreds of variants is typically time-consuming. Teyweb completely automates this workflow through the intelligent Restock Planner modal:
- Click the "Restock Planner" button at the top of the Inventory Hub.
- The planner automatically isolates all products that have breached your store's Low Stock Threshold or will run out of stock within 30 days based on their sales velocity.
- Target Buffer Calculation: The system automatically calculates the exact recommended reorder units needed to maintain a comfortable 30-day operational safety buffer (`Target Buffer = Daily Velocity * 30 - Current Stock`).
- Customizable Reorder Units: You can inspect each item, review wholesale cost estimates, and manually tweak proposed quantities.
- Download Vendor-Ready PO Sheet: Click "Download PO Sheet" to generate a formatted Microsoft Excel (`.xlsx`) purchase order spreadsheet complete with Item Names, SKUs, Barcodes, Cost Prices, and Ordered Quantities ready to email directly to your factory or distributor.
Inline Optimistic Stock Spinners & Floating Bulk Action Bar
Updating stock in Teyweb requires zero tedious page reloads or deep navigation:
1. Inline Quick Spinners: Directly in the inventory table, use the (+) and (-) stepper buttons to increment or decrement stock by 1, or click the number to type an exact stock quantity. Updates commit to the database with optimistic UI feedback and toast confirmation.
2. Floating Bulk Action Bar: When receiving a multi-item shipment or performing a stocktake, select multiple items using the table checkboxes. A floating action bar appears at the bottom of your screen with powerful mass actions:
Key Takeaways
- Add Stock (+X): Add a specific number of received units across all selected items simultaneously.
- Reduce Stock (-X): Deduct inventory units across selected items for shrinkage, store damage, or write-offs.
- Set Exact Stock: Override stock quantities across all selected products to a specific target number.
- Mark as Out of Stock: Set selected items to 0 units with a single click, immediately updating storefront product pages.
Enterprise Stock Movement Audit Log (`InventoryLog`)
Accountability and shrinkage prevention require transparent audit trails. Every single stock change that occurs in your store is recorded in Teyweb's immutable `InventoryLog` database ledger.
Click the "Audit Log" button in the Inventory Hub to open the enterprise activity drawer, featuring chronological records with:
| Audit Field | What It Records | Example Value |
|---|---|---|
| Timestamp | Exact date and time of the inventory change | Oct 17, 2026, 09:24 PM |
| Product & Variant | Item title, SKU, and variant option attributes | Silk Evening Dress (SKU: SED-BLK-M) |
| Change Delta | Previous stock level, new stock level, and net change | 12 -> 25 (+13 units) |
| Adjustment Reason | Categorized operational cause of the adjustment | Shipment Received, Customer Checkout, Return Restored, Damage Write-off, Physical Count |
| Operator / Actor | User identity or automated system process | Merchant Admin (theophilus@...), Customer Order #ORD-1082 |
| Operational Notes | Optional merchant explanation or supplier invoice reference | "Received shipment from Vendor A - Invoice #4402" |
Multi-Status Filtering & 1-Click Spreadsheet Exports
Teyweb makes it easy to segment and export your inventory for accounting and logistics:
- Stock Status Filter Tabs: Switch effortlessly between All, Healthy, Low Stock, Critical Runway, Out of Stock, Overstocked, and Dead Stock.
- Category & Text Search: Filter by department or search instantaneously by Product Title, SKU, or Barcode.
- 1-Click Spreadsheet Exports: Click "Export Inventory" to download a complete inventory valuation report in formatted Microsoft Excel (`.xlsx`) or RFC 4180 CSV (`.csv`), complete with retail valuations, cost investments, and days of runway.
Low Stock Threshold & Global Inventory Settings
By default, Teyweb flags products as "Low Stock" when inventory falls to 5 units or below. You can customize this threshold in Store Settings to match your business fulfillment cycle (e.g., setting it to 10 for fast-turnover fashion, or 2 for high-ticket luxury electronics).
When any product or variant drops below your configured threshold, Teyweb updates the inventory status badges, highlights the item in the Restock Planner, and triggers an automated notification in your merchant dashboard.
Was this guide helpful?
Help us improve our merchant documentation by sharing your feedback.