October 24, 2020

cm-mini

Thinking Magento

Magento - The Importance of Cronjob

Now the cronjob is probably the most overlooked factor when it comes to setting up your Magento store. The cronjob is responsible for the following;

  • Sending out product email alerts
  • Updating your catalog flat catalog each evening - these are your prices rules
  • Removing expired quotes from customers baskets
  • Updating your currencies
  • Sending out newsletters
  • Updating your google sitemap

The cronjob can also be utilised in future addons such as auto cancelling orders, cleaning out tables and expiring RMA's.

The wiki on how to setup the cronjob can be found below and it really depends on your server configuration and if you are able to set it up. Cpanel and plesk environments make this a very easy job, however both can be resource hog platforms when it comes to dealing with a Magento store.

http://www.magentocommerce.com/wiki/1_-_installation_and_configuration/how_to_setup_a_cron_job

So don't forget to get your developer or host to setup your cronjob for you. It will make the difference between a store that is becoming a black hole of expired quotes and a smooth running store.

If you have had your Magento store up and running for several years now and you've just got a cronjob to setup and running, however your receiving lots of php max_execution errors, it means your tables have become far too chunky for the cronjob to deal with. This leaves you with the quesiton of what the heck do i do now? Well, there is only one logical solution and that is the scary task of truncating tables. The main tables that you'll need to truncate are the sales_quote tables and the product alert tables. MAKE A BACKUP OF YOUR DATABASE FIRST! If you are not comfortable with this, do not attempt it and contact a Magento Developer or your hosting company to do so.

Next post - > how to prevent your database from turning into a black hole of data that you really really don't need and have it nicely cleaned each evening.