Odoo Help

Welcome!

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.

4

List products in all subcategories

By
Ahmad Khayyat
on 4/10/13, 6:55 PM 9,089 views

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

Example:

  • 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
1

Bonnet Denis

--Bonnet Denis--
925
| 5 6 8
Vannes, France
--Bonnet Denis--

Engeneer at MGS Consulting Ouest at Vannes, FRANCE

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
0

Priyesh Solanki (pso)

--Priyesh Solanki (pso)--
Tiny ERP Pvt Ltd
http://www.odoo.com
1110
| 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

0

Leonardo Donelli

--Leonardo Donelli--
1040
| 5 4 8
Cave, 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>
        </field>
    </field>
</record>

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.

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

How to do this?

Eric
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?

Eric
on 9/24/14, 12:44 AM

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)

Stats

Asked: 4/10/13, 6:55 PM
Seen: 9089 times
Last updated: 3/16/15, 8:10 AM