Odoo Help


This community 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.


EAV product attributes

Sandor Dobi
on 3/19/15, 12:01 PM 593 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

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

2 follower(s)


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