Shathish has given you a nice and correct answer. However, you can use the singleton method and a query: $shimnetId = "1"; // use your shipment id: $read = Mage::getSingleton('core/resource')->getConnection('core_read'); $query = "SELECT * FROM sales_flat_order_address WHERE entity_id='".$shipmentId."'"; $results = $read->fetchAll($query); var_dump($results); `sales_flat_order_address` contains both the billing and shipping address. Hope it will work for you.