«order item having status CANCELLED by order status is COMPLETED»

Derrick_Liew · January 6, 2020, 9:31am

at first customer failed payment, (order item status become CANCELLED)
after 3 min the payment was captured (ORDER status become PROCESSING then COMPLETED) - see image attached

06-17_19_15

issue is now order item having status CANCELLED by order status is COMPLETED. No shipment can be created. I think is due to ipay88 callback after payment captured.

how to solve this issue with your extension?

Derrick_Liew · January 6, 2020, 10:58am

dmitrii_fediuk · January 6, 2020, 11:13am

Please provide me SSH access to the website’s server.

Derrick_Liew · January 6, 2020, 2:47pm

ssh server: sportsclick.my
user: root-control
psw: *********

dmitrii_fediuk · January 7, 2020, 6:24pm

I have fixed it with the code:

UPDATE sales_order_item SET qty_canceled = 0 WHERE 6178 = order_id;

Derrick_Liew · January 8, 2020, 5:17am

is this a permanent solution? because this happen few times
anything to do with the extension? i think is due to an ipay call back to update the payment status which caused this. it should also update the order item status as well.