Post by Qphoria » Wed Jan 05, 2011 1:31 pm

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

Image
Donate!|OpenCart Basics|GeoZones
Image


User avatar
Administrator

Posts

Joined
Tue Jul 22, 2008 3:02 am

Post by Qphoria » Fri Jul 29, 2011 3:52 am

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

Image
Donate!|OpenCart Basics|GeoZones
Image


User avatar
Administrator

Posts

Joined
Tue Jul 22, 2008 3:02 am

Post by fsit » Wed Aug 03, 2011 3:48 am

Great addition, thank you very much.

New member

Posts

Joined
Mon Jul 25, 2011 12:44 am

Post by tunnu » Sun Aug 07, 2011 9:59 pm

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

New member

Posts

Joined
Sun Jun 05, 2011 11:38 pm

Post by Qphoria » Sun Aug 07, 2011 10:25 pm

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

Image
Donate!|OpenCart Basics|GeoZones
Image


User avatar
Administrator

Posts

Joined
Tue Jul 22, 2008 3:02 am

Post by tunnu » Thu Aug 11, 2011 10: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

New member

Posts

Joined
Sun Jun 05, 2011 11:38 pm

Post by fido-x » Thu Aug 11, 2011 11: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.

Image
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!


User avatar
Expert Member

Posts

Joined
Sat Jun 28, 2008 1:09 am
Location - Tasmania, Australia

Post by peecha85 » Mon Sep 05, 2011 3:22 pm

How to show random products on 1.5.1. without vqmod?

Active Member

Posts

Joined
Tue May 11, 2010 10:28 pm

Post by peecha85 » Mon Sep 05, 2011 3:30 pm

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

Active Member

Posts

Joined
Tue May 11, 2010 10:28 pm

Post by sitesurfer » Tue Sep 06, 2011 6:43 pm

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

Newbie

Posts

Joined
Tue Sep 06, 2011 6:26 pm

Post by sitesurfer » Thu Sep 08, 2011 6:11 am

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.

Newbie

Posts

Joined
Tue Sep 06, 2011 6:26 pm

Post by gamersmarket » Mon Sep 19, 2011 2:52 am

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

New member

Posts

Joined
Mon Aug 29, 2011 3:21 pm

Post by gamersmarket » Mon Sep 19, 2011 3:11 am

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

New member

Posts

Joined
Mon Aug 29, 2011 3:21 pm

Post by Eva30 » Thu Sep 22, 2011 7:24 am

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

User avatar
New member

Posts

Joined
Fri Sep 09, 2011 4:17 pm

Post by Demartini » Mon Oct 31, 2011 10:28 pm

Perfect! :)

It worked perfectly in version 1.5.1.3.1

Thank you for sharing.

Hugs.

Att:
Iolar Demartini
twitter.com/iolardemartini


User avatar
Newbie

Posts

Joined
Sun Aug 21, 2011 12:33 pm
Location - Anápolis - Goiás - Brasil

Post by idan » Mon Dec 26, 2011 7:39 pm

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

Newbie

Posts

Joined
Thu Dec 22, 2011 6:52 pm

Post by allenshea » Tue Dec 27, 2011 9:37 am

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 know nothing about PHP and SQL, but I still try my best to understand it.


Active Member

Posts

Joined
Mon Dec 14, 2009 10:01 pm

Post by idan » Tue Dec 27, 2011 7:52 pm

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

Newbie

Posts

Joined
Thu Dec 22, 2011 6:52 pm

Post by Qphoria » Wed Dec 28, 2011 12:20 am

limit field for featured module added to 1.5.2

Image
Donate!|OpenCart Basics|GeoZones
Image


User avatar
Administrator

Posts

Joined
Tue Jul 22, 2008 3:02 am

Post by xlam » Sat Jan 07, 2012 9:49 am

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


New member

Posts

Joined
Sun Dec 25, 2011 2:58 pm
Who is online

Users browsing this forum: No registered users and 8 guests