Sort products module?

[jewelrykind]

Hi

I need to randomly sort products in categories. Is there any module for this? For example a module that randomly assign a position number in cayegory (for products).  And after that i can set the prestashop to sort my product by position in category. In this way i can have a random sorting of products.

Can anyone help with a module?

[premiumpresta]

You could run something like this on your database:

UPDATE `ps_category_product` SET `position`=FLOOR(RAND()*10);

Note that position numbers will repeat, but it will still be random. If you have many products you could use a number bigger than 10.

[selectshop.at]

Prestashop version ? There are some tutorials for how to PS 1.6. and PS 1.5.

 

https://www.prestashop.com/forums/topic/533797-random-products-on-category-page/

https://www.google.com/search?dcr=0&source=hp&ei=2LU2Wo6zJ83IwAKrzqz4AQ&q=prestashop+random+products+product+category&oq=prestashop+random+products+product+category&gs_l=psy-ab.3...1473.12752.0.13048.0.0.0.0.0.0.0.0..0.0....0...1.1.64.psy-ab..0.0.0....0.nQlzP1brBjI&gws_rd=cr