Product order

[bflan]

I am new to os Commerce and would like to know how to display products in the order of my choosing. At the moment they seem to display in alphabetical order.

 

bflan

[ErollorD]

show them where? in product listing?

 

http://www.oscommerce.com/community/contributions,911

[oschellas]

You would have to modify following logic in the index.php to change the default order.

 

	if ( (!isset($HTTP_GET_VARS['sort'])) || (!ereg('^[1-8][ad]$', $HTTP_GET_VARS['sort'])) || (substr($HTTP_GET_VARS['sort'], 0, 1) > sizeof($column_list)) ) {
  for ($i=0, $n=sizeof($column_list); $i<$n; $i++) {
	if ($column_list[$i] == 'PRODUCT_LIST_NAME') {
	  $HTTP_GET_VARS['sort'] = $i+1 . 'a';
	  $listing_sql .= " order by pd.products_name";
	  break;
	}
  }
}