Delete address from phpmyadmin

Question

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

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 — Morgan Tartreau, Sep 21, 2018 at 9:49

Niranjan B · Accepted Answer · 2018-09-21 09:51:53Z

1

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

use the query.

answered Sep 21, 2018 at 9:51

Niranjan B

1,23211 silver badges13 bronze badges

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

Add a comment |

1 Answer 1