Product Listing - sort by price

[mindpower77]

When one clicks on category, the original product order is by product name. The client needs it to show in the ascending price order. In the configuration/product listing settings one can only change the order of columns, but not the default order of products.

 

I know that ones products appear in the list, you can click on Price and sort the listing by price, BUT the client wants it to appear in the order of price by default.

 

Anyone can help me with that? Thank you

 

 

 

 

 

 

this is osCommerce 2.2 MS2

[Guest]

For the listing in index.php change 'order by p.products_name' to 'order by p.products_price asc' :P

 

Matti

[mindpower77]

For the listing in index.php change 'order by p.products_name' to 'order by p.products_price asc'  :P

 

Matti

<{POST_SNAPBACK}>

 

 

i did a search for 'order by p.products_name' on index.php, none were found.

then i kinda reviewed the code myself and found a lot of &listing variables. can you please give more detail on your comment.

 

thank you