Magento – Catalog Price Rules disappear overnight

catalog-price-rulescronmagento-1.8pricepricing

I am running Magento 1.8.1.0. I made a price rule to give all customer groups 20% off on all products, up to date 12/25/2014. I click the button "Save and Apply", the prices of all products run well.

But on the next day, all prices are restored to the original price automatically.
Can anybody can help me?

Best Answer

  • 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

Related Topic