Magento - How to get the Order ID and 2-letter state abbreviation of an order

Magento - How to get the Order ID and 2-letter state abbreviation of an order

September 24, 2026 · Illustrated author avatarBy Stefan Bogdanescu
Magento - How to get the Order ID and 2-letter state abbreviation of an order

Getting Order ID in Magento

In order to retrieve the order ID in a Magento store, you need to access the sales_order database table directly or use the Mage_Core_Model_Session object provided by Magento.

Using Direct Database Query

You can write a direct SQL query to fetch the last inserted order ID from the sales_order table. Here’s how:

$orderId = $this->getResourceModel('sales/order')->fetchAll()->getLastItem()->getId();

This code retrieves all orders and fetches the ID of the latest one using the getLastItem() method.

Using Mage_Core_Model_Session

Magento provides a way to access the last real order ID through its session object:

$order = Mage::getSingleton('checkout/session')->getLastRealOrderId();

However, this will only work if an actual order has been placed and saved in the session. If you’re trying to retrieve the current quote ( Shopping Cart ) ID instead of a real order, use this code:

$quote = Mage::getModel('checkout/session')->getQuote()->getId();

Code Example

Here’s a complete example that fetches both the last real order ID and the cart quote ID:

// Get the last real order ID
try {
    $lastOrderId = Mage::getSingleton('checkout/session')->getLastRealOrderId();
    echo "Last Order ID: {$lastOrderId}\n";
} catch (Exception $e) {
    echo "No real order placed yet.\n";
}

// Get the current cart quote ID
$quote = Mage::getModel('checkout/session')->getQuote();
$cartId = $quote->getId();
echo "Current Cart Quote ID: {$cartId}\n";

Getting 2-Letter State Abbreviation

To get the two-letter state abbreviation in Magento, you need to map the region ID from the shipping address to its corresponding abbreviation. You can do this by accessing the directory_country_region table.

Using Direct Database Query

You can write a direct SQL query to fetch the region name and get its abbreviation:

$state = $this->getResourceModel('directory/country_region')->fetchAll()->addFieldToFilter('region_id', $shippingAddress->getRegionId())->getFirstItem()->getCode();

Using Magento Core Functions

Magento provides functions to translate state names into their corresponding two-letter abbreviations:

$state = Mage::getModel('directory/region')->load($shippingAddress->getRegionId())->getName();

Mapping State Names to Abbreviations

However, the getName() method returns the full name of the state. To get the abbreviation, you’ll need to map it manually or use a third-party extension. One way is to create an array mapping each state ID to its two-letter code:

$stateCodes = [
    '1' => 'AL',
    '2' => 'AK',
    //... other codes...
];

$state = $stateCodes[$shippingAddress->getRegionId()];

Conclusion

Retrieving the order ID and state abbreviation in Magento requires a good understanding of its session management and database structure. Direct SQL queries, core session objects, and model loading are all valid methods depending on your specific needs.

Remember to always sanitize and validate data before using it, especially when dealing with user inputs like shipping addresses. This can help prevent security vulnerabilities and ensure the integrity of your store’s data.

For more advanced affiliate tracking and state mapping functionalities, consider exploring Magento extensions available at Laravel Company. These extensions often provide pre-built solutions for complex tasks, saving you development time.

Checkout Database Orders Errors

Our network