Odoo Help

Welcome!

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.

0

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

By
Pascal Tremblay
on 3/10/16, 8:13 AM 484 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?

1
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

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)

Stats

Asked: 3/10/16, 8:13 AM
Seen: 484 times
Last updated: 3/10/16, 12:34 PM