Odoo Help


EAV product attributes

Sandor Dobi
on 3/19/15, 12:01 PM 1,124 views


I would like to add custom product category specific attributes to products. It would be very similar to an EAV system, but I DON'T need this for Magento Integration. It is for custom parametric searches in products.

For this i need a rather fast or optimized searchable EAV extension to product table. I looking first to the JSONB field in the postgresql backend because it is a primary candidate for such feature.
Is there any possibility to implement this using the Odoo v8 ORM framework (even when for this one needs to use raw SQL queries) ?

If not. Is there any tips or clues how to implement a product category tied attribute set definition, which can be effectively used to parametric product searches?

Thanks a lot



Have you seen this module in OCA?:


I think some of the modules that are currently in the __unported__ folder in that (product-attribute) repository may be of interest to you.

Luke Branch
on 3/20/15, 12:48 PM
Sandor Dobi
On 3/22/15, 6:46 PM


Thanks. I'll check this tomorrow and see how it can used.

I have a hope when i checked the product modell because there is some limited attribute child table.

But it is used only for product variants :(


I'll be taking a look at this in more detail myself over next weekend. I think it should handle the default product variant (ie. what you see in product.template before any variants have been created), so this should be workable.

I'll post back here with what I find when I have time.

Luke Branch
on 3/22/15, 10:10 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

2 follower(s)


Asked: 3/19/15, 12:01 PM
Seen: 1124 times
Last updated: 3/22/15, 6:46 PM