I want to update the order email id from the admin when you see the order detail, note I don't want to update the customer email id, Just want to update the email address for order only.

  • Goto sales_order and sales_order_grid table and update the email ids for particular order. Commented Jul 10, 2018 at 14:27
  • I want to edit the email from admin not using the custom query Commented Jul 11, 2018 at 6:31
  • There is no such feature available in magento Commented Jul 11, 2018 at 6:37

3 Answers 3


Here is step by step guide to achieve the above -:

Step 1 : Go to your phpMyAdmin or sqlyog for your Magento 2 store database

Step 2 : Run the following query against your Magento 2 store database

update sales_flat_order set customer_email='[email protected]' 
where customer_email='[email protected]' 
and increment_id='100000003'

Please take back up before running any delete / update / insert statements against your live database

The above will work for limited amount of requests you get to update or modify email address from your customers.

But if you get a lot of requests or you are not familiar with phpMyAdmin or sqlyog then we would highly recommend you to use the following module as this module allows you to edit email address via admin interface.



Access your database table sales_order_grid and update the customer_email field of the required record.

Execute the below query on your database to achieve the same.

UPDATE sales_flat_order SET customer_email = '[email protected]' 
WHERE increment_id = 'xxxxxx'

Try this cheaper and fully verified solution by magento team

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.