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
Post a Comment