I would like to load Magento product by sku, what function or method should I use
You can use “load” method from “catalog/product” model to load the Magento product by sku
$sku = 'my-sku';
$_product = Mage::getModel('catalog/product')->load($sku , 'sku');