sort by product code or name

[Guest]

i have a record shop and i want to sort my records by name and not price.

 

i want to sort it numerically. a generic title would be "INP004 - Artist - Title" i want the sort to check that INP004 is listed above INP003 and INP002 etc. i am sure you catch me drift. basically the higher the number the higher the listing on the products page (INP001 being the earliest or first release and INP011 being the last or latest release)

 

i am not sure whether to have the INP004 part in a separate field or bunch it together with the title. whichever i choose it doesnt affect the outcome

 

the only place i have seen and acend/descend radio box is in the Configuration - My Store - Expected sort order. regardless of what i choose the order stays the same. is there a module for this at all?

 

thanks for your help

[ErollorD]

hi, can you show your website and post the links to where you want to sort records by name, is this on product listing or where??

[Guest]

http://70.86.10.162:81/inperspective/Shop/...796e21271557149

 

i want the order to start from INP015 down to INP006. at the mo it starts with INP006. this i do not want

[ErollorD]

go index.php file and search for

 

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

 

and change it to

 

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

[Guest]

just adding the DESC changed it completely to what i wanted. why is that? i take it that DESC means description. so what was it taking before? not the whole description which included numerical data?

[ErollorD]

ASC means that the results will be shown in ascending order, and DESC means that the results will be shown in descending order. If neither is specified, the default is ASC.