Post by spitos » Tue Aug 23, 2011 8: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 ... on_id=3444
Last edited by spitos on Tue Oct 04, 2011 9:46 am, edited 3 times in total.

Image
Google Analytics Expert - Advanced e-commerce tracking, Product & options reporting, transaction/conversion reporting, Google Adwords conversion & profit reporting, goal & funnel reporting, event tracking, site search tracking, multi-store compatibility, EU Cookie Law compliance and works with any theme or checkout! Easy vqmod install. Get it here


User avatar
Active Member

Posts

Joined
Mon May 23, 2011 6:19 pm
Location - UK

Post by RitchieTheBrit » Tue Aug 23, 2011 7:12 pm

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.


Posts

Joined
Sun Apr 10, 2011 5:44 am

Post by hcorobert » Mon Aug 29, 2011 12:54 pm

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

Newbie

Posts

Joined
Mon Aug 29, 2011 8:31 am

Post by cantykiwi » Mon Aug 29, 2011 1:18 pm

Try here:- http://forum.opencart.com/viewtopic.php?f=23&t=24529

Everything you could ever want to know about vQmod ;)

New member

Posts

Joined
Mon Sep 13, 2010 12:37 pm

Post by uksitebuilder » Mon Aug 29, 2011 4:58 pm

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.

User avatar
Guru Member

Posts

Joined
Thu Jun 09, 2011 11:37 pm
Location - United Kindgom

Post by spitos » Tue Aug 30, 2011 3:37 pm

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.
Last edited by spitos on Tue Oct 04, 2011 9:54 am, edited 3 times in total.

Image
Google Analytics Expert - Advanced e-commerce tracking, Product & options reporting, transaction/conversion reporting, Google Adwords conversion & profit reporting, goal & funnel reporting, event tracking, site search tracking, multi-store compatibility, EU Cookie Law compliance and works with any theme or checkout! Easy vqmod install. Get it here


User avatar
Active Member

Posts

Joined
Mon May 23, 2011 6:19 pm
Location - UK

Post by mkh » Tue Aug 30, 2011 4:29 pm

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

mkh
New member

Posts

Joined
Fri Jun 24, 2011 1:55 am

Post by spitos » Tue Aug 30, 2011 4:43 pm

Do you have other mods installed?

Image
Google Analytics Expert - Advanced e-commerce tracking, Product & options reporting, transaction/conversion reporting, Google Adwords conversion & profit reporting, goal & funnel reporting, event tracking, site search tracking, multi-store compatibility, EU Cookie Law compliance and works with any theme or checkout! Easy vqmod install. Get it here


User avatar
Active Member

Posts

Joined
Mon May 23, 2011 6:19 pm
Location - UK

Post by mkh » Tue Aug 30, 2011 4:46 pm

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

mkh
New member

Posts

Joined
Fri Jun 24, 2011 1:55 am

Post by spitos » Tue Aug 30, 2011 4:53 pm

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

Image
Google Analytics Expert - Advanced e-commerce tracking, Product & options reporting, transaction/conversion reporting, Google Adwords conversion & profit reporting, goal & funnel reporting, event tracking, site search tracking, multi-store compatibility, EU Cookie Law compliance and works with any theme or checkout! Easy vqmod install. Get it here


User avatar
Active Member

Posts

Joined
Mon May 23, 2011 6:19 pm
Location - UK

Post by mkh » Tue Aug 30, 2011 4:58 pm

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

mkh
New member

Posts

Joined
Fri Jun 24, 2011 1:55 am

Post by spitos » Tue Aug 30, 2011 5:09 pm

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?

Image
Google Analytics Expert - Advanced e-commerce tracking, Product & options reporting, transaction/conversion reporting, Google Adwords conversion & profit reporting, goal & funnel reporting, event tracking, site search tracking, multi-store compatibility, EU Cookie Law compliance and works with any theme or checkout! Easy vqmod install. Get it here


User avatar
Active Member

Posts

Joined
Mon May 23, 2011 6:19 pm
Location - UK

Post by mkh » Tue Aug 30, 2011 5:15 pm

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

mkh
New member

Posts

Joined
Fri Jun 24, 2011 1:55 am

Post by spitos » Tue Aug 30, 2011 5:29 pm

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

Image
Google Analytics Expert - Advanced e-commerce tracking, Product & options reporting, transaction/conversion reporting, Google Adwords conversion & profit reporting, goal & funnel reporting, event tracking, site search tracking, multi-store compatibility, EU Cookie Law compliance and works with any theme or checkout! Easy vqmod install. Get it here


User avatar
Active Member

Posts

Joined
Mon May 23, 2011 6:19 pm
Location - UK

Post by mkh » Tue Aug 30, 2011 5:36 pm

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 22127 times


mkh
New member

Posts

Joined
Fri Jun 24, 2011 1:55 am

Post by jomeza001 » Wed Aug 31, 2011 1:57 am

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

User avatar
Active Member

Posts

Joined
Tue May 17, 2011 10:55 am

Post by spitos » Wed Aug 31, 2011 2:11 am

To enable sub category display in category module, go to:
http://www.opencart.com/index.php?route ... on_id=3444
Last edited by spitos on Tue Oct 04, 2011 9:48 am, edited 1 time in total.

Image
Google Analytics Expert - Advanced e-commerce tracking, Product & options reporting, transaction/conversion reporting, Google Adwords conversion & profit reporting, goal & funnel reporting, event tracking, site search tracking, multi-store compatibility, EU Cookie Law compliance and works with any theme or checkout! Easy vqmod install. Get it here


User avatar
Active Member

Posts

Joined
Mon May 23, 2011 6:19 pm
Location - UK

Post by jomeza001 » Wed Aug 31, 2011 5:59 am

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

User avatar
Active Member

Posts

Joined
Tue May 17, 2011 10:55 am

Post by spitos » Wed Aug 31, 2011 4:43 pm

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).
Last edited by spitos on Tue Oct 04, 2011 9:48 am, edited 1 time in total.

Image
Google Analytics Expert - Advanced e-commerce tracking, Product & options reporting, transaction/conversion reporting, Google Adwords conversion & profit reporting, goal & funnel reporting, event tracking, site search tracking, multi-store compatibility, EU Cookie Law compliance and works with any theme or checkout! Easy vqmod install. Get it here


User avatar
Active Member

Posts

Joined
Mon May 23, 2011 6:19 pm
Location - UK

Post by mkh » Wed Aug 31, 2011 9:09 pm

Yep, Mike the changes you sent me by email worked here... also the same you listed here on the site...

So a big thanks...

mkh
New member

Posts

Joined
Fri Jun 24, 2011 1:55 am
Who is online

Users browsing this forum: No registered users and 11 guests