hideCategories

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

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!!!!!

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.

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!!!

Quote:

---

Originally Posted by 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:

Code:

---

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:

Code:

---

$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.

---

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...

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".

Hi there,

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

Thx...

Quote:

---

Originally Posted by gabstero

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?

Quote:

---

Originally Posted by scatzc

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

---

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

Quote:

---

Originally Posted by DivaVocals

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

---

Thank you.