Looking at the
cms_page table in the database I can see there is a field called
sort_order however I can't see any where in the admin system where you can set this. Could someone point me in the right direction
I have Check the SQL Script
At First Install script they are not include this
sort_order in first script verson
when they are update the structure in
so they are trying to put sorting functionality at back-end but still they are forgot to implement that.
May be In Magento 2 they are launch this feature.
Its crazy that we would have to do this as sorting page order should be native but if you add the following code to app/code/core/Mage/Adminhtml/Block/Cms/Page/Edit/Tab/main.php you can then change the page order in the admin
$fieldset->addField('sort_order', 'text', array( 'name' => 'sort_order', 'label' => Mage::helper('cms')->__('Sort Order'), 'title' => Mage::helper('cms')->__('Sort Order'), 'required' => false, ));
I found the solution from http://www.magentocommerce.com/boards/viewthread/12462/