magento 修改订单号,订单状态和订单时间，以及设置时间与本地直接一致

# 删除此订单
delete from sales_flat_order_grid where entity_id=6;
delete from sales_flat_order_grid where entity_id=8;
部分一：修改sql
--------------------------------------订单2-------------------------------------------------------------
# 修改订单号：
UPDATE `sales_flat_order` SET `increment_id` = '2010252318065074' WHERE `sales_flat_order`.`entity_id` =9;
# 真正修改订单状态和订单时间
UPDATE `sales_flat_order_grid` SET `status` = 'complete' WHERE `entity_id` =9;
UPDATE `sales_flat_order_grid` SET `created_at` = '2020-10-25 23:18:11' WHERE `entity_id` =9;
UPDATE `sales_flat_order_grid` SET `updated_at` = '2020-10-25 23:18:11' WHERE `entity_id` =9;    
UPDATE `sales_flat_order_grid` SET `created_at` = '2020-10-25 11:18:11' WHERE `entity_id` =9;
UPDATE `sales_flat_order_grid` SET `updated_at` = '2020-10-25 11:18:11' WHERE `entity_id` =9;
====================================================
部分二：更改文件
1.
E:\phpStudy\PHPTutorial\WWW\magento19/app/design/adminhtml/default/default/template/sales/order/view/info.phtml
隐藏ip信息 84行：
 <?php if($_order->getRemoteIp() && $this->shouldDisplayCustomerIp()): ?>
改为if(0)  
2.重要：修改后台配置，时间默认是格林威治UTC,如果要求中国看到时间跟数据库一致，就要把Locale定位成Chinese
system->Configuration->Locale Options     
Timezone 改为 UTC（Etc/GMT）
Locale 改为Chinese(China)