Problem with products ordering

[gatis_lee]

Hi,

I’ve been trying to find the answer also tried to modify code by myself but have no results for about a week now and also can’t find this anywhere in any forum well question for the million :) = how to order all products by price, if special price exists then by special price (The query set variable final_price) I’m changing everywhere as possible querys default for example order by m.manufacturers_name to order by final_price or order by p.products_price but anyway at least one product will be incorrect, seams that the products are ordering not only by sql query mentioned but also is taking some other info as order parameter. Well for short – can anyone please explain how the products are ordering in OS-Commerce and where to find and how to modify those parameters; The problem is with the index.php file – general product listing, with specials.php and products_new.php I had no problem;

Great thanks