zen cart delete customer by last login date

[swguy]

That just puts an item in the menu. You need to edit the admin/delete_spam_customers.php and add a new query there.

find the last $queries entry and right after it add:

$queries[] = array(
'name' => 'No login for 2 years',
'string' => "SELECT customers_info_id as customers_id FROM " . TABLE_CUSTOMERS_INFO . " WHERE customers_info_date_of_last_logon < '" . date('Y-m-d', strtotime("-2 years")) . "'");

Make a backup before you do this!

[Heresy Miniatures]

In order to do this to get rid of the customers with 'blank' last logins who still escaped the purge of that code, by switching it to people who haven't ordered in two years, I should simply change the above code to "WHERE customers_date_of_last_order < '" instead, is that right?

[swguy]

There's no such field as customers_date_of_last_order.

[mc12345678]

In order to do this to get rid of the customers with 'blank' last logins who still escaped the purge of that code, by switching it to people who haven't ordered in two years, I should simply change the above code to "WHERE customers_date_of_last_order < '" instead, is that right?

There's no such field as customers_date_of_last_order.

To do that lookup requires a review of the orders table.

This "other" group though of individuals. Saying that somehow they have an empty date of last login. Ok. But then to address removal of someone that hasn't ordered in the last 2 years? Can you explain the relationship you're trying to use? What about someone that just created their account yesterday or even 30 minutes ago. They may not have ordered yet, but also indicating that it seems such individuals have some sort of empty last login field. So... trying to understand what criteria are to be (further) met to address the data?

[Heresy Miniatures]

Good point - basically when I look at the list of customers, and sort it by Last Logon ASC, there are people who, says, created their account in 2012, made one order, in 2012, and then never logged in again after that. On the list of customers in Admin, they have a blank entry under Last Login, and if I check the side menu for more specific info, it says eg
Last Logon: [blank space, no entry]
Number of logons: 0
I really shouldn't have any data kept on customers from 10 years ago, I expect GDPR comes into play or something

So in an ideal world, i'd look to delete anybody with 0 logins whose account was also created before 2 years ago, maybe?
Or somebody whose account was created more than 2 years ago with only 1 order on it, or 0 orders?

My knowledge of coding is entirely based on what I read in, (and copy and paste from) these threads so thanks for any guidance