Magento通过订单id修改订单创建时间的sql_magento修改订单id-优快云博客

本文链接：https://blog.youkuaiyun.com/github_26672553/article/details/45074103

本文详细介绍了如何使用SQL更新特定订单的时间戳，包括多个表的更新操作。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

/*修改订单时间*/
update sales_flat_order  set created_at="2015-04-12 06:13:47" where increment_id="100000689";
update sales_flat_order_grid  set created_at="2015-04-12 06:13:47" where increment_id="100000689";

update sales_flat_order_item as t1 
left join sales_flat_order as t2 on t2.entity_id=t1.order_id  
set t1.created_at="2015-04-12 06:13:47" where t2.increment_id="100000689";

update sales_flat_order_status_history as t1
left join sales_flat_order as t2 on t2.entity_id=t1.parent_id  
set t1.created_at="2015-04-12 06:13:47" where t2.increment_id="100000689" and t1.status="pending_payment";






/* 下面的表不要了*/
/* 
update sales_flat_quote as t1 
left join sales_flat_order as t2 on t1.reserved_order_id=t2.increment_id 
set t1.created_at="2015-03-24 06:53:20" where t2.increment_id="100000378";

update sales_flat_quote_address as t1 
left join sales_flat_quote as t2 on t1.quote_id=t2.entity_id
left join sales_flat_order as t3 on t2.reserved_order_id=t3.increment_id  
set t1.created_at="2015-03-24 06:53:20" where t3.increment_id="100000378";

update sales_flat_quote_item as t1 
left join sales_flat_quote as t2 on t1.quote_id=t2.entity_id
left join sales_flat_order as t3 on t2.reserved_order_id=t3.increment_id  
set t1.created_at="2015-03-24 06:53:20" where t3.increment_id="100000378";

update sales_flat_quote_payment as t1 
left join sales_flat_quote as t2 on t1.quote_id=t2.entity_id
left join sales_flat_order as t3 on t2.reserved_order_id=t3.increment_id  
set t1.created_at="2015-03-24 06:53:20" where t3.increment_id="100000378";


update sales_flat_quote_shipping_rate as t1 
left join sales_flat_quote_address as t2 on t1.address_id=t2.address_id
left join sales_flat_quote as t3 on t2.quote_id=t3.entity_id  
left join sales_flat_order as t4 on t3.reserved_order_id=t4.increment_id  
set t1.created_at="2015-03-24 06:53:20" where t4.increment_id="100000378";  */