catalog price rules disappear after mid night in magento site

catalog price rules disappear after mid night in magento site

August 28, 2026 · Illustrated author avatarBy Stefan Bogdanescu
catalog price rules disappear after mid night in magento site

Troubleshooting Catalog Price Rules Disappearance in Magento

If you’re facing the issue of catalog price rules disappearing after midnight in your Magento site, you’ve come to the right place. In this post, we’ll dive into possible causes for this problem and provide step-by-step solutions.

Understanding the Issue

You mentioned that you have around 1000 products with specific price rules applied to a subset of them. These special prices are displayed correctly until midnight, but suddenly vanish after that point, even though your cron jobs appear to be functioning properly.

Potential Causes and Solutions

Let’s explore some common reasons for this behavior:

  1. Timezone and Date Format Mismatch Magento stores dates in the system timezone (configured under System > Configuration > General). If there’s a mismatch between the Magento system date format and your server’s date format, it could cause the rules to vanish.

    To check this:

    • Go to System > Configuration > General > Date and Time.
    • Ensure the Date Format matches what you expect. For example, if your server is set to M/d/Y (Month/Day/Year), Magento should also be configured similarly.
  2. Product Prices Not Being Reindexed Even though cron jobs are running, it’s possible that the product prices aren’t being reindexed correctly after the rule updates.

    You can manually trigger a price reindex:

    • Navigate to System > Index Management.
    • Find Product Prices and click “Reindex Now”.
  3. Invalid Rule Configuration Sometimes, an invalid configuration in your catalog price rules could lead to this issue.

    Check for common errors such as:

    • Incomplete or incorrect SKU lists
    • Incorrect attribute combinations
    • Non-existent product categories
  4. Memory Limits Exceeded During Rule Application If your server has low memory, the rule application process might fail silently due to insufficient resources.

    You can check this by enabling Magento’s exception logging:

    • Open the file app/code/core/Mage/Exception.php.
    • Change line 16 $log = null; to $log = Mage::getModel('core/log_adapter_file');.
    • Restart cron jobs and see if it logs any exceptions.

Best Practices

To avoid this issue in the future, consider these best practices:

  • Always set a clear start/end date for your price rules. Even if you intend them to be permanent, setting a far-off end date ensures they behave predictably.
  • Regularly monitor your server’s system log and Magento exception logs for any errors related to cron jobs or rule application.
  • Keep your Magento installation up-to-date with the latest security patches.

Conclusion

The disappearance of catalog price rules after midnight is usually caused by one of the issues we’ve discussed—timezone mismatches, indexing failures, invalid rule configurations, or server resource limitations.

By following the troubleshooting steps and best practices outlined in this post, you should be able to resolve the issue and maintain a stable Magento site with predictable pricing behavior.

Remember, if you’re facing any other technical challenges, feel free to check out our Magento development services at Laravel Company. Our team of experienced developers is ready to help you optimize your e-commerce platform for success!

Catalog Indexing Configuration Cron

Our network