İçereği Atla
Menü
Bu soru işaretlendi
3 Cevaplar
2469 Görünümler

Can I get the cheapest price for a product (e.g. book) quoted by different vendors using lambda or any other alternative

store maybe somewhere showing vendor x was the cheapest for product book.


I have tried searching for an answer in Odoo community but with fail.

I will appreciate any help. I'm really stuck.

Avatar
Vazgeç
En İyi Yanıt

Hello, Leonard. Shivoham's answer can serve as an suggestion for you. I have another way. Isn't your goal to discover the cheapest product? Assume you have attributes 'name,' 'price,' and 'vendor id' in the model 'product.'
You can 'group_by' all of its records by name, and see which record has the lowest 'price.'
You'll know which vendor provides that product thanks to the field 'vendor id.'

Avatar
Vazgeç
Üretici En İyi Yanıt

Thanks for the response Shivoham,

I have tried many for loops but they seem not work.

The below code is what I was trying to do.

def compute_cheapest(self):
for rec in self:
partner = rec.env['purchase.order'].search([('partner_id', '=', rec.partner_id.id)])
for each_partner in partner:
line = each_partner.order_line
for item in line:
if item.product_id._________________:


item.write({'quality': True})
else:
item.write({'quality': False})

The place where I have put the dash is where I am stuck. How can I search in every vendor's oder_line and find similar products quoted by them. The cheapest price for that product I do the last code which I have written:

NB: I have set field quality to Boolean that's why in the end I am writting "True" or "False"

....
item.write({'quality': True})
else: item.write({'quality': False})

Or is there a better way to do it

Avatar
Vazgeç
En İyi Yanıt

Hello Leonard, 

You have to use loop in product vendor's list and take the minimum price from that and set it to order line. 

Avatar
Vazgeç
İlgili Gönderiler Cevaplar Görünümler Aktivite
3
Nis 22
26342
1
Ara 19
3322
0
Ara 23
1300
1
Şub 21
3960
Odoo Features Çözüldü
6
Ara 23
18727