Useful Tricks

This section contains some useful programming tricks.
Magento: Delete All Products & Categories via SQL

FOR PRODUCTS SET FOREIGN_KEY_CHECKS = 0;TRUNCATE TABLE `catalog_product_bundle_option`;TRUNCATE TABLE `catalog_product_bundle_option_value`;TRUNCATE TABLE `catalog_product_bundle_selection`;TRUNCATE TABLE `catalog_product_entity_datetime`;TRUNCATE TABLE `catalog_product_entity_decimal`;TRUNCATE TABLE `catalog_product_entity_gallery`;TRUNCATE TABLE `catalog_product_entity_int`;TRUNCATE…

Fixing Magento Catalog Price Rules Issue

try {Mage::getConfig()->init()->loadEventObservers(‘crontab’);Mage::app()->addEventArea(‘crontab’);Mage::dispatchEvent(‘default’);$observ = Mage::getModel(‘catalogrule/observer’);$observ->dailyCatalogUpdate(“0 1 * * *”);} catch (Exception $e) { Mage::printException($e);}

1 2 3 42