hideCategories

[Figster]

I was just wondering, if it would be easier to create a new product type, that it's own rules, than it would be to try and hide a category.. Just a thought.

[peanut77]

Help

I am trying to hide all the products in a category from the search. Th category is invisable so it is not showing up in my menu and I have instaleed the module with no problesm, however the products show up in the search - is there any way to hide these completely so they don't show up in the search.

[s_mack]

Hi folks,
The answer to everything is "yes". You can do that. As I stated in the first post, I made this specifically for our store and its not a contrib I plan to support at all since there's a million things you could want that someone else wouldn't. Its nearly impossible to release this contrib so that it works for everyone. You'll need to modify it yourself to do what you want.

For example the search request: You'll have to find wherever in Zen the search function(s) exist and have them check to see the hidden status of the category before adding any given product to the results. The hard part is finding the appropriate functions. Once you do, it should be fairly easy. Look at the other files included in the package for hints and how I did it.

Obviously, it takes a good understanding of PHP/SQL as well as good level of zen structure knowledge.

Sorry I can't spend the time with individual requests. I provided the basis... I hope you can use it to get where you want to be.

- Steven

[peanut77]

Cheers for your quick reply.

All I need is one category and everything inside this to be hidden.

I kinda presumed this is what the hide category module does? as right now installed on 1.37 it just does exactly the same as changing the staus button to red - is that correct? (or am I being incredibly dumb :-) )

I am reckon I am missing something v.v.v.v basic and I appreciate you don't take requests but as I have only enough php knowledge to allow me to install zen cart I wouldn't even know where to start with functions etc.

Is there anyway you could nudge me in the right direction the only thing I have noticed which may cause it to work as a hide item is there is code in the tpl_products_all file - should this hide code be on all products templates you use?

Sorry to be a pest and thanks for taking the time to reply.

[jettrue]

Help

I am trying to hide all the products in a category from the search. Th category is invisable so it is not showing up in my menu and I have instaleed the module with no problesm, however the products show up in the search - is there any way to hide these completely so they don't show up in the search.

If the module is installed correctly, it shouldn't show up in the search. I had an error with includes/modules/MY_TEMPLATE/product_listing.php, and that caused the producy to NOT be hidden in the search. After I put product_listing.php in the right folder, the product no longer showed up in the search.

[peanut77]

Jettrue

Your a complete and utter star!! that is all that is was - I thought i'd been through everything with a fine toothcomb!!

Thank you for pointing me in the right direction - much aprreciated.

[reza]

HI STEVEN
IT's a great contribution, but there is a problem, when I use css flyout category sidebox or header css flyout, the hidden categories are still showing!!!
do you now how can I solve this problem?
thanks

[tatiana77]

Just wanted to say that I installed this mod tonight and I love it.

Thank you!

Tatiana

[ideasgirl]

I am having problem on the 1.36 ZC.

I got following when I click "New Product",
===
1146 Table 'jun9505_jlcxxxxxx.products_description' doesn't exist
in:
[select count(*) as total FROM jun9505_products p LEFT JOIN jun9505_manufacturers m ON (p.manufacturers_id = m.manufacturers_id) LEFT JOIN jun9505_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_id = pd.products_id AND pd.language_id = 1 ]
===

Note, jlcxxxxxx is the database name, jun9505 is the prefix.
If everything is right, It should looking for Table 'jun9505_products_description'. Any idea on why this happen?

Thanks.

When you put in the included SQL, how did you do it? I've seen this problem come up and this question asked on just about every contrib support forum out there :) I don't know how table prefixes work because mine don't use them (I don't understand why anyone's do)... but the answer always seems to be "input the SQL into phpmyadmin, NOT the SQL tool in your Zen admin!"

Good luck. I'm pretty sure its not a problem with this contrib though.

- Steven

The jun9505 it's not the prefix is the username of your hosting account.

Smack, I tried your solution, and doesn't fix the issue. I think your SQL query is missing a "description" table? I'm not programmer but that's what it looks from my error as well as the previous poster. The system somehow it's looking for a description that doesn't exist on the table???

Again... I really don't know since I'm not programmer but this issue only comes up when I install this module (which I love BTW).

This is my error:

1146 Table 'USER_DATABASENAME.products_description' doesn't exist
in:
[select count(*) as total FROM _zenproducts p LEFT JOIN _zenmanufacturers m ON (p.manufacturers_id = m.manufacturers_id) LEFT JOIN _zenhide_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_id = pd.products_id AND pd.language_id = 1 ]

Is it posible for you or any of the other coder guru look into this?

[s_mack]

Someone else will have to help. I'm really short on time, but more than that... I really just don't get the whole prefix thing as I've never used them... the two that have had problems, it is related to prefixes.

Its not missing a description table. "products_description" exists, but "USER_DATABASENAME.products_description" does not... why your cart is trying to add that prefix is what I don't understand.

I'm sure its not complicated... and I'm sure someone that gets prefixes can answer exactly what you have to do. I've personally never worked with a host that does that. I don't even know why or when prefixes come about. So I can't help. But its not the contrib... or if it is, it is only the contrib on hosts like yours that use prefixes.

- Steven