Thread: Reset forced voided orders?

Hello.

Is there a way to reset the status of a forced voided order to "pending"?

If you have access to Sql Server Management Studio, or you could do it in the 'Advanced > Run SQL' box in the admin site, but you get no feedback.

Code:

UPDATE [Orders] SET [TransactionState] = 'PENDING' WHERE [OrderNumber] = x

replace x with the order number.

But what the ramifications of doing this is, who knows!

Hi Esedirect!

Thanks! I almost forgot about the "Advanced > Run SQL" feature...^_^
I started with that code, but then there were more than that when force voiding an order, I read.

I did this

Code:

aspdnsf_AdjustInventory <orderNumber>,-1

where -1 means to remove the inventory again when it was restored during the force void (1 is to restore the inventory).
and

Code:

update Orders set VoidTXCommand=NULL, TransactionState='PENDING', VoidedOn=NULL, IsNew=1 where OrderNumber=<orderNumber>

This works, the order was back to 'Pending'. But as you've said, I don't know the ramifications of such action. ^_^
This is just for simple orders, no coupons or giftcards, or anything else. When I looked at the code, there are more to it than just what I did. More complicated orders, more complicated solution for this problem.

Thanks again.