/** * Listener for before product delete event. Deletes product custom redirects. * Needed because of http://bugs.mysql.com/bug.php?id=11472 * @param Varien_Event_Observer $observer */ public function deleteProductCustomRedirects(Varien_Event_Observer $observer) { if ((string) $this->_app->getConfig()->getNode(Enterprise_UrlRewrite_Model_Index_Observer::XML_PATH_REDIRECT_URL_SUFFIX_UPDATE_ON_SAVE)) { return; } /** @var Mage_Catalog_Model_Product $product */ $product = $observer->getProduct(); /** @var Enterprise_UrlRewrite_Model_Resource_Redirect $redirects */ $redirects = $this->_factory->getResourceModel('enterprise_urlrewrite/redirect'); $redirects->deleteByProductIds(array($product->getId())); }