[OFBIZ-566] Searching on 'widgets' in the demo shouldn't tell you that the category is empty

• Type: Improvement
• Status: Closed
• Priority: Trivial
• Resolution: Cannot Reproduce
• Affects Version/s: Trunk
• Component/s: ecommerce
• Sprint: Bug Crush Event - 21/2/2015
• Assignee: Jacques Le Roux
• Reporter: David Welton
• Created: 27/Dec/06 16:08
• Updated: 21/Oct/15 13:52
• Resolved: 21/Oct/15 13:03

Description

Hi,

I was perusing OFBiz again to gain some insights, and one thing jumped out at me as a minor annoyance that ought to be fixed, so I'm reporting it.

The problem is that when you click on 'widgets' in the demo', you get a screen saying that "There are no products in this category", as well as getting the two subcategories expanded on the left bar.

If I am trying to sell stuff, I think I would prefer to have products in this category's subcategories come up, if there is nothing in the category itself, as well as a list of the subcategories that could be selected. I know that things are meant to be customized, but the better the defaults are, the easier it is for people to see how cool OFBiz is, and start using it with less modification required.

Unfortunately, I don't have the time or incentives to take care of this... the query I'd be after is something like this:

select * from product_category_member where product_category_id in (select product_category_id from product_category where primary_parent_category_id = '200' or product_category_id = '200') limit N; (200 is 'widgets')

But I don't know how to implement that...

Thanks,
Dave