Order Payment Status not updating for some Canadian orders
Posted: Wed Nov 25, 2009 10:40 am
We are recently having problems with the payment status of a few Canadian orders.
We have already captured payments for these orders but on the Orders listing page, their Payment status is showing as 'Captured' rather than 'Paid'.
In the database also, the PaymentStatusId field in the ac_Orders table for these orders is set to 1 instead of 2.
We need the status to change to paid so that these orders can be imported to QuickBooks
After failing to figure out the problem, we manually set the PaymentStatusId in the ac_Orders table to 2.
This worked but as soon as we opened the Orders Detail page(Admin/Orders/ViewOrders.aspx), the payment status changed back to unpaid.
We are not sure what is triggering the order payment status to change back to unpaid when the payment has already been captured. Its only happening with a few Canadian orders but we have already compared these orders with others and didn't find anything different.
We have already captured payments for these orders but on the Orders listing page, their Payment status is showing as 'Captured' rather than 'Paid'.
In the database also, the PaymentStatusId field in the ac_Orders table for these orders is set to 1 instead of 2.
We need the status to change to paid so that these orders can be imported to QuickBooks
After failing to figure out the problem, we manually set the PaymentStatusId in the ac_Orders table to 2.
This worked but as soon as we opened the Orders Detail page(Admin/Orders/ViewOrders.aspx), the payment status changed back to unpaid.
We are not sure what is triggering the order payment status to change back to unpaid when the payment has already been captured. Its only happening with a few Canadian orders but we have already compared these orders with others and didn't find anything different.