Remove Customers who have no orders and do not have valid address's

[Bio_scott]

I am trying to clean up some bad data in our Customer data base and wanted to see if there is simple process to delete customer who have no orders, and have invalid addressing, No State Code, NO Street Address, No Country, etc.

Thank you

Scott

[Gabriel Guarino · Accepted solution]

Hi @Bio_scott,

The best way of doing that is creating a custom shell script to remove those customers.

Here you can see how to create a shell script in Magento:

Then, in the shell script, you should get the customer collection and filter the collection to get those customers that meet your conditions.

Finally, you can run the script to remove those customers.

Best regards.
Gabriel

[bruce_behrstock]

I HAVE THOUSANDS OF BOGUS CUSTOMER ON MY MAGENTO.

I AM NOT A PROGRAMMER AND UNFAMILIAR WITH WRITING CODE.

CAN SOMEONE OUT THERE HELP ME TO REMOVE THESE RECORDS.  THEY ALL HAVE GMAIL EMAIL ADDRESS BUT LETTERS THAT LOOK LIKE THEY CAME FROM RUSSIA.

BRUCE

BRUBEHRS@ACEHOSE.COM