This is an old revision of the document!


Price doesn't change at front end when I update product price through db directly, How to fix it?

For user's Magento 1 store, it has some special scripts to update product price through database change directly instead of Magento Admin Panel. The front end is cached and the price doesn't show the updated figure.

While, when a user updates anything through Magento Admin Panel, LiteMage will identify the changes and initiate the purge event to update the related pages. If the prices are updated in Database directly, LiteMage has no way to detect such changes hence there is no purge event triggered during the price changed in DB. If the front pages were cached and cache TTL is not expired, the front pages will probably still show the out of date figures instead of new figures in the database.

How to trigger price update in this situation?

The user might think how to exclude the price from the cache? No, not that way. LiteMage is not designed to exclude price block, which will slow down every page and make it not usable. Instead, for user's data feed, he can use “lsws/admin/misc/cleanlitemage.sh” to do purge for the related productions in his existing price change script. It can purge any particular product IDs, category_IDs, store_IDs, or raw tags. Please check this wiki on how to use it.

  • Admin
  • Last modified: 2018/06/15 15:33
  • by Jackson Zhang