As of 1.4.2 it is deprecated to define order statues and states via config.xml. Then, how will you get more order statuses in the admin order details page?
Consider for example you have an order in ‘Pending Payment’ state and you want to change it to ‘Processing’. If, you go to the order details page in the admin you will find only one option in the order status drop down (which is ‘Pending Payment’ itself!)
What if you want to show ‘Processing’ too in the drop down?
You will need to make changes in the Magento sales_order_status_state table like this:
INSERT INTO `sales_order_status_state` (`status`, `state`, `is_default`) VALUES ('processing', 'pending_payment', '0');
[EDIT] Just for your info:
Before 1.4.2 you would need to override the Mage/Sales/etc/config.xml file and modify the <global><sales><order><states> section to look like this:
<global> ..... ..... <sales> ..... ..... <order> ..... ..... <states> ..... ..... <pending_payment translate="label"> <label>Pending Payment</label> <statuses> <pending_payment default="1"/> <processing default="0"/> </statuses> </pending_payment> ..... ..... </states> ..... ..... </order> ..... ..... </sales> ..... ..... </global>




