Delete all your products in Magento
If you don't know what you are doing don't do this. It will completely ruin your site. You will have no products left. Always make a backup! This is tested on 1.6 + Vern has pointed out I need to remove products and categories, I have posted his updateSET FOREIGN_KEY_CHECKS = 0; TRUNCATE TABLE `core_url_rewrite`; TRUNCATE TABLE `catalog_product_relation`; TRUNCATE TABLE `catalog_category_entity`; TRUNCATE TABLE `catalog_category_entity_datetime`; TRUNCATE TABLE `catalog_category_entity_decimal`; TRUNCATE TABLE `catalog_category_entity_int`; TRUNCATE TABLE `catalog_category_entity_text`; TRUNCATE TABLE `catalog_category_entity_varchar`; TRUNCATE TABLE `catalog_category_product`; TRUNCATE TABLE `catalog_category_product_index`; INSERT INTO `catalog_category_entity`(`entity_id`,`entity_type_id`,`attribute_set_id`,`parent_id`,`created_at`,`updated_at`,`path`,`position`,`level`,`children_count`) VALUES (1,3,0,0,'0000-00-00 00:00:00','2009-02-20 00:25:34','1',1,0,1),(2,3,3,0,'2009-02-20 00:25:34','2009-02-20 00:25:34','1/2',1,1,0); INSERT INTO `catalog_category_entity_int`(`value_id`,`entity_type_id`,`attribute_id`,`store_id`,`entity_id`,`value`) VALUES (1,3,34,0,2,1),(2,3,34,1,2,1); INSERT INTO `catalog_category_entity_varchar`(`value_id`,`entity_type_id`,`attribute_id`,`store_id`,`entity_id`,`value`) VALUES (1,3,33,0,1,'Root Catalog'), (2,3,35,0,1,'root-catalog'), (3,3,33,0,2,'Default Category'), (4,3,41,0,2,'PRODUCTS'), (5,3,35,0,2,'default-category'); 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_label`; TRUNCATE TABLE `catalog_product_super_attribute_pricing`; TRUNCATE TABLE `catalog_product_super_attribute`; TRUNCATE TABLE `catalog_product_super_link`; TRUNCATE TABLE `catalog_product_enabled_index`; TRUNCATE TABLE `catalog_product_website`; TRUNCATE TABLE `catalog_category_product_index`; TRUNCATE TABLE `catalog_category_product`; TRUNCATE TABLE `cataloginventory_stock_item`; TRUNCATE TABLE `cataloginventory_stock_status`; TRUNCATE TABLE `cataloginventory_stock`; TRUNCATE TABLE `catalog_compare_item`; TRUNCATE TABLE `adminnotification_inbox`; TRUNCATE TABLE `index_event`; TRUNCATE TABLE `index_process_event`; TRUNCATE TABLE `log_url_info`; TRUNCATE TABLE `log_url`; TRUNCATE TABLE `log_visitor`; TRUNCATE TABLE `log_visitor_info`; TRUNCATE TABLE `report_viewed_product_index`; TRUNCATE TABLE `report_event`; DELETE FROM `eav_attribute_option` WHERE attribute_id = 70; DELETE `eav_attribute_option_value`.* FROM `eav_attribute_option_value` LEFT JOIN `eav_attribute_option` USING (`option_id`) WHERE `eav_attribute_option`.`option_id` IS NULL; 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'); TRUNCATE TABLE `catalog_product_entity`; SET FOREIGN_KEY_CHECKS = 1;
This post is informative and helpful to me.Maintaining backup to the magento products is good thing. Magento Website Design
ReplyDeletePersonal Injury Solicitor Bradford
ReplyDeleteI was very pleased to find this site
Excellent tips. Really useful stuff .Never had an idea about this, will look for more of such informative posts from your side.. good job…
ReplyDeletejoomla programmers
hire joomla developer
A very good and interesting post that i have come across, thanks for sharing the post.
ReplyDeleteReally appreciable
Web Design Bangalore
Nice article...this post is outstanding in regards of both information as well as information.thanks for talking about you post with us.
ReplyDeleteWebsite Designers Bangalore
Great post...
ReplyDeletemobile child tracker app
Gud information. Website Design Company in chennai
ReplyDeleteNice Article, Good Information, Lovely Content.
ReplyDeleteCar Rental In Chennai
A Very Great Post, Thanks For Sharing This Post...
ReplyDeleteBridal Cars Chennai
car travels in vijayawada
ReplyDelete
ReplyDeleteBootstrap technology is the one I am not familiar with. The advantages of Bootstrap technology inspire me to use this technology in my website. Great work author.
Hire Web Developer
Hire a Programmer
Hire a Coder
You've shared some excellent article about Magento Developers. I'm grateful for this post because it contains a lot of useful information. Thank you for sharing this piece of writing.
ReplyDeleteMmorpg oyunları
ReplyDeleteinstagram takipçi satın al
tiktok jeton hilesi
Tiktok Jeton Hilesi
SAC EKİMİ ANTALYA
referans kimliği nedir
instagram takipçi satın al
metin2 pvp serverlar
instagram takipçi satın al
kartal vestel klima servisi
ReplyDeletekadıköy mitsubishi klima servisi
ümraniye vestel klima servisi
kartal bosch klima servisi
ümraniye bosch klima servisi
kartal arçelik klima servisi
ümraniye arçelik klima servisi
beykoz samsung klima servisi
üsküdar samsung klima servisi
Our expert workers compiles and ranks lists of the playing industry's best possible sites. Explore our hottest Sportsbook, Casino and Poker sites, plus learn our critiques, 카지노 사이트 suggestions and strategies. However, because of local laws, clients even have the flexibility to make a deposit using PayPal, Neteller, Visa, and different safe fee strategies. These funds can then be used to play on-line on line casino video games offering money prizes.
ReplyDelete