Magento - Get Product SKU's and quantities on order

Magento - Get Product SKU's and quantities on order

August 28, 2026 · Illustrated author avatarBy Stefan Bogdanescu
Magento - Get Product SKU's and quantities on order

Accessing Product SKUs and Quantities for Complex Magento Products

In Magento, when dealing with complex product types like bundles or configurables within an order, it can be challenging to retrieve the precise SKU and quantity information for each individual child item selected by the customer during checkout. This is especially true when you need this data to send to an external inventory management system.

Let’s first understand your current logic:

$order = $observer->getEvent()->getOrder();
$joomecomPacket = array();

if ($order->getTotalItemCount() > 0) {
    $items = $order->getAllItems();

    foreach ($items as $item) {
        $productType = $item->getProductType();

        switch ($productType) {
            case 'bundle':

            break;
            case 'configurable':

            default: // simple products
                if (isset($joomecomPacket[$item['sku']])) {
                    $joomecomPacket[$item['sku']] += $item['qty_ordered'];
                } else {
                    $joomecomPacket[$item['sku']] = $item['qty_ordered'];
                }
            break;
        }
    }
}

You’re on the right track here. You’re retrieving all order items and iterating over them, but you’ve got a critical gap: when the product type is ‘bundle’ or ‘configurable’, you aren’t pulling any data from the children.

Handling Complex Product Types

For complex product types, Magento doesn’t directly provide methods like getBundleChildrenSkuQuantity() or getConfigurableChildrenSkuQuantity(). Instead, you need to use some additional Magento magic.

Bundled Products

Let’s say you have a bundle product with SKU “BUNDLE123” and it contains two child products: “CHILD1” and “CHILD2”.

To access the selected children in your observer:

if ($productType == 'bundle') {
    $children = $item->getChildren();
    foreach ($children as $child) {
        if (isset($joomecomPacket[$child['sku']])) {
            $joomecomPacket[$child['sku']] += $child['qty_ordered'];
        } else {
            $joomecomPacket[$child['sku']] = $child['qty_ordered'];
        }
    }
}

Configurable Products

For configurable products, you also need to access the selected child SKUs and quantities.

if ($productType == 'configurable') {
    $parentSku = $item->getProduct()->getSku();
    $children = $item->getChildren();

    foreach ($children as $child) {
        if (isset($joomecomPacket[$child['sku']])) {
            $joomecomPacket[$child['sku']] += $child['qty_ordered'];
        } else {
            $joomecomPacket[$child['sku']] = $child['qty_ordered'];
        }
    }
}

Conclusion

Remember, when dealing with complex product types in Magento, you often need to dig deeper into the item object to extract the required data. Don’t hesitate to use Magento’s built-in methods like getChildren() to access child products within bundles or configurables.

For more detailed insights on Magento order management and event observers, check out our comprehensive guide at Laravel Company.

By incorporating this logic into your observer, you’ll be able to accurately capture the SKUs and quantities of every product—simple or complex—in a Magento order.

Checkout Catalog Extensions Configuration

Our network