Community Forums

by **spitos** » Tue Aug 23, 2011 12:08 am

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=extension/extension/info&extension_id=3444

by **RitchieTheBrit** » Tue Aug 23, 2011 11:12 am

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.

by **hcorobert** » Mon Aug 29, 2011 4:54 am

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. :-[

by **cantykiwi** » Mon Aug 29, 2011 5:18 am

Try here:- viewtopic.php?f=23&t=24529

Everything you could ever want to know about vQmod

by **uksitebuilder** » Mon Aug 29, 2011 8:58 am

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.

by **spitos** » Tue Aug 30, 2011 7:37 am

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.

by **mkh** » Tue Aug 30, 2011 8:29 am

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

by **spitos** » Tue Aug 30, 2011 8:43 am

Do you have other mods installed?

by **mkh** » Tue Aug 30, 2011 8:46 am

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...

by **spitos** » Tue Aug 30, 2011 8:53 am

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...

by **mkh** » Tue Aug 30, 2011 8:58 am

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...

by **spitos** » Tue Aug 30, 2011 9:09 am

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?

by **mkh** » Tue Aug 30, 2011 9:15 am

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..

by **spitos** » Tue Aug 30, 2011 9:29 am

So your sub-categories categories don't show ONLY in the category module on the left?

by **mkh** » Tue Aug 30, 2011 9:36 am

Yes, I only have sub categories in the category module, the topbar has been edited to use hardcoded links.

: screenshot; screenshot.png (17.27 KiB) Viewed 8586 times

by **jomeza001** » Tue Aug 30, 2011 5:57 pm

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??

by **spitos** » Tue Aug 30, 2011 6:11 pm

To enable sub category display in category module, go to:
http://www.opencart.com/index.php?route=extension/extension/info&extension_id=3444

by **jomeza001** » Tue Aug 30, 2011 9:59 pm

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).

by **spitos** » Wed Aug 31, 2011 8:43 am

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).