Say we have 500,000 products in our DB, which we no longer want. How can we permanently delete them?
If we remove them from the GUI, they are just flagged as ‘deleted’ in the database table. To keep the DB/resources light, we would prefer to remove them completely.
Can this be done?
P.S. Why don’t you use foreign keys in the DB to handle cascading deletions of products (and their child data records)?