Magento – How to Export All Guest Customers

customerexportorders

I would like to give my client, who is running a Magento Store, the possibility, in the backend, to export the list of all guest customers who made orders.

Is there a simple way to achieve this?

Best Answer

You need to create a module that adds the customer_is_guest column to the sales_flat_order_grid table. Once this is done the value from sales_flat_order will automatically copy over when orders are created (you'll have to update all the old ones though).

Next you need to add a Customer Is Guest column to the grid in Sales > Orders. This can be done by extending Mage_Adminhtml_Block_Sales_Order_Grid::_prepareColumns() and adding

$this->addColumn('customer_is_guest', array(
    'header' => Mage::helper('sales')->__('Customer Is Guest'),
    'index' => 'customer_is_guest',
    'type'  => 'options',
    'options' => array(
        0 => Mage::helper('sales')->__('No'),
        1 => Mage::helper('sales')->__('Yes')
    ),
));

Now you'll be able to filter the grid by guest checkouts. Then simply use the built in Export button at the top of the page to get the results in CSV or XML format.

Related Solutions

Magento 1.7 – How to Get All Customer Names and Emails

You can write the below query for guest customer..

    $orderCollection = Mage::getModel("sales/order")->getCollection()
                      ->addFieldToSelect('*')
                      ->addFieldToFilter('customer_is_guest',1) ;
    foreach( $orderCollection  as $order){

             echo $order->getCustomerFirstname()." ";
             echo $order->getCustomerLastname()."<br>";

    }

if you put "customer_is_guest" to 0 then you can get the registered customers..

This comes directly from the "sales_flat_order" table .

Hope this helps..

Magento 2 – Get List of Guest Orders

You can get guest customer order list by below code.

public function __construct(
    \Magento\Sales\Model\ResourceModel\Order\CollectionFactory $orderCollectionFactory,

) {
    $this->orderCollectionFactory = $orderCollectionFactory;
}

public function getGuestOrderCollection()
{
    $orderCollecion = $this->orderCollectionFactory
        ->create()
        ->addFieldToSelect('*');

    $orderCollecion->addAttributeToFilter('customer_is_guest', ['eq'=>1]);

    echo "<pre>";
    print_r($orderCollecion->getData());
    exit; 
    return $orderCollecion;
}

Best Answer

Related Solutions

Magento 1.7 – How to Get All Customer Names and Emails

Magento 2 – Get List of Guest Orders

Related Topic