OpenCart Community

Created vqmods for random latest, featured, bestsellers, and specials using the new no-strain method

What does "no-strain" mean?
Normally items are randomized by using the "rand()" mysql command. The problem with this is that the more products you have, the more items that must be randomized on the database. If you have a lot of products, it puts a large strain on the database having to randomize them all first, then only grabbing 10 of them.

So this mod uses a better method. It will pull more than the limit set and randomize them with php which is much faster and less intensive. Then return only the limit requested. Removing strain from the database.

UPDATED WITH 2.X and 2.3.x SUPPORT

Updated the files to support 1.4.x and 1.5.x

Great addition, thank you very much.

can u please tell me where to upload this xml file to get it working?

tunnu wrote:can u please tell me where to upload this xml file to get it working?

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

Best sellers mod not working on 1.4.9.4. i want to show random products as best sellers, because i dont have any products sold in my site as the site is new.

just 1 product is coming up in bestsellers. Instead, i need to show many products randomly, purchased or not purchased

tunnu wrote:Best sellers mod not working on 1.4.9.4. i want to show random products as best sellers, because i dont have any products sold in my site as the site is new.

just 1 product is coming up in bestsellers. Instead, i need to show many products randomly, purchased or not purchased

Bestseller products are exactly that "bestsellers". If you haven't sold anything, nothing will show in the bestsellers module.

How to show random products on 1.5.1. without vqmod?

Ok, had to try before asking- that was easy...

Hi.

Just to be clear I have installed VQMod (working) and amaware where to place the xml files thanks to clear instructions on other posts.

My question is fairly simple, I believe I may have missed the point of this mod - correct me please if I am way off but this mod is designed to randomise the pull of the featured products from the db - using the list as populated in the admin section in the backend.

However - despite my searching and checking I can find no relevant input in the admin that allows me to limit the number of items per random page pull - for instance : if I choose 30 products to 'feature' I would expect some form of requester to limit the items per page (in a similar fashion to specials) otherwise the random nature of the pull would only usefully be to affect the ordering?

It is of course highly likely that I need to do some extra coding work to alter the sql query in the first place - however it is my understanding that the VQMod xml is designed cleverly to circumnavigate that nessecity?

Would it be possible to some kind person to indicate how one can achieve the limitation of the 'displayed' number of featured items within the product pull? Also - is there an acceptable way to prove that VQMod scripts are being imlpemented? Just in case mine is not actually working as expected!

Open Cart Version: 1.5.0
Mods already installed: VQMod - Price Redux & (Non VQ Mod) Showcase Pro.
Link to cart: http://www.bantastic.co.uk

Ok I went off and figured out how to use vQmod instead

Brilliant! Added a new function to the model and an update to featured on the fly.
Wow. Just Wow.

sitesurfer wrote:Ok I went off and figured out how to use vQmod instead

Brilliant! Added a new function to the model and an update to featured on the fly.
Wow. Just Wow.

Can you tell me what did you do? I have the same problem. Thanks

gamersmarket wrote:

sitesurfer wrote:Ok I went off and figured out how to use vQmod instead

Brilliant! Added a new function to the model and an update to featured on the fly.
Wow. Just Wow.

Can you tell me what did you do? I have the same problem. Thanks

I think I have found it: http://forum.opencart.com/viewtopic.php ... ed#p192834

fido-x wrote:

tunnu wrote:Best sellers mod not working on 1.4.9.4. i want to show random products as best sellers, because i dont have any products sold in my site as the site is new.

just 1 product is coming up in bestsellers. Instead, i need to show many products randomly, purchased or not purchased

Bestseller products are exactly that "bestsellers". If you haven't sold anything, nothing will show in the bestsellers module.

buy something from your own store...
maybe..

Perfect!

It worked perfectly in version 1.5.1.3.1

Thank you for sharing.

Hugs.

Works fine on 1.5.1.3 but I want to limit the list of Featured. How I do it?

idan wrote:Works fine on 1.5.1.3 but I want to limit the list of Featured. How I do it?

I want the same feature.

i devided do develop this mod, if you want:
http://www.opencart.com/index.php?route ... order=DESC

limit field for featured module added to 1.5.2

hellow...
works for me...many thanks:)

using OC 1.5.3.1