Automatically alerts when products are low in stock

This alert notifies you when product stock levels fall below the minimum threshold defined for each product. It helps ensure timely reordering and avoids stockouts, keeping your inventory under control

Process Overview:

1. Minimum Quantity Setup:

Each product has a Minimum Quantity (Min Qty) field. This value defines the lowest acceptable stock level for that product

2. Settings Configuration:

In the Settings, there is an option to enable the Minimum Quantity feature. Once activated, the Min Qty field becomes visible on the product form view, allowing users to set threshold levels for each product.

3. Scheduled Action (Automation):

A Scheduled Action (Cron Job) runs automatically at defined intervals (e.g., daily). It checks all products and identifies those with quantities below the minimum.

4. Alert Record Creation:

For each low stock product, an entry is created in a custom Low Stock Alert model. These records are stored and displayed in a Tree View under the “Low Stock Alerts” menu.

5. Email Notification:

If one or more products are low in stock, an automated email is sent to the responsible user. The email includes a detailed list of all low stock products in a table format.

6. User-Friendly Menu:

A dedicated Low Stock Alerts menu is added to the Inventory or Custom App. Users can easily view all current low-stock products and take action accordingly.

7. Efficient Inventory Control:

This module helps avoid stockouts, improves inventory visibility, and ensures timely replenishment of products.

Low Stock Alerts Integration

Step 1

When you enable the 'Min Qty' field in the settings, the 'Minimum Stock Qty' field will become visible in the product form view.

Step 2

First, you need to fill in the Minimum Stock Quantity field in the product form.

Step 3

When the Minimum Stock Quantity is greater than the Available Quantity, the scheduled action will run on a daily basis.

Step 4

After the scheduled action runs, an email is sent containing a list of products that are low in stock. Additionally, a new menu named Low Stock Alerts appears under the Stock section in the Reporting menu. This menu opens a tree view that displays all the low stock products listed in the email. Clicking on any product in the tree view will open its corresponding product form view.

Developed by:

Muhammad Umar
Odoo Developer
Email: umar200ak@gmail.com / Github