Sort Products by Price

[dailce]

On index.php when you click on a product/category it will show the products listed in order alphabetically.

 

How do I get my products sorted by price?

[dailce]

WILL THIS WORK????

 

 

Change (arround line 193)

CODEif ($column_list[$i] == 'PRODUCT_LIST_NAME') {

 

into

CODEif ($column_list[$i] == 'PRODUCT_LIST_PRICE') {

 

 

And change (arround line 195)

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

 

into

CODE$listing_sql .= " order by p.products_price, pd.products_name";

 

Then it orders by price and then by name, and there are no problems with browsing pages.

[Guest]

yes that should do it