Community Forums

by **Qphoria** » Wed Jan 05, 2011 5:31 am

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.

by **Qphoria** » Thu Jul 28, 2011 7:52 pm

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

by **fsit** » Tue Aug 02, 2011 7:48 pm

Great addition, thank you very much.

by **tunnu** » Sun Aug 07, 2011 1:59 pm

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

by **Qphoria** » Sun Aug 07, 2011 2:25 pm

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

viewtopic.php?f=23&t=24529

by **tunnu** » Thu Aug 11, 2011 2:52 pm

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

by **fido-x** » Thu Aug 11, 2011 3:01 pm

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.

by **peecha85** » Mon Sep 05, 2011 7:22 am

How to show random products on 1.5.1. without vqmod?

by **peecha85** » Mon Sep 05, 2011 7:30 am

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

by **sitesurfer** » Tue Sep 06, 2011 10:43 am

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

by **sitesurfer** » Wed Sep 07, 2011 10:11 pm

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.

by **gamersmarket** » Sun Sep 18, 2011 6:52 pm

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

by **gamersmarket** » Sun Sep 18, 2011 7:11 pm

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?f=110&t=40068&p=193030&hilit=random+featured#p192834

by **Eva30** » Wed Sep 21, 2011 11:24 pm

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