Magento – Category Sorting Product list: How to take off position from attributes

You can do that writing directly to the database below is a working code that do that using an array of categories products

You have to create the array like this

            $categoryPosition[] = array('product_id' => $mageProduct->getId(),
                                        'category_id' => $categoryId,
                                        'position' => $position);

an run this code

foreach ($categoryPosition as $position){                        
            //print "Position: c=".$position['category_id']." prod=".$position['product_id']." pos=".$position['position'] . "\n";
            $query = "UPDATE tn_catalog_category_product SET position = :position "
                    . "WHERE category_id = :category_id and product_id = :product_id";
            $values = array('position' => $position['position'],
                                'category_id' => $position['category_id'],
                                'product_id' => $position['product_id']);
            $writeConnection->query($query,$values);                    
}

and remember to run the indexer catalog_category_product

Thanks

You can just add 2 product attributes with the names you want and make them available for sorting.
If you need a custom logic behind it rewrite the method Mage_Catalog_Model_Resource_Product_Collection::addAttributeToSort and add your own case section to handle your attributes.

Here is an example on how it's done for created_at. You can do something similar for your attributes.