For about 24 hours yesterday we were experiencing an issue where Magento could not create new invoices. It has since been resolved but I now have a series of orders (22) that are trapped in the sales_flat_quote tables. The customers' credit cards have been charged however their orders are not showing up in our order grid. I need to get these quotes out of limbo and into the order phase.
I initially tried switching sales_flat_quote.is_active to 0 but it requires more than that for Magento to move data to the sales_flat_order tables. Any idea how to proceed?
UPDATE: Currently investigating a programmatic approach that might trigger Magento quotes to be processed: http://inchoo.net/magento/programmatically-create-order-in-magento/