Although we do have features such as the Replenishment tool (v14) and Reordering Rules, some users require to have an automatic (live) notification of when a product (or certain products) go below a certain stock level.
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Accounting
- Inventory
- PoS
- Project management
- MRP
This question has been flagged
2
Replies
6717
Views
2. Go to product.product, form view.
3. Create a new field type float (using Studio).
4. Access the field properties:
5. On the fields “Related Field” and “Dependencies, add “qty_available”. Make sure to mark the field as “Stored”.
6. Go to Server Actions and create this server action:
The field “x_studio_quantity_on_hand_stored” is the new float field created. Make sure to adapt this to your field name.
for record in records:
qty = record['qty_available']
record['x_studio_quantity_on_hand_stored'] = qty
7.
Go to product.product list viewand add filter the list by “Product Type: Storable Product”8. Select all the products
9. Go to Actionsand execute the server action just created:
This server action will compute the field “On Hand Quantity” into the new field you just created.
10. Go back to the Server Actions menu and DELETE THE SERVER ACTION.
11. Go to Email Templatesand create a new email template which the user will receive when the stock level is low. For example:
12. Go to Automated Actionsand create a new automated action. Model: “Product, Trigger: “On Update”, Action to Do: “Send Email”, Email Template: the email template you just created.
Before Update Domain: Quantity on Hand (stored) Quantity on Hand (stored) [THIS SHOULD BE THE FIELD YOU CREATED >= ”threshold number”
Before Update Domain: Quantity on Hand (stored) Quantity on Hand (stored) [THIS SHOULD BE THE FIELD YOU CREATED >= ”threshold number”
Apply On: Quantity on Hand (stored) [THIS SHOULD BE THE FIELD YOU CREATED] < “threshold number”
Click on the 3 dots icon on the right side of the window:
Select the product IDs that you’d like to apply that threshold with a “Any” condition:
Ideally, you’ll add all the product IDs of the products that meet the same threshold for low stock level.
If you need to add more than one threshold, create a new automated action with the same parameters, but changing the threshold. Be careful with creating too many automated actions.
13. Once the product quantity goes below the threshold, the user that you defined on your email template will receive the email.
We want to use this mechanism, except for us it's not (as much) about quantity on-hand. We have a virtual warehouse that is the default warehouse for web orders, and we only keep a certain amount of stock in that warehouse. We're wanting to notify the right personnel that they need to do a stock move/internal transfer (from main warehouse to web warehouse). We don't want the stock move to be automatic because most of our stock (non-web sales orders) is B2B (to distributors). Web orders is direct to public but priority for stock is given to distribution, so they need to make a situational decision about how much stock to make available to the public.
Hi, Lucas,
if you are looking for automatic emails when stock levels are low, you can take a look at this application:
Low Stock Alert It is recommended that you customize the application to suit your business requirements.
Enjoying the discussion? Don't just read, join in!
Create an account today to enjoy exclusive features and engage with our awesome community!
Sign up| Related Posts | Replies | Views | Activity | |
|---|---|---|---|---|
|
2
Mar 23
|
5923 | ||
|
3
Dec 24
|
15078 | ||
|
2
Apr 23
|
1805 | ||
|
|
1
Aug 24
|
2233 | ||
|
Bank reconciliation methods
Solved
|
|
1
Mar 24
|
5312 |
