Quote Originally Posted by nabrown78 View Post
In fact that is not the file you need to edit. You need to edit includes>modules>new_products.php (Or preferably includes>modules>YOUR_TEMPLATE>new_products.php). Beneath the SQL query, there is a line that says:
PHP Code:
 $new_products = $db->ExecuteRandomMulti($new_products_query, MAX_DISPLAY_NEW_PRODUCTS); 
That's what's randomizing everything. I also want to base the index display on product sort order, not random, but I can't figure out how to do it. Anyone got an idea?
Maybe you are right, but it don't randomize teh "New Products for..." on the home page. Knows somebody where can I change it to be not random displayed?

Thanks