Index page sort order is Random

[nabrown78]

Hi all,
On my index page, I have only 'New Products' shown. In Configuration>New Listings, I have chosen option 8, Product sort order. I have also done this in Configuration>All Listings. I have about 8 products, with sort orders like: 0, 5, 10, 15 etc. However, when I go to my store's index page:
www.roll-over-rover.com/store
the product list order is randomized, and changes with each refresh!
How can I control this? Any help is really appreciated, it's driving me crazy.
Thanks.

[Louis]

Have a look in Admin>configuration>product listing.

More specifically at "Display Product Listing Default Sort Order"

[nabrown78]

Have a look in Admin>configuration>product listing.

More specifically at "Display Product Listing Default Sort Order"

I left this field blank as instructed, in order to sort by Product Sort Order, which is specified per individual product. I see in modules>new_products.php a line which reads:

$new_products = $db->ExecuteRandomMulti($new_products_query, MAX_DISPLAY_NEW_PRODUCTS); 

Surely this is what is randomizing everything, and I see no way to turn it off. I'm wondering how I could rewrite the php to just normally execute the query.

[SnapCount80]

I left this field blank as instructed, in order to sort by Product Sort Order, which is specified per individual product. I see in modules>new_products.php a line which reads:

$new_products = $db->ExecuteRandomMulti($new_products_query, MAX_DISPLAY_NEW_PRODUCTS); 

Surely this is what is randomizing everything, and I see no way to turn it off. I'm wondering how I could rewrite the php to just normally execute the query.

nabrown, I went to Admin > Tools > Developers Tool Kit and did a search on "ExecuteRandomMulti". It brought up a list of pages, but I traced the function back to one page of interest:

includes > classes > db > mysql > query_factory.php

I scrolled through the function to find the php random function and found the following on line 230:

$obj->result_random = array_rand($obj->result, sizeof($obj->result)); 

I copied and commented out the text so not to do irreparable damage, then pasted it below and edited the line to my liking. I wanted to display specific items, and since I knew there were only 9 items to display, I created my own array, using my limited knowledge of PHP and w3shools website, to list (what I assume are) the keys for the specific items in the order I wanted to display them. My code looks like the following:

//$obj->result_random = array_rand($obj->result, sizeof($obj->result));
      $obj->result_random = array(1,7,4,3,5,6,2,0,8); 

This achieved what I was looking for, so thanks for taking the first step in finding the random function. Hopefully this will help others too.

[thetankgirl]

Thank you! it helped me a lot :-)

[dharam1987]

If any body is looking for the same solution.

I think we needn't modify anything.

In stead of using

$db->ExecuteRandomMulti('sql query goes here');

and $obj->MoveNextRandom();//this is in while loop 

we can use

$db->Execute('sql query goes here');
$obj->MoveNext(); //this is in while loop 

Note :: This is only if you dont want the products or the query to product any random result.

[tkjohnson]

hi there -
I am trying to de-randomize the new products on the index page as well but the above code didn't work for me. I have tried every sort order setting in the admin as well as changing the code to the array as mentioned above to no avail... what am I missing?
http://showerhug.com/shop/
thnx

[jamielife]

Soooooo to recap:

open includes/modules/new_products.php(or featured_products.php depending on your index page)

find:

$db->ExecuteRandomMulti 

and change to:

$db->Execute 

as dharam1987 instructed.

this part seems to have changed a bit. next find:

$new_products->MoveNextRandom 

and change it to:

$new_products->MoveNext 

leave everything before and after intact. save/upload... and problem solved.

[jamielife]

oh and if you're changing the featured products module you will need to chage:

[COLOR="Red"]$featured_products->MoveNextRandom[/COLOR] 

to

[COLOR="red"]$featured_products->MoveNext[/COLOR] 

in the corresponding file.

thanks guys for figuring this out.

[magnusrf]

I followed the instructions above and I was able to stop the random display, but the sort order is not the way I want it.

I have the appropriate sort order I want on each product, but for some reason it's displaying differently.

Any thoughts?

http://store.baseballrose.com/