I have a customer that have a lot of addresses (because I saved his address after each order)

So now I can't save changes I've made from backend because there's to many addresses and it's crashing my website.

How can I remove addresses from phpmyadmin? Knowing that some orders are related to addresses

  • What's crashing the site? what error does it come up with?
    – treyBake
    Commented Sep 21, 2018 at 9:46
  • When I want to change one info from my user dans I click on "save", the site shows "address" part (from the Backend) and just not responding after Commented Sep 21, 2018 at 9:49

1 Answer 1


Check the customer_address_entity delete the address based on the parent_id which is customer id.

use the query.

  • I though about that, but isn't this going to create error with existing order ? Commented Sep 21, 2018 at 9:53

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.