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
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
Attachments
http://forum.opencart.com/viewtopic.php?f=23&t=24529tunnu wrote:can u please tell me where to upload this xml file to get it working?
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
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.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
Modules for OpenCart 2.3.0.2
Homepage Module [Free - since OpenCart 0.7.7]
Multistore Extensions
Store Manager Multi-Vendor/Multi-Store management tool
If you're not living on the edge ... you're taking up too much space!
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
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.
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. Thankssitesurfer 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.
I think I have found it: http://forum.opencart.com/viewtopic.php ... ed#p192834gamersmarket wrote:Can you tell me what did you do? I have the same problem. Thankssitesurfer 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.
buy something from your own store...fido-x wrote:Bestseller products are exactly that "bestsellers". If you haven't sold anything, nothing will show in the bestsellers module.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
maybe..
i devided do develop this mod, if you want:
http://www.opencart.com/index.php?route ... order=DESC
http://www.opencart.com/index.php?route ... order=DESC
hellow...
works for me...many thanks:)
using OC 1.5.3.1
works for me...many thanks:)
using OC 1.5.3.1
Baju Muslim Baju Pria Baju Anak Baju Korea Sparepart Printer Baju Muslim JNE Surabaya
Who is online
Users browsing this forum: No registered users and 36 guests