I have received order, if i try to take invoice its not possible to do that because of qty canceled as well as Canceled updated in Comment History,
I am using CCAvenue Payment Gateway.
How to solve the issue?
Magento Stack Exchange is a question and answer site for users of the Magento e-Commerce platform. It only takes a minute to sign up.Sign up to join this community
I cannot tell you the reason why the order was canceled. There could be a lot of reasons
But I can tell you how to make it invoice-able again.
Take the order id. The
entity_id field in the
sales_order table, not the increment id.
Let's say it's 110.
Now run these queries:
update sales_flat_order set state = 'processing' where entity_id = 110; update sales_flat_order_item set qty_canceled = 0.0000 where order_id = 110;
Now you should see the invoice button and you should be able to invoice the order.
Please backup your db before doing this in case I'm wrong.