Latest News: (loading..)
Search the Community
Showing results for tags 'remove'.
Found 1 result
A customer can have multiple addresses but when their account is deleted only the primary address is deleted. How can the other addresses be deleted if they exist? After 11 years working with osC I have the database a bit saturated and I'm doing cleaning. Spanish laws require to keep invoices for a minimum of 5 years, although they are recommended 6. From there, there is no obligation to keep obsolete old orders, they can be eliminated and that is what I am doing. The problem is that many have two addresses because they are gifts that are made to each other or that they want to receive it at home but that the invoice is made on behalf of the company or similar situations. When you delete those orders they only delete the main address, not the others, and that is filling the database little by little. I'm afraid that at any moment it will be corrupted. Provisionally I am doing it manually but I would like to know if there is a way to do it automatically. Doing so is slow and heavy, very heavy. There must be a simple form but right now I am also saturated checking one by one each data from the different tables in the database so as not to make an error. Thanks in advance for the help, it is something that we would all appreciate since it had never been raised because it has not been given due importance.