After creating categories and products in your osCommerce, you will want to have them organized. You do not have to worry about the order or where they were originally created as you have the ability to transfer them around from within the admin area. Follow the instructions below to learn how to move categories and products in your osCommerce program.
Moving products and categories in your osCommerce admin panel
- Log into your osCommerce admin interface.
Under the left hand menu find and click the Catalog button.
- From here, select the Categories/Products option.
You are now on the Categories/Products page where you will see products and categories listed. Find the product or category you want to move and click on the name. This will highlight an arrow to the far right and you will see several buttons in the right hand panel. Click on the Move button. In our example, we are going to move the Dog collar product.
The right hand panel changes to display a dropdown for you to select the destination category for the move. Highlight the destination in the dropdown and click on the Move button at the bottom. This will move your category or product to the desired location. Below is a before and after display showing the move for the Dog collar from no category to the Dogs category.
Before After 
If want alphabetical order in any languaje, just need to change Query order in boxes module:
includes/modules/boxes/bn_categories.php
change:
$categories_query = tep_db_query(“select c.categories_id, cd.categories_name, c.parent_id from ” . TABLE_CATEGORIES . ” c, ” . TABLE_CATEGORIES_DESCRIPTION . ” cd where c.parent_id = ‘0’ and c.categories_id = cd.categories_id and cd.language_id='” . (int)$languages_id .”‘ order by sort_order, cd.categories_name”);
For:
$categories_query = tep_db_query(“select c.categories_id, cd.categories_name, c.parent_id from ” . TABLE_CATEGORIES . ” c, ” . TABLE_CATEGORIES_DESCRIPTION . ” cd where c.parent_id = ‘0’ and c.categories_id = cd.categories_id and cd.language_id='” . (int)$languages_id .”‘ order by cd.categories_name, sort_order”);
Invert that order in any categories queries and templates modules to. That do the trick !!