| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Discuss (mail)
• Inventory (stock) |
| Lines of code | 323 |
| Technical Name |
sf_product_low_stock_notification |
| License | LGPL-3 |
| Website | http://www.squadfoucs.com |
| Versions | 18.0 19.0 |
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Discuss (mail)
• Inventory (stock) |
| Lines of code | 323 |
| Technical Name |
sf_product_low_stock_notification |
| License | LGPL-3 |
| Website | http://www.squadfoucs.com |
| Versions | 18.0 19.0 |
Product Low Stock Notification
Automatically monitor Quantity On Hand and send low stock alert emails to users who have the Low Stock Message Send access right.
Module Highlights
- Adds Minimum Quantity field on product inventory tab.
- Adds menu: Inventory > Configuration > Low Stock Notification.
- Uses stock.quant (internal locations) to calculate current Quantity On Hand.
- Sends alerts through daily cron with no dependency on reorder rules.
- Recipients are picked automatically from users in group Low Stock Message Send.
- Notification email template is configurable from setup form.
How It Works
- Set minimum quantity on each product that you want to monitor.
- Mark users with Low Stock Message Send access right.
- Daily scheduled action runs automatically and checks stock levels.
- When Qty On Hand < Minimum Quantity, module prepares alert lines.
- Configured email template is used and alert is sent to all eligible users.
Step-by-Step Setup & Result
Below screenshots are arranged exactly in implementation flow.
Step 1: Configuration List
Go to Inventory > Configuration > Low Stock Notification and open the default record.
Step 2: Configuration Form
Configure the notification record with these key fields:
- Email Template: Select the template used for low stock alert emails.
- Email Intro Message: Custom content shown before the low stock table.
- Email Footer Message: Custom closing content shown after the low stock table.
This allows business users to personalize alert text from configuration without editing the locked template structure.
Note: Email Intro Message and Email Footer Message are applied only when the selected template is Low Stock Notification.
Step 3: User Access Right
Open user form in Settings > Users and tick Low Stock Message Send. Only users with this group receive alert emails.
Step 4: Set Minimum Quantity (Product Example 1)
In product Inventory tab, define Minimum Quantity for each item.
Step 5: Set Minimum Quantity (Product Example 2)
Same setup on another product to show independent threshold per product.
Step 6: Set Minimum Quantity (Product Example 3)
Third product example to demonstrate low-stock tracking across multiple products.
Step 7: Daily Scheduled Action
In Settings > Technical > Scheduled Actions, cron runs daily and executes: model.cron_check_low_stock_notifications().
Step 8: Email Alert Result
Final low-stock alert email shows product name, reference, Qty On Hand, minimum quantity and UoM.
Technical Behavior (Current Code)
- Configuration model: low.stock.notification.config (one record per company).
- Product field: product.product.minimum_quantity.
- Template helper for single-variant template: product.template.minimum_quantity_display.
- Stock source: stock.quant with location usage internal.
- Monitored products: active consumable products with minimum quantity greater than zero.
- Recipients: active internal users, email present, in company, and assigned to Low Stock Message Send group.
- Email sending is per recipient and uses selected template from configuration.
- Intro and footer message content are managed from configuration HTML fields.
- No reorder rule logic is used anywhere in this module.
Please log in to comment on this module