HIDDEN category

Locked
Results 1 to 9 of 9
This thread is locked. New replies are disabled.
09 Nov 2006, 05:48
#1
digivixen avatar

digivixen

New Zenner

Join Date:
Mar 2006
Posts:
26
Plugin Contributions:
0

HIDDEN category

i used a HIDDEN category and then a series of sub-categories as the master categories for manufacturers products in version 1.2 to make creating coupons and sales easier but now in v 1.3.0.2 i can't seem to get it to work the way it used to.

when i change the HIDDEN category status to off it also disables the products and i can't see an option to disable/hide just the category but not the products?

what do i need to do or is there another way of doing this now.
09 Nov 2006, 05:51
#2
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Posts:
62,757
Plugin Contributions:
1

Re: HIDDEN category

How many Products are in the Category?
10 Nov 2006, 08:15
#3
digivixen avatar

digivixen

New Zenner

Join Date:
Mar 2006
Posts:
26
Plugin Contributions:
0

Re: HIDDEN category

each manufacturer has at least 70+ products.
14 Nov 2006, 12:30
#4
digivixen avatar

digivixen

New Zenner

Join Date:
Mar 2006
Posts:
26
Plugin Contributions:
0

Re: HIDDEN category

BTT any ideas?
15 Nov 2006, 05:01
#5
digivixen avatar

digivixen

New Zenner

Join Date:
Mar 2006
Posts:
26
Plugin Contributions:
0

Re: HIDDEN category

BTT again - please, please, please someone i need help with this :)
15 Nov 2006, 05:16
#6
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Posts:
62,757
Plugin Contributions:
1

Re: HIDDEN category

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:

[PHP]UPDATE products SET products_status = 1 where master_categories_id = XX;[/PHP]

Where XX is the matching master_categories_id

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

[PHP]UPDATE categories SET categories_status = 0 where categories_id = XX;[/PHP]
15 Nov 2006, 19:09
#7
magicpants avatar

magicpants

Zen Follower

Join Date:
Aug 2005
Posts:
314
Plugin Contributions:
0

Re: HIDDEN category

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! :)
15 Nov 2006, 19:25
#8
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Posts:
62,757
Plugin Contributions:
1

Re: HIDDEN category

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 ...
09 May 2007, 05:39
#9
fireflyz avatar

fireflyz

New Zenner

Join Date:
May 2007
Posts:
89
Plugin Contributions:
0

Re: HIDDEN category

Hi everyone,.. I've done the HIDDEN category but my products are all priced by attribute.. I only see the discount on Product Info page but not in the dropdowns. Please help a newbie out! thanks!