blocks|key|1739753|text|要删除产品，只需使用后台即可：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1739754|Catalog+>+Manage+Products+>选择所有复选框，选择Action+=+Delete并点击submit。|1739755|这可能对数千种产品非常有效。|1739756|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|H|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|I|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|J|8|@]|9|@]|A|$]]|$1|F|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|G|$]]

In order to delete products, you can simply use backend: 
Catalog > Manage Products > Select all checboxes and choose Action = Delete and hit submit. 
This may work very good for some thousands of products.

blocks|key|1739768|text|不管用于删除产品的方法是什么，重建"Category+products“索引应该可以修复计数。转到系统>索引管理。选中"Category+Products“旁边的复选框，将操作(右上角)更改为"Reindex”，然后单击submit。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1739769|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

Regardless of the method used to delete the products, rebuilding the "Category Products" index should fix the counts. Go to System > Index Management. Check the box next to "Category Products", change the action (top right) to "Reindex" and click submit.

blocks|key|1953286|text|要删除所有产品，您可以使用以下查询：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1953287|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`;

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');|code-block|syntax|javascript|1953288|致敬:)|1953289|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

To delete all products you can use this query:

<pre><code>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`;

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');
</code></pre>

Regards :)

blocks|key|1739827|text|从Magento中删除所有产品都很容易，只需运行：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1739828|DELETE+FROM+`catalog_product_entity`|code-block|syntax|javascript|1739829|由于Magento的数据库中设置了外键约束，因此可以很好地清理其中包含产品信息的所有其他表。当然，删除很多产品需要一些时间，但至少会得到很好的清理。|1739830|如果查询因为最大执行时间而无法运行，则可以始终运行以下命令：|1739831|DELETE+FROM+`catalog_product_entity`+LIMIT+10000|1739832|更新:这个逻辑也被用在了Magento的核心中，所以使用起来很安全！https://github.com/OpenMage/magento-mirror/blob/magento-1.8/app/code/core/Mage/ImportExport/Model/Import/Entity/Product.php#L462|offset|length|1739833|entityMap|0|LINK|mutability|MUTABLE|url|https://github.com/OpenMage/magento-mirror/blob/magento-1.8/app/code/core/Mage/ImportExport/Model/Import/Entity/Product.php#L462^0|0|0|0|0|0|Y|3K|0|0^^$0|@$1|2|3|4|5|6|7|Y|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|Z|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|10|8|@]|9|@]|A|$]]|$1|I|3|J|5|6|7|11|8|@]|9|@]|A|$]]|$1|K|3|L|5|D|7|12|8|@]|9|@]|A|$E|F]]|$1|M|3|N|5|6|7|13|8|@]|9|@$O|14|P|15|1|16]]|A|$]]|$1|Q|3|-4|5|6|7|17|8|@]|9|@]|A|$]]]|R|$S|$5|T|U|V|A|$W|X]]]]

Deleting all products from Magento can be easily achieved, just run:

<pre><code>DELETE FROM `catalog_product_entity`
</code></pre>

Because of the foreign key constraints set up in Magento's database, all other tables that have product information in them are cleaned up nicely. It will of course take some time to delete a lot of products, but it at least gets cleaned up nicely.

If the query can't run because of maximum execution time, you can always run something like:

<pre><code>DELETE FROM `catalog_product_entity` LIMIT 10000
</code></pre>

Update:
this logic also gets used in Magento's core, so it's safe to use! <a href="https://github.com/OpenMage/magento-mirror/blob/magento-1.8/app/code/core/Mage/ImportExport/Model/Import/Entity/Product.php#L462">https://github.com/OpenMage/magento-mirror/blob/magento-1.8/app/code/core/Mage/ImportExport/Model/Import/Entity/Product.php#L462</a>

blocks|key|1953334|text|Mage::getModel('catalog/product')->getCollection()->delete();|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|1953335|unstyled|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|G|8|@]|9|@]|A|$B|C]]|$1|D|3|-4|5|E|7|H|8|@]|9|@]|A|$]]]|F|$]]

<pre><code>Mage::getModel('catalog/product')-&gt;getCollection()-&gt;delete();
</code></pre>

blocks|key|1739852|text|像个护身符一样工作。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1739853|Php+myadmin+-选择顶部的数据库(magento)+SWL，然后粘贴以下内容：|1739854|DELETE+FROM+`catalog_product_entity`|code-block|syntax|javascript|1739855|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|L|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|M|8|@]|9|@]|A|$G|H]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

Worked like a charm...

Php myadmin - select databse (magento) SWL at top and then pasted the following:

<pre><code>DELETE FROM `catalog_product_entity`
</code></pre>

blocks|key|1739862|text|在Magento+1.7.0.2上测试|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1739863|++++SET+FOREIGN_KEY_CHECKS+=+0;
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_flat_1`;
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_product_relation`;
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_status_idx`;
TRUNCATE+TABLE+`cataloginventory_stock`;
TRUNCATE+TABLE+`core_url_rewrite`;
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;|code-block|syntax|javascript|1739864|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

Tested on Magento 1.7.0.2 

<pre><code> SET FOREIGN_KEY_CHECKS = 0;
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_flat_1`;
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_product_relation`;
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_status_idx`;
TRUNCATE TABLE `cataloginventory_stock`;
TRUNCATE TABLE `core_url_rewrite`;
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;
</code></pre>

There are a lot of posts regarding this issue on Magento. Most of them work but the problem with Categories not resetting their values to ZERO after executing the delete codes/SQL statements still persists and not being addressed up until now.

Does anyone here has the correct code or procedure to properly delete all products from the inventory and have the Category listing also reset to zero after executing it?

Thanks in advance.

Deleting ALL products on Magento

数据库

在Magento上有很多关于这个问题的帖子。它们中的大多数都可以工作，但是类别在执行delete代码/SQL语句后没有将它们的值重置为零的问题仍然存在，直到现在还没有得到解决。在座的任何人都有正确的代码或程序，可以正确地从库存中删除所有产品，并在执行后将类别列表也重置为零？提前谢谢。

问删除Magento上的所有产品
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问删除Magento上的所有产品EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问删除Magento上的所有产品
EN