清空测试订单信息及测试商品信息的方法（V3.0+）
用户在安装系统后，需要对系统进行测试，产生了一些测试订单，而订单在发货或者完成状态下，就已经无法删除了。现在官方提供清除这些测试订单的方法，该方法需要手动执行数据库语句，请谨慎使用：TRUNCATE TABLE `dbshop_order`;TRUNCATE TABLE `dbshop_order_change_amount`;
TRUNCATE TABLE `dbshop_order_delivery_address`;
TRUNCATE TABLE `dbshop_order_discount_record`;
TRUNCATE TABLE `dbshop_order_goods`;
TRUNCATE TABLE `dbshop_order_goods_evaluation`;
TRUNCATE TABLE `dbshop_order_goods_evaluation_base`;
TRUNCATE TABLE `dbshop_order_goods_return`;
TRUNCATE TABLE `dbshop_order_refund_log`;
TRUNCATE TABLE `dbshop_order_self_location`;
TRUNCATE TABLE `dbshop_order_status`;
UPDATE `dbshop_goods_sales_record` SET `goods_sales_num`=0;
下面为清空测试商品信息的sql执行语句：
TRUNCATE TABLE `dbshop_goods`;
TRUNCATE TABLE `dbshop_goods_brand_in_class`;
TRUNCATE TABLE `dbshop_goods_class`;
TRUNCATE TABLE `dbshop_goods_consultation`;
TRUNCATE TABLE `dbshop_goods_custom`;
TRUNCATE TABLE `dbshop_goods_discount`;
TRUNCATE TABLE `dbshop_goods_group_price`;
TRUNCATE TABLE `dbshop_goods_image`;
TRUNCATE TABLE `dbshop_goods_in_attribute`;
TRUNCATE TABLE `dbshop_goods_in_class`;
TRUNCATE TABLE `dbshop_goods_in_spec_goods`;
TRUNCATE TABLE `dbshop_goods_in_spec_goods_group_price`;
TRUNCATE TABLE `dbshop_goods_in_spec_group_tag`;
TRUNCATE TABLE `dbshop_goods_in_spec_image`;
TRUNCATE TABLE `dbshop_goods_in_tag`;
TRUNCATE TABLE `dbshop_goods_in_wholesale`;
TRUNCATE TABLE `dbshop_goods_sales_record`;
TRUNCATE TABLE `dbshop_goods_spec_tag`;
TRUNCATE TABLE `dbshop_goods_spec_tag_goods`;
TRUNCATE TABLE `dbshop_goods_stock`;
TRUNCATE TABLE `dbshop_goods_virtual`;
TRUNCATE TABLE `dbshop_cart`;
页:
[1]