Magento 2 Bundle Products – Get All Bundle Products

bundled-productdatabasemagento2.4producttable

So I have to create a report (SQL Script) which has all the bundle products and all its customizable options.
I can get list of all the bundle products using this query.

select entity_id, type_id, sku, has_options from catalog_product_entity where type_id='bundle';

In catalog_product_entity, I assume that entity_id is the primary key.

Now I want all the options associated with bundle product.

which tables should I refer to? I know catalog_product_bundle_option and catalog_product_bundle_option_value can give me option title but when I try to join using parent_id with entity_id it doesn't return anything.

Can anyone explain table structure to me or which tables should I refer to then that will be great.

Best Answer

Technically, you should be able to join catalog_product_entity and catalog_product_bundle_option_value on:

catalog_product_entity.entity_id = catalog_product_bundle_option_value.parent_product_id

However, if you look at the table definition for catalog_product_bundle_option_value, parent_product_id is not a key and no database-defined constraint binds it to catalog_product_entity.entity_id. The relationship is maintained outside of the database, meaning that you have to know and trust Magento's logic.

As an alternative, you should also be able to join catalog_product_entity and catalog_product_bundle_option on:

catalog_product_entity.entity_id = catalog_product_bundle_option.parent_id

And additionally be able to join catalog_product_bundle_option and catalog_product_bundle_option_value on:

catlog_product_bundle_option.option_id = catalog_product_bundle_option_value.option_id

Nesting these two will allow you to create a query that effectively joins catalog_product_entity and catalog_product_bundle_option_value on actual keys.

Related Solutions

Magento – Bundle products – get default title for a bundle item

I'm new to magento and have the same requirement. I was able to solve this with this code snippet.

$bundled_product = new Mage_Catalog_Model_Product();        
$bundled_product->load($prodID);


    $typeInstance = $bundled_product->getTypeInstance(true);

    $selectionCollection = $typeInstance->getSelectionsCollection(
        $typeInstance->getOptionsIds($bundled_product), $bundled_product
    );

    $optionCollection = $typeInstance->getOptionsCollection($bundled_product);

    $_options = $optionCollection->appendSelections($selectionCollection, false, Mage::helper('catalog/product')->getSkipSaleableCheck());

    $bundle_option = array();

    foreach ($_options as $key => $value) {
        $default_title = $value->getData('default_title');
        $option_id = $value->getData('option_id');

        echo 'default_title: '. $default_title .' option_id: '.$option_id;

        foreach ($value['selections'] as $selKey => $selection) {

            // for selection option / products data

        }

    }

Magento 1.9 – Bundled Product Pricing and Configuration Confusion

As per my above scenario, I haven't got the main product listed as a bundled item/associated product within the bundled product, it is in fact the actual product that I converted to a bundled product...

And that's the problem. Think of bundle products as containers, that don't have their own stock. So if you care about stock management it's absolutely necessary to have the main product as simple product. Also it will solve your problem with price display as bundles with dynamic pricing don't have a base price, their price is the sum of all selected bundle options.

How to add a fixed main product to a bundle

Add one option, "main product" with type "checkbox" and make it "required".
Add the main product as only selection to this option, with "User defined qty" = "No".

The main product will show up on the bundle product page without input field or checkbox and its price will be shown for "price as configured" and "as low as"

Best Answer

Related Solutions

Magento – Bundle products – get default title for a bundle item

Magento 1.9 – Bundled Product Pricing and Configuration Confusion

How to add a fixed main product to a bundle

Related Topic