Hi. I am using Joomla 2.5.27 and Virtuemart 2.6.10.
I have iánstalled module SJ Virtuemart Version 2.3.0. I like this free extension, but I have one problem.
My problem is that random order of product does not work. When i choose random order there are allways displaying the same products in the same order. Nothing is changing after reloading page. And nothing is changing when I visit the webpage in another time.

Can you help me?

please fix...

lukasdancak wrote:

I have also the same problem. Random order in SJ Virtuemart module is NOT Working. Always show the same products and not changing after refresh

I found it !!!!!!
in /modules/mod_sj_virtuemart/core/helper.php
find the line 298 :
$orderBy = ' ORDER BY p.`virtuemart_product_id` ';
change to:
$orderBy = 'ORDER BY RAND()';

Thats it

Thanks you