This question has been flagged
2 Replies
5278 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.

Thanks.

Avatar
Discard
Best Answer

check ir_property  table 

Avatar
Discard

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.

Author Best Answer

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.

Thanks.

Avatar
Discard

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.