Odoo Help


How to change the cost method for each product with one SQL query?

Pascal Tremblay
on 3/10/16, 8:13 AM 1,116 views

Hello guys,

The field « cost method » of the product.template is a « selection » field. 

Once again, I don't find where are stored the value of this field in the database. So, I can't make a SQL query to change all the cost method of all the products from « standard price » to « average ».

Could you guide me please?

Maxime Chambreuil
On 3/10/16, 12:17 PM

Have a look at the mass_editing module ;) It is not recommended to bypass the ORM.

never touch this mass_editing module. Will have a look. Thanks mister.

Pascal Tremblay
on 3/10/16, 12:25 PM

absolutely great module! Thanks again.

Pascal Tremblay
on 3/10/16, 12:34 PM

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: 3/10/16, 8:13 AM
Seen: 1116 times
Last updated: 3/10/16, 12:34 PM