Woocommerce Question posted in
The official Woocommerce documentation can be found here.

Woocommerce: edit customer's email address?

In a Woocommerce shop where there are no account registrations, how can I edit a customers email address that got entered wrong by the customer? For that matter, how can I edit any of the information they put in?

When I go to Woocommerce/Customers, I can see the customers info but I can’t edit any of the information.

I tried manually updating the "wp_wc_customer_lookup" table directly in mysql, but that failed to show any change on the woocommerce/customers page.

Any help would be appreciated!

Tags:

2

Answers


  1. Chosen as BEST ANSWER
    0

    The answer to my question is in the original post, however there was a cache somewhere (still not sure where) that kept me from seeing it as updated:

    Manually updating the "wp_wc_customer_lookup" table directly did the trick.


  2. 0

    First update

    UPDATE `wp_users` SET `user_email`='[email protected]' WHERE `user_email` = '[email protected]'

    And then update

    UPDATE `wp_usermeta` SET `meta_value` = '[email protected]' WHERE `meta_key` = 'billing_email' AND `meta_value` = = '[email protected]'

    Now the new email should appear

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search