How to Change Registered Customer Billing Email at Checkout in Magento

billing-addressorder-emailorderssales-ordersales-quote

I am trying to implement one functionality where logged in user can able to change the billing email address on the time of checkout. I have tried to do that but all the time it updates customer account email address which I don't want. I have tried by updating email from quote & order both before save order function using $quote->getCustomer->setEmail(",,,,,") & $order->getCustomer()->setEmail("...") but unfortunately all the time it updates customer account email address but I need to update customer email id for particular order only (table- sales-flat-order).

Please suggest any solution.

Best Answer

$quote->getCustomer() retrieved the customer model. The email address for the order / quote is stored in the billing address object and in the quote object.

$quote->getBillingAddress()->setEmail('info@example.com');
$quote->setCustomerEmail('info@example.com');

Related Solutions

Magento – How to add the Company Name to the Billing Address information in a new order email

You will need to add the attribute as a field to the tables sales_flat_quote_address and sales_flat_order_address. Then update you config.xml to copy the attributes when the address is converted from quote to order.

<sales_convert_quote_address>
    <your_attribute>
        <to_order_address>*</to_order_address>
        <to_customer_address>*</to_customer_address>
    </your_attribute>
<sales_convert_quote_address>

Now once this is done the item should be on the address object that you have in the email so simply calling $address->getYourAttribute() should work here.

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..

Best Answer

Related Solutions

Magento – How to add the Company Name to the Billing Address information in a new order email

Magento 1.7 – How to Get All Customer Names and Emails

Related Topic