清空测试订单信息及测试商品信息的方法（V3.0+）

admin

用户在安装系统后，需要对系统进行测试，产生了一些测试订单，而订单在发货或者完成状态下，就已经无法删除了。现在官方提供清除这些测试订单的方法，该方法需要手动执行数据库语句，请谨慎使用：

1. TRUNCATE TABLE `dbshop_order`;
   
2. TRUNCATE TABLE `dbshop_order_change_amount`;
   
3. TRUNCATE TABLE `dbshop_order_delivery_address`;
   
4. TRUNCATE TABLE `dbshop_order_discount_record`;
   
5. TRUNCATE TABLE `dbshop_order_goods`;
   
6. TRUNCATE TABLE `dbshop_order_goods_evaluation`;
   
7. TRUNCATE TABLE `dbshop_order_goods_evaluation_base`;
   
8. TRUNCATE TABLE `dbshop_order_goods_return`;
   
9. TRUNCATE TABLE `dbshop_order_refund_log`;
   
10. TRUNCATE TABLE `dbshop_order_self_location`;
    
11. TRUNCATE TABLE `dbshop_order_status`;
    
12. UPDATE `dbshop_goods_sales_record` SET `goods_sales_num`=0;

复制代码

下面为清空测试商品信息的sql执行语句：

1. TRUNCATE TABLE `dbshop_goods`;
   
2. TRUNCATE TABLE `dbshop_goods_brand_in_class`;
   
3. TRUNCATE TABLE `dbshop_goods_class`;
   
4. TRUNCATE TABLE `dbshop_goods_consultation`;
   
5. TRUNCATE TABLE `dbshop_goods_custom`;
   
6. TRUNCATE TABLE `dbshop_goods_discount`;
   
7. TRUNCATE TABLE `dbshop_goods_group_price`;
   
8. TRUNCATE TABLE `dbshop_goods_image`;
   
9. TRUNCATE TABLE `dbshop_goods_in_attribute`;
   
10. TRUNCATE TABLE `dbshop_goods_in_class`;
    
11. TRUNCATE TABLE `dbshop_goods_in_spec_goods`;
    
12. TRUNCATE TABLE `dbshop_goods_in_spec_goods_group_price`;
    
13. TRUNCATE TABLE `dbshop_goods_in_spec_group_tag`;
    
14. TRUNCATE TABLE `dbshop_goods_in_spec_image`;
    
15. TRUNCATE TABLE `dbshop_goods_in_tag`;
    
16. TRUNCATE TABLE `dbshop_goods_in_wholesale`;
    
17. TRUNCATE TABLE `dbshop_goods_sales_record`;
    
18. TRUNCATE TABLE `dbshop_goods_spec_tag`;
    
19. TRUNCATE TABLE `dbshop_goods_spec_tag_goods`;
    
20. TRUNCATE TABLE `dbshop_goods_stock`;
    
21. TRUNCATE TABLE `dbshop_goods_virtual`;
    
22. TRUNCATE TABLE `dbshop_cart`;

复制代码