How to delete all Magento’s sample products in Magento’s database

The following queries will delete all products in Magento’s database

TRUNCATE TABLE `catalog_product_bundle_option`;
delete from catalog_product_bundle_option where option_id >0;
TRUNCATE TABLE `catalog_product_bundle_option_value`;
TRUNCATE TABLE `catalog_product_bundle_selection`;
TRUNCATE TABLE `catalog_product_entity_datetime`;
TRUNCATE TABLE `catalog_product_entity_decimal`;
TRUNCATE TABLE `catalog_product_entity_gallery`;
TRUNCATE TABLE `catalog_product_entity_int`;
TRUNCATE TABLE `catalog_product_entity_media_gallery`;
delete from catalog_product_entity_media_gallery where value_id < 373;
TRUNCATE TABLE `catalog_product_entity_media_gallery_value`;
TRUNCATE TABLE `catalog_product_entity_text`;
TRUNCATE TABLE `catalog_product_entity_tier_price`;
TRUNCATE TABLE `catalog_product_entity_varchar`;
TRUNCATE TABLE `catalog_product_link`;
delete from catalog_product_link where link_id >0;
TRUNCATE TABLE `catalog_product_link_attribute`;
delete from catalog_product_link_attribute where product_link_attribute_id>0;
TRUNCATE TABLE `catalog_product_link_attribute_decimal`;
TRUNCATE TABLE `catalog_product_link_attribute_int`;
TRUNCATE TABLE `catalog_product_link_attribute_varchar`;
TRUNCATE TABLE `catalog_product_link_type`;
delete from catalog_product_link_type where link_type_id >0;
TRUNCATE TABLE `catalog_product_option`;
delete from catalog_product_option where option_id > 0;
TRUNCATE TABLE `catalog_product_option_price`;
TRUNCATE TABLE `catalog_product_option_title`;
TRUNCATE TABLE `catalog_product_option_type_price`;
TRUNCATE TABLE `catalog_product_option_type_title`;
TRUNCATE TABLE `catalog_product_option_type_value`;
delete from catalog_product_option_type_value where option_type_id > 0;
TRUNCATE TABLE `catalog_product_super_attribute`;
delete from catalog_product_super_attribute where product_super_attribute_id>0;
TRUNCATE TABLE `catalog_product_super_attribute_label`;
TRUNCATE TABLE `catalog_product_super_attribute_pricing`;
TRUNCATE TABLE `catalog_product_super_link`;
TRUNCATE TABLE `catalog_product_enabled_index`;
TRUNCATE TABLE `catalog_product_website`;
TRUNCATE TABLE `catalog_product_entity`;
delete from catalog_product_entity where entity_id>0;

TRUNCATE TABLE `cataloginventory_stock`;
TRUNCATE TABLE `cataloginventory_stock_item`;
TRUNCATE TABLE `cataloginventory_stock_status`;

After executed the above queries, you need to insert some default data back running the below queries:

insert  into `catalog_product_link_type`(`link_type_id`,`code`) values (1,'relation'),(2,'bundle'),(3,'super'),(4,'up_sell'),(5,'cross_sell');
insert  into `catalog_product_link_attribute`(`product_link_attribute_id`,`link_type_id`,`product_link_attribute_code`,`data_type`) values (1,2,'qty','decimal'),(2,1,'position','int'),(3,4,'position','int'),(4,5,'position','int'),(6,1,'qty','decimal'),(7,3,'position','int'),(8,3,'qty','decimal');
insert  into `cataloginventory_stock`(`stock_id`,`stock_name`) values (1,'Default');

If the above queries give errors, that might be the version issues, then just go open the Magento sample data script you used to creat all the tables in Magento’s database, find and run the queries used to inserting data to those tables: catalog_product_link_type, catalog_product_link_attribute, and cataloginventory_stock.