For your security, we currently do not support deleting products permanently. Products are simply marked as deleted internally and that is the suggested mode.
If you have only been testing and need to permanently delete all products before starting production, you can try to execute these SQL queries. Please make sure to take a full backup, run the queries and test your system afterwards.
We don't support nor encourage deleting products permanently. Use at your own risk.
DELETE FROM Revindex_Storefront_RecurringSalesOrder
DELETE FROM Revindex_Storefront_VoucherHistory
DELETE FROM Revindex_Storefront_SalesPayment
DELETE FROM Revindex_Storefront_SalesOrderDetail
DELETE FROM Revindex_Storefront_SalesOrder
DELETE FROM Revindex_Storefront_Gallery WHERE ProductID IS NOT NULL OR ProductVariantID IS NOT NULL
DELETE FROM Revindex_Storefront_ProductAttribute
DELETE FROM Revindex_Storefront_ProductCategory
DELETE FROM Revindex_Storefront_ProductReview
DELETE FROM Revindex_Storefront_ProductVariantOption
DELETE FROM Revindex_Storefront_WishListDetail
DELETE FROM Revindex_Storefront_RequiredProduct
DELETE FROM Revindex_Storefront_ProductVariant
DELETE FROM Revindex_Storefront_ProductVariantGroupOption
DELETE FROM Revindex_Storefront_ProductVariantGroup
DELETE FROM Revindex_Storefront_CrosssellProduct
DELETE FROM Revindex_Storefront_RelatedProduct
DELETE FROM Revindex_Storefront_Product