How do I sort the order of products displayed?

[Jet200]

Products in my categories seem to be sorting alphabetically.

 

http://www.jet200.com/catalog/index.php?cPath=4

 

I'd like to be able to dictate how they sort.

 

Thanks

[Gauravs]

Default sorting is by product_name...

 

you would find the line below in index.php

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

 

You may replace pd.products_name - to the field you would like to use for sorting.

 

 

Cheers

GS

[Jet200]

that seems easy enough, but where are these fields defined? i wouldn't know what to put there

[Jet200]

i've searched and searched but cannot find where these things are defined. really need some help with this as it just looks stupid having the products sort by alphabet. otherwise i will have to resort to some lame product names ;)

[Guest]

Hey why don't you take that line of code

 

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

 

and change it to your product id

 

$listing_sql .= " order by p.products_id";

 

this way its how you insert the products not by the name. :thumbsup:

[ReBeL Tech]

Default sorting is by product_name...

 

you would find the line below in index.php

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

 

 

I do not see this line in index.php

[picard102]

I do not see this line in index.php

 

 

How do I reverse the order though. It displays the product ID in descending order, I want it in ascending.