Magneto Product Catalog Development.

I want to share some info related with magneto Major Bug: though I don’t have a time that’s why I have not posted this with Magneto Blog and forum.
If we use the default magneto Promotion... It will take effect to our system but if we delete it does not remove the rule completely from the referenced table. That’s why we have $2.00 in test and $0.00 in live site as a special price.
What we have to do in future if this happens again:
Truncate the table: catalogrule_product_price
And update the table: catalog_product_index_price
Update `catalog_product_index_price` SET `final price`=19.9900,`min_price`=19.9900,`max_price`=19.9900;
19.000 is for the price what we want to set there.
Even for promotion magneto need Price to be set but we have to put some words there.
So if you say we can put some hard code stuff there.... but the promotion way you want will not work with magneto.

http://ping.fm/ZbNJ0