Put Product Listings In Order

[mystifier_uk]

When I click on Categories/Products I can change the order of them by changing the sort order, but how can I do this for the products inside a category?

 

There doesn't seem to be a 'sort order' option to do this! :blink:

[mystifier_uk]

Anyone?

 

Surely there is a way to change the order of the product listings to a custom order instead of just by alphabetical order?

[mystifier_uk]

Help!

[mystifier_uk]

:blink:

[madcrazygirl]

No expert but think probably in catalog/product_info file:

 

the order by bit:

 

 $products_options_name_query = tep_db_query("select distinct popt.products_options_id, popt.products_options_name from " . TABLE_PRODUCTS_OPTIONS . " popt, " . TABLE_PRODUCTS_ATTRIBUTES . " patrib where patrib.products_id='" . (int)$HTTP_GET_VARS['products_id'] . "' and patrib.options_id = popt.products_options_id and popt.language_id = '" . (int)$languages_id . "' order by popt.products_options_name");