Turn off random function in Featured Products

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!

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

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

Hi,
simply do the following

change

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

to
[/PHP]

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

and

    $featured_products->MoveNextRandom();

to

    $featured_products->MoveNext();

cheers

Deviation --

That worked perfectly! Exactly what I needed.

Thank you very much for the help!

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

Thanks for the help with this!

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.

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.

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.