Filter the Odoo catalog by colour, size or any other attribute

Up to Odoo 18, the Catalog button of a quotation, a purchase order or an invoice opened a product grid with an Attributes section in its side panel. Odoo 19 removed it: only Categories and Tags are left. Catalog Attribute Filter brings it back, without the limits of the old one. Free, for Odoo 19 and 20.

  • Free
  • Odoo 19 · 20
  • Community & Enterprise
  • Odoo.sh

Finding “the red ones in size M” by hand

The catalog is most useful precisely when variants come in the hundreds.

No more Attributes section

In Odoo 19 and 20, the side panel of the catalog only offers Categories and Tags.

One value at a time

You type “red” in the search bar, then “M”, and start again for the next colour.

The old section had its flaws

In Odoo 18, it listed one entry per product (“Color: Red” once per shirt) and stopped at 200 entries with “Too many items to display”.

Two queries, whatever the number of variants

On an Odoo 19 test database with 20,000 variants (400 products, 10 colours, 5 sizes), when the catalog opens:

2queries for the module’s section
< 10 msto build it
6,010queries for the Odoo 18 section, uncapped
9.3 sto build it

The Odoo 18 section is replayed with its settings (one entry per product, counters), with its 200-entry cap removed: with the cap, it only shows “Too many items to display”. Ticking a value does not reload the module’s panel.

What Catalog Attribute Filter does

One more section in the side panel, and nothing to configure.

One entry per value

Values are listed once, under their attribute: Color › Red, Blue; Size › S, M, L. Red covers every product that comes in red.

Combined like in a web shop

Two values of the same attribute add up, two attributes intersect: red or blue, in size M.

Fast on large catalogs

No counters: the panel costs two queries when it opens, whatever the number of variants.

Only what is used

Archived values, values used by no active product and attributes that never create variants are not listed.

In every catalog

Quotations, purchase orders, customer invoices and vendor bills, repairs: every catalog built on the standard catalog search view gets it.

Nothing in the database

A search filter, nothing else: neither products nor orders are changed.

Product catalog of an Odoo quotation with the Attributes section in the side panel, Red and M ticked
The Attributes section of the catalog: one entry per value, under its attribute.

Installed means ready

  1. Open the catalog

    From a quotation, a purchase order, an invoice or a repair order, click Catalog.

  2. Tick the values

    Under Attributes, tick one or more values: the grid only shows the matching variants. Add them to the order as usual.

  3. Nothing else to do

    The section shows for users who see product variants (Variants setting).

Frequently asked questions

On purpose. The panel computes a counter with one query per value, at every click: on 20,000 variants with 15 values, 17 queries, and the cost grows with every value and every variant. Without counters, the section costs two queries when it opens.
It shows for users who see product variants. Enable Variants in the settings and give the user the matching access right.
Attributes set to never create variants do not appear: the catalog lists variants, which never carry those values.
Odoo 19 and 20, Community and Enterprise alike: it only depends on the Products module. Odoo 18 and earlier still have the original section.
No: Odoo Online does not accept third-party modules. It works on Odoo.sh and on your own server.

A catalog that is slow or hard to filter?

Show me your products and variants: I tell you what the standard can do and what needs a module.