Sort by Reference

[Results]

I have looked here, Wiki, and the manual, BUT might be blind as I can not find the answer.

I have a number of products that appear in sequence in the back office, but online appear in a different order.

Mono Printer Toners : Better Cartridges

Tk-17, Tk-18 TK-19 etc in order, yet TK-144 appears first.

I may get around it by renaming Tk-017 etc but my customers would be confused.

Any simple answers?

Thanks in advance!

Bruce

[ridexbuilder]

Non-simple answer:

The order in which products are displayed in the admin/database are of no consequence as to how they are displayed to the end-user. It is the SQL query on the data that determines the sort order.

If you set Product Listing|Product Display Type to 0 in Admin, you'll notice that there is an option to sort by Product Name or Price. This is done via a change to the sort order in the SQL query. You could have an additional column with Product Reference and a suitable query to sort by that column. So, in Admin, Product Listing, select an appropriate display order (including Product Model) to allow sorting by that column.

Notice: Case is important, also model numbers should have the same number of digits for the sort to be consistent. Example CLK-TK-17 should be CLK-TK-017, if you are using a maximum of 3 numerical designators. Product name could remain as is, to avoid possible confusion?

EJ

[Results]

Thanks for the prompt repy!

Will try your sugestion.

Thanks Again.
Bruce

[Results]

All working well now.

Thanks again for the help.
Bruce