How to Change Existing Customer Email Address

Open Putty with your default Username & Copy – Paste the below Script in it. 

#Customer Email change

select * from sales_flat_order_address where email='old@gmail';
update sales_flat_order_address set email='' where email='old@gmail' and telephone='Telephone Number';
select * from customer_entity where email = 'old@gmail';
update customer_entity set email = '' where email ='old@gmail';
select * from sales_flat_order where customer_email='old@gmail';
update sales_flat_order set customer_email='' where customer_email='old@gmail';
select * from sales_flat_quote where customer_email = 'old@gmail';
update sales_flat_quote set customer_email='' where customer_email='old@gmail';

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s