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

  • ir.property


For example:


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


Need more Odoo advanced techniques ?

Check my Udemy courses: http://udemy.com/user/akhmaddaniel

Or visit our website for courses and other interesting stuffs: http://vitraining.com


 DO NOT CLICK THIS https://bit.ly/3biXWMc

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

Visit YouTube Channel http://youtube.com/odooindonesia

Untuk trik Odoo lainnya bisa cek Udemy courses http://udemy.com/user/akhmaddaniel

Visit official site http://vitraining.com

One Touch and Go Live with Odoo http://1toucherp.com

Twitter http://Twitter.com/akhdaniel 

Check our blog: http://indonesia.odoo.com


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
Archive
Sign in to leave a comment
How to Add Statistic Buttons on Odoo Form?