hideCategories

southshorepizza:

I have my test site up now. I merged these files together. I just have one issue. The site is http://onlineorder.sshorepizza.com across the top of the page is a navigation bar. It has all the categories listed there. I like having it there but I'm sure I can turn it off just haven't found where. Ideally though I'd like to modify the file that makes this category listing. I think it is found at onlineorder/includes/templates/template_default/templates/tpl_modules_categories_tabs.php I'm not positive. I was going to try and merge that with the sidebox template but can't figure out what I would put where. Can you give me any help with this? Other than this one issue it seems to be working. I can't search for the items and can't see them in the category sidebox.

Thank you

The Categories tab is already included in the hideCategories module.. (see the changelog, this was added in v2.00) Hidden categories should not appear in the categories tab..

Okay so the problem I have now is the test site is identical to the real site. I used filezilla to just copy everything from the store domain to the test site. I then created a opened every category and resaved it. Then created a new category and marked it hidden(not the one with direct link required but just hidden). I created a product called RCS gave it a description of RCS. On the test site I cannot search for RCS and find it. On the real site I can search for it and find it. Unfortunately on the test site I cannot find anything via search. I have recopied the files from the real site to the test site in the folders includes/modules/pages/advanced_search and includes/modules/pages/advanced_search_result So I cannot find hidden or non hidden. Can you help with this?

southshorepizza:

Okay so the problem I have now is the test site is identical to the real site. I used filezilla to just copy everything from the store domain to the test site. I then created a opened every category and resaved it. Then created a new category and marked it hidden(not the one with direct link required but just hidden). I created a product called RCS gave it a description of RCS. On the test site I cannot search for RCS and find it. On the real site I can search for it and find it. Unfortunately on the test site I cannot find anything via search. I have recopied the files from the real site to the test site in the folders includes/modules/pages/advanced_search and includes/modules/pages/advanced_search_result So I cannot find hidden or non hidden. Can you help with this?

I've read this post a few times and I really am not understanding what the issue is.. Links to the sites along with a much clearer explanation might help..

I gave my site in my previous post so I thought you had it. http://onlineorder.sshorepizza.com
The problem is the search doesn't work at all. No matter what I search for on the test site I get no results. The live store search works. I can't figure out why it doesn't work on the test site. It not only doesn't work for hidden products that should be searchable it doesn't work for non hidden products. My only hidden product right now is in the category "Instore" and the Product is RCS. The problem is I cannot access it through the search page. But I cannot search any of the products either. The product RCS is found at http://onlineorder.southshorepizza.net/index.php?main_page=product_info&cPath=41&products_id=127 So I know it is active and on the site. I just cannot search and find it.

southshorepizza:

I gave my site in my previous post so I thought you had it. http://onlineorder.sshorepizza.com
The problem is the search doesn't work at all. No matter what I search for on the test site I get no results. The live store search works. I can't figure out why it doesn't work on the test site. It not only doesn't work for hidden products that should be searchable it doesn't work for non hidden products. My only hidden product right now is in the category "Instore" and the Product is RCS. The problem is I cannot access it through the search page. But I cannot search any of the products either. The product RCS is found at http://onlineorder.southshorepizza.net/index.php?main_page=product_info&cPath=41&products_id=127 So I know it is active and on the site. I just cannot search and find it.

need the link to both the live and test site.. (edited to add: the link you provided above doesn't work) and to solve the issue you are going to need to use your file comparison program to compare your live site to your test site to see what's different between the two.. I don't use WinMerge so I don't know if it will allow you to do this directly from your host (Beyond Compare allows you to compare files from your host). If it doesn't allow you compare directly on the host, then you will need to download both sites and compare the files between the two..

So as has been reported by others, the search does not work for me either on my test store.. I don't know why, and it's over my head to fix, so I'm not going to attempt it.. If someone else wants to tackle this, they can feel free to do so.. In the meantime I will submit the updated fileset that works with Zen Cart v1.5 with this caveat clearly documented..

knuckle-101:

Try the file header_php.php file attached see if that works for you. This is unedited without any other mods installed. I take no credit or responsibility, backup your original first.

Simply upload it to includes/modules/pages/advanced_search_result/header_php.php it is for 1.5.1 version

[Attachment no longer available]

Danielle:

I've installed the latest version of this mod (2.1) and it looks like it includes the changes below. However, when I search, I get no results, even for categories that are not hidden. If I put back the original advanced_search_result/header_php.php file, the products all show up, but it includes the products from the hidden categories. I have checked and rechecked all the files and I just don't know what is causing this problem.

kamelion0927:

Alrighty, I think I've got it.

MAKE A BACKUP BEFORE YOU MAKE THIS CHANGE BECAUSE THIS ISN'T AN OVERRIDE FILE and it worked for me, but I'm not 100% sure it is correct.

In includes/modules/pages/advanced_search_result/header.php, find

$from_str = "FROM (" . TABLE_PRODUCTS . " p
LEFT JOIN " . TABLE_MANUFACTURERS . " m
USING(manufacturers_id), " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_CATEGORIES . " c, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c )
LEFT JOIN " . TABLE_META_TAGS_PRODUCTS_DESCRIPTION . " mtpd
ON mtpd.products_id= p2c.products_id
AND mtpd.language_id = :languagesID";

> and change to
> ```php
$from_str = "FROM (" . TABLE_HIDE_CATEGORIES . " h, " . TABLE_PRODUCTS . " p
             LEFT JOIN " . TABLE_MANUFACTURERS . " m
             USING(manufacturers_id), " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_CATEGORIES . " c, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c )
             LEFT JOIN " . TABLE_META_TAGS_PRODUCTS_DESCRIPTION . " mtpd
             ON mtpd.products_id= p2c.products_id
             AND mtpd.language_id = :languagesID";

Then find

// Notifier Point
$zco_notifier->notify('NOTIFY_SEARCH_FROM_STRING');

$where_str = " WHERE (p.products_quantity > 0
AND p.products_status = 1
AND p.products_id = pd.products_id
AND pd.language_id = :languagesID
AND p.products_id = p2c.products_id
AND p2c.categories_id = c.categories_id ";

> and change to
> ```php
// Notifier Point
$zco_notifier->notify('NOTIFY_SEARCH_FROM_STRING');

$where_str = " WHERE (p.products_quantity > 0
               AND p.products_status = 1
               AND p.products_id = pd.products_id
               AND pd.language_id = :languagesID
               AND p.products_id = p2c.products_id
               and (p.master_categories_id = h.categories_id and h.visibility_status !=2)
               AND p2c.categories_id = c.categories_id ";

All I did was utilize the code from hideCategories/includes/modules/sideboxes/my_template/whats_new.php and adapted it to fit the search code.

Hopefully it will continue to work and not cause issues with any of my other mods but I would appreciate feedback from someone who knows code as to whether it is the appropriate way to handle this situation.

Thanks!

I've already tried that. Thanks though. The live site is http://d132s.southshorepizza.net The test site is http://onlineorder.sshorepizza.net Like I stated the search keyword doesn't work for any products. Regardless of hidden or not I get 0 results on the test site. Almost like the code is broken. However when I put the original zen-cart v 1.5.1 header_php.php file back on the test site I still cannot get any results. Perhaps if your search works you could post the entire file? Maybe that could help resolve it. I'm stumped since neither file works.

southshorepizza:

I've already tried that. Thanks though. The live site is http://d132s.southshorepizza.net The test site is http://onlineorder.sshorepizza.net Like I stated the search keyword doesn't work for any products. Regardless of hidden or not I get 0 results on the test site. Almost like the code is broken. However when I put the original zen-cart v 1.5.1 header_php.php file back on the test site I still cannot get any results. Perhaps if your search works you could post the entire file? Maybe that could help resolve it. I'm stumped since neither file works.
Re-read my post above..

southshorepizza:

I've already tried that. Thanks though. The live site is http://d132s.southshorepizza.net The test site is http://onlineorder.sshorepizza.net Like I stated the search keyword doesn't work for any products. Regardless of hidden or not I get 0 results on the test site. Almost like the code is broken. However when I put the original zen-cart v 1.5.1 header_php.php file back on the test site I still cannot get any results. Perhaps if your search works you could post the entire file? Maybe that could help resolve it. I'm stumped since neither file works.

Gonnna post my reply to you in the other thread you started on this same topic here so the information is available to all..

DivaVocals:

The readme and the SQL file for hideCategories VERY clearly says that the SQL file does nothing but create ONE table that is used by ONLY by hideCategories.

As I reported on the hideCategories support thread, the modifications to the **includes/pages/advanced_search_results/header.php.php **file included in hideCategories Version: 2.1 do not work and causes the issue the OP is reporting (the search doesn't find ANYTHING). hideCategories Version: 2.1 was the version where this file is introduced. (there were no other changes) I will NOT be attempting to fix this as I'm not entirely sure why it worked for Zen Cart v1.3.9, and does not work with Zen Cart v1.5.x. It is addmittedly over my head to fix, which is why I won't attempt it. I will in fact exclude this file from the upcoming version of hideCategories I will be submitting **(updated for Zen Cart v1.5.1)

**My advice to the OP mimics yours.. Get the test site to match the live site..

After he does that, THEN install hideCategories WITHOUT the modified includes/pages/advanced_search_results/header.php.php file. (suggest installing hideCategories - Version: 2.0)

So the file that was breaking the search engine was located at
includes/templates/your_template/templates/tpl_advanced_search_default.php

The one I kept being told was the problem was
includes/modules/pages/advanced_search_result/header_php.php

southshorepizza:

So the file that was breaking the search engine was located at
includes/templates/your_template/templates/tpl_advanced_search_default.php

The one I kept being told was the problem was
includes/modules/pages/advanced_search_result/header_php.phpIt is in fact BOTH files that are the problem.. For different reasons as the edits to these files serve a different purpose..

The issue with the** includes/templates/your_template/templates/tpl_advanced_search_default.php** is due to a conflict with the categories sidebox which makes the categories dropdown default to the last category in the list versus "All Categories" as it should. (which is why you get no search results)

Make the following change to includes/templates/your_template/templates/tpl_advanced_search_default.php

//  Begin hideCategories code
    list($nada, $mycpath)= split('=', $box_categories_array[$i]['path']);
    $mycid = split('_', $mycpath);
   [B]$cat_to_check  [/B]= array_pop($mycid);
    $hide_status = $db->Execute("select visibility_status 
                    FROM " . TABLE_HIDE_CATEGORIES . "
                    WHERE categories_id = " . [B]$cat_to_check  [/B]. "
                    LIMIT 1");
    if ($hide_status->fields['visibility_status'] < 1) {
//  End hideCategories code

The code in the includes/modules/pages/advanced_search_result/header_php.php does not work at all.. Still don't know why, and unless someone else has the answer for how to get this to work, I will not be including it in the next hideCategories release..

I have the site up and running fine. I used the original header_php.php and the tpl_advanced_search_default.php I did not upload. The search feature works fine. I am not using the hidden direct link only feature so this works great for me as is. I just wanted to post the problem I found in case anyone else might happen to run into this and search for an answer.

Thank you very much for all your help on this though!!! It was much appreciated!

southshorepizza:

I have the site up and running fine. I used the original header_php.php and the tpl_advanced_search_default.php I did not upload. The search feature works fine. I am not using the hidden direct link only feature so this works great for me as is. I just wanted to post the problem I found in case anyone else might happen to run into this and search for an answer.

Thank you very much for all your help on this though!!! It was much appreciated!As long as you understand that by NOT using the **tpl_advanced_search_default.php **your hidden categories are seen in the categories dropdown on the Advanced Search page..

Made some minor changes below it is the sideboxes/tpl_categories.php file where the changes need to be made

DivaVocals:

It is in fact BOTH files that are the problem.. For different reasons as the edits to these files serve a different purpose..

The issue with the** includes/templates/your_template/templates/tpl_advanced_search_default.php** is due to a conflict with the categories sidebox which makes the categories dropdown default to the last category in the list versus "All Categories" as it should. (which is why you get no search results)

Make the following change to includes/templates/YOUR_TEMPLATE/sideboxes/tpl_categories.php```
// Begin hideCategories code
list($nada, $mycpath)= split('=', $box_categories_array[$i]['path']);
$mycid = split('_', $mycpath);
[B]$cat_to_check [/B]= array_pop($mycid);
$hide_status = $db->Execute("select visibility_status
FROM " . TABLE_HIDE_CATEGORIES . "
WHERE categories_id = " . [B]$cat_to_check [/B]. "
LIMIT 1");
if ($hide_status->fields['visibility_status'] < 1) {
// End hideCategories code

> 
> The code in the **includes/modules/pages/advanced_search_result/header_php.php** does not work at all.. Still don't know why, and unless someone else has the answer for how to get this to work, I will not be including it in the next hideCategories release..

Thanks for making sure I understand. I'm selling pizza obviously and I have a category called in store only. So if they find it so be it. I just don't want to confuse people with buying items like slices and think they can get them delivered by having them front and center on the main categories.

southshorepizza:

Thanks for making sure I understand. I'm selling pizza obviously and I have a category called in store only. So if they find it so be it. I just don't want to confuse people with buying items like slices and think they can get them delivered by having them front and center on the main categories.
Sure.. the issue is with the categories sidebox code though, making the change to the categories sidebox I posted solves the issue with the includes/templates/your_template/templates/tpl_advanced_search_default.php file though (no changes needed to this file).. just so you know.. It seems simple enough to do.. Your choice though.. glad you have it all working..

I'm seeing it's been a long time since this has been updated. Does anyone know if it will work for v1.5.1? Is there something newer that does the same or similar?

I'm wanting to have wholesale discounted products in a hidden category so a user would have to know a private link to get there.

I also thought it would be useful to have "pre-release" products in another hidden category so I could have them ready to go, and just move them over when the product is available. I know there are other ways to do that last bit.

Thanks in advance.

I am using it with 1.5.1 with no issues.

How can i include hidden categories in XML Sitemap?

ShopVille:

How can i include hidden categories in XML Sitemap? I do not think this is possible them being hidden. It kind beats the concept they are hidden? But I could be wrong and it be possible.