Magento export customers who are not unsubscribed -


is there way in magento admin panel export customers not unsubscribed i.e.

required_customers = all_customers - unsubscribed_customers

in way, get:

new_customers(who have not subscribed) + subscribed_customers - unsubscribed_customers(who subscribed once unsubscribed)

you can change code

 $collection = mage::getmodel('customer/customer')->getcollection();  $collection->getselect()->joinleft(array('ns'=>'newsletter_subscriber'), 'ns.customer_id=e.entity_id', array('substatus'=>'ns.subscriber_status') );  foreach($collection->getdata() $customer){     if($customer['substatus']!=1){         print_r($customer);     } } 

you can modify if condition per requirement.


Comments

Popular posts from this blog

c++ - QTextObjectInterface with Qml TextEdit (QQuickTextEdit) -

xcode - Swift Playground - Files are not readable -

jboss7.x - JBoss AS 7.3 vs 7.4 and differences -