在magento的后台删除产品太慢,蜗牛的速度,下面是快速清空magento的所有产品,
登录你的cpanel,然后进入phpmyadmin,然后执行下面的sql语句即可!
然后清除缓存,会看到产品都没了!
TRUNCATE TABLE `catalog_product_bundle_option`;
2 |
TRUNCATE TABLE `catalog_product_bundle_option_value`; |
3 |
TRUNCATE TABLE `catalog_product_bundle_selection`; |
4 |
TRUNCATE TABLE `catalog_product_entity_datetime`; |
5 |
TRUNCATE TABLE `catalog_product_entity_decimal`; |
6 |
TRUNCATE TABLE `catalog_product_entity_gallery`; |
7 |
TRUNCATE TABLE `catalog_product_entity_int`; |
8 |
TRUNCATE TABLE `catalog_product_entity_media_gallery`; |
9 |
TRUNCATE TABLE `catalog_product_entity_media_gallery_value`; |
10 |
TRUNCATE TABLE `catalog_product_entity_text`; |
11 |
TRUNCATE TABLE `catalog_product_entity_tier_price`; |
12 |
TRUNCATE TABLE `catalog_product_entity_varchar`; |
13 |
TRUNCATE TABLE `catalog_product_link`; |
14 |
TRUNCATE TABLE `catalog_product_link_attribute`; |
15 |
TRUNCATE TABLE `catalog_product_link_attribute_decimal`; |
16 |
TRUNCATE TABLE `catalog_product_link_attribute_int`; |
17 |
TRUNCATE TABLE `catalog_product_link_attribute_varchar`; |
18 |
TRUNCATE TABLE `catalog_product_link_type`; |
19 |
TRUNCATE TABLE `catalog_product_option`; |
20 |
TRUNCATE TABLE `catalog_product_option_price`; |
21 |
TRUNCATE TABLE `catalog_product_option_title`; |
22 |
TRUNCATE TABLE `catalog_product_option_type_price`; |
23 |
TRUNCATE TABLE `catalog_product_option_type_title`; |
24 |
TRUNCATE TABLE `catalog_product_option_type_value`; |
25 |
TRUNCATE TABLE `catalog_product_super_attribute`; |
26 |
TRUNCATE TABLE `catalog_product_super_attribute_label`; |
27 |
TRUNCATE TABLE `catalog_product_super_attribute_pricing`; |
28 |
TRUNCATE TABLE `catalog_product_super_link`; |
29 |
TRUNCATE TABLE `catalog_product_enabled_index`; |
30 |
TRUNCATE TABLE `catalog_product_website`; |
31 |
TRUNCATE TABLE `catalog_product_entity`; |
32 |
TRUNCATE TABLE `cataloginventory_stock`; |
33 |
TRUNCATE TABLE `cataloginventory_stock_item`; |
34 |
TRUNCATE TABLE `cataloginventory_stock_status`; |
36 |
INSERT INTO `catalog_product_link_type`(`link_type_id`,`code`) VALUES (1, 'relation' ),(2, 'bundle' ),(3, 'super' ),(4, 'up_sell' ),(5, 'cross_sell' ); |
37 |
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' ); |
38 |
INSERT INTO `cataloginventory_stock`(`stock_id`,`stock_name`) VALUES (1, 'Default' ); |