I have multiple Vendors for several Products.
I would like Odoo to automatically select the Vendor with the cheapest price (the prices change each month) when generating an RFQ (draft Purchase Order).
Is this possible.
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Accounting
- Inventory
- PoS
- Project
- MRP
This question has been flagged
5
Replies
14331
Views
Hi all,
I converted this to an automated action that works in v17.
My code:
def sort_seller_ids(self):
for rec in self:
seller_ids = self.env['product.supplierinfo'].search([('product_tmpl_id', 'in', [rec.product_tmpl_id.id])])
rec.product_tmpl_id.message_post(body=f'seller_ids: {seller_ids}')
seller_prices = {}
for seller in seller_ids:
# seller's ID --> key and their price --> value
seller_prices[seller.id] = seller.price
# Sort the dictionary by price in ascending order
sorted_seller_ids = sorted(seller_prices, key=seller_prices.get, reverse=False)
# Update the sequence of seller_ids based on the sorted order
for sequence, seller_id in enumerate(sorted_seller_ids, start=1):
seller = seller_ids.filtered_domain([('id', '=', seller_id)])
if seller:
seller.write({'sequence': sequence})
sort_seller_ids(record)
Removing the drag handles is not obligatory, but they have no funcionality anymore.
Best,
Friedrich
Hi Friedrich - I'm not a Python programmer, but from my testing it seems as if this is putting the highest price first. Also, is there any way to make this work as a Server Action (to do a mass update)?
Hi Chris, you are right! I changed the code.
Putting this in a server action can work. you need to go through all products and use the action on its order lines. in serveractions with model product.template use something like:
def sort_seller_lines_for_all_products(self):
for product in records:
seller_ids = product.seller_ids
seller_prices = {}
for seller in seller_ids:
# seller's ID --> key and their price --> value
seller_prices[seller.id] = seller.price
# Sort the dictionary by price in ascending order
sorted_seller_ids = sorted(seller_prices, key=seller_prices.get, reverse=False)
# Update the sequence of seller_ids based on the sorted order
for sequence, seller_id in enumerate(sorted_seller_ids, start=1):
seller = seller_ids.filtered_domain([('id', '=', seller_id)])
if seller:
seller.write({'sequence': sequence})
sort_seller_lines_for_all_products(records)
You can add this as an "contextual action" so that is is available under the action wheel in the products view. (I have not tested this code btw)
Best,
Friedrich
Note: Right Click the images below and select VIEW IMAGE / OPEN IMAGE IN A NEW TAB to see larger versions.
Yes.
Odoo uses the first Vendor in the list by default.
To have it choose the cheapest, the easiest way is to sort the list by price each time it is edited. You will also have to remove the drag handle from the list to stop users re-sorting the list.
1. Create an Automated Action that makes sure the list of is always sorted after any edits (also works if you change prices from the Vendor Pricelist menu).
2. Remove the drag handle by creating your own view that inherits and overrides the default:
is this working on Odoo 15.0? I am using Odoo Cloud by Odoo. I tried this ccode, it seem no working. I just follow the first step.
Is there a way to stop Odoo to pick the cheapest price? It's handy when there are several vendors for one product. However, when there is only one supplier and prices increase every year, this function does not make sense. It's really difficult to remove old prices one by one when there is a huge number of products in the system.
Just a thought...
Did you try to work with the start and end dates of the price?
Another approach would be to add a custom boolean field "current_price". Export the whole list (updatable) and set current_price to 0. Add your new records with the current_price = 1.
Now all you need is the add this field in the sort somehow, perhaps a Python specialist can help with that.
You can try "end date" when you add the price.
In odoo 13 CE is not possible sort suppliers list from product template, changes will not be saved.
It's possible sort suppliers list from product.supplierlist, changes will be saved.
Can anyone adapt code descripted in this post, for use it in template product.supplierinfo
Below original code:
if record.seller_ids: record['seller_ids'] = record.seller_ids.sorted(key = lambda s: s.price)
Thanks
Make sure base_automation "Automated Action Rules" is installed and visit the Automated Actions menu.
Hi Ray, thanks for your help. I've do it some days ago, and it work. I've do step 1 only (1. Create an Automated Action) and not step 2. (2. Remove the drag handle). But if I change manually a supplier price, in product template, It not reoder automatic supplier list. Maybe I must to do step 2, for work well? Thanks
Hi, I'm using odoo 13 community, not work! I've do it, both modifies, but not sort supplier list by price.
I think there may be an extra step. As well as removing the "drag handle", existing records on product.supplierinfo need to be updated so that the sequence is 1 (otherwise this overrides the sort done in the Automated Action)
Hi Chris, can you write more details to do, I'm not a developer and I don't know how do. Could you write what I must do? Thanks
Here's a step-by-step guide: https://odootricks.tips/automatically-select-lowest-price-vendor/
Hi Chris, thanks for guide. I've try, and suppliers are sorted by price. But I've look that suppliers are sorted by min_qty first , and by price after. If I have some suppliers with high min_qty and more expensive, they will be sorted before others more cheap end with low min_qty. I don't know if is this correct action, but I needed sort by price first , and by min_qty secondary. Any idea?
I'm not a Python programmer, but a bit of quick research reveals that you can add a second field to the sort:
if record.seller_ids:
record['seller_ids'] = record.seller_ids.sorted(key = lambda s: (s.price,s.min_qty))
Hi Chris I don't know why, but not work anyway. It is sorted by min_qty before, always. Thank you very much. If anyone have any others solution is appreciated, thanks
would this work if you updated by import (i dont think it would)
Yes. Create and Update are triggered with data imports, and I tested this particular automation.
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 | |
|---|---|---|---|---|
|
0
Sep 23
|
3229 | ||
|
1
Jun 23
|
243 | ||
|
1
Dec 22
|
4673 | ||
|
1
Oct 22
|
2949 | ||
|
Sales Unit Price
Solved
|
|
1
Jan 22
|
3126 |
