How to get SKU of custom options selected for item order programatically in Magento

How to get SKU of custom options selected for item order programatically in Magento

July 24, 2026 · Illustrated author avatarBy Stefan Bogdanescu
How to get SKU of custom options selected for item order programatically in Magento

How to Retrieve Custom Option SKUs for Items in an Order Programatically in Magento

As a senior developer tasked with integrating Magento with your warehouse system, you’ve hit a snag while trying to export order data: retrieving the SKUs of custom options selected by customers during checkout.

You’re currently pulling order information using Magento’s built-in sales_order model and getAllItems() method. While this gives you access to product labels, option IDs, and values, it falls short when you need those all-important SKUs for each custom option.

Understanding the Challenge

The issue lies in how Magento stores custom options data. Unlike standard products with predefined SKUs, custom options are configured dynamically based on customer selection during checkout. As a result, their SKUs aren’t directly tied to the order item itself but rather to the product associated with that option.

Retrieving Custom Option SKUs

To tackle this issue effectively, you’ll need to follow these steps:

  1. Access the Order Item’s Product

First, ensure you’re retrieving the product object tied to each order item. You can do this using the getProduct() method:

foreach ($order->getAllItems() as $item) {
    $product = $item->getProduct();
}
  1. Identify Custom Option IDs

You’ve already extracted the custom option IDs from $optionsArr['options']. These correspond to the options configured for each product in your Magento admin panel.

  1. Retrieve Option SKUs Using Product ID and Option ID

Now, you can use these IDs to fetch the actual SKUs. Magento stores this information under catalog_product_option and catalog_product_option_title database tables. Here’s an example of how to achieve this:

$optionTable = Mage::getSingleton('core/resource')->getTableName('catalog_product_option');
$optionTitleTable = Mage::getSingleton('core/resource')->getTableName('catalog_product_option_title');

foreach ($product->getOptions() as $option) {
    if ($option['type'] == 'drop_down' || $option['type'] == 'radio') {
        foreach ($option['values'] as $value) {
            // Fetch SKU from database
            $readConnection = Mage::getSingleton('core/resource')->getConnection('core_read');
            $select = $readConnection->select()
                ->from($optionTitleTable, array('sku'))
                ->where('option_id = ?', (int)$option['option_id'])
                ->where('title like ?', '%' . $value)
                ->limit(1);

            try {
                $result = $readConnection->fetchRow($select);
                if ($result) {
                    // Found SKU; store or process it
                    $customOptionSku = $result['sku'];
                }
            } catch (Exception $e) {
                Mage::logException($e);
            }
        }
    }
}

Conclusion

Retrieving custom option SKUs requires a combination of accessing order item data, identifying relevant option IDs, and querying the database to fetch the corresponding SKUs.

Remember, Magento’s database schema can vary slightly between versions, so always adjust your SQL queries accordingly. Also, ensure you have proper error handling in place when fetching data from the database.

For more advanced tips on customizing Magento for e-commerce businesses like yours, check out Laravel Company. Our team of seasoned developers specializes in helping companies maximize their potential with Magento!

Checkout Catalog Admin Configuration

Our network