Magento 订单清空

于 2013-06-13 16:54:45 发布
阅读量869 收藏
点赞数 
Magento站点复制成一个新的后，要做的是清空订单和用户等垃圾数据。以下是清空这些数据的方法。

1.4.1的Magento订单清空：[php]

TRUNCATE `sales_flat_invoice` ;

TRUNCATE `sales_flat_invoice_grid`;

TRUNCATE `sales_flat_invoice_item` ;

TRUNCATE `sales_flat_order` ;

TRUNCATE `sales_flat_order_address` ;

TRUNCATE `sales_flat_quote_shipping_rate` ;

TRUNCATE `sales_flat_quote_payment` ;

TRUNCATE `sales_flat_quote_item_option` ;

TRUNCATE `sales_flat_quote_item` ;

ALTER TABLE `sales_flat_invoice` AUTO_INCREMENT=1;

ALTER TABLE `sales_flat_invoice_grid` AUTO_INCREMENT=1;

ALTER TABLE `sales_flat_invoice_item` AUTO_INCREMENT=1;

ALTER TABLE `sales_flat_order` AUTO_INCREMENT=1;

ALTER TABLE `sales_flat_order_address` AUTO_INCREMENT=1;

ALTER TABLE `sales_flat_quote_shipping_rate` AUTO_INCREMENT=1;

ALTER TABLE `sales_flat_quote_payment` AUTO_INCREMENT=1;

ALTER TABLE `sales_flat_quote_item_option` AUTO_INCREMENT=1;

ALTER TABLE `sales_flat_quote_item` AUTO_INCREMENT=1;


TRUNCATE `customer_address_entity`;

TRUNCATE `customer_address_entity_datetime`;

TRUNCATE `customer_address_entity_decimal`;

TRUNCATE `customer_address_entity_int`;

TRUNCATE `customer_address_entity_text`;

TRUNCATE `customer_address_entity_varchar`;

TRUNCATE `customer_entity`;

TRUNCATE `customer_entity_datetime`;

TRUNCATE `customer_entity_decimal`;

TRUNCATE `customer_entity_int`;

TRUNCATE `customer_entity_text`;

TRUNCATE `customer_entity_varchar`;

TRUNCATE `customer_group`;


ALTER TABLE `customer_address_entity` AUTO_INCREMENT=1;

ALTER TABLE `customer_address_entity_datetime` AUTO_INCREMENT=1;

ALTER TABLE `customer_address_entity_decimal` AUTO_INCREMENT=1;

ALTER TABLE `customer_address_entity_int` AUTO_INCREMENT=1;

ALTER TABLE `customer_address_entity_text` AUTO_INCREMENT=1;

ALTER TABLE `customer_address_entity_varchar` AUTO_INCREMENT=1;

ALTER TABLE `customer_entity` AUTO_INCREMENT=1;

ALTER TABLE `customer_entity_datetime` AUTO_INCREMENT=1;

ALTER TABLE `customer_entity_decimal` AUTO_INCREMENT=1;

ALTER TABLE `customer_entity_int` AUTO_INCREMENT=1;

ALTER TABLE `customer_entity_text` AUTO_INCREMENT=1;

ALTER TABLE `customer_entity_varchar` AUTO_INCREMENT=1;

ALTER TABLE `customer_group` AUTO_INCREMENT=1;


TRUNCATE `review` ;

TRUNCATE `review_detail` ;

TRUNCATE `review_entity` ;

TRUNCATE `review_entity_summary` ;

TRUNCATE `review_status` ;

TRUNCATE `review_store` ;


ALTER TABLE `review` AUTO_INCREMENT=1;

ALTER TABLE `review_detail` AUTO_INCREMENT=1;

ALTER TABLE `review_entity` AUTO_INCREMENT=1;

ALTER TABLE `review_entity_summary` AUTO_INCREMENT=1;

ALTER TABLE `review_status` AUTO_INCREMENT=1;

ALTER TABLE `review_store` AUTO_INCREMENT=1;


1.4.1以前版本的订单清空：

//注意要修改这个表的最后ID。

UPDATE `eav_entity_store` SET `increment_last_id` = ’100000000′ WHERE `entity_store_id` = ’1′ LIMIT 1 ;


TRUNCATE `customer_address_entity`;


TRUNCATE `catalog_category_entity`;

TRUNCATE `catalogsearch_fulltext`;

TRUNCATE `catalogsearch_query`;

TRUNCATE `catalogsearch_result`;


TRUNCATE `customer_address_entity_datetime`;

TRUNCATE `customer_address_entity_decimal`;

TRUNCATE `customer_address_entity_int`;

TRUNCATE `customer_address_entity_text`;

TRUNCATE `customer_address_entity_varchar`;

TRUNCATE `customer_entity`;

TRUNCATE `customer_entity_datetime`;

TRUNCATE `customer_entity_decimal`;

TRUNCATE `customer_entity_int`;

TRUNCATE `customer_entity_text`;

TRUNCATE `customer_entity_varchar`;

TRUNCATE `customer_group`;


TRUNCATE `sales_flat_order_item`;

TRUNCATE `sales_flat_quote`;

TRUNCATE `sales_flat_quote_address`;

TRUNCATE `sales_flat_quote_address_item`;

TRUNCATE `sales_flat_quote_item`;

TRUNCATE `sales_flat_quote_item_option`;

TRUNCATE `sales_flat_quote_payment`;

TRUNCATE `sales_flat_quote_shipping_rate`;

TRUNCATE `sales_flat_invoice_grid` ;

TRUNCATE `sales_flat_invoice_item` ;

TRUNCATE `sales_order`;

TRUNCATE `sales_order_datetime`;

TRUNCATE `sales_order_decimal`;

TRUNCATE `sales_order_entity`;

TRUNCATE `sales_order_entity_datetime`;

TRUNCATE `sales_order_entity_decimal`;

TRUNCATE `sales_order_entity_int`;

TRUNCATE `sales_order_entity_text`;

TRUNCATE `sales_order_entity_varchar`;

TRUNCATE `sales_order_int`;

TRUNCATE `sales_order_tax`;

TRUNCATE `sales_order_text`;

TRUNCATE `sales_order_varchar`;


TRUNCATE `tag`;

TRUNCATE `tag_relation`;

TRUNCATE `tag_summary`;


TRUNCATE `wishlist`;

TRUNCATE `wishlist_item`;


ALTER TABLE `customer_address_entity` AUTO_INCREMENT=1;

ALTER TABLE `customer_address_entity_datetime` AUTO_INCREMENT=1;

ALTER TABLE `customer_address_entity_decimal` AUTO_INCREMENT=1;

ALTER TABLE `customer_address_entity_int` AUTO_INCREMENT=1;

ALTER TABLE `customer_address_entity_text` AUTO_INCREMENT=1;

ALTER TABLE `customer_address_entity_varchar` AUTO_INCREMENT=1;

ALTER TABLE `customer_entity` AUTO_INCREMENT=1;

ALTER TABLE `customer_entity_datetime` AUTO_INCREMENT=1;

ALTER TABLE `customer_entity_decimal` AUTO_INCREMENT=1;

ALTER TABLE `customer_entity_int` AUTO_INCREMENT=1;

ALTER TABLE `customer_entity_text` AUTO_INCREMENT=1;

ALTER TABLE `customer_entity_varchar` AUTO_INCREMENT=1;

ALTER TABLE `customer_group` AUTO_INCREMENT=1;


ALTER TABLE `sales_flat_order_item` AUTO_INCREMENT=1;

ALTER TABLE `sales_flat_quote` AUTO_INCREMENT=1;

ALTER TABLE `sales_flat_quote_address` AUTO_INCREMENT=1;

ALTER TABLE `sales_flat_quote_address_item` AUTO_INCREMENT=1;

ALTER TABLE `sales_flat_quote_item` AUTO_INCREMENT=1;

ALTER TABLE `sales_flat_quote_item_option` AUTO_INCREMENT=1;

ALTER TABLE `sales_flat_quote_payment` AUTO_INCREMENT=1;

ALTER TABLE `sales_flat_quote_shipping_rate` AUTO_INCREMENT=1;

ALTER TABLE `sales_order` AUTO_INCREMENT=1;

ALTER TABLE `sales_order_datetime` AUTO_INCREMENT=1;

ALTER TABLE `sales_order_decimal` AUTO_INCREMENT=1;

ALTER TABLE `sales_order_entity` AUTO_INCREMENT=1;

ALTER TABLE `sales_order_entity_datetime` AUTO_INCREMENT=1;

ALTER TABLE `sales_order_entity_decimal` AUTO_INCREMENT=1;

ALTER TABLE `sales_order_entity_int` AUTO_INCREMENT=1;

ALTER TABLE `sales_order_entity_text` AUTO_INCREMENT=1;

ALTER TABLE `sales_order_entity_varchar` AUTO_INCREMENT=1;

ALTER TABLE `sales_order_int` AUTO_INCREMENT=1;

ALTER TABLE `sales_order_tax` AUTO_INCREMENT=1;

ALTER TABLE `sales_order_text` AUTO_INCREMENT=1;

ALTER TABLE `sales_order_varchar` AUTO_INCREMENT=1;


ALTER TABLE `tag` AUTO_INCREMENT=1;

ALTER TABLE `tag_relation` AUTO_INCREMENT=1;

ALTER TABLE `tag_summary` AUTO_INCREMENT=1;


ALTER TABLE `wishlist` AUTO_INCREMENT=1;

ALTER TABLE `wishlist_item` AUTO_INCREMENT=1;


TRUNCATE `log_customer`;

TRUNCATE `log_quote`;

TRUNCATE `log_summary`;

TRUNCATE `log_url`;

TRUNCATE `log_url_info`;

TRUNCATE `log_visitor`;

TRUNCATE `log_visitor_info`;


ALTER TABLE `log_customer` AUTO_INCREMENT=1;

ALTER TABLE `log_quote` AUTO_INCREMENT=1;

ALTER TABLE `log_summary` AUTO_INCREMENT=1;

ALTER TABLE `log_url` AUTO_INCREMENT=1;

ALTER TABLE `log_url_info` AUTO_INCREMENT=1;

ALTER TABLE `log_visitor` AUTO_INCREMENT=1;

ALTER TABLE `log_visitor_info` AUTO_INCREMENT=1;


TRUNCATE `report_event_types`;

ALTER TABLE `report_event_types` AUTO_INCREMENT=1;
可乐电影网www.51cola.com
lxm88168
关注
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值