Odoo Help


This community 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.


Add pricelist item reference to product in fronted.

Alessandro D'Armiento
on 6/20/16, 5:35 AM 231 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

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

1 follower(s)


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