Acctivate allows products that have never been in use to be deleted. Once there are transactions tied to a product, that product can no longer be deleted. Users can mark products as inactive to hide the product from product lookup screens, but it cannot be deleted for historic data purposes.
This is done to ensure data integrity and to preserve a history of transactions. If an item were to be deleted, all transactions related to these products would have to be altered.