Magento CSV Export All customer with Billing and Shipping Address

Magento CSV Export All customer with Billing and Shipping Address

In this post we will show you how to create Magento CSV Export All customer for Billing and Shipping Address. hear we will show you Export All customer to CSV with Billing and Shipping Address.

<?php
require_once('app/Mage.php');
umask(0);
Mage::app();
 
$customers_obj = Mage::getModel('customer/customer')->getCollection();
$customers_obj->addAttributeToSelect('*');
 
$customers_data_array[0] = array(    
    'email',
    'prefix',
	'suffix',
	'created_at',
	'is_active',
    'firstname',
    'middlename',
	'entity_id',
    'lastname',
    'group_id',
    'website_id',
    'store_id',   
    'is_subscribed',
    'customer_billing_firstname',
    'customer_billing_lastname',
    'customer_billing_street_1',
    'customer_billing_street_2',
    'customer_billing_city',
    'customer_billing_region_id',
    'customer_billing_region',
    'customer_billing_postcode',
    'customer_billing_country_id',
    'customer_billing_telephone',
    'customer_shipping_firstname',
    'customer_shipping_lastname',
    'customer_shipping_street_1',
    'customer_shipping_street_2',
    'customer_shipping_city',
    'customer_shipping_region_id',
    'customer_shipping_region',
    'customer_shipping_postcode',
    'customer_shipping_country_id',
    'customer_shipping_telephone'
);
 
$i = 1;
foreach ($customers_obj as $key => $customer_data) {
    $customers_data_array[$i]['entity_id'] = $customer_data->getData('entity_id');
    $customers_data_array[$i]['email'] = $customer_data->getData('email');
    $customers_data_array[$i]['prefix'] = $customer_data->getData('prefix');
    $customers_data_array[$i]['firstname'] = $customer_data->getData('firstname');
    $customers_data_array[$i]['middlename'] = $customer_data->getData('middlename');
    $customers_data_array[$i]['lastname'] = $customer_data->getData('lastname');
    $customers_data_array[$i]['suffix'] = $customer_data->getData('suffix');
    $customers_data_array[$i]['website_id'] = $customer_data->getData('website_id');
    $customers_data_array[$i]['store_id'] = $customer_data->getData('store_id');
    $customers_data_array[$i]['group_id'] = $customer_data->getData('group_id');
    $customers_data_array[$i]['created_at'] = $customer_data->getData('created_at');
    $customers_data_array[$i]['updated_at'] = $customer_data->getData('updated_at');
    $customers_data_array[$i]['is_active'] = $customer_data->getData('is_active');
 
    $subscriber = Mage::getModel('newsletter/subscriber')->loadByEmail($customers_data_array[$i]['email']);
    $subscriberStatus = $subscriber->isSubscribed();
 
    $customers_data_array[$i]['is_subscribed'] = ($subscriberStatus? 1 : 0);
 
    if($customer_data->getDefaultBilling()) {
        $customer_billingAddress = Mage::getModel('customer/address')->load($customer_data->getDefaultBilling());
        if($billingAddress->getId()) {
            $customers_data_array[$i]['customer_billing_firstname'] = $customer_billingAddress->getData('firstname');
            $customers_data_array[$i]['customer_billing_lastname'] = $customer_billingAddress->getData('lastname');
            $customers_data_array[$i]['customer_billing_street_1'] = $customer_billingAddress->getStreet1();
            $customers_data_array[$i]['customer_billing_street_2'] = $customer_billingAddress->getStreet2();
            $customers_data_array[$i]['customer_billing_city'] = $customer_billingAddress->getData('city');
            $customers_data_array[$i]['customer_billing_region_id'] = $customer_billingAddress->getData('region_id');
            $customers_data_array[$i]['customer_billing_region'] = $customer_billingAddress->getData('region');
            $customers_data_array[$i]['customer_billing_postcode'] = $customer_billingAddress->getData('postcode');
            $customers_data_array[$i]['customer_billing_country_id'] = $customer_billingAddress->getData('country_id');
            $customers_data_array[$i]['customer_billing_telephone'] = $customer_billingAddress->getData('telephone');
        }
    }
    if($customer_data->getDefaultShipping()) {
        $customer_shippingAddress = Mage::getModel('customer/address')->load($customer_data->getDefaultShipping());
        if($shippingAddress->getId()) {
            $customers_data_array[$i]['customer_shipping_firstname'] = $customer_shippingAddress->getData('firstname');
            $customers_data_array[$i]['customer_shipping_lastname'] = $customer_shippingAddress->getData('lastname');
            $customers_data_array[$i]['customer_shipping_street_1'] = $customer_shippingAddress->getStreet1();
            $customers_data_array[$i]['customer_shipping_street_2'] = $customer_shippingAddress->getStreet2();
            $customers_data_array[$i]['customer_shipping_city'] = $customer_shippingAddress->getData('city');
            $customers_data_array[$i]['customer_shipping_region_id'] = $customer_shippingAddress->getData('region_id');
            $customers_data_array[$i]['customer_shipping_region'] = $customer_shippingAddress->getData('region');
            $customers_data_array[$i]['customer_shipping_postcode'] = $customer_shippingAddress->getData('postcode');
            $customers_data_array[$i]['customer_shipping_country_id'] = $customer_shippingAddress->getData('country_id');
            $customers_data_array[$i]['customer_shipping_telephone'] = $customer_shippingAddress->getData('telephone');
        }
    }
    $i++;
}
 
$csv_file = fopen('customer_csv_export.csv', 'w');
foreach ($customers_data_array as $customers_data) {
    fputcsv($csv_file, $customers_data);
}
fclose($csv_file);
 
//echo "<pre>";
//var_dump($customers_data_array);
//echo "</pre>";
?>

You also like Get Order Details using Order and customer registration programmatically and Magento2 admin login user detail