Comments on: Sending Emails by Queue in Magento 1.9.1

By: Ashish @ MagikCommerce

Ashish @ MagikCommerce — Mon, 09 Feb 2015 08:28:58 +0000

Which queuing mechanism is being used here? I personally use Redis based queuing which works rock solid but i am definitely going to to try this.

By: ranbir

ranbir — Fri, 06 Feb 2015 04:49:36 +0000

hello sir,

i am using magento 1.9.0.1 version to develop a store. and i want to remove the sku from order email. but after trying all metheds which are mentioned in google search like (sales.xml and editing block and template ) .i am unable to remove it form email.
please help……

By: Helmy

Helmy — Sat, 31 Jan 2015 10:11:18 +0000

Hello Ashley,

Thank you so much for such useful notes, reading this i do understand to some extent about how to handle new email setup in magento 1.9.1

I found the database table as you mentioned all the emails are queued.. after this point i couldn’t follow the instruction about the magento two new cron jobs (core_email_queue_send_all, core_email_queue_clean_up) are this cron jobs already exists in cron tab of some xml file? or do we need to create this entry in some .xml file?

If this were cron job’s already exists in some file, could you please share with us the location of the file please… ? so i can create a “command” to run this job from my hostgator cronjob manager…

P.S: i also tested by removing the queue process from the template.php file inorder to send an instant email when order is placed by the customer and it worked well..:), but i don’t want to deviate from the magento way of sending new order email…

Thank you so much and appreciate your valuable inputs..

Helmy

By: Jeff

Jeff — Thu, 29 Jan 2015 18:52:37 +0000

A recent problem i’m having with this new way of sending emails is that the scheduler only runs for either 10 / 20 mins (jobs) before stopping abruptly…

If i truncate the cron_schedule table it starts again and merrily continues with its job.
It will schedule ahead as per admin settings, but never regenerate past the initial generation of jobs.

any ideas..?

By: Johan

Johan — Thu, 29 Jan 2015 13:26:29 +0000

So it’s basically using the database as a job queue, which from a scaling perspective is inviting trouble from all sorts of angles. From a performance point of view, this just screams out for being replaced by an external messaging or e-mail service. Shops slowing down due to non-essential tasks is never a good thing.

AWS fans could consider SQS for the queueing and then SES for the sending. Perhaps an idea for MageSend to incorporate SQS job queueing so other systems can also use SES via a common system-in-the-middle.

By: Yorrd

Yorrd — Tue, 27 Jan 2015 19:24:53 +0000

I have updated Magento to 1.9.1 a few days back and I cannot find any tables beginning with core_email. This is already leading to issues (for example with paypal).

From what I remember after skimming through your nice article, I suspect my database is messed up? Can anyone confirm this and tell me there SHOULD in fact be tables like that?

Or even better, can someone tell me where I find the structure of those tables so that I can recreate them on my own in order to fix the issue the paypal module is running into? Thanks a lot in advance 😉