How to use JSON fields in Odoo.
JSON fields allow you to store structured and flexible data inside a single field. They are useful when data does not have a fixed schema or changes frequently.
✅ JSON Field Definition
from odoo import fields, models
class ProductTemplate(models.Model):
_inherit = ‘product.template’
extra_info = fields.Json(string=”Extra Information“)
Storing Data in JSON Field
product.extra_info = {
‘color’: ‘Red’,
‘weight’: 10,
‘is_fragile’: True
}
reading JSON Data
color = product.extra_info.get(‘color’)
✅ Use Cases
Use JSON fields only when relational fields are not suitable. JSON data is harder to search and index.
