Thursday, August 11, 2011

Bulk Emails import into Magento Newsletter Subscriber List

<?php
require_once 'app/Mage.php';
umask( 0 );
Mage :: app( "default" );
//$_helper = new Mage_Newsletter_Model_Subscriber();
//$_helper->subscribe("myemail@e-mail.co.uk");
$emails = array("myemail4@e-mail.co.uk","myemail5@e-mail.co.uk","myemail6@e-mail.co.uk");
foreach($emails as $email){
 $db = Mage::getSingleton('core/resource')->getConnection('core/write');
 $query = "SELECT * FROM newsletter_subscriber WHERE subscriber_email = '$email'";
 $result = $db->query($query);
 if($result->fetchAll()):
 echo "Email Not Added: $email<br/>";
 else:
 $db->query("INSERT INTO newsletter_subscriber (`subscriber_id` , `store_id` , `change_status_at` , `customer_id` , `subscriber_email` , `subscriber_status` , `subscriber_confirm_code`) VALUES (NULL,'1',NULL,'0','$email','1',NULL)");
 echo "Email Successfully Added: $email<br/>";
 endif;
}
?>

No comments:

Post a Comment