Magento – Catalog Price Rules Disappear After Midnight

• Ensure that your Magento cron is setup correctly: Installing and Verifying Magento: Setting Up Cron Jobs

• Check if the cron-job is running

  • look into cron_schedule-db-table
  • use /cron.php to refresh
  • delete /var/cache for changes in etc/config.xml cron-sections (not sure to also truncate db-table)

• Check if price-calculation happens after indexing.

"After the indexed price is saved into the index table this events triggers an observer method, which updates the index table with catalog rule adjusted prices. Because of this fact it is important to make sure that the Mage_CatalogRule module’s cronjob, which calculates rule prices for the current day, is run before the daily product price indexer." http://www.solvingmagento.com/magento-catalog-price-rules/

• There is a time-issue. So beware for day-breaks. Control DB-table-times.
• Control errors: There are just stored in DB.

I have Magento 1.7.0.2

Are you running cronjob.php or.sh... in both cases you could edit the files and let it send a email to you when it runs.

A second solution would be to try out this amazing extension giving you the best insight in the health, quality and possible issues with you cronjobs.

This extensions shows you the schedule of you cronjob and gives you insight if it runs and how long tasks take and which tasks have run.

https://github.com/AOEpeople/Aoe_Scheduler

Hope this helps. Cheers!