Get configurable sku from simple SKU or ID

Get configurable sku from simple SKU or ID

July 12, 2026 · Illustrated author avatarBy Stefan Bogdanescu
Get configurable sku from simple SKU or ID

Configuring Magento EE: Retrieving the Correct Configurable SKU

As an e-commerce developer working with Magento Enterprise Edition (EE), one of the common challenges we face is retrieving specific product data from the cart or checkout process. In your case, you’re looking to extract the exact configurable SKU that a customer has added to their cart, rather than collecting all potential parent configurables.

Why Your Current Approach Isn’t Suitable

The StackOverflow question you referenced indeed provides a solution for retrieving all associated configurable products from a simple product. However, this method doesn’t differentiate between the different configurable items in a customer’s shopping cart. It simply lists every possible parent that could theoretically be linked to the child item.

In your scenario, each simple product might belong to multiple configurable variations. Therefore, you need a more granular approach that ties directly to the specific configurable chosen by the customer during checkout.

Retrieving the Specific Configurable SKU

To achieve this, we’ll leverage Magento’s observer pattern and hook into the sales_order_place_after event. This event fires immediately after an order is successfully placed. By using a custom observer, you can capture the specific configurable product chosen by the customer during checkout.

Here’s a step-by-step guide:

  1. Create Your Observer Class

    First, create your custom observer class in app/code/local/Namespace/Module/etc. The full path would look something like this: app/code/local/MyCompany/MyModule/Model/Observer.php.

class MyCompany_MyModule_Model_Observer
{
    public function afterOrderPlace($observer)
    {
        $event = $observer->getEvent();
        $order = $event->getOrder();

        // Access the order items
        foreach ($order->getAllVisibleItems() as $item) {
            if ($item->getProductType() == 'simple') {
                $configurableItemId = $this->_getConfigurableItemId($item);
                $configurableSku = $this->_getConfigurableSkuFromId($configurableItemId);

                // Now you have the specific configurable SKU
                // You can log it or use it for further processing
            }
        }
    }

    private function _getConfigurableItemId($_item)
    {
        // Implement your logic here to find the parent configurable item ID
    }

    private function _getConfigurableSkuFromId($configurableItemId)
    {
        $product = Mage::getModel('catalog/product')->load($configurableItemId);
        return $product->getSku();
    }
}
  1. Configure Your Observer in the Config File

    Next, you need to configure your observer in app/code/local/Namespace/Module/etc/config.xml.

<config>
  <global>
    <models>
      <mycompany_mymodule>
        <class>MyCompany_MyModule_Model</class>
      </mycompany_mymodule>
    </models>
  </global>
  <frontend>
    <events>
      <sales_order_place_after>
        <observers>
          <mycompany_myobserver>
            <type>singleton</type>
            <class>MyCompany_MyModule_Model_Observer</class>
            <method>afterOrderPlace</method>
          </mycompany_myobserver>
        </observers>
      </sales_order_place_after>
    </events>
  </frontend>
</config>
  1. Implement the Logic to Find the Parent Configurable

    The _getConfigurableItemId method is currently a placeholder. You’ll need to implement your own logic here based on how you’ve configured your product relationships in Magento EE.

Conclusion

Retrieving the specific configurable SKU from a simple item placed in the cart involves a combination of understanding Magento’s observer pattern and leveraging the sales_order_place_after event. By implementing this approach, you can accurately capture the exact parent configurable chosen by the customer during checkout.

Remember that the _getConfigurableItemId method is where you’ll need to apply your specific business logic based on your store’s configuration. This might involve querying the catalog_product_entity table or using Magento’s internal methods to traverse the product relationships.

For more in-depth guidance on customizing Magento EE, I highly recommend exploring our dedicated resources at Laravel Company. We provide detailed tutorials and best practices for optimizing your e-commerce platform.

Checkout Catalog Database Extensions

Our network