hideCategories

[gabstero]

Nevermind - fixed that -

One other place where my hidden category turns up is in the "Site Map" - wonder if that can be filtered out -

any ideas?

thanks

gabstero

[jill8026]

Is there any way to get this to work with a header dropdown navigation? Site is http://www.mypandapaws.com/shop.

I have the mod installed fine, but it apparently doesnt work with dropdowns? Please advise! THANK YOU!!!!!

[agaisine]

Hi and thank you for the link to the "hide categories" module. I downloaded the module and unzipped the files but I don't know how to install it so that it's available in my ZenCart. Can you please give me some advice on that.

[DivaVocals]

Gotta love the thread search!!! Glad I decided to give searching this thread a shot.. (saved me from having to pay/beg someone to help me with this!!!) I know this post is almost 1.5 years old, but this is EXACTLY what I was looking for.. I'm using the Improved SiteMap Display mod, and I needed to make the hidden products disappear!!! So if the author of this post still hangs out here.. thank you thank you thank you!!!

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.

[Berserker]

Hi there,

Is this mod compatible with BetterCategories? I downloaded the mod and it seems it will overwrite the tpl_categories file that the BetterCategories mod is using. Any way around this?

Thx...

[s_mack]

Like any mod... see what is being changed and modify/merge your files accordingly. If you don't know how to do that or aren't comfortable with your php skills, then the answer is "no, it isn't compatible".

[Berserker]

Hi there,

Thanks for the reply. Just wondering, how do I add padding/spacing between each link? #categoriesContent a doesnt seem to work...

Thx...

[scatzc]

One other place where my hidden category turns up is in the "Site Map" - wonder if that can be filtered out - any ideas?

Hear hear... Same problem here. Is there a quick fix for that?

[DivaVocals]

Hear hear... Same problem here. Is there a quick fix for that?

The solution for this is posted TWICE in this thread..

[s_mack]

The solution for this is posted TWICE in this thread..

Thank you.