手动取消订单 [英] Manually Cancel An Order

问题描述

我有一些需要取消的订单，但是由于它们最初是通过auth.net预先授权的，因此不会取消.尝试取消/无效时，我收到未找到交易"消息.因此，我只想在数据库中手动取消订单并跳过标准的无效过程.有谁知道Magento数据库中需要修改以取消订单的特定表?

I have some orders that need to be cancelled but because they originally were pre-authorized through auth.net, they will not cancel. I get a "no transaction found" message when trying to cancel/void. Because of this I simply want to cancel the orders manually in the database and skip the standard void process. Does anyone know the specific tables in the Magento database that need to be modified to simply cancel an order?

推荐答案

对此要小心. 1.7中的表为sales_flat_order.列为state和status. 您打算将它们都设置为canceled的原因. 注意:您可以使用select和where子句来验证名称.这应该可以，但是我不能百分百确定不会造成问题.我只是在回答你的问题.

Be careful with this. The Table in 1.7 is sales_flat_order. Columns are state and status. Your going to what to set them both to canceled. NOTE: You can use a select and where clause to verify names. This should work but I'm not 100% sure that it will not cause problems. I'm just answering your question.

您真的可以使用此方法弄乱事情，因此在尝试任何操作之前备份数据库将很明智.

You can really mess things up with this method so it would be smart to backup your database before you try anything.

GL

这篇关于手动取消订单的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！