Odoo Help


How to set or update fields.function value of existing data ?

Jeudy Nicolas
on 4/5/13, 12:09 PM 12,516 views


I just add a fields.function(_myfunc, .... , store=True) on one OpenERP V7 model. This instance allready has some value in database.

How can I force openERP to compute the value for this field ? New data are ok (set when write method is launch) but for existing one nothing ...!


If a change store=True with store=False, my data are ok, but I need to add this field on search filters.

thanks for your help,


I recently came across this kind of problem (needed to update computed values) and I created a module to add 2 methods to the ORM (compute and compute_all).

You can find it here if you want, and if you ever get a chance to test if on Odoo 8+, let me know (I'm using OpenERP 7.0)


Hope this helps.

Thanks Henri! It works for v8 in my case!

on 10/30/15, 10:01 AM
Antonio Antiun
On 6/2/15, 6:24 PM

You could remove the column from database, for example, for field 'margin' at sale.order model you could execute next SQL with psql:

your_database=> alter table sale_order drop column if exists margin;

Then update the addon in Configuration > Local modules

If you look at Odoo log file you will see one line like:

openerp.models: Storing computed values of sale.order fields margin

Ray Carnes
On 4/5/13, 9:42 PM

Export the model records, then import them.

This will trigger the write and the values for the functional field will be computed and stored.

If I trigger a write method all my value will be updated ?

Tuxservices, Jeudy Nicolas
on 4/6/13, 5:42 AM

Hy, is this the only way to do this? Isn't it possible to generate a write trigger during installation process?

Mind & Go, Mind And Go
on 6/11/13, 7:05 PM

The best answer I found is here : http://forum.openerp.com/forum/topic30196.html

Mind & Go, Mind And Go
on 6/11/13, 7:46 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: 4/5/13, 12:09 PM
Seen: 12516 times
Last updated: 6/2/15, 6:24 PM