Sort products by price

[Anonymous]

Hi! I want to order my products by price when browsing the categories and manufacturer instead of model number, how can I do this? Thank you for your help.

[lbs]

Hi! I want to order my products by price when browsing the categories and manufacturer instead of model number, how can I do this? Thank you for your help.

I to are looking for a way to sort products by price.
So when customers open a category they see the cheapest products first
PLEASE CAN ANY ONE HELP

[nemail]

Hi. Not tried this myself, but it might be worth having a look here in the replies to this previous post:
http://oscdox.com/PNphpBB2-viewtopic...ight-sort.html
It may be dealt with elsewhere on the forum also.

Good luck.

[Jonnyboy]

Hi

You need to change the index.php file on around line 110.
You need to edit the end section of the sql query

$listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m on p.manufacturers_id = m.manufacturers_id, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . (int)$languages_id . "' and p2c.categories_id = '" . (int)$current_category_id . "' order by p.products_price ASC";

Hope this helps
John