Odoo Help


List products in all subcategories

Ahmad Khayyat
on 4/10/13, 6:55 PM 11,020 views

Isn't there a way to list all products under all subcategories of one parent category?


  • Category 1
    • Subcategory A
      • Product 1
      • Product 2
    • Subcategory B
      • Product 3
      • Product 4
  • Category 2
    • Subcategory C
      • Product 5
      • Product 6

How do I list products 1, 2, 3, and 4 only, which are all the products under the top-level Category 1?

I have no problem listing products immediately under a category or a subcategory. I can use "Group by Category" in the Products screen for that, or use the steps you mentioned.

I want to list all products under all subcategories of one main category.

Question updated with an example.

Ahmad Khayyat
on 4/11/13, 4:02 AM

Ok, I understand. For now, I don't see any other option to list out all products under all subcategories of one main category. You need to do customization for it, I think.

Priyesh Solanki (pso)
on 4/11/13, 5:49 AM

Bonnet Denis

--Bonnet Denis--
| 5 6 8
St avé, France
--Bonnet Denis--

CEO/ODOO expert at Talyes.in

Bonnet Denis
On 6/25/13, 2:21 PM

You can go to Sales --> Products --> Products by Category menu and delete the filter in search bar. You'll have all product of the category tree.

Or you can create a filter like

<filter string="NAME" icon="terp-accessories-archiver" domain="[('categ_id','child_of',X]"/>

where X is the ID of your category. You can use a list of categories like domain="[('categ_id','child_of',[X,Y])]"

This is exactly what I was looking for. Unintuitive, but at least it's possible.

Ahmad Khayyat
on 6/25/13, 2:45 PM

Priyesh Solanki (pso)

--Priyesh Solanki (pso)--

| 2 2 4
--Priyesh Solanki (pso)--
Priyesh Solanki (pso)
On 4/11/13, 3:45 AM

What I understood is that You want to list out all products of subcategory of parent category. For that, Go to the Sales --> Products --> Products by Category menu. Expand categories and click on it. You will see all products related to that category. Otherwise let me know more information regarding it.

Thanks, Priyesh Solanki


Leonardo Donelli

--Leonardo Donelli--
| 5 4 8
Roma, Italy
--Leonardo Donelli--

Physics student and part-time developer.

Leonardo Donelli
On 5/6/14, 6:06 AM

Late answer for those who come here from Google

If when you set a category filter in the search widget you want to display all products in that category or subcategories (the default behaviour is to display only products with that exact category set, which is kind of stupid if you ask me), you can modify the search view defined in product_product: add this xml in a custom module:

<record id="view_product_search_child_categories" model="ir.ui.view">
    <field name="name">Redefined product search view: subcategories</field>
    <field name="model">product.product</field>
    <field name="inherit_id" ref="product.product_search_form_view" />
    <field name="arch" type="xml">
        <field name="categ_id" position="attributes">
            <attribute name="operator">child_of</attribute>

this the same solution than mine but it's a better integration. Thanks for the trick.

Bonnet Denis
on 5/6/14, 8:11 AM

Yes, and you don't need to specify the ID of the category, so you can use it for all categories. But it is indeed based on your answer.

MONK Software, Leonardo Donelli
on 5/12/14, 9:40 AM

How to do this?

on 9/24/14, 12:41 AM

I added this xml in /addons/product/product_view_all.xml together with the and . Then I edited __openerp__.py to include the new xml on the 'data' :[] But i still can't find the way to make it work. Where can I add the XML?

on 9/24/14, 12:44 AM

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: 4/10/13, 6:55 PM
Seen: 11020 times
Last updated: 3/16/15, 8:10 AM