How to send newsletter queue in Admin Magento


If newsletter queue is not going to sent by default magento cron, try to send newsletter manually as following way. In some magento version there is problem of newsletter queue. It is not going to sent by default magento cron to all your subscriber. So your newsletter will not sent to all of your customer which are subscribe to your site.

But don't worry if this is happens with you can send your newsletter to all your customer manually as described below. 



i have found the page of newsletter queue which is

'app\design\adminhtml\default\default\template\newsletter\queue\list.phtml'
in this page getChildHtml('grid') ?> this function call the list body

which come from

'app\code\core\Mage\Adminhtml\Block\Newsletter\Queue\Grid\Renderer\Action.php'

add following code in that page but don't make any change in core file, override that file
in your local directory as

'app\code\local\Mage\Adminhtml\Block\Newsletter\Queue\Grid\Renderer \Action.php'

just copy and paste that file in this directory.

Now add the following code in line number 77 before this code $this->getColumn()->setActions($actions);

$actions[] = array(
'url'=> $this->getUrl('*/newsletter_queue/sending'),
'caption'=>Mage::helper('newsletter')->__('Send'),
'popup' =>true
);

Update: By default magento send only 20 recipients at time. if you want to change this number and want to send more recipients at a time change in following file.

app/code/core/Mage/Adminhtml/controllers/Newsletter/QueueController.php in this file change following line

$countOfSubscritions = 20;
to
$countOfSubscritions = 100; //change 100 with what ever number you want to change.



Hit like or leave comment if post help!

8 comments: Click to see all comments

  1. Thank you for this MUCH NEEDED work-around. All of a sudden the newsletter queue stopped working after 3 months of non use. WTH??? I don't know why. Had to remove 3 of the 0 subscriber queues via the db from a prior time (as suggested in a posted forum), but nothing worked except your work-around. THANKS A MILLION!

    @Ricky Mignanego -> You may be able to stop the popup by changing the word true to false in the last statement of the code.

    'popup' =>true change to 'popup' =>false

    However, it seems that the popup generates some sort of key. Not sure of the usefulness of the popup, though.

    ReplyDelete
  2. Thank you, thank you, thank you!!!! GREAT JOB!!!! good bye cron!!!!

    Did i say Thank You???? :-)

    ReplyDelete
  3. Mabuhay! Thank you now its working :)

    ReplyDelete
  4. Mabuhay! Great help, it works :)

    ReplyDelete
  5. Thanks for this solution.
    It works for me just by adding

    $actions[] = array(
    'url'=> $this->getUrl('*/newsletter_queue/sending'),
    'caption'=>Mage::helper('newsletter')->__('Send'),
    'popup' =>true
    );

    I did not copy the other page because i dont understand what it says. I mean i dont know what to copy to where.
    Is this the reasen that when is use send that only 20 e-mails a time are sent?

    Thanks again, Hilvy

    ReplyDelete
  6. So far so good! Now has a send button in the queue and said sent after hitting the send button. Now to see if it actually worked!

    ReplyDelete
  7. For me show SENDING after that fix... but I am waiting 24h and didn't send any email... still showing SENDING... :-(

    ReplyDelete
  8. Thanks it worked!

    @amows if you have to many failed (and or newsletters with no assigned customers) newsletters in queue it doesn't work. You need to delete them from database first.

    ReplyDelete

 

Copyright @ 2014 HK Magento Blog.