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/

  • We are in a similar situation, do you still have the code you used?
    – Walf
    Commented Sep 2, 2015 at 1:23

1 Answer 1


If you've got some quotes in sales_flate_quote table, you could easily convert them to an order. It's only working if all required information like payment method, shipping & billing addresses are correctly set.

$quote = Mage::getModel('sales/quote')->load(1);

// convert quote to order
$service = Mage::getModel('sales/service_quote', $quote);

$order = $service->getOrder();
  • I do have all the information. So basically package it in this correct? <?php require_once('app/Mage.php'); //Path to Magento umask(0); Mage::app();
    – sparecycle
    Commented Dec 10, 2014 at 22:52
  • 1
    No. That will not trigger events.
    – benmarks
    Commented Dec 10, 2014 at 22:59
  • Forgive my ignorance. I'm not familiar with how to implement this. Does this code need to be packaged into a controller and executed?
    – sparecycle
    Commented Dec 11, 2014 at 14:42

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.