Magento - Get children/options of an ORDERED bundle item

Magento - Get children/options of an ORDERED bundle item

August 12, 2026 · Illustrated author avatarBy Stefan Bogdanescu
Magento - Get children/options of an ORDERED bundle item

Accessing Bundle Options in Magento

As a senior developer, I understand your pain point when it comes to retrieving bundle product options after an order has been placed in Magento. The platform’s architecture can sometimes make this process more complex than expected.

Why You’re Facing Challenges

The issue arises because Magento stores the bundle items differently during the checkout process compared to simple or configurable products. While a simple product is added directly to the cart, a bundle item is broken down into its constituent components before being stored in the sales_flat_order_item table.

This means that when you query the order items, you won’t find direct references to the child products and their options within the standard tables. Instead, Magento uses a more complex data structure that requires additional joins to access fully.

The Approach: Joining Multiple Tables

To solve this, we need to perform a SQL join between multiple tables in your database:

  1. Start with the sales_flat_order_item table where you have the parent bundle order item.
  2. Join this to the sales_flat_order_option table using the option_id.
  3. Then, join from sales_flat_order_option to either catalog_product_bundle_selection or catalog_product_super_attribute.

Here’s a basic example of how you might structure your query:

SELECT b.*
FROM sales_flat_order_item AS oi
JOIN sales_flat_order_option AS op ON oi.option_id = op.option_id
JOIN catalog_product_bundle_selection AS bs ON op.option_id = bs.selection_id
JOIN catalog_product AS p ON bs.product_id = p.entity_id

Querying Child Product Options

Remember, the catalog_product_super_attribute table is used when you have a “Super Attribute” bundle product type. The selection_price field in this table represents the price of each child item.

For a more detailed guide on how to handle different types of bundle products (grouped, simple, virtual), I recommend checking out our comprehensive article on Working with Bundle Products in Magento.

Optimizing Your Query

While this query gets you the information you need, it can be quite heavy for large orders or stores with many products. To optimize, consider using Magento’s built-in API layers like the SOAP or REST APIs.

These interfaces provide a layer of abstraction over your database queries and can handle pagination and other optimizations more efficiently than raw SQL.

Conclusion: Persistence Pays Off

Retrieving bundle options in Magento requires a deeper understanding of the platform’s data architecture. By joining multiple tables carefully, you can access the child products and their options within an order item.

Remember, performance is key when dealing with large datasets, so consider using Magento’s built-in APIs to offload some of this processing work.

Don’t hesitate to explore our Magento development resources for more in-depth guides on handling complex product configurations.

Checkout Catalog Database Configuration

Our network