Odoo Help


Add pricelist item reference to product in fronted.

Alessandro D'Armiento
on 6/20/16, 5:35 AM 890 views


Given the product.template table with a line for each of all the products, and the product.pricelist.item table with, for each pricelist version, for each pricelist, a line for each product in that pricelist version. 

I have to access in the front-end to ALL information of "that" line in the product.pricelist.item which is referring to "that" product (same product_id) in the product.template table.

Imagine other fields like the price surchage that i have to access for each product and display in the front-end.

I currently implemented a ultra-bad, debug only function in the backend which retrieve the whole product.pricelist.item table, and the frontend makes the join to find out these information.

This is (off course) performance killing and insecure and a real mess.

Do anyone of you know a way to make the join in the backend, serverside, and retrive the information in a form accessible in the front-end with something like product.item.myInformation?

thank you

Juan Vicente Pascual
On 6/20/16, 6:25 AM

try module product_pricelist

Kind regards,

Hello, the module is already present. Therefore I do not have access to every field I need since the price is computed by a dedicated method which (I guess) uses only base_price, price_surcharce and price_discount. And other fields are not available at all.

Alessandro D'Armiento
on 6/20/16, 8:37 AM

About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

1 follower(s)


Asked: 6/20/16, 5:35 AM
Seen: 890 times
Last updated: 6/20/16, 6:25 AM