How can i change "Refunded" to "Paid" in an order

In error, I clicked on the icon twice in my admin panel and marked and order "refunded" after I had marked it "paid".

I do offline processing.

Is there a way to reverse it back to "Paid"?

Only by running an SQL Query or editing the database data
I use Microsoft Access linked to the database to do data maintnance
You need to clear the cache after making any changes like this

If you modify it in the database, you'll need the Payment Status Id

Pending = 10,
Authorized = 20,
Paid = 30,
PartiallyRefunded = 35,
Refunded = 40,
Voided = 50


In SQL it looks like this to set for Paid.  Replace 'n' with the Order Id

UPDATE [Order]
SET [PaymentStatusId] = 30
WHERE Id = n

(If you need "order processing workflow" to occur (e.g. send emails), it might be a good idea to set it Pending in the DB, and then use Admin UI to set it to Paid.    I've never tried.)

Yidna wrote:

Thank you, it worked.