To delete all product related data, use the following query:
DELETE FROM catalog_product_entity;
Due to the constraints it will delete all related data from other tables as well.
Deleting all products using SQL
Need help implementing this solution, or still looking for a fix to your Magento problem? Get in touch and I will be happy to help with your project.