Magento - get order id from increment id

Question

How do you get the Order Id from magento Order Increment Id?

I can use the following get the product id from SKU:

$product_id = Mage::getModel('catalog/product')->getIdBySku('ABCD1234');

The above example lets me get just the database entity_id of a product without loading everything. I want to achieve the same for order.

Answer 1

You can load an order from the IncrementId.

$orderIncrementId = "1000001";
$order = Mage::getModel('sales/order')->loadByIncrementId($orderIncrementId);
echo $order->getId();

Answer 2

In a Magento model, the load method can take an optional second argument of what attribute to load by. So, in your case, the following should work:

   $order = Mage::getModel('sales/order')->load($incrementId, 'increment_id');
   $id = $order->getId();

In more complex cases, e.g. where you want to load by a combination of fields, you can load a collection, and get the first element of the collection. In your case, you'd do it like this:

   $order = Mage::getModel('sales/order')->getCollection()
      ->addFieldToFilter('increment_id', $increment_id)
      ->getFirstItem();