How to Get Odoo Product Cost Price from  SQL Query

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:


Videos fill be uploaded regularly, so subscribe our youtube Channel.

Visit YouTube Channel

Untuk trik Odoo lainnya bisa cek Udemy courses

Visit official site

One Touch and Go Live with Odoo


Check our blog:

accounting,belajar erp,belajar odoo,business software,cloud computing,crm,dunia erp,enterprise resource planning,erp,erp software,erp system,event,inventory,it,it erp,mrp,odoo,odoo 11,odoo consultant indonesia,odoo erp,odoo indonesia,odoo tutorial bahasa indonesia,odoo tutorial indonesia,openerp,point of sales,pos,purchase,software as a service,tinyerp,tutorial odoo,tutorial odoo indonesia,odoo indonesia week,odoo indonesia payroll,odoo 13 indonesia
How to Get Odoo Product Cost Price from  SQL Query
vitraining, odoo indonesia
16 May, 2020
Share this post
Sign in to leave a comment
How to Add Statistic Buttons on Odoo Form?