Magento 1.9 Reports – How to Get SKU in Products Ordered Reports

Open app\code\core\Mage\Adminhtml\Block\Report\Product\Sold\Grid.php and put the below code in _prepareColumns() function

You can move Grid.php in your local folder as well.

$this->addColumn('sku', array(
    'header'    => Mage::helper('reports')->__('Product Sku'),
    'index'     =>'sku'
));

Code Taken From: http://chandreshrana.blogspot.in/2016/08/add-sku-column-in-products-ordered.html

Use Magento event observer and use catalog_product_save_before event on this function you need update magento Product url key field (url_key)

<global>
        <events>
            <catalog_product_save_before>
                <observers>
                    <stockalert>
                        <type>singleton</type>
                        <class>yourmodel/observer</class>
                        <method>autoupdateurlKey</method>
                    </stockalert>
                </observers>
            </catalog_product_save_before>
        </events>
    </global>   

And Observer code is:

    public function autoupdateurlKey($observer)
    {
        $product=$observer->getEvent()->getProduct();
        $oldUrlKey=$product->getOrigData('url_key');

        $Sku=$product->getSku();
        $TypeId=$product->getTypeId();

        // put yourlogic 
        $product->getData('url_key',$YourNewUrl);

         return $this;
    }