Turn off random function in Featured Products

**MSport** · 21 Nov 2006, 03:52 PM

Hello,

I need to stop the products from rotating in the Featured Products box. The site only has a handful of products to sell, and I'd like them to consistently display in their default sort order -- not randomly rotate!

Have searched through the Forum and found a very dated method of doing this - anyone have a new simple fix for accomplishing this?

Running Zen Cart version 1.3.6
DB Patch level 1.3.6

Thanks in advance!

**Ajeh** · 21 Nov 2006, 03:54 PM

You would need to re-write the code to not randomize the Featured Products ...

Copy the file:
/includes/modules/featured_products.php

To your template and overrides directoy, then change the way the selected products are handled to not do the randmization ...

**MSport** · 21 Nov 2006, 04:22 PM

Linda,

Thank you for the quick response! Unfortunately, I'm not versed well enough to re-write the code!

Anyone other suggestions would be appreciated!

Thanks again

**deviation** · 14 Jan 2007, 09:50 PM

Hi,
simply do the following

change

PHP Code:


[PHP]

$featured_products = $db->ExecuteRandomMulti($featured_products_query, MAX_DISPLAY_SEARCH_RESULTS_FEATURED);

to
[/PHP]

PHP Code:


$featured_products = $db->Execute($featured_products_query, MAX_DISPLAY_SEARCH_RESULTS_FEATURED);

and

PHP Code:


    $featured_products->MoveNextRandom();

to

PHP Code:


    $featured_products->MoveNext();

cheers

**MSport** · 18 Jan 2007, 04:51 PM

Deviation --

That worked perfectly! Exactly what I needed.

Thank you very much for the help!

**blainbci** · 30 Jul 2007, 04:26 PM

I wanted to stop the random feature for the new products on the main page. I used your code change and it worked perfectly. Thanks for your help. It took several hours to find this post which seems to always be the case with the forum. Does the new book or manual have answers like this in it?

Thanks
Blain

**GoodBuyGail** · 30 Jul 2007, 04:51 PM

Thanks for the help with this!

**blarney** · 19 Sep 2007, 02:53 PM

Thanks for the great instructions on "unrandomizing" the features. One follow-up... is there a simple way to instruct it how to sort those items? I can't figure out how they are currently sorted but doesn't seem to follow any ID/ title/ or such.

**J Price** · 25 Sep 2007, 03:23 PM

I don't know if you already figured out the answer to this but if not or for anyone else viewing this thread- here is how I changed it.

Go to Configure, Featured Product
Change the Display Product Display - Default Sort Order
Choose the sort order that you want.

**blarney** · 25 Sep 2007, 04:24 PM

JPrice,
Thanks for your reply but the Configure/FeaturedProducts sorts the side box but not the center box for featured products.

I figured out how to fix that and just added a contribution called Featured Items Sorted in the "Other Modules" section of downloads with a fix I created for this.

I hope that helps others looking for a similar solution.