Deleting of a product will remove the products from the database.
NOTE: This delete will not work if the product have some transactions related to it. Transaction can be Opening Stock, Purchase, Sales or Stock transfer of the product. It will show some error like:
When a product has any transactions it cannot be deleted.
Transactions can be either Sales, Purchase, or Adding opening stock.
The best way to avoid such products is by deactivation them