hideCategories

[Boggled]

Lori,

I don't know if this will help in your situation at all, but I'll mention it here just in case it might help someone else.

I sell on eBay and direct my customers to my website to pay via credit card.
I enter the auction item in a completely hidden category using the eBay item # as the model #. They can only put it in their cart by typing in the eBay item # on our eBay Auction Checkout page (quick order mod).

I was running into the problem of non-eBayers still finding these items and buying them since the 'add to cart' button was showing and active.

I discovered I could mark these items 'call for price' (but still enter a price) and no Add to Cart button would show. I replaced the 'call for price' button with a 'sold on eBay' button and the text to say 'already sold, etc.'

This has completely done away with 'accidental' purchases. The item still shows up in 'Others who purchased this' and my 'What's New' box, but even if they click on it, they can't buy it.

If anyone wants to see how it works, just go to my Driftwood site, enter 1234 for the item # and add to cart.

The cart is live, so please don't actually buy it!

HTH

[redheads]

Lori,

I discovered I could mark these items 'call for price' (but still enter a price) and no Add to Cart button would show. I replaced the 'call for price' button with a 'sold on eBay' button and the text to say 'already sold, etc.'

hey, I like this idea, thanks for posting it -- it might just work... I add the link and item number in the forum and they can quick-order the items to their cart from there. I will play with it a bit and see where it leads!

Thanks! You Zenners are awesome!

Lori

[Boggled]

hey, I like this idea, thanks for posting it -- it might just work... I add the link and item number in the forum and they can quick-order the items to their cart from there. I will play with it a bit and see where it leads!

Thanks! You Zenners are awesome!

Lori

I'm glad to finally get to help someone else instead of being the one begging for help all the time.

Hope it works for you!

[lukemcr]

Quick question, S-mack: by the way, this mod is great.

I've installed hideCategories, but hidden categories are still showing up in the upper category listing, underneath the logo. Everything's fine in the category navigation on the left - hidden categories are staying properly hidden.

During the installation, I only manually modified one file, tpl_advanced_search.php. (I merged the changed hideCategories code with my custom tpl_advanced_search.php.) What files control the upper category navigation hidden settings?

Thanks a lot for the help!

[s_mack]

Yeah... that's why this isn't really a clean mod :) There are potentially dozens of places that one would have to account for in order to hide the categories completely... as mentioned in the ReadMe, I just did the ones we were using - which didn't include the upper links.

I don't know what file controls that upper menu as I've never used it. See if you can find that out (by asking in a general forum or something) and report it here and someone (maybe me) should be able to figure out what code to change.



Ultimately, when I'm less busy, I'd like to re-release this contrib with an as-exhaustive-as-possible set of files... but even then, there will be 3rd-party contribs and such that will need to be modified. In other words... this was destined from the beginning to be a nightmare to support :)

It would be dead easy if the core code made thier population calls differently. If every file in the system called some common function to get the list of categories/items then we'd only have to modify that one function rather than dozens or even hundreds of files.

Oh well.

- Steven

[MOTAS]

I use the table prefixes in my client's cart, because there are other things going on in the database, and had a problem getting this contrib to run out of the box. I found out there is a simple code fix to two files:
./includes/templates/YOUR_TEMPLATE/templates/tpl_products_all_default.php
LINE 24

	$products_all_query_raw = preg_replace('/, ' . TABLE_PRODUCTS_DESCRIPTION . ' pd(\s*)WHERE/', ' LEFT JOIN ' . TABLE_HIDE_CATEGORIES . ' h ON (p.master_categories_id = h.categories_id), ' . TABLE_PRODUCTS_DESCRIPTION . ' pd WHERE (h.visibility_status < 2 OR h.visibility_status IS NULL) AND', $products_all_query_raw);

./includes/templates/YOUR_TEMPLATE/templates/tpl_products_new_default.php
LINE 24

	$products_new_query_raw = preg_replace('/, ' . TABLE_PRODUCTS_DESCRIPTION . ' pd(\s*)WHERE/', ' LEFT JOIN ' . TABLE_HIDE_CATEGORIES . ' h ON (p.master_categories_id = h.categories_id), ' . TABLE_PRODUCTS_DESCRIPTION . ' pd WHERE (h.visibility_status < 2 OR h.visibility_status IS NULL) AND', $products_new_query_raw);

I added the second TABLE_PRODUCTS_DESCRIPTION, which was previously set to 'products_description'. In other words, it was looking for the table named products_description and not DB_PREFIX . products_description.

It was likely just a missed statement. I know someone else in this thread had posted having a problem with this.

hope that helps...
marc...

[s_mack]

Thanks! Missed that one :)

- Steven

[d1rage5]

I use the table prefixes in my client's cart, because there are other things going on in the database, and had a problem getting this contrib to run out of the box. I found out there is a simple code fix to two files:
./includes/templates/YOUR_TEMPLATE/templates/tpl_products_all_default.php
LINE 24

	$products_all_query_raw = preg_replace('/, ' . TABLE_PRODUCTS_DESCRIPTION . ' pd(\s*)WHERE/', ' LEFT JOIN ' . TABLE_HIDE_CATEGORIES . ' h ON (p.master_categories_id = h.categories_id), ' . TABLE_PRODUCTS_DESCRIPTION . ' pd WHERE (h.visibility_status < 2 OR h.visibility_status IS NULL) AND', $products_all_query_raw);

./includes/templates/YOUR_TEMPLATE/templates/tpl_products_new_default.php
LINE 24

	$products_new_query_raw = preg_replace('/, ' . TABLE_PRODUCTS_DESCRIPTION . ' pd(\s*)WHERE/', ' LEFT JOIN ' . TABLE_HIDE_CATEGORIES . ' h ON (p.master_categories_id = h.categories_id), ' . TABLE_PRODUCTS_DESCRIPTION . ' pd WHERE (h.visibility_status < 2 OR h.visibility_status IS NULL) AND', $products_new_query_raw);

I added the second TABLE_PRODUCTS_DESCRIPTION, which was previously set to 'products_description'. In other words, it was looking for the table named products_description and not DB_PREFIX . products_description.

It was likely just a missed statement. I know someone else in this thread had posted having a problem with this.

hope that helps...
marc...

So do i need to change anything now with this update or do i still need to add my prfix somewhere?

[bbsbcastle]

I'm thinking this would be a good fit for a customer. They want a "5-pack" item that wouldn't appear in listings, etc. So far so good.

The question is, do you know if they would we be able to use the Quick Order plugin to directly access the item? We're actually driving the sales on this project by the customer having "Buy 1 Now" and "Buy 5 Now" buttons on their site, which then leads directly to the ZC cart page via QO.