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

Please run the below queries to delete the data from your magento.

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 you run above queries, please run below ones to insert the some deafult data.

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 queries give any 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.