Hi all, David Boyes schrieb am 21.02.2013 16:45:
As of now we only have an option to make customer invalid by setting Valid=0.
Do we have any option to permanently delete the customer?
David is right, there is no need and no good reason to risk the integrity of the database by simply deleting the records. If you need to comply with a data privacy act, why not simply blank the fields with personal data but leave the record itself in place? Have you tried something like UPDATE `customer_user` SET `last_name`=`` WHERE `valid`=0; ? (SQL untested; you have to add the other fields) (please do a backup before playing with the database) If you blank or NULL the respective fields there would be no personal data left and legal aspects would be o.k. Greets, Henning