[mffowler]

I need to randomize all products in all categories. I've looked at the recommends for help, but it just isn't the same relation to the overall products.php.

Has anyone done this? If so, do you have the SQL statement that will give the option in General Settings/Appearance to display randomn products?

Funky has some 3.x code in the forum, but there just doesn't seem to be anything for 4.0.x. In recommends you see $rnd = rand(); and ORDER BY RAND(NOW()+$rnd). Ideas?

Thanks, Mike