Removing products from Magento database
Every implementation is followed by the moment when removing some testing and badly imported files is necessary. If their amount is not high, this can be done from the level of administration panel. What if we need to remove thousands of products? Of course this can be done by sitting hour after hour doing this manually but what we also can do is to remove it by database.
If we use second method, it is sure that the problem will be solved within few seconds, moreover, it is worth remembering to remove all charts. Magento is not the easiest system ever made so it contains over 30 charts responsible for the same products. Proper database products signification requires cleaning all charts connected with the products. Below You can see the commands list which may be used in any implementations aiming to clean up database from products:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 | TRUNCATE TABLE `catalog_product_bundle_option`;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`;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`;TRUNCATE TABLE `catalog_product_link_attribute`;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`;TRUNCATE TABLE `catalog_product_option`;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`;TRUNCATE TABLE `catalog_product_super_attribute`;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`; TRUNCATE TABLE `cataloginventory_stock`;TRUNCATE TABLE `cataloginventory_stock_item`;TRUNCATE TABLE `cataloginventory_stock_status`; <span class="ptw615s480h" id="ptw615s480h_5">INSERT</span> INTO `catalog_product_link_type`(`link_type_<span class="ptw615s480h" id="ptw615s480h_3">id</span>`,`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');<br><br> |
Please remember that in case of Magento 1.5 version it is important do insert into the chart called cataloginventory_stock information stock_id with plain 1 and stock_name signed with Default. Enjoy!
