cancel
Showing results for 
Search instead for 
Did you mean: 

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

SOLVED

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

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

1 REPLY

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

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:

Screen Shot 2016-10-10 at 8.43.58 PM.png

 

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

If my answer was useful, please give "Kudos" to this post.
If my answer helps you to resolve the problem, click on "Accept as Solution".