Odoo Help


How to change all products income account?

Jim Biergans
on 10/8/13, 10:32 PM 2,133 views

I want to change all of my products assigned income account to a different income account. Is there a way to do this in OpenERP for all existing products? There are several thousand products, and I don't want to go through each one manually.


Hi ,

you can use mass editing module , here is the detail , http://www.youtube.com/watch?v=9BH0o74A748

and all the useful module can be found here, https://code.launchpad.net/~server-env-tools-core-editors/server-env-tools/7.0

and for your case , after you check out the youtube , you can set up your mass edit configuration by selecting either the product.product or product.template , please look for the field , incoming account , then you should be able to do the changes.

hope that helps.

thank you! but i ran into 2 problems: 1. there's no "incoming account" field in either product table. 2. after adding the sidebar button, when i switch over to products, mass editing doesn't appear in the dropdown list, just share, embed, etc. (i used incoming_qty to test, saved it, etc.) i must have missed something...?

Jim Biergans
on 10/9/13, 5:58 PM

those informations are stored in the ir_property table. For product income account, look for "property income account" in name column and the column "res_id" for the product id, and "value_reference" for the reference to the account.

on 10/10/13, 6:00 PM

got it working. thanks! big help!

Jim Biergans
on 11/14/13, 4:06 PM

Hi, I am facing the same issue, the mass editing does not appear in the drop-down list for product module.could you elaborate more on how you fixed your issue. Appreciate it a lot :)

Elie H. Nassif
on 2/18/14, 7:16 AM

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

0 follower(s)


Asked: 10/8/13, 10:32 PM
Seen: 2133 times
Last updated: 3/16/15, 8:10 AM