Magento – Getting customer collection with only those that are subscribed to newsletters

customerimportnewsletter

I need to import a load of customers to a third party email company but need to only import those that are currently subscribed to newsletters. The import itself has to be a file of customer details which I need to generate. I know I could load up all customers into a collection and iterate through them, only inserting those that are subscribed into the import file but as we have 90000 plus customers I would rather just load the ones that are subscribed into the collection. The import itself uses an API but it needs to have the import file added as an attachment (fine doing that, just including it for information).

Any ideas?

Best Answer

You have to join EAV collection with regular table. It is achievable with joinTable method of Mage_Eav_Model_Entity_Collection_Abstract class. The forth parameter defines the WHERE condition because apparently you can't use addAttributeToFilter method here.

$collection = Mage::getModel('customer/customer')->getCollection();
$collection->addNameToSelect()
    ->joinTable('newsletter_subscriber', 'customer_id=entity_id', array('subscriber_status'), '{{table}}.subscriber_status=1');

Please let me know if something is unclear.

Related Solutions

Magento – How to fully load customers when returned in a customer collection

You don't want your afterLoad event to fire and trigger your method because you will be in a similar case as calling load for each customer. I see that you method calls load on the address model. For a 1k items collection you will get 1k load calls. Not cool.
This may not be the best idea but it should work with 1 query and a few loops through the customer collection.

Why not collect all the address ids you need, then retrieve a collection, then match that collection to the customers from the customer collection.

Let's say that you customer collection is $collection.
You applied filters and everything to it.

$addressIds = array();
$customersByDefaultShipping = array();
foreach ($collection as $item) {
    $defaultShipping = $item->getDefaultShipping();
    if ($defaultShipping) {
         $addressIds[] = $item->getDefaultShipping();
         $customersByDefaultShipping[$defaultShipping] = $item;
    }
}
//get all the addresses.  
$addressCollection = Mage::getModel('customer/address')->getCollection()
    ->addAttributeToSelect('*') //or replace with an array with the attributes you need
    ->addAttributeToFilter('entity_id', $addressIds);
//now loop through the address collection and attach the addresses to the customers;  

foreach ($addressCollection as $address) {
    $customersByDefaultShipping[$address->getId()]->setData('my_value', $address);
}

The beauty of it is that, since the customers are objects, they are passed by reference so now you can loop through the customers collection and the ones that have an address will have it attached to it even if I have used arrays in the code above.

Notice: Untested code. Watch out for typos and even logic errors.

Best Answer

Related Solutions

Magento – How to fully load customers when returned in a customer collection

Related Topic