And how am I suppose to know if their is a link or if the one above my post works unless I ask?Quote:
Originally Posted by gjh42
Printable View
And how am I suppose to know if their is a link or if the one above my post works unless I ask?Quote:
Originally Posted by gjh42
is this 1.3.8 compatible? I installed and set a category to hidden from menus but it still shows up.
Probably :)
I have no plans to upgrade to 1.3.8 just to find out. But I would think the answer is yes - looking at the list of changes there doesn't seem to be anything related to categories views. Although, I admit I skimmed.
- Steven
yep, it is actually, I missed renaming one of the folders to my template name.
I am getting an error on my left navigation...
any help would be appreciated :(Quote:
1054 Unknown column 'cPath' in 'where clause'
in:
[select visibility_status FROM zen_hide_categories WHERE categories_id = cPath LIMIT 1]
For some reason your cPath variable is being presented literally instead of showing the value of the variable "cPath". Probably a conflict with another mod you have installed. Maybe something SEO related. Good luck.
Ahhh, you're right..
I had a ul list mod on my left nav
Got this mod working ... it is *perfect* for what I needed it for. Howevor, upon installing it my layout changed and I have not been able to fix it.
What I *had* was 4 column categories 4 column product listings ..... once I installed the hidden category mod suddenly my column ability for products went away and no matter what i changed it still listed 1 product per row. I adjusted my settings so it looks like I meant it now (lol) but I'd still like to get my 4 across for my product listings.
I'm *thinking* somehow it changed something in the coding that the configuration: product listing settings won't overide?
www.badgersden.com - Once you get past the categories in to the products you'll see that they are listed by row now .... not quite what I am wanting. Advice please?? :)
Sign me ...
a confused badger ...
I don't readily see what could be causing any difference in display of the product listings... but then again, I didn't know you COULD list the products 4x :)
Probably one of the template files... try comparing to the originals and see if you can spot it. I looked at the two module files and I can't see those changes affecting anything... they just hide.
Just to clarify .... I meant that my products listed across 4 to a row -- not 4 x per product :P
What / where do I compare? I'm still rather new to all this.
OK .. got it working now :)
The hide mod over wrote the product / column mod I had forgotten I installed ... lol .... it's all playing nicely together now after a few tweaks and pokes.
Thanks
I am having the same problem, but can't find where to tweak and poke...Quote:
Originally Posted by badgersden
Can you tell me just what modifications you made to get the columns back as they were?
I have just installed this in the hope I could hide categories from the general public but not from certain user but it seems not possible?
I also do not see an ICON change:
/admin/images/icons/folder_HIDDEN.gif
/admin/images/icons/folder_NOMENU.gif
/admin/images/icons/folder_NORMAL.gif
do not show up in the admin area.
any ideas?
No, that is not what the module is intended for. Though I'm sure its not much of a stretch to modify it for that use.
If you installed it according to the instructions and put the files in the right place, then you'll see those images when you change the folder's hidden status.
- Steven
I double checked and the permissions also but the change in status does not change the icon.Quote:
Originally Posted by s_mack
I'll try re-install the whole thing again.
So what would I need to change in order to Hide All Categories from the general public but not a user or group.?
I have seen many inquiries about it here in my search for such a thing so I am not alone in this.
Ideally there would be a option in user or group settings to set the category visible or not
If you read the readme/instructions then you'd also see that this isn't a contribution that will be right for everyone and necessarily do what they want. It was built for a specific purpose and released in case it met other people's needs, and that's it. If you need it to do something in particular that it doesn't do, then you are welcome (under the GNU license terms) to modify it as you see fit. If you want me to do it, then you're welcome to solicit my services for a fee by personal message.
As for it not working for you, what can I say? You've given me next to no details so all I can tell you is it works for others, it has been tested to work on a fresh install... so either you did something wrong or perhaps it is conflicting with something (though I can't imagine what with the images you're talking about).
Is this compatible with Glen's Categories Dressing contrib?
Thanks,
Tinman
beats me. There are so many contribs out there that its impossible for the authors to maintain a list. The only person that can find out is you. Download both packages and look at them... any files in common? If yes, then it will NOT be compatible without a little work - you have to go through both and find what's different and merge them carefully. Hopefully, if they are both well written it will be easy to find the blocks of code for that module. If no, then it doesn't mean they WILL work together, but no harm in trying.
Never "try" anything on a live site, and always have backups. Good luck.
- Steven
Incidentally, I've updated this contribution to reflect some changes in 1.3.8 that went previously unnoticed. They aparantly are not crucial as nobody reported any problems, but there were significant updates to the core code so its not a bad idea to update. If updating, you don't have to run the SQL, just copy the files. I've uploaded it to the downloads section, but it may take a bit for it to show up.
- Steven
Steven,
I just tested this mod and it works great under the classic template. Nice to be able to block categories from the search feature.
A couple questions:
Is there a way to selectively have categories hidden depending on some setting for customers? I ask because we sell a line of paper products, but only make them available to our customers local. We don't want people outside of Chicago attempting to order them online (hence your mod is perfect...).
So... How would you suggest I set things up??
Second Question:
I tested your mod using Jade's Horizontal Dropdown Menu, and Apple Template, but something is throwing an error, and not showing the menu. Install is 1.3.8a.
(correct for URL)
chicagophoto <dot> net <forward-slash> apple
If you could point me in the right direction to finding what is causing this that would be a great help! Odd thing is, sometimes it works, sometimes it doesnt' depending on what you click.
BTW. The "chaddro" category is supposed to be hidden. Click home, you see the error. Click chaddro and you get the drop menu and no errors... ???
Gotta love programming!
-chaddro
For your first question... no. Unless you modified the contribution. Its probably doable, but that falls into the "programming for hire" category if you want me to do it.
However... think about it. Unless you REQUIRE customers to be logged in before they can see any products (which is a setting in Zen, but not very user friendly so I doubt many use it) the system won't know who's from Chicago or not until they log in. So you'd still have people outside of Chicago seeing the item, they just can't order it... is that what you want? But then it has nothing to do with this contrib. See what I mean? If you do require shoppers to be logged in to view your store, then it could work. But I think (my opinion) would be best is forget this mod for that... make a new mod that instead disallows checkout for certain items based on location and have a note in the product page saying "for local customers only" or something like that. Not an easy mod to make, but certainly possible.
2nd question... when it comes to conflicting mods, sorry... its not something I'm interesting in helping to debug. Too many variables. First thing... remove hideCategories and make sure its not just a bug with their mod that exists anyway.
- Steven
I have a question is there a reason why that when I try to download the new version of hideCategories it just opens in my browsers and does not download as a zip?
ok it only happens in firefox
is it possible to only hide the categories untill a customer logs in
Yes, browser issue. I think the admin is repackaging it as a zip. You can right click and choose "Save Target As..." and it will work.Quote:
Originally Posted by colemanpa
Possible, sure.Quote:
Originally Posted by CnTGifts
As is said in the readme and above in this thread... it is what it is. If you need it to be something else, either modify it or pay someone (me if you catch me at a down time) to do it for you. It was developed for a specific purpose and the company that paid for it was kind enough to have me release it back to the public... whether or not it suits you as-is is for you to decide.
Now, to possibly save you time and/or money... if you want to hide EVERYTHING from customers until they log in, that's already built into ZenCart. But if you want specific categories hidden until a customer logs in... you're up the right alley... it would be this mod, but changed. Actually shouldn't be too hard to do, and maybe someone would be willing to make that change for you au gratis. I don't have the time right now (for freebies or otherwise) though, sorry.
- Steven
yeah i dont want everything hidden, just the categories
Is it possible to hide a category from general customers - but make it visible to groups with this? I'm wanting a way to hide Consultant supplies from the general customers, but make them available for purchase to my Consultants. I have the Consultants set up for group pricing.
Here is the site I'm working on:
http://www.undertherainbow-gifts.com
I want the Consultants and Distributors to be able to view and purchase marketing and sales supplies without the general customers seeing it.
Read above... same answer. Yes, its possible but not as-is - it has to be modified for that purpose.
- Steven
Do I need to sit down before I ask you what you'd charge for this modification? :lookaroun
i just installed this and somehow, it removed all my category annd prodyct meta tags
Sorry, I didn't see this until now. Contact me via PM for custom coding requests... however, I'm not really taking any projects on right at the moment as I'm far too busy.Quote:
Originally Posted by Ralyn
That is very unlikely.Quote:
Originally Posted by CnTGifts
- Steven
So I read the readMe carefully, ran the SQL in ZenCart admin (then in mysqladmin to make sure), edited the category I wanted to hide by choosing "hidden" and then logged on to my shop.
Problem is, I can still see the category in the categories list and in the parent category's contents.
I hope I'm being stupid but only if someone can point out exactly why. Any help would be much appreciated.
yes, i also want this to work in my site wherein there are categories where are hidden to public.Quote:
Originally Posted by Ralyn
thankz
You were right not to respond Mr Mack ... I had three problems you see:
1. My template was not YOUR_TEMPLATE
2. Version 1.3.0.2 does not have the function zen_get_new_date_range() ... I commented it out
3. In reference to point 1 ... I am a tool
It works, it's good
Good to know ;)
Incidentally... I wasn't ignoring you. I try to respond to every post (at least the ones that I can think of a reasonable response to) but I've always had a problem with this zen-cart.com site NOT NOTIFYING ME when there is a reply to a thread I am subscribed to. Sometimes I get them (like this time) but sometimes I don't (like your original post).
- Steven
I installed the mod but I can't find anything in the admin to turn it on? I re looked it over and I changed all the my_template folders and ran the sql file so I don't understand, is anyone else had this problem, and where in the admin should it be? any help would be great.
HI There
installed and working fine BUT
the "hidden" category still appears in the TOP menu underneath the image logo? Have i missed something? On 1.38
thanks
Quote:
Originally Posted by colemanpa
A little reading goes a long way. Colemanpa, your answer is in the readme file. David, yours is in this thread somewhere because I know I answered it before... its also in the readme less directly under "Limitations". The site I developed it for doesn't use that top menu so it wasn't part of the contrib.Quote:
Originally Posted by davidandrews
- Steven
I apologise , shouldn't run in the way I do!
Love the contribution, and the community appreciate your work, thankyou
I'm curious in adding this feature... how did you go about making the categories hidden from the other menus? is there a file thats referenced for that top menu?Quote:
Originally Posted by s_mack
I honestly don't know. That's the inherent problem with this contribution is that everywhere you want to hide the categories from has to be dealt with individually. When I first started the project, I remember thinking I could probably do it at some higher level, and the trickle down effect would have it hidden from everything with one bit of code. But it didn't turn out that way and it had to be done individually.
Go through the readme for tips and look at the code in the files I've provided to get an idea of how its done and see if you can find where the code for the upper menu is and hide it in a similar fashion.
Its probably pretty easy. And if I was bored with nothing to do, I'd likely take a look at it. But right now I'm so busy that even if you told me you'd pay me $1000 I'd have to pass. Ok, well... maybe not $1000 :) But any reasonable amount I'd have to pass on.
Sorry I can't help more than that.
- Steven
Quote:
Originally Posted by s_mack
I would like to thank-you for the Mod, it solves some of the challenges I was facing.
I created a fully hidden category and have found that those items still show in the 'New Products Center Box' Does anyone know of an easy way to hid items from there?? I notice above it says it excludes them from the side box, but doesn't mention the center box.
any thoughts??
Geoff
--
www.thefoxworthystore.com
tips are in the readme.
Hi Steven,
Great Contrb. Works great since I offer custom made to order products. This gives me the way to put together a special product quantity discount, color or what have you and then send an email with a link letting the customer purchase using their CC via the internet.
One question is there an easy way to get the URL of the hidden product. Right now I make the product and then look for it with out hiding it. copy the url in the browser and save it and then hide the product.
Just wondering if there is an easier way.
Thanks RJ
well, yeah... the url's for your product always follow the same pattern. Go to any of your products, and the URL will contain the product ID. The product IDs of your various products are shown in your admin section. So if you know the product ID then making a link should be easy from there. Your way works too :) Other than that... no, I guess not.
- Steven
Thanks Steven,
Now I do have a problem. I have check and double checked and I do have all the files in place. I get this
Fatal error: Call to undefined function zen_get_generated_category_path_rev() in /home/rjfinewo/public_html/store/includes/modules/iC_AcadameV1.2/product_listing.php on line 171
This is on catagorie page. When you click on the catagory you get this.
Try this http://www.rjfinewood.com/store
Help!!
It is working now.
I downloaded the 1.10 version for 1.38. I have 1.37 installed. The newer product_listing.php did not work in 1.37.
One other note the file in includes/template/your template/sideboxes/tlp_catagories had to be merge together with the one that was used for the template that I am using. This was done to keep the formating.
Again I want to say this is a great!! mod. :clap:
RJ
Thanks for this mod. Perfect for what we require. The only (small) issue I have is that it seems to have added a <br> tag after each list item on the categories menu. Where can I remove this?
Thanks!
Hmm... odd.
The readme file contains a list of all the modified files. You can compare each to the original and try to see where that's being introduced. I'm sorry I haven't looked at the files in a very long time now so I can't say off the top of my head where that behavior is coming from. I can't say for sure its my contrib doing it, but I can't say its not either. I'm just too busy with work right now to look it up for you. If you find it, please post.
- Steven
ok i have merged the files that need merging, uploaded all files and re checked and when i go into admin area under cat/pro then add a new cat or edit one i do not see the option to hide.
I ran the sql and two items were sussfull.
What am i missing?
i am on the latest version 1.3.8a
So do i need to change anything now with this update or do i still need to add my prfix somewhere?Quote:
Originally Posted by MOTAS
give it a try. you haven't provided any information that lets anyone help you. To the question, "what am I missing"... the obvious and only answer is "whatever you're missing".
Read the readme carefully, go over this forum carefully... it obviously works for most people so just go step-by-step.
Good luck.
OK everything is installed, every file is in its correct location, sql patch is installed and sussful.Quote:
Originally Posted by s_mack
When i login to the admin page....goto cat/products and add a new cat and go to edit it, there is no option for hinding the cat and when you are at the root of cat/products you dont see any change here as well.
if you want to login and take a look let me know, (send PM)
Thanks,
Daniel
Its rather simple. If you aren't seeing the option where it should be then everything isn't installed, not every file is in its correct location, or the sql patch didn't install successfully.Quote:
OK everything is installed, every file is in its correct location, sql patch is installed and sussful.
Sorry to make a presumption here, but judging by how carelessly you write your messages ("sussful", "hinding") it seems to make sense that you're reading the instructions much the same way. Not trying to be insulting, but also not really in the habit of wasting my time.
Read through it carefully. If you are 100% certain you've done everything, then ok - it won't work for you for some unexplained reason. If its a conflict with another mod you have, then there is nothing that I can do anyway.
Regardless, keep in mind this is a free contribution offered as-is without warranty (actually, I suppose since its free I can give you your money back). It works. It works rather well. Its not perfect and I suppose it won't work for everyone.
you will have to pardonnnnn my typeing as i am connected thru my cell phone. and i understand about free...............ALL I WAS DOING is what everyone else here does and ask for advice NOT STUPID smart comments.
We have a developer and he is looking at the mod and yes we have others that work fine SO yes there may be a conflict.
All that needed to be said was I (YOU) dont know of any issues that would cause this and it may just be another mod that could be causing the problem. But no i get the 12 year old reply.
Thanks anyway.
Excuse me, but if you needed me to say something then you should have told me what you wanted me to say. All you said was "it doesn't work". How am I supposed to respond to that? It seems to me that you aren't following the instructions. I said so, wished you luck... and you pretty much repeated it all again: "I did it perfect, it doesn't work... fix it".
So you asked for advice, I gave it (read it again and follow carefully). The only thing left was "STUPID smart comments".
Hello,
I'm running under zc 1.3.7 and I 've some problem with the fully hidden status
because I cant see the not showing products on:
site map
RSS contrib
css menu
Catalog contrib
How can I hide those product from those contrib ?
via the query ?
thanks in advance,
Its in the readme. At least hints are. I was open about that from the beginning that it works for the setup we used and it was never intented to work with every option under the sun, and certainly not other 3rd party contribs. But hints are there for making it work for anything. The problem is that even the core components have different coding methods so the same "trick" won't work with all things so you sort of have to know what you're doing. This is even more true with other contribs because they're almost guaranteed to use different coding techniques.
So there's really no answer for you here. Just a "good luck". If you aren't familiar with PHP you'll probably have to pay someone, as you are looking for custom coding.
- Steven
Uhg. I install the contrib, and I create the new table in the database.
When I edit a category, I see the new options to Hide that category...
But when I put a category like "hide", the category does not change, and it can sees in the menu.
No mistake its produced, simply the category does not hide.
I use 1.3.8a.
What can happen?.
Sorry for my mistakes in the text, I´m spanish and my english is very poor.
Do you have any other contribs that modify the menu? Also, which menu? I never used the top menu bar so it does show there (and that is mentioned in this thread). It only hides from the side menu.
- Steven
I installed this module and it was exactly what I was looking and it all worked great until I started editing the css id's and classes. I can only assume that this module works in tandem with the id and classes so I have one question.
Which id's are they and where can I edit this in the module files so it starts working again?
I like working with a set css format ie:
wrapper
container
header
left
right
footer
etc. etc.
And ZC is not built like this, way too many id's and classes for my liking, so I had to change it not realizing it would affect this module.
A little help or point in the right direction would help.
Thanks in advance.
That's the problem with contribs... any contribs... that have to touch core files or tempate files. Just look at all the files that were incuded with the contrib, and use a tool like WinMerge to compare them to the ORIGINAL files. Then compare them to the css files you altered and try to pick out what happened. Its probably the template files in this contrib you have to look at, but not necessarily only those. Because Zen is a collaborative effort, they don't have consistent coding all the time so you may have to do different things in different places to achieve the same resuts.
Good luck!
- Steven
So true.Quote:
Originally Posted by s_mack
I did go through and figured out the problem. I had replaced the sidebox template that included the hideCat functionality. Now all is well. So changing the id's and classes really did not do much. Though I did not get rid of any id or class that was generated by ZC so that helped I think.
Thanks for the quick response.
Hi -
I'm having an issue with this. I've installed the files properly, as directed, and the SQL query runs fine. however, when I go to edit any category, I'm presented with this message:
1146 Table 'databasename.TABLE_HIDE_CATEGORIES' doesn't exist
in:
[select visibility_status FROM TABLE_HIDE_CATEGORIES WHERE categories_id = 4 LIMIT 1]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.
Now, I've gone through phpMyAdmin and dropped the table, and hand-built the table myself to no avail. I dropped the table again and ran your query directly through phpMyAdmin. the table IS indeed there, but so is the error in the admin area.
I cannot find a reason why it won't recognize th table is there - I can see it, and it's just as it should be - yet it won't let me do anything.
Have any ideas for me?
...and for the record, I've been doing more searching on this issue, and I see it's been a problem before. However all stated solutions (adding the "TABLE_PRODUCTS..." stuff) have already been added to the latest release - and it's not working. It's really strange. So just so you know I'm not posting just ot post (and I haven't done searches) - I have, and even googled it as well. All possible solutions I've found have been tried - yet here I am...so any help would be appreciated. Thanks!
Is that the exact error?
it actually says "databasename.TABLE_HIDE [etc etc]"?
Or you replaced your database name with "databasename"?
I replaced my actual database name with the word "databasename".
First of all thank you so much for this module! I installed it and it worked great! I am now in the process of creating a product for a category hidden when I chanced upon a google search and found that the category I hid was listed on google?
I suppose I should put something in the robot.txt to prevent the spider from collecting data on the category?
Yeah. There was nothing in the module to hide it from spiders. Probably getting it from your sitemap or something... or just nabbed it before you hid it? Obviously the pages are still valid HTML pages so Google won't know you intended to hide it.
Is there a way to prevent the spider from picking up the data? e.g specifying it in robot.txt...(though not sure how to do this)
Yes, I would think that would work. Can't really help you with that thought. Probably best to do some searching on Google for something like "robots.txt dynamic pages" or something like that.
i can seem to get hide categories to work with expanded_category_list_1-01 or any other catagory sidebox
I suppose the obvious answer then is to not use those modifications. or don't use this one.
Hi, i'm trying to use this interesting mod.
I want to hide some category, but i want to let user search into hide categories or into real category
For example, i've 2 different way to let user find a product:
From category sidebox menu or from different tipe of category, but i don't want loading them every time into sidebox so i'm trying to use this mod; or from advanced seach
now i need a second category box or a different advanced search...or a second quick search with category and subcategory selection, to let users searching selecting the hidden category
it's possible?
i have installed this mod with only a few issues.
I have my products set to list as columns (NOT ROWS) but only one column will show up.
Also looks like breadcrumbs is back on even when trurned off in the admin area.
(ie)
1 if i go to a categorie that has sub cats (at the top of the page it has the cat NAME then under that has cat descritpion)
(to fix this - i removed all the cat descriptions)
2 When i click on a sub cat with products. you get the cat NAME (this is fine) but under this you get four items that were not there before.
New Products (MORE)
Product Image
Item Name
Price+
Thanks in advance for any help you can give..
Site www.halloweenspace.com
I uninstalled this until someone can reply with any insight.
So when you go to the site it may look likes its working but again as above i removed this mod.
I installed this and although it shows up in my admin, I can still see the category I've hidden on the front end. Am I doing something wrong? I just went to Catalog?Categories/Product and edited the category that i wanted to hide. I chose "Hidden from main menus" and updated it. The icon for that category shows up as a lighter shade of yellow with a red dot in it, so I assume that was correct. However, on my front end, it still shows up under the category listing.
As a general FYI: I am not providing support. As stated all along, this was made for a certain situation and it may not suit yours. Read the readme (that answers most of the Qs) and post here for PEER support, but do not PM me please looking for help with this. I am way too busy now and in the forseeable future.
In general, if this doesn't do what you want then it is probably better to hire someone (or do yourself) to start from scratch then it is to force this into something it isn't.
- Steven
You probably didn't merge the files correctly. This mod needs to be merged with your admin files, just like it says in the readme. Go back and double check that. There are a few to merge in. Easy way to do this is to use WinMerge. It is free, there are others, that may be better, but that takes care of that.Quote:
Originally Posted by fright-rags
Separately, has anyone used this program with Google sitemaps? I noticed that my hidden cats are still in my sitemaps and want to mod that mod to not do that with the hidden cats.
Thanks, Matt
Hey There,
Your mod might be just what I'm after..
However, I noticed one of the files overwritten is the categories sidebox, which might cause a problem with the store I'm thinking of using this module on, because I'm using the yahoo AJAX category tree module.
Thanks for this one.
I'm just wondering if someone knows if I can keep a category in the categories sidebox but exclude it from the best sellers sidebox?
I apologise if this has been asked before, I've been unable to find a way to remove a category from the best sellers sidebox.
I had the same problem, it was working fine in the Admin but nothing happened on the site. It's a simple mistake... Where the folder name is YOUR_TEMPLATE, you have to make sure that those files and folders end up in your specific template folders. Once I had the files and folders where they belong, everything worked perfectly. I'm very impressed. This is a nice mod and the ReadMe file is very well done.
if you need to remove this mod, the instructions in the read me file says just undo the changes. This is not true. My store has required a lot of work to remove it. Avoid unless you have lots of time on your hands especialy as the designer seems less than helpfull.
:frusty:
Hmm... there's only one thing I can say to that.
JERK!
"less than helpful" my ######. I stated from the beginning that I designed it for a specific purpose and support wouldn't be given. There is an expectation that if YOU are modding YOUR site that YOU know what YOU are doing. It certainly isn't my fault that you can't follow directions or figure out things on your own or understand PHP. It very much IS as simple as reversing what you did.
Dumbass.
Understanding PHP????????????? reversing what you did?????????? Yupp that's all good Dumbass!
Provided that you have a working knowledge of PHP. My comment was aimed at the support that you give which as you stated is "NONE". If you do not have a working knowledge of PHP then as I stated it takes a bit of work to remove as you have edits in some of the core files. Therefore if you already have modified your zencart a simple re-tracing of your steps is not possible for the novice as it also includes some modifications to global templates if again you have modified your templates too.
So a simple re-trace your steps is not possible. :P
Sorry if I upset you Dumbass!
Your lack of appreciation for a community which provides FREE software is what upsets me.
Of course a simple re-trace of your steps is possible. If you don't know what you're doing then proceed with caution and keep backups until you figure out what you're doing. That's not advice for my mod, it is for any mod. But bashing me for not holding your hand is ludicrous. Go pay someone and stop yer bitchin.
Hi, thrilled I found this mod by chance as it solves a problem I've been mulling over for days!
OK I'm no techi, but I've installed a couple of things on ZC already and managed to get them working.
I've looked through the entire thread, and tried the suggestions relating to tables not existing and descriptions, but I still get this error in the store. I've checked that I merged the files twice.
Looking at the error it might be to do with the Bestseller box? And the error appears where a sidebox would go. Sorry to sound stupid but this is the first time I've done anything involving the 'install sql patches' (seemed to work though, said it was successful).
1146 Table 'jasweene_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]
Anyone spot any glaringly obvious errors I've made to cause this?
Thanks in advance
Adele
I have this same problem. I removed the bestseller box files since I do not use the best seller box on my site. It worked after that.Quote:
Originally Posted by webwahm
I still have a few things to figure out though.
In the readme, there are hints on how to edit sideboxes so that it works. There was no way to make the package work with every possible configuration, sorry. I'm not going to look at this code any more because once the new version of zen comes out it will be done in a completely different way.
Steven
s_mack I have a question for you that is very important.
I have uploaded all the files correctly, that I am sure of.
We have a pricegrabber page, and we want all the pricegrabber prices to go to the hidden product pages that have a discounted price.
For some reason, all our discounted prices are showing up on the products listing page. For instance, if you click adobe, you can see our regular price, and the discount price listed.
The category is set to hidden in the admin, and i've not had any issues except for this one.
Please let me know what I can do ASAP, or we will have alot of unhappy customers!
www.baselinesoftware.com
Thanks!
can anyone help?
Steven,
Just to let you know thank you so much for creating this mod. This mod is what exactly what my client need for his store. I installed and everything is great, works great.
For those who had sidebox mess up... try to look for the answer in the coding.
Because I figured out myself.
does anyone know how to make this mod work properly when working along side the "categories Dressing" mod?
All files merged with winmerge and site functioning properly. I have the hide options in admin category edit, but they still appear in the category tree menu.
I'm using the latest version of Zen Cart with several addons. This hidden category with products accessible only by password should work with any version.
I have come up with a pretty simple answer to something that may be of interest to several of you out there. I have set up an “Invisaible” category with “invisible” products (invisible to the casual visitor/customer). I can e-mail a password and/or user name to any number of individuals giving them access to the hidden product or products. They have access to the normal checkout procedures. The method also uses “cookies” so they don’t have to log in again if going from page to page. They will have to log in to your store site in order to check out, however.
Not sure this is what a number of you are looking for, but if you are interested (my information is free!), e-mail me at [email protected] and I’ll send you my instructions (14 steps) and supporting info.
:D
Nice! Curious though... did you modify my contrib or you came up with a new one entirely?
Love this mod Steven. This is exactly what I needed for my site.
Like a couple others on this thread, I use the top category tab and wanted a way to hide the categories there as well. I came up with this solution that is working for me....
copy: /includes/modules/categories_tab.php
to: /includes/modules/YOURTEMPLATE/categories_tab.php
around line 31, replace the code:
PHP Code:$categories_tab_query = "select c.categories_id, cd.categories_name from " .
TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd
where c.categories_id=cd.categories_id and c.parent_id= '0' and cd.language_id='" . (int)$_SESSION['languages_id'] . "' and c.categories_status='1'" .
with new code:
This adds an argument to the query to check the visibility status and hide any category that is not set to normal.PHP 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'" .
As with another post I read in this thread, this does require that all of your categories have a hide_categories value in the database. The other post noted this could be done through editing the database to add the value. Being a novice, I don't like to directly edit the database and found a different solution. For new categories, or categories that were created before installing the hide mod, edit the category to be hidden, save, then re-edit to normal. This creates the record needed in the database.
Hope this helps.
Great addition! Thanks Bumpspt.
This is the mod I have been looking for! I have installed (run the scripts and copied the files to the server) it but there is a little problem. After I edited the category to be "Hidden", in the admin panel the folder icon changes to a lighter colour, however, in the storefront the category is not hidden. I am using v1.3.8.
Appreciate your help :smile:
./includes/templates/YOUR_TEMPLATE/templates/tpl_products_all_default.php
does YOUR_TEMPLATE means the name of my template? does it need to be changed for the mod to work?
Thanks
yes! that was my problem!
After pulling hair for 2 days, self-resolved :D
Nope. This is something I came up with. I didn't realize anyone else had made any inroads on the problem until I logged on to post my update. I use two freeware downloadable scripts and made them work. Don't have to do anything at all to any of the Zen Cart files.
Keep up the good work, all!
Ron