Synopsis
For various reasons, a store admin may want to bulk delete every product from their store all at once.
Procedure
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