sort products by rand (in stock first)

[Franklin]

Hi everyone.

 

How and what i can do for doing that?

 

What file and what change on sql query i can made?

 

Thanks all.

[jetway]

Hi, are you wanting to sort this on the front or back end? Or where exactly do you want to do this?

Edited October 27, 2016 by jetway (see edit history)

[Franklin]

Hi

 

I want this on product list (front office).

 

 

Thanks a lot

[Franklin]

Plz, some help?

 

I try a lot but can't work yet

[rocky]

I recommend that you don't sort your products in random order, since then you can't use caching. If you have caching enabled, the products will only be randomised once and then stay the same. It's better to reposition the products yourself into the order you want them to display.