Disable/Hide Category and not the products

[ivogue]

I want to disable / hide category and not the products.

Let's say I sell flowers
Categories are 40 colors, red, blue, etc.

But I also sell clay pots but I don't want it listed on the same Nav. I want to disable it but NOT the products.

cause I want to make a ezpage, and link to it.

Plus if the categories nav is call "flower by colors" it wouldn't make sense to put clay pot in there.

Anyways, I tried to click on the green button to disable the category but it will disable its products too.

Any other ways i could do that?

[Ells]

Have you tried disableing the category, but then re-enabling each product individualy? I THINK that would hide it from the menu, but still allow you to link to each product. Just take note of the URLs you'll need before disabling the category.

[Ajeh]

You could also run a quick SQL command in the Tools ... Install SQL Patches ...

UPDATE categories SET categories_status = 0 where categories_id = XX;

where XX is the categories_id you want to set to disabled ...

[swordfish]

GREAT!! Thanks Ajeh, that worked a dream! So, anyone else needing the same thing, use:

UPDATE categories SET categories_status = 0 where categories_id = XX;

as recommended by Ajeh!!

Just one point... I'm no wizz in databases, so how do I RE-ENABLE should I want to?

Thanks.

[g1smd]

I assume that

UPDATE categories SET categories_status = 1 where categories_id = XX;

would do it.

[Ajeh]

That should work for you ... test it out and see ...

[Friedrich72]

Thanks for your advice on this thread!

Another way to do it is this:
Create a new category titled "HIDE", deactivate it, then create whatever active categories you want inside of it as subcategories.

...which is pretty much what Ajeh said but you'd use the cool little red and green buttons instead of the sql.

[piscean29]

Have you tried disableing the category, but then re-enabling each product individualy? I THINK that would hide it from the menu, but still allow you to link to each product. Just take note of the URLs you'll need before disabling the category.

Awesome! Just what I need! Didn't realise that was possible.

Cheers!

[Rudolphcorporative1]

Cool, it worked fine, thanks buddy!