Odoo Help


Property fields Storage in Database

Sai kumar
on 6/8/16, 9:21 AM 969 views

HI friends,

Can anyone help me in knowing, where are the property fields stored in Postgres Database. I want to use the data existing in the property field. But, No where I can see that field is stored in DB.

I want to use the values in "property_cost_method" field in "product_category" model.



Prakash Sharma

--Prakash Sharma--
--Prakash Sharma--

I like to surround myself with brave, creative people.

My motivation for learning different technologies and algos drive me. I love challenges of a steep learning curve which I believe makes me a better learner. I have a strong desire to learn different technologies, which would enable me to become a full stack developer.

Prakash Sharma
On 6/8/16, 12:27 PM

check ir_property  table 

It may happens that there is no record in ir_property. As I understand, each time a property is updated, Odoo first deletes the record, and then recreates it only if the value is not the default one.

Jérôme Thériault
on 5/15/17, 11:49 AM
Sai kumar
On 6/9/16, 3:09 AM

Hi Prakash Sharma,

Thanks for your interest . I have three values in property_cost_method field : 'Average price', 'Standard price', 'Real price' of "product_category" model . I checked in ir_property  table for these values, but I din't find any of these values.

Can you guide me where are these values stored in DB.


How to import data into property field in multiple companies at the same time. Like; I want to set stock input account on 100 product categories for 5 companies where each company has a different account for stock input field.

Dexciss Technology Pvt Ltd, Apoorv Soral
on 4/5/17, 4:00 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: 6/8/16, 9:21 AM
Seen: 969 times
Last updated: 5/15/17, 11:28 AM