Hiding Categories

[jmberman]

Sometimes we get so busy that I want to have a catch-up week where only consignment category is showing and the rest of the categories are hidden... is this possible?


That way I wouldn't have to put the whole site in maintenance which would really help my consignment partners.

Thanks!

[mc12345678]

Sometimes we get so busy that I want to have a catch-up week where only consignment category is showing and the rest of the categories are hidden... is this possible?


That way I wouldn't have to put the whole site in maintenance which would really help my consignment partners.

Thanks!

Absolutely this is possible, just need to disable all of the other categories (and accompanying product unless there is some expectation that the disabled product are linked to your "consignment" category and they are still to be seen). There are also some potential considerations such as it would be ideal if the consignment category was immediately off of the main store and not a sub-category of one of the categories to be disabled...

Disabling just the category(ies) without disabling the product will easily permit access to the product (bookmark or webpage link) while should prevent simple navigation through category menus.

[jmberman]

You say I can but not how.

How do I disable a category? I was hoping that'd be in the category settings, but it's not.

[Design75]

You say I can but not how.

How do I disable a category? I was hoping that'd be in the category settings, but it's not.

In the categories listing in the admin, press the green button on the row of the category you want to disable.

[jmberman]

In the categories listing in the admin, press the green button on the row of the category you want to disable.

Omg, lol so simply, thank you.

[jmberman]

Once I re-enable a category, I seem to have to re-enable all the products within it individually, is there a faster way so where I enable the category it re-enables all the products too?

[mc12345678]

Once I re-enable a category, I seem to have to re-enable all the products within it individually, is there a faster way so where I enable the category it re-enables all the products too?

I thought that was something presented to the user when re-enabling the category, much like when disabling the category. It might be something that has recently been added to ZC 1.5.7, but regardless the categories template has been rewritten to hide the selection button when on a mobile device (small screen resolution which could also occur if the screen width for the browser is shrunk down) and my current install hasn't been modified to support seeing the buttons and therefore I'm having difficulty confirming that additional operation.

Now, it is possible to execute a sql query to cause this, but playing with database data manually comes with its own concerns...

There are two queries that come to mind. One is to enable all product that are "rooted" in the category, meaning the master_categories_id is that of the category being enabled. The other is any product that is to be visible in the category (this includes those with a master_categories_id of as well as those linked to the category being re-enabled). Taking a step back further though, it is possible that a category has other sub-categories that were disabled which also may need to be re-enabled, but that would be yet another set of queries compared to the two I would generate from the above.

So, the one where the product are rooted in the category. First for either of these, need to identify the categories id which is the number to the left of the categories name.

UPDATE products SET products_status = 1 WHERE master_categories_id = N AND products_status = 0;

Where N is the value of the categories_id that has the product to be enabled.

The second which affects linked product as well:

UPDATE products p SET p.products_status = 1 WHERE p.products_id IN (SELECT p2c.products_id FROM products_to_categories p2c WHERE p2c.categories_id = N) AND p.products_status = 0;

Again where N is the categories_id as previously discovered.