Hi,

Always don't use DB if you don't know the consequences.

You can archive them, You will filter them from list view, select them and from actions menu select Archive.

If you want to delete them completely, You can filter them from list view, select them and from actions menu select delete.

If you can select them from list view, you can write code on product_template model and use ORM unlink.