How to quickly get rid of 1000+ old customers from database?
Is there an sql code or something to allow me to quickly prune the old and no longer relevant customers from my database? I've got several thousand on there, going back to 2010, and what with gdpr, people moving house or changing email, efficiency and general jurisprudence and so forth I could probably do with deleting anyone who hasn't logged into their account in a few years as the data will be out of date anyway.
I can't believe that i will literally have to manually delete each and every account via the Admin - there must be a database query of some sort that I could apply? One that would delete people with, say, last log in before 2016 or no log in at all (blank entry)?
Any help appreciated!
ta
Andy
v 1.5.6
Re: How to quickly get rid of 1000+ old customers from database?
Or indeed, based on their last order date...?
Re: How to quickly get rid of 1000+ old customers from database?
You may want to use my Delete Spam Customers mod, which can delete customers according to whatever query you want to build.
https://www.zen-cart.com/downloads.php?do=file&id=2253