Rate of Sale & Stock-Out Forecast
Predict Stock-Outs with Real-Time 30/60-Day Sales Velocity & Automated Risk Alerts
Stop relying on static reordering rules or guessing inventory turnover in Excel.
Automatically calculate daily sales velocity per warehouse, forecast days remaining before stock-outs, and get automated risk warnings directly inside Odoo Inventory.
Prevent Revenue Loss From Unexpected Stock-Outs
Static reorder points fail when demand fluctuates rapidly, leading to stock-outs of best-sellers or capital locked in slow-moving items. This module continuously analyzes actual customer outgoing stock moves (net of returns) over 30 and 60-day windows. It categorizes products into Critical, Warning, Healthy, or Out of Stock risk levels so replenishment teams can reorder proactively.
Comprehensive Inventory Forecasting Features
An automated analytics framework ensuring multi-warehouse accuracy, flexible recomputation, and early replenishment warnings.
Dual-Window Sales Velocity
Calculates both 30-day and 60-day average daily sales velocity per warehouse. Includes automated net calculations by subtracting customer returns from outgoing stock moves.
Automatic Risk Classification
Categorizes every product/warehouse pair into Critical, Warning, Healthy, Out of Stock, or No Sales Data based on per-company threshold settings (e.g. 21-day Warning, 7-day Critical).
Daily Cron & Manual Wizard
Runs a daily background scheduled action to keep all forecasts updated. Includes a manual wizard to recompute on demand for specific warehouses or product lines.
Pivot, Graph & Smart Buttons
Direct integration with Product Template forms via a smart button. Offers interactive Pivot, Graph, and List views for supply chain analysts and inventory managers.
Rate of Sale Calculation Engine
Explicit stock move filtering ensures precise financial and operational metrics.
Stock Move Formula
| Metric Step | Calculation Logic |
|---|---|
| Outgoing Qty | Done moves (Warehouse â Customer) |
| Return Qty | Done moves (Customer â Warehouse) |
| Net Quantity Sold | Outgoing Qty â Return Qty |
Stock-Out Forecast Formula
| Forecast Field | Calculation Logic |
|---|---|
| Rate of Sale (ROS) | Net Quantity ÷ Period (30 or 60 Days) |
| Days to Stock-Out | On Hand Quantity ÷ ROS |
| Estimated Date | Today + Forecast Days |
Operational Setup Guide
| 1. | Navigate to Inventory â Configuration â Settings â Rate of Sale Forecast and adjust Warning/Critical thresholds (default 21 and 7 days). |
| 2. | Run an initial computation via Inventory â Rate of Sale Forecast â Compute Rate of Sale or let the daily cron trigger automatically. |
| 3. | Review risk states under Inventory â Rate of Sale Forecast â Forecast Report and filter by Critical or Warning items. |
| 4. | Access individual product forecasts instantly using the Rate of Sale smart button on any Product form. |
User Interface Walkthrough
Clear reporting, configurable settings, and intuitive smart buttons inside standard Odoo Inventory.
Future Development Roadmap
- Automated email/activity alerts sent to purchasing managers when items drop into Critical status.
- One-click automated Purchase Order creation pre-filled with suggested replenishment quantities.
- Customizable calculation windows (e.g., 7-day, 14-day, or 90-day seasonal trend analysis).
Odoo Proprietary License v1.0 This software and associated files (the "Software") may only be used (executed, modified, executed after modifications) if you have purchased a valid license from the authors, typically via Odoo Apps, or if you have received a written agreement from the authors of the Software (see the COPYRIGHT file). You may develop Odoo modules that use the Software as a library (typically by depending on it, importing it and using its resources), but without copying any source code or material from the Software. You may distribute those modules under the license of your choice, provided that this license is compatible with the terms of the Odoo Proprietary License (For example: LGPL, MIT, or proprietary licenses similar to this one). It is forbidden to publish, distribute, sublicense, or sell copies of the Software or modified copies of the Software. The above copyright notice and this permission notice must be included in all copies or substantial portions of the Software. THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
Please log in to comment on this module