Product Sort Order not working

[Ajeh]

It has to be your template then ...

You need to do a comparison on what the template and override files are doing compared to the original files ...

Beyond Compare from scootersoftware.com is a good tool for this ...

There is definitely something wrong with the files, as if you click on one of the titles such as Name, you will see the SQL error ...

Does the same thing happen in the Classic Template or does it sort by Product Name?

[barendfaber]

The classic template works perfect, it displays the products in the correct order. I have looked ta the files supplied with the template, the only one I could see that I think may have to do with this is product_listing under Modules. None of the other files has a name that suggests it may affect the product listing. Could this be the problem?

[Ajeh]

You would be better off comparing the files on your server to the original files and comparing anything that uses the templates and overrides as there are quite a few files that are used for the Product Listing ...

Anywhere you see a templates and overrides directory, you should compare those files to the originals and see what differences there are ...

[barendfaber]

Must I look at just the files supplied with the template, or that and any other add ons I installed?

[Ajeh]

I would check any file that is not part of the original files ...

NOTE: It sounds like it is a templates and overrides file ... so I would start there ...