I installed the original hide categories mod alright. I followed the above instructions to install your mod, but the zen cart page become blank (only head banner is displayed) after the mod is installed, what might the problem be? Thanks
Printable View
Hi :) . I've used this mod before and never had trouble, but with this particular site, I am. Two things. First, they're using the Best Sellers box and I'm getting this error with your bestsellers.php in the modules/sideboxes/custom folder:
Second, I just took that file out and thought it was working, but when I clicked on the manufacturer for the product, the product still showed up.Code:1146 Table '(removed for security purposes)_zc2.products_description' doesn't exist
in:
[select distinct p.products_id, pd.products_name, p.products_ordered from zen_products p LEFT JOIN zen_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_ordered > 0 and p.products_id = pd.products_id and pd.language_id = '1' order by p.products_ordered desc, pd.products_name limit 10]
Any help is appreciated :) .
Hi, I'm back. I have installed this again in a different shop and the best sellers sidebox is not a problem, but the product is not hidden. The category is, I chose hidden, direct link only, but the product is showing up everywhere.
Okay, figured out the sql error, but in both shops I have installed this in in the last two days, it isn't hiding them from the displays. They're showing up in new products (bottom of the page) and also when I browse by manufacturer. Sorry to keep posting, am not trying to bump, just giving updates on what is happening. Any help is appreciated.
Well I installed this mod a week or so ago and it appears to be functioning to the point it is not creating any errors, but have one issue that is driving two of us crazy. The cats do appear to be hidden in the edit screen, but no matter what I do they still show up in the breadcrumbs on the main page. I have called myself double checking the files but nothing seems to help. Our cart is driven by direct links on after the completion of registration type forms. But if a user stumbles on to the main menu the required form will be bypassed. I have had to point the main menu to one of the cats for the time being but would like to be able to go back to the standard for one cat but until I can hide the others that is not feasible. Of course being older than dirt makes me a bit slow.
Mel
This is a response to your post, but also a reminder/suggestion in general.
This contribution, as initially stated, was done for a specific site so the categories are hidden from the modules/boxes/pages that the specific site used and ignored the ones that it didn't use. It is up to the user to find and fix... or eliminate... any page elements, sideboxes, etc that aren't used by this mod. Hints are provided in the readme. So in general, if you aren't up to snuff with PHP programming and aren't intimately familiar with zen cart, then my suggestion is you not use this contribution. It is probably more headache then it is ultimately worth to you.
If I had the time... and I don't... to do this contrib over again with more general use in mind (rather than just the site that was paying me) I would probably go about it entirely different, making use of the hooks available in recent zen versions if at all possible. With new major versions of Zen on the horizon... I doubt I'd undertake it even if I had the time (and I don't) until they were released and stable. I'm talking about zen v4 whenever it is ready, because it should give even better ways to interact with your data.
- Steven
For me, they're showing up in the sideboxes and in the New Products on the main page...I have the Category Tabs disabled. This is happening on two sites...can't figure it out. I understand you wrote it for a particular purpose, but I think what I'm trying to do is within that realm and don't understand why it isn't working...
Hi.
Advice #1 - read the readme file that came with the contrib.
Advice #2 - look for something else if #1 + your php knowledge doesn't = a solution.
Steve
Hi all,
I've recently migrated to a new server host and prior to this move the hide categories mod worked perfectly. However now the store is on the new server the mod is still there i.e. I have the hide options when editing a category. But when I choose to hide a category it does nothing and the category is still visible.
Any ideas?
Just guesses.
My top guess is when you backed up and restored the DB that somehow the new entries got trashed? Try uninstalling the mod and installing it fresh.
Otherwise perhaps an incompatibility with the version of PHP and/or MySQL on your new server?
Dunno.
Steve
Already tried that route Steve.
PHP & MySQL are the same on both servers
Could this overall be related to the PHP version? It seems I'm not the only one with this problem recently and I've installed this on other sites and had it work fine...and I didn't do anything different this time. Your response didn't really help me as I've looked over everything more than once and there's nothing different about the two installations I had problems with than any others I've done before...except maybe the PHP version.
OK it looks like a MOD conflict on my install. The strange thing is that I had the same MODs on the old server and they worked fine. I again removed the hide categories thread and re-installed and it worked fine (last time I removed it I must have missed one or more files :oops:) I re-installed the hide categories MOD and it worked like before with no issues with the MOD. However I also use the categories dressing MOD which then ceased to work.
Categories Dressing mod:
http://www.zen-cart.com/index.php?ma...roducts_id=609
I re-installed the categories dressing MOD and the hide categories MOD then stopped working again. Strange since they both worked happily on my old server and using the same version of ZC.
Any ideas Steve?
Don't use both, or use Winmerge to figure out what the two have in common and figure out a way to merge the code.
Ok, I went through all the posts, and nothing helped.
I'm using Zen Cart v1.3.8a, clean install, i actually installed it twice. Ran through the hideCategories Installation successfully, installed the sql with no errors, I see the radio buttons with the options to hide the categories and everything...:clap:
But here's where i'm confused, The categories that I have listed as hidden, still show up under the categories listing regardless if they are hidden from main menus, or hidden (direct link only), What did i do wrong if anything, is anyone else experiencing this, as far as what I read, everything works well right off the bat...I don't knwo what I did, this is not my first time installing scripts or using sql, so i'm LOST... :lamo:
I"m sorry if anyone could assist....i'm going to reinstall zencart again, and create a new sql table just for this, hopefully it will work...
Thank you guys............
It hides categories, not products. If you want to hide products its easy... don't add them to your store :)
Origel - read the readme. It hides categories from the modules it is works with. If you're using a module that we didn't use when we set it up then you have to modify that module. The reason this module will NEVER be a right-for-everyone thing is the way Zen handles its product/category calls. It isn't centralized so every module that makes the call has to be modified instead of just making one change to the central call (which doesn't exist).
There would be loads of benefits and possibilities if they had done it more centralzied... but ce la vie.
Steven
I used this mod and had some problems so I went back and replaced the over written files with my original files now its killed my categories section. I try to log into the categories and it says
Error 500 - Internal server error
An internal server error has occured!
Please try again later.
I removed all the files this mod installed, deleted the table on the DB and it still screwed it up :frusty:
Clearly you didn't then :)
PHP isn't some magic virus. You put something in, then you take it back out and you're exactly where you were. So either you had that problem before you installed the mod, or you introduced it after (most likely) or you haven't fully removed it.
Its a learning process. Keep at it. Unmodded Zen is pretty simple... once you start modding you see how complex it can be. Once you start to understand... it is satisfying. Before then, it is frustrating.
Have fun.
(consider starting from scratch with a fresh install and CAREFULLY and SLOWLY make changes, fully testing step by step along the way)
- Steven
Lovely Mod!
Thanks Steven!
One minor thing. The hidden category shows up on the top horizontal category bar. I really don't care much for that bar - how can I disable it?
Thanks!
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
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!!!
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...
Thanks are you referring to this?
http://www.zen-cart.com/forum/showpo...&postcount=224
OK I think that I found it:
http://www.zen-cart.com/forum/showpo...2&postcount=94
It turns out that I was using the wrong keyword in the Thread Search: It should be "site map", not "sitemap".
I am using the css_horizontal_dynamic_menu mod, how do i make the hidden categories mod work with the css_horizontal_dynamic_menu mod. I have followed the instruction with the Hidden categories mod however the category that i want to hide still shows up. Any idea?
So if you go to these links you get the errors in the queries as shown:
http://www dot hairisle dot com/products_new
Quote:
http://www dot hairisle dot com/products_allQuote:
1054 Unknown column 'p.master_categories_id' in 'on clause'
in:
[select count(p.products_id) as total FROM zen_products p LEFT JOIN zen_manufacturers m ON (p.manufacturers_id = m.manufacturers_id), zen_products_description pd LEFT JOIN zen_hide_categories h ON (p.master_categories_id = h.categories_id) 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 ]
Quote:
This did not occur on the dev site as you can see:Quote:
1054 Unknown column 'p.master_categories_id' in 'on clause'
in:
[select count(p.products_id) as total FROM zen_products p LEFT JOIN zen_manufacturers m ON (p.manufacturers_id = m.manufacturers_id), zen_products_description pd LEFT JOIN zen_hide_categories h ON (p.master_categories_id = h.categories_id) 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 ]
http://clients dot overthehillweb dot com/hairisle/products_new
http://clients dot overthehillweb dot com/hairisle/products_all
I've been doing a LOT of searching of this forum and Googling, and my research indicates that this might be an issue with the on clause of the left join.. This post was very helpful in nundging me inthe right direction. It reads in part:
http://www.zen-cart.com/forum/showpo...47&postcount=6
Quote:
So I took a look at both dev and the live site and yes indeed they are on different versions of mySQL. (thought my server was running 5.x.. it's not... I'll deal with that later this week)Quote:
The real culprit is Mysql data base queries. Once your host upgrade sql database to 5.x, you need to fix your sql queries...
DB Versions:
hairisle dot com - Database: MySQL 5.0.81-community-log
clients dot overthehillweb dot com/hairisle - Database: MySQL 4.1.22-max-log
So I think I have a grasp on WHAT the issue is, and if I can get some assistance to what the corrected syntax for these queries should be, I should be good to go in correcting the queries for these pages..
I am hoping a s_mack can pop in to help.. YES I read other threads on this error.. Unfortunately the queries are different, and I can't make the leap to figure out how to correct the syntax of this query based on some of the other threads.. Hope someone will take pity on me and help..
Please see this post for the solution I am trying out to resolve the mySQL v5 issue: http://www.zen-cart.com/forum/showpo...8&postcount=14
If you want to read this full thread:
http://www.zen-cart.com/forum/showthread.php?t=139864
I'm still testing to make sure this doesn't break other aspects of the hideCategories add-on. So far so good.. Your mileage may vary..:smile: I also plan to test if this "fix" will work with mySQL v4.x as well.. If I get a different result, I will share those findings as well.
Nope, can't help. Sorry.
I'm no MySQL expert by any stretch of the imagination and I have no idea what's up with your situation. Best of luck though.
Not a problem.. It's a mySQL v5.x compatibility issue with one of the queries in this add-on..
See my post above yours.. I am already working out testing a fix which appears to have resolved the issue.. Looks like one file contained the second left join statement which caused the query to fail (hence the error message). Thanks to DrByte and a friend who both pointed out that this was the cause for the error, I searched the code and found where the second left join was coming from.. Gonna test on mySQL v4.x as well since as I understand things the second left join isn't needed anyway..
I have MySQL 5. Should I not even bother attempting to use this addon?
Password protect doesn't work, either, and I need to implement SOME form of protection for a particular category...
Previous posts already answer questions regarding PHP5 compatibility..
Well, sure, I'm aware the topic has been brought up.
Good news, though. I successfully installed the module on a site running php5 without making any modifications! A customer pointed out that they can still see the hidden category by going to my generic 404 page, however. Not a huge problem, just something to take note of for any future updates (should there be one)
Is this in regard to the question I asked about mySQL 5 , you said PHP5?
Hello,
Can someone please help me merge the hidecategories and the tpl_categories (from BetterCategories) module.
Thank you
I'm using categories tabs and this mod doesn't hide categories from it. Is there any way to make this mod hide categories in categories tabs?
It works perfectly for everything else and I find it a great mod! Now if only I could make it work in my categories tabs...
Please help.
I don't know how many times and ways I have to say it... yes, it can do that. No, it won't do that unless you make it do that. HideCategories was made for a specific client with specific needs... it hides the categories from displaying in the areas used by that client. If you want to hide it from something else, you need to make the changes (to that something else) yourself. Hints are in the readme file.
Thank you very much for such a kind answer, your highness!
If I knew how to do it myself, i wouldn't ask here, don't you think?
Plus, if you can't answer my question or help me, maybe some other member here can. So, you need to understand that this forum is NOT your private forum and that OTHER people might help! I kindly asked for help - if you can't help me, why do you feel the need to push me down? I respect your programming skills, but you really should work on your social skills...
Anyone else out there willing to HELP me?
Well, minion, off to the dungeon for you. But you're right, this isn't "my" thread. I started it and I suppose I take posts like yours as a "I don't feel like reading the readme so just fix it for my needs" but you're right that I had no reason to think you were asking me specifically.
If I could un-make this contrib, I would.
So forget my last post and take this advice instead (or don't): If you don't know how to do what you need to do to modify this contrib to meet your needs, and you are unwilling or unable to learn, then don't use it. It really isn't a good idea to go messing around with a contrib like this THAT CHANGES CORE FILES without knowing what you're doing. That's not me being all high on myself (because you may respect my programming skills but everything I know was self taught and could fit on a little fingernail of a real programmer) that's just sound advice.
Of my published contribs, this is one of the most used and also by far the least useful and most problematic. That's not so much because of how I wrote it, but rather because of how the core uses somewhat inconsistent methods relating to category display.
Anyway, carry on peasant. His highness only has so much time alloted for dabbling with the riff raff.
Gonna make the same suggestion I always make to EVERYONE..
Whenever I install ANY new mod, I make it a habit to read through the ENTIRE support thread before I install it for a few good reasons, but here are few important reasons:
- I can see where all the "bodies are buried". For example does the module have good author support, does it have good community support.
- Tips and tricks are often posted throughout a support thread that will be useful.. In the case of this mod many of the "How do I hide my hidden category from..." have already been answered throughout the thread.
- Is the module even working?? Some modules just simply don't work.. You can get a sense of that by reading through the WHOLE support thread..
Today I happened to be going through THIS support thread. Not to answer your question, but because I'm working on compiling a full list of all the most frequently asked for "how do I hide my hidden category from.." questions and fixes along with the SQL 5.x compatibility fix I posted (http://www.zen-cart.com/forum/showpo...&postcount=238) for a personal project I am working on. I MAY compile all those changes and upload a new version of this module with all of those "fixes" in place.
That said, here is the answer to your question.. I found it nestled in THIS support thread.. HTH..
http://www.zen-cart.com/forum/showpo...&postcount=195
So I'm setting up a test store with the latest version of Zen. The Whats New sidebox has changed in 1.3.9, and I want to make sure that what I propose to add to the query to make hideCategories work with this sidebox is correct.. Left joins confuse me a tad.. So I am hoping someone could take a peek and "grade my homework" so to speak.. So here's what's going on:
Old What's New query
Current What's New queryCode:$random_whats_new_sidebox_product_query = "select p.products_id, p.products_image, p.products_tax_class_id, p.products_price
from " . TABLE_PRODUCTS . " p
where p.products_status = 1 " . $display_limit . "
limit " . MAX_RANDOM_SELECT_NEW;
Old What's New query with hideCategories changesCode:$random_whats_new_sidebox_product_query = "select p.products_id, p.products_image, p.products_tax_class_id, p.products_price, pd.products_name,
p.master_categories_id
from (" . TABLE_PRODUCTS . " p
left join " . TABLE_PRODUCTS_DESCRIPTION . " pd on p.products_id = pd.products_id )
where p.products_id = pd.products_id
and pd.language_id = '" . (int)$_SESSION['languages_id'] . "'
and p.products_status = 1 " . $display_limit;
Proposed What's New query with hideCategories changesCode:$random_whats_new_sidebox_product_query = "select p.products_id, p.products_image, p.products_tax_class_id, p.products_price
from " . TABLE_PRODUCTS . " p, " . TABLE_HIDE_CATEGORIES . " h
where p.products_status = 1
and (p.master_categories_id = h.categories_id and h.visibility_status !=2)
" . $display_limit . "
limit " . MAX_RANDOM_SELECT_NEW;
(See highlighted in blue below -- is this the correct syntax??)
Code:$random_whats_new_sidebox_product_query = "select p.products_id, p.products_image, p.products_tax_class_id, p.products_price, pd.products_name,
p.master_categories_id
from (" . TABLE_HIDE_CATEGORIES . " h, " . TABLE_PRODUCTS . " p
left join " . TABLE_PRODUCTS_DESCRIPTION . " pd on p.products_id = pd.products_id )
where p.products_id = pd.products_id
and pd.language_id = '" . (int)$_SESSION['languages_id'] . "'
and (p.master_categories_id = h.categories_id and h.visibility_status !=2)
and p.products_status = 1 " . $display_limit;
You certainly have the right idea. I can't 100% confirm you have the correct syntax exactly (I'm not using the latest version)... but yeah, you have the right concept. Give it a test run on your non-live site and see what happens. ALWAYS MAKE BACKUPS WHEN EXPERIMENTING.
- Steven
This was absolutely BRILLIANT!!!! Just to share what I did, I used the Product Type "Document - Product" and to make sure it was CLEAR for the client, I edited the product type name to display "Product - Hidden" and made it a sub type of "Product - General" (Go to Catalog > Product Types to make these changes)
Now I need to edit the product details page for the Document - Product product type and add the appropriate styles to the stylesheet (or perhaps simply edit the buttons out the product details page)
So I've compiled a new version of hideCategories. Here's the changelog:
- updated files to reflect changes in Zen release 1.3.9d.
- Incorporated the following posted modifications in to the codebase:
- Add Hidden Categories code to What's New sidebox
- Add Hidden Categories code to Site Map & Customers Who Bought center box
- Add Hidden Categories code to Categories Tab
- Included a modified includes/templates/YOUR_TEMPLATE/templates/tpl_document_product_info_display.php template specifically for hidden products. This template removes the top and bottom "Next" and "Previous" navigation buttons as well as the category link/image without compromising regular products. Requires using "document-product" product type to create your hidden categories.
- http://www.zen-cart.com/forum/showpo...1&postcount=96
- http://www.zen-cart.com/forum/showpo...&postcount=258
I've tested it on my own site and it works great, but I'd like other folks to test it before I submit it to the downloads section.. If you are interested in testing, please PM and I'll get you a copy of the new fileset. I may also include files and/or instructions for using hideCategories with the Improved Sitemap module..
I need to make sure that it's clear that I am looking for testers who will provide feedback on the updated module, not just folks who are looking for an advanced copy of the new version..
So as a result I will be scrutinizing folks who are new to this forum a little more than some of the folks who've been around longer..
That said if you are interested in testing, you should be willing/able to provide feedback once you install and test.
Thanks for understanding..:smile:
Willing to test and sent you a PM. Thanks!
Interested in testing the mod.
Regards
........
Quote:
If you are interested in testing, please PM and I'll get you a copy of the new fileset.
Alright, I hate to ask this because it has probably already been asked but I can't find the answer.
Here is goes:
I will have only hidden products at my store. How do I figure out what the URL is for the hidden product so I can sent it to the customer?
I've set up one hidden category and one product but I can't for the life of me figure out how to compose a simple URL for the product.
Thanks,
Jason
make a non-hidden one for testing purposes, then navigate to that product in your browser. Look up at your address bar and you'll see the format for how a product URL looks and in that will be an identifier with that product's ID. So that's the format, and then you just have to change the ID to suit the other products. Their ID numbers can be seen in your admin. If you just came to your store, however, keep in mind that a session ID will be tagged on.. be sure not to use that. For example, here's a url from a real store:
The grey part is the session ID that you want to delete. It may or may not be in your address bar but if it is, do NOT include it in your links.Quote:
http://www.smartieparts.com/shop/index.php?main_page=product_info&products_id=149&zenid=cfb4a133ac5e3192da149ac987953fa3
The red part is the product ID. That's what you change depending on the product.
Hope that helps. I can't really think of a situation where you'd want a completely hidden shop! And because that is your situation, I have to say that using this mod probably isn't the best way to go about it... but if you find it useful then I wish you the best!
- Steven
<rant>Unfortunately most of the folks who've downloaded this new version have not provided ANY feedback (which I NEED to troubleshoot problems before submitting this to the Zen Cart downloads).. The closest thing I've gotten to feedback is the proverbial "it didn't work" **sigh**:no:</rant>
That said, I wanted to publicly thank X@vier for REALLY testing the new version of hideCategories.. He will be along to post his feedback soon I hope..:smile:
So if you are interested in trying out the updated version of hideCategories, PM me and I will guide you through where to get it..
PLEASE POST FEEDBACK (positive or negative) here.. I need to hear from folks to KNOW if there are any issues..:smile:
Thank you, DivaVocals, for the compliment.
Hereby my report:
* installed it on zc 1.3.9d (PHP5). the final installation will be on 1.3.9g. I don't know if that makes a big difference?
* this installation http://www.collectors.room.eu/zc is already very much customized. It's a dev and testing site;
* The installation goes very well. The two parts are clear in use;
* The readme file is clear and better than the original one;
* After the installation none of the categories in the top navigation bar where visible.
* They are only visible after you resave the existing categories;
* on this site I've also installed a module products in columns. Here's a conflict. The file was overwriten. Need to be merged;
* changed the document type to product - hidden;
* created category and hide it (http://collectors-room.eu/zc/index.php?main_page=index&cPath=4);
* added product to category;
* the category and product aren't visible in sitemap, new product, all products, featured products.
* The base template I use is ZJ-Template-pack. A special feature is the box with the tabs at the right hand site. There is a tab called "new". There the hidden product is visible.
It's a great module. You have done a great job. Thank you very much.
The next great feature would be that the hidden category should only be visible for registered users....
Greetings,
xavier
You are very welcome.. Thank you for posting your feedback.. VERY helpful!!!
You'll just need to compare your store files to the 1.3.9g files and incorporate any changes between the two..
This is required for stores with existing categories to add the correct flags that identify a category as hidden or visible.... on a fresh install where you've not yet created categories the mod should have the right flags in place which identify them as visible or hidden categories.. I'll have a looksee at the readme.. I thought I made this clear in the instructions..
You'll need to compare the files this add-on has in common with your "Products in Columns" add-on.. Merge in the hideCategories changes needed..
Suggest looking at the sideboxes included in the hideCategories package for guidance on the changes needed for your template's sidebox..
This is probably very doable.. Just a little over MY paygrade to make happen..:laugh:
Actually, its not that tough to make it visible only to registered AND LOGGED IN users. Registered but not logged in would be impossible. I don't recall specifics, as its been a long time since i've done any work on Zen, but there is a very simple check to see if the current customer is logged.
That would be a great marketing tool...
First of all, my apologies for not posting this feedback sooner. I was too busy with other projects to work on the one that uses hideCategories. That being said, the new version appears to be working fine for me. I am using it in combination with the Categories Center Box Module from Numinix. This allows me to feature certain items of the month or staff picks for the month. If I create categories for the features and then set the categories to"Hidden (direct link only)", I am able to have them visible only in the center box. This is exactly what I was looking for. Thank you for the mod.
I am interested in testing mod. Is it possible? Thanks
Sure, go ahead.
Send me a PM.. Truthfully I already have the test feedback I needed.. I have been busy and kinda forgot that I needed to submit the updated version to the Zen Cart downloads..:blush: Gonna update the readme and do that this weekend..
Nevertheless PM me and I'll be happy to share where you can get the updated version from in the meantime..:smile:
1st - Very cool mod :smile:
Works like a charm on the categories sidebox,
I inserted the following code:
to disable same categories for my category tabs.Code:$categories_tab_query = "select c.categories_id, cd.categories_name from " .
TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd," . TABLE_HIDE_CATEGORIES . " cde
where c.categories_id=cd.categories_id and c.categories_id=cde.categories_id and c.parent_id= '0' and cd.language_id='"
. (int)$_SESSION['languages_id'] . "' and c.categories_status='1' and cde.visibility_status='0'" .
when:
I get no categoriesCode:cde.visibility_status='0'
when:
I get the hidden categoriesCode:cde.visibility_status='1'
when:
I get the (direct link only) categoriesCode:cde.visibility_status='2'
But at no time do I see the categories I want displayed, does the above code work for category tabs?
I read all 28 pages. thanks, the code I posted was from post 195. doesn't work. I decided to go a different route. Thanks anyways!
At last I got the readme updated, and will be submitting this as soon as I click "Submit Reply". I will post an update when the new version is available in the Zen Cart downloads. Changes as follows:
2.00 - 03/09/2011
- updated files to reflect changes in Zen release 1.3.9h.
- Incorporated the following posted modifications in to the codebase (some of these posted solutions were modified slightly so they worked properly and worked with the latest version of Zen Cart 1.3.9 - most notably the posted solution for hiding categories in the category tabs):
- Add Hidden Categories code to What's New sidebox
- Add Hidden Categories code to Site Map & Customers Who Bought center box
- Add Hidden Categories code to Categories Tab
- Included a modified includes/templates/YOUR_TEMPLATE/templates/tpl_document_product_info_display.php template specifically for hidden products. This template removes the top and bottom "Next" and "Previous" navigation buttons as well as the catgory link/image without compromising regular products. Requires using "document-product" product type to create your hidden categories.
- Corrected files which caused issues in MySQL 5
Hello,
The following files are not stated in the Read Me Files tab. Are they supposed to be included with this mod and uploaded?
includes/classes/site_map.php
includes/classes/db/mysql/define_queries.php
Regards
Forgot to add, my categories tabs disappeared completely. Havent installed any modules with conflicting files.
Yes.. left off the readme inadvertently
From the hideCategories readme:
Quote:
FOR EXISTING STORES: You will need to open ALL your EXISTING categories and re-save them in order to apply the hideCategories changes. Otherwise some places where categories should be hidden will not work correctly, and some places where categories should NOT be hidden may not display correctly.
Minor updates.. Here's the changelog:
2.0.1 - 03/19/2011
- Update the readme file list (2 files were inadvertently left out)
- Minor changes to language files (for better clarity)
- Updated folder icons (again for better clarity - wanted slightly more OBVIOUS icons -this change was made based on feedback I've received from my clients)
- Added hidden folder icons to category page legend
I'm wondering if your hidden categories will help solve the management of prices?
I have downloadable products that are currently priced solely by attribute (priced by size).
I'd like to create four bands of price attributes (cheap --> expensive) and categories seem to be the best way of achieving this because I can copy the price of 1 product (I can create a reference product that is used soley for this purpose; in fact 4 reference products, one in each category) to all other products in that category.
I don't particualarly want the customer to be aware of the category only that some products are more expensive than others, so hiding the category (but not the product) seems a good idea. Currently all products reside within 1 category "stock photos" - not a problem at the moment because stock photos are all that is sold and all are downloadable. If I start supplying framed photos, for example, they would reside in a completely new category where price banding would not apply.
Any thoughts / downfalls about using hidden categories for price banding?
Thanks,
Ric
I don't think this is what you're looking for. It certainly wasn't designed with that in mind anyway. I think you're going to need to customize it so much, that you may as well not use it and just customize the core. I'm surprised there's no other mod out there that does what you want - group by pricing is common on many ecomm sites. Anyway, I don't think HideCategories is really going to help you for that purpose.
Hi and thank you for your reply.
Yes, I find it odd that price banding by some parameter or other isn't more available in Zen Cart.
Another solution is to upload a batch of products to a temporary category, apply the prices to that category and then transfer those products to their final category.
Thanks though for having a think about this problem!
Regards,
Ric
Using a clean version of Zen 1.3.9h and just installed this mod and everything seems to be working, except the products still appear when using the search function.
I am using the hide direct link and it is working for everything but the search function.
I searched the forum and reviewed the install, but can't figure it out. Did I miss something?
Okay, some feedback.
1) Went through each step carefully.
2) Made correct edits to appropriate php files, as per the contents of the latest download.
3) Loaded all up to test site X.
4) Loaded the sql through Admin function.
5) Verified presence of the sql table through MyPHPadmin.
6) Created new category and moved a test product into it.
However.
According to my meagre understanding from reading this entire thread, I ought to be seeing at least one or more additional commands, options, buttons, whatnot on in the Admin control for "Hiding..." whatever.
Nothing shows, no controls, options, anything that can be used to make a category, and thus its contents, hidden.
I have no clue why. All the correctly edited php are in the correct locations, all permissions match those of other files.
Nothing.
I'm using the latest version of the cart 1.3.9h.
MySQL 5.0
I have a couple of other mods on the cart (captcha and shipping related) but non requiring modification of the same php files. So there ought to be no direct conflict there.
I haven't seen any similar experience from anyone here, so either it's my settings or a switch I haven't seen and thrown yet.
Is there some place where you're supposed to switch this thing "On"?
To repeat, yes, I have read this entire thread, and the notes in the package and followed each edit as required, and loaded them up twice and reinstalled the sql twice, and still see nothing new.
:frusty:
The install is straightforward.. Just installed it on my test store (again) and no issues..
From the readme:If you do not see the following (see image below) when editing your category, simply put something is wrong with your install:Quote:
FOR EXISTING STORES: You will need to open ALL your EXISTING categories and re-save them in order to apply the hideCategories changes. Otherwise some places where categories should be hidden will not work correctly, and some places where categories should NOT be hidden may not display correctly.
NOTE: The hidden feature is ONLY available when you EDIT, not when you CREATE a new category. You must create your category 1st first, then go back and edit it. You'll notice the folder icon changes to give you a visual cue that it is hidden.
http://i54.tinypic.com/i3hyt3.png
I gathered that something was wrong, but no idea what.
And yes, I'm not daft I did, repeatedly, "edit" each of the categories, and all the test products in case this had an effect.
Just done it again. No effect and no clue why.
I have several disabled products, Status OFF, during current testing, could that have an effect?
Sorry, ignore all the above babblings.
Went through all the edits again and found the problem, a missing block of code in one page.
Now working.
Apologies for the inconvenience, it's been another long day.
:blush:
Reviewed the information on post 285 and re-installed all the files. Still have the same issue. I am able to hide the products with the direct link but to doesn't hide them from the search function. Does the mod allow you to hide products when someone is doing a search in the cart? If so, any idea what the issue is would be helpful.
I am also having issues hiding hidden products from the search function. I have quadruple checked my install and have marked the category as hidden (several times). On top of that, I installed the optional file and limited the hidden category to hidden products.
The only file in this mod that intersects with the search function (as far as I can see, and I'm no coder) is tpl_advanced_search.php - and it only hides the hidden categories from the category dropdown selection on the advanced search page - if I search for my hidden category, the products still appear on the advanced search result page.
I'm assuming (and yes, I know how dangerous it is to assume) that changes need to be made to the advanced search result header to hide the products from the search results.
Is this the correct file to change to hide the products from the search function? I appreciate any feedback - even if it's in the form of a slap to the back of the head. :smile: