Please help us to make AbanteCart Ideal Open Source Ecommerce Solution for everyone.

Support AbanteCart eCommerce

Author Topic: Random sort order for products  (Read 6002 times)

Offline Palamedes

  • Newbie
  • *
  • Posts: 36
  • Karma: +5/-0
    • View Profile
    • RandomStringOfWords
Random sort order for products
« on: March 07, 2012, 01:25:34 PM »
MySQL allows for a random order of items..  It would be nice if we could have a sort by that uses "ORDER BY RAND()" for product category pages so that it shows a random listing.

~Pal

Offline TopEcommerce

  • Newbie
  • *
  • Posts: 6
  • Karma: +0/-0
    • View Profile
Re: Random sort order for products
« Reply #1 on: March 08, 2012, 08:58:26 AM »
Where exactly do you suggest to have that?
Any downside on performance of SQL with larger sets?

Offline Palamedes

  • Newbie
  • *
  • Posts: 36
  • Karma: +5/-0
    • View Profile
    • RandomStringOfWords
Re: Random sort order for products
« Reply #2 on: March 08, 2012, 05:43:01 PM »
Howdy!

I'd like to see it as an option in the latest products maybe with some weighting mechanic or at the very least in a category view.

Right now the category view has a sort drop down with a number of options.. it would be trivial to add the random option.. ( I already did it on mine to see if I could.. )
~Pal

 

Powered by SMFPacks Social Login Mod