Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

Product sort order


Recommended Posts

Hello all...


I have an OSC cart that is quickly approaching 40,000 items (CD's).

By default it displays products descendingly by product name.

I need to make it display ascendingly by product name.


Does anyone have a quick hack for this..?


This will make it easier for my customers to see the newest releases first, because under the "product name", I follow the same naming convention.

ie: SC2001 - Best of Bette Midler, SC2002 - Hits of Whitney Houston, etc.


Currently, in order for my customers to see the newest releases, they have to drill down to the bottom of the list...a big one...or click on the + - sort link...which most don't realize is there.

Having it sort the products ascendingly by default would save them (and me) a lot of trouble.


Any help with this would be greatly appreciated.

I've tried to hack the code myself with no luck.




Mark :)

Link to comment
Share on other sites

Edit catalog/default.php, and line 201 should be:

          $listing_sql .= " order by pd.products_name";

and just attach asc to the end of that to be in ascending order.

"Great spirits have always found violent opposition from mediocre minds. The latter cannot understand it when a man does not thoughtlessly submit to hereditary prejudices but honestly and courageously uses his intelligence." - A. Einstein

Link to comment
Share on other sites


This topic is now archived and is closed to further replies.

  • Create New...