Where is standard_price stored in Odoo 18?

Question

In previous versions of Odoo, the standard_price was stored as an ir.property. However, in Odoo 18, I can see the field in product.product, but it always returns 0.00.
Does anyone know where this field is now managed or stored? I use it frequently for production-related calculations.
I generate reports using SQL queries, not the ORM, so solutions based on the ORM won’t be very useful for my case.
Any insights would be greatly appreciated!

Ray Carnes (ray) · Accepted Answer

The values of company-dependent fields are now stored in a JSON column on the record instead of separately via the *ir.property *model.
The standard_price field is still where we store the price, but the JSON value is a dict *{company_id: value}* mapping company ids to the field's value.
image [2]
This represents a price of $1.23 for company 1.
See  https://github.com/odoo/odoo/pull/175627 [1]
The Company Properties Menu has been removed, since the ir.property model is no longer part of Odoo 18.

Powiązane posty	Odpowiedzi	Widoki
My Custom Module don't show in apps list after update development	2 sie 25	192
Training Odoo development in Belgium development	0 sie 25	299
odoo18 ValueError: Wrong value for ir.ui.view.type: 'tree' in Docker Rozwiązane development	1 sie 25	686
Change position chatter Rozwiązane development	1 sie 25	534
Fields defined as char take up way to much space in list view development	4 lip 25	1904

To pytanie dostało ostrzeżenie

Podoba Ci się ta dyskusja? Dołącz do niej!