Page 1 of 5

[vQmod] Remove product count from all category areas

Posted: Tue Aug 23, 2011 8:08 am
by spitos
This will remove the product count next to the category in the header, category module and also category pages. It will also massively reduce page load time on large stores.

There are now two versions of this vqmod.

Please visit the extension page for details:
http://www.opencart.com/index.php?route ... on_id=3444

Re: [vQmod] Remove product count from all category areas

Posted: Tue Aug 23, 2011 7:12 pm
by RitchieTheBrit
Nice one!

I completely forgot about the item count ont he actual category page. Handy having it in one file as well, I split the module and mene changes into two in case for some reaosn I required one of them on.

Re: [vQmod] Remove product count from all category areas

Posted: Mon Aug 29, 2011 12:54 pm
by hcorobert
Sorry if this is a dumb question, but how is this used? I tried uploading the file you posted and accessing it via my browser, but that did nothing. I'm sort of a newbie. :-[

Re: [vQmod] Remove product count from all category areas

Posted: Mon Aug 29, 2011 1:18 pm
by cantykiwi
Try here:- http://forum.opencart.com/viewtopic.php?f=23&t=24529

Everything you could ever want to know about vQmod ;)

Re: [vQmod] Remove product count from all category areas

Posted: Mon Aug 29, 2011 4:58 pm
by uksitebuilder
Hi Spitos,

Does this stop the actual queries from being run ?

If so this will be great for stores with a large amount of categories cutting the overhead and page load time down dramatically.

Re: [vQmod] Remove product count from all category areas

Posted: Tue Aug 30, 2011 3:37 pm
by spitos
Hi Simon,

I've just updated the xml files with the changes to fix speed issues for large stores.

It now loads the pages soooo much quicker than before!!

Would you believe that it took over 18 seconds to load one of the main category pages!? With these changes it now takes less than 2 seconds!

I was struggling to find a resolution for the speed issues due to the massive (well over 150k and growing) categories & sub categories we currently have on the store but your prompt has sorted that out and I can move on.

Re: [vQmod] Remove product count from all category areas

Posted: Tue Aug 30, 2011 4:29 pm
by mkh
Hmm, when i try to use this mod i get a 500 server error? any ideas... I'm running the latest vqmod and oc 1.5.1.1

Re: [vQmod] Remove product count from all category areas

Posted: Tue Aug 30, 2011 4:43 pm
by spitos
Do you have other mods installed?

Re: [vQmod] Remove product count from all category areas

Posted: Tue Aug 30, 2011 4:46 pm
by mkh
spitos wrote:Do you have other mods installed?
Yes, and now you say that, I do have the module that hides empty categories... that might be the problem :/

Testet and yep that is the problem :(

And now when it works I can see that I cant use my sub categories...

Re: [vQmod] Remove product count from all category areas

Posted: Tue Aug 30, 2011 4:53 pm
by spitos
Open the two xml files and look at the operations to change the code.
I'm guessing there is a conflict and both files are changing the same piece of code, i've experienced this before with other mods.

You may need to merge or edit the code so that both are being run successfully.

What do you mean by this?
And now when it works I can see that I cant use my sub categories...

Re: [vQmod] Remove product count from all category areas

Posted: Tue Aug 30, 2011 4:58 pm
by mkh
What I mean is when I remove the module that hides the empty cats, then your module work, but I get no sub categories for my products...

Re: [vQmod] Remove product count from all category areas

Posted: Tue Aug 30, 2011 5:09 pm
by spitos
This module only hides the product count from the categories and sub categories, it doesn't hide the sub categories from showing themselves.

I have this working for me and sub categories display fine, what happens if you remove both of the extensions?

Re: [vQmod] Remove product count from all category areas

Posted: Tue Aug 30, 2011 5:15 pm
by mkh
If I remove both mods the product module works normal, when I use your module I cant access my sub cats and if I use both mods I get the error.. maby I need to say the cat module is added to the left side..

Re: [vQmod] Remove product count from all category areas

Posted: Tue Aug 30, 2011 5:29 pm
by spitos
So your sub-categories categories don't show ONLY in the category module on the left?

Re: [vQmod] Remove product count from all category areas

Posted: Tue Aug 30, 2011 5:36 pm
by mkh
Yes, I only have sub categories in the category module, the topbar has been edited to use hardcoded links.
screenshot.png

screenshot - screenshot.png (17.27 KiB) Viewed 22126 times


Re: [vQmod] Remove product count from all category areas

Posted: Wed Aug 31, 2011 1:57 am
by jomeza001
Running 1.5.1.1 and just installed this mod. However I have this same problem as MKH. Sub categories don't show on the left. Only Parent categories. Why??

Re: [vQmod] Remove product count from all category areas

Posted: Wed Aug 31, 2011 2:11 am
by spitos
To enable sub category display in category module, go to:
http://www.opencart.com/index.php?route ... on_id=3444

Re: [vQmod] Remove product count from all category areas

Posted: Wed Aug 31, 2011 5:59 am
by jomeza001
Didn't work for me. I applied the code changes above and the result is:

1.- Header categories with no counter (perfect)
2.- Left menu showing categories AND sub-categories (perfect), but both with Counters :(

I think the goal is to disable ALL the category counters and stop the Counters Query, but still show Child Categories where they should be displayed (left menu).

Re: [vQmod] Remove product count from all category areas

Posted: Wed Aug 31, 2011 4:43 pm
by spitos
Ah okay, MKH said that it solved the problem for him.

I'll try and have a look at it later today and find a resolution, in the meantime please test out the changes by manually editing the category module file to ensure there are no conflicts going on (you should revert these if it doesn't work).

Re: [vQmod] Remove product count from all category areas

Posted: Wed Aug 31, 2011 9:09 pm
by mkh
Yep, Mike the changes you sent me by email worked here... also the same you listed here on the site...

So a big thanks...