jewelrykind Posted December 1, 2017 Posted December 1, 2017 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? Share this post Link to post Share on other sites More sharing options...
premiumpresta Posted December 1, 2017 Posted December 1, 2017 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. Share this post Link to post Share on other sites More sharing options...
selectshop.at Posted December 17, 2017 Posted December 17, 2017 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 Share this post Link to post Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now