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 ACCEPTED SOLUTION

Accepted Solutions

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

Welcome to the Magento Forums. Remember to introduce yourself and read the Magento Forums Guidelines.

View solution in original post

2 REPLIES 2

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

Welcome to the Magento Forums. Remember to introduce yourself and read the Magento Forums Guidelines.

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

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