How to Get Odoo Product Cost Price from  SQL Query

by Joining product, template, and company property table

vITraining Admin

to find the product cost price from direct SQL query you need to join it from these tables:

  • product.template

  • product.product


For example:

select, prop.value_float
 from product_template temp
 left join product_product pp on pp.product_tmpl_id =
 left join ir_property prop on prop.res_id = 'product.product,' ||
where = 'Corner Desk'
and prop.company_id=1

Need more Odoo advanced techniques ?

Check my Udemy courses:

Or visit our website for courses and other interesting stuffs: