Where can I find standard_price in postgreSQL table?

Question

By using PgAdmin III, I was able to find list_price in product_template table, but there is no standard_price in any of the tables.
By activating the developer mode in odoo,  standard_price is shown to be under product.template object,
and going to the database structure, under "product_template", there is a "standard_price" field.
The question is, where in PgAdmin, under table product_template, there is no column with the name standard_price? Is the value of this field stored somewhere else？

Temur · Accepted Answer

standard_price is not a normal field, but it's a property field, so it's *values are stored in  ir_property*  table. run this in your PgAdmin:
SELECT id, value_float, name, res_id
FROM ir_property
WHERE name='standard_price';
- here res_id column shows to which "Model, ID" combination the value belongs to.

Bas · Answer

I believe cost_price is stored, but when using real price or average price these are computed values and therefor not stored in the database but computed.

Jignesh Mehta · Answer

Hello Allen Xu,
*standard_price* field of *product.template* class is the *property field* and property field *can't store* in the database.
If in filed, *store=True* then it will *store* but in the product module there is *no define store=True *at field so it *can't be store.*
Thanks,

La domanda è stata contrassegnata

Ti stai godendo la conversazione? Non leggere soltanto, partecipa anche tu!