Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

CRM
e-Commerce
Księgowość
Zapasy
PoS
Projekt
MRP

All apps

Wszystkie posty Osoby Odznaki

Tagi (Zobacz wszystko)

odoo accounting v14 pos v15

O tym forum

Pomoc

EAV product attributes

product orm odooV8

2 Odpowiedzi

5717 Widoki

Sandor Dobi

Hi,

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

Luke Branch

@Sandor,

Have you seen this module in OCA?:

https://github.com/OCA/product-attribute/tree/8.0/__unported__/product_categ_attributes

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

Sandor Dobi

Autor

Hi,

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 :(

Luke Branch

@Sandor,

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.

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

Stwórz konto dzisiaj, aby cieszyć się ekskluzywnymi funkcjami i wchodzić w interakcje z naszą wspaniałą społecznością!

Zarejestruj się

Powiązane posty	Odpowiedzi	Widoki
Access one2many list in many2one onchange event orm odooV8	7 paź 17	13872
Declare onchange method inside old API inherited model orm odooV8	2 kwi 16	7655
how to use ORM methods in odoo v8.0 with efficient? Rozwiązane orm odooV8	3 mar 15	5179
How to get product quantity Rozwiązane stock warehouse product orm odooV8	4 mar 22	34040
link between stock.location and product.product Rozwiązane product stock_location odooV8	1 wrz 21	5848

To pytanie dostało ostrzeżenie

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