HIDDEN category

[Ajeh]

If you have a Top Level Category:
Hidden

Then subcats:
Manufactuer 1
Manufactuer 2
Manufactuer 3

Then turn off the Hidden Category ... that marks all as status 0

Now, go to the subcategories and turn them back on ...

So the Top Level is hidden ... but the subcategories are not ...

Since the Top Level does not show, it will not show in the listings ...

However, then you still need to adjust things for searches ...

Another method is to edit the products table ...

If the master_categories_id for the products matches the categories_id that is turned OFF or status 0 ... then you could run the command:

UPDATE products SET products_status = 1 where master_categories_id = XX; 

Where XX is the matching master_categories_id

Or, you could do the opposite ... just turn off the Categories Status manually ...

UPDATE categories SET categories_status = 0 where categories_id = XX; 

[magicpants]

Ajeh, could you explain how to adjust things for searches? This is where I got stuck as well. The products are hidden but they're coming up in the searches. Kinda odd when a customer stumbles across one of these hidden products! :)

[Ajeh]

You would need to have the select statements ignore these categories/products ...

It can be quite a bit of work to make the selects manage this ... but it can be done ...