For various reasons, a store admin may want to bulk delete every product from their store all at once.

To do this, run the following SQL statements against your store database.  This removes these products for good, there is no recovering them!  Be sure you have a good backup first.

Note: These queries are designed for the latest version of the software.  Customers on earlier versions may get errors about objects (tables) not existing.  That will not cause any problems.

DELETE FROM Product

DELETE FROM ProductAffiliate

DELETE FROM ProductCategory

DELETE FROM ProductCustomerLevel

DELETE FROM ProductDistributor

DELETE FROM ProductGenre

DELETE FROM ProductLocaleSetting

DELETE FROM ProductManufacturer

DELETE FROM ProductSection

DELETE FROM ProductVariant

DELETE FROM ProductVector

DELETE FROM ShippingByProduct
DELETE FROM ProductStore
DELETE FROM ProductView