hideCategories

[s_mack]

Designed specifically for our store, I thought it might be of use to others so I released it as a contrib. However, I'm not sure how useful it will be.

In our case, we often have to put together custom packages for customers... basically, that means we make a 'product' just for them and send them a link. Unfortunately, that means that custom product is visible to the public. This contrib addresses that.

You can declare specific folders to be 'hidden'. There are two levels of hidden:

1) Hidden from menus: This setting only hides the folder from the main categories sidebox and the main index categories listing. It will still show up elsewhere, including searches. We don't use this - I just conceived it might be useful so I added it. I guess if you have an "others" category but you don't want to show it on the menu for asthetic reasons.

2) Fully hidden: This setting hides it from the two places above, but also from the "all products", "new products", "featured products" links as well as the search function and the bestsellers sidebox. *NOTE* That is all! There may be other places that it shows up that we don't use!!!

In either case, you can still directly link to the product and it can still go through checkout as normal.

Enjoy if its any use to you!

Here's a link to the download: link

- Steven

[misty]

Great contribution..thanks..does it only work with ZenCart 1.36*
i.e. been tested on 1.2*/1.3*?

[s_mack]

Not tested on anything before 1.36, but I think you can be pretty sure it WONT work on 1.2x versions. Probably works on 1.3x, but untested.

- Steven

[misty]

Thanks for prompt response,s_mack.. for members using 1.2*/1.3* and
don't wish to use/try this contribution.. thread at
http://www.zen-cart.com/forum/showth...=hide+category will come in handy

[s_mack]

Not really for 1.3x... when you read through that "solution", you should find this contrib to be a lot more useful and easier to implement.

- Steven

[john95051]

I am having problem on the 1.36 ZC.

I got following when I click "New Product",
===
1146 Table 'jun9505_jlcxxxxxx.products_description' doesn't exist
in:
[select count(*) as total FROM jun9505_products p LEFT JOIN jun9505_manufacturers m ON (p.manufacturers_id = m.manufacturers_id) LEFT JOIN jun9505_hide_categories h ON (p.master_categories_id = h.categories_id), products_description pd WHERE (h.visibility_status < 2 OR h.visibility_status IS NULL) AND p.products_status = 1 AND p.products_id = pd.products_id AND pd.language_id = 1 ]
===

Note, jlcxxxxxx is the database name, jun9505 is the prefix.
If everything is right, It should looking for Table 'jun9505_products_description'. Any idea on why this happen?

Thanks.

[reza]

HI STEVEN
IT's a great contribution, but there is a problem, when I use css flyout category sidebox or header css flyout, the hidden categories are still showing!!!
do you now how can I solve this problem?
thanks

[tatiana77]

Just wanted to say that I installed this mod tonight and I love it.

Thank you!

Tatiana

[eddierosenthal]

could you elaborate on how you installed it?
i must have installed this contrib incorrectly somehow
i hand copied all the files listed to the correct dirs and sub dirs,
i can see the new table has three rows ( where i have first created a category then edited it and chosen to give it only direct links.
however, the categories still show up ( along with the other categories)
so i wonder which php file is either missing or not copied right.
i have double checked everything...

[trebor79]

After installing the mod, I noticed that there were a few places where my hidden categories were still showing (Site Map, Customers who bought this product also purchased...).

I haven't seen any posts for solutions to hiding in Site Map & Customers who bought... sections, so I thought I'd post my ideas. I use Zen-Cart 1.3.7 too, BTW.

Here's how I stopped the categories from showing in Site Map & individual products from w/in a hidden category from being shown in Customers who bought...

Customers who bought...
go to: /includes/classes/db/mysql/define_queries.php
and find the section that starts w/ DEFINE('SQL_ALSO_PURCHASED' and make it look like this:

DEFINE('SQL_ALSO_PURCHASED', "select p.products_id, p.products_image
                     from " . TABLE_ORDERS_PRODUCTS . " opa, " . TABLE_ORDERS_PRODUCTS . " opb, "
                            . TABLE_ORDERS . " o, " . TABLE_PRODUCTS . " p LEFT JOIN "
			    . TABLE_HIDE_CATEGORIES . " h ON (p.master_categories_id = h.categories_id)
		     where (h.visibility_status < 2 OR h.visibility_status IS NULL)
                     and opa.products_id = '%s'
                     and opa.orders_id = opb.orders_id
                     and opb.products_id != '%s'
                     and opb.products_id = p.products_id
                     and opb.orders_id = o.orders_id
                     and p.products_status = 1
                     group by p.products_id
                     order by o.date_purchased desc
                     limit " . MAX_DISPLAY_ALSO_PURCHASED);

Now for the Site Map
go to: /includes/classes/site_map.php
On or around line 37 (depending if you've edited this file before) & make sure it looks like this:

$categories_query = "select c.categories_id, cd.categories_name, c.parent_id
	from " . TABLE_CATEGORIES . " c LEFT JOIN "
	. TABLE_HIDE_CATEGORIES . " h ON (c.categories_id = h.categories_id), "
	. TABLE_CATEGORIES_DESCRIPTION . " cd
	where (h.visibility_status < 2 OR h.visibility_status IS NULL)
	and c.categories_id = cd.categories_id
	and cd.language_id = '" . (int)$_SESSION['languages_id'] . "'
	and c.categories_status != '0'
	order by c.parent_id, c.sort_order, cd.categories_name";

These changes *should* work. Mileage may vary. Make a copy of these files & backup before editing them in case something looks screwy afterwords.

I hope this is useful to someone out there.