Magento – How to create a configurable product with associated products

magento-1magento-enterprise

The following code does create a configurable product, however, when I open the product in the backend, the following message appears:

when I create the configurable product and open it in the backend, I get this message: Select Configurable Attributes Only attributes with scope "Global", input type "Dropdown" and Use To Create Configurable Product "Yes" are available.

Material 
Size 
Cotton 
Color 
Colour Group

I selected size and color, and clicked continue, however, there are no associated products. All of the other product data is there.

//Mage Product
$mpr = Mage::getModel('catalog/product');
$mpr
    ->setTypeId(Mage_Catalog_Model_Product_Type::TYPE_CONFIGURABLE)
    ->setTaxClassId(5)
    ->setVisibility(Mage_Catalog_Model_Product_Visibility::VISIBILITY_BOTH)
    ->setStatus(Mage_Catalog_Model_Product_Status::STATUS_ENABLED)
    ->setWebsiteIds(array(1))
    ->setAttributeSetId(4) // You can determine this another way if you need to.
    ->setSku("C12345")
    ->setName("C12345")
    ->setQty(25)
    ->setShortDescription('short description')
    ->setDescription('description')
    ->setPrice(1)
    ->setStockData(array(
        'use_config_manage_stock' => 1,
        'is_in_stock' => 1,
        'is_salable' => 1,
    ));

    $productData = array(
         '7039604' =>
            array('0' => array('attribute_id' => '85', 'label' => 'ROYAL','value_index' => '28563', 'is_percent' => 0, 'pricing_value' => '')
                 ,'1' => array('attribute_id' => '192', 'label' => '14', 'value_index' => '28728', 'is_percent' => 0, 'pricing_value' => '')
            )
    );
    $attributeData = array(
        '0' => array(
            'id' => NULL
            ,'label' => 'Color'
            ,'position' => NULL
            ,'values' => array(
                '0' => array('value_index' => 28563, 'label' => 'ROYAL', 'is_percent' => 0, 'pricing_value' => '0', 'attribute_id' => '85')
            )
            ,'attribute_id' => 85
            ,'attribute_code' => 'color'
            ,'frontend_label' => 'Color'
            ,'html_id' => 'config_super_product__attribute_0')
        ,'1' => array(
            'id' => NULL
            ,'label' => 'Rivers Size'
            ,'position' => NULL
            ,'values' => array(
                '0' => array('value_index' => 28728, 'label' => '14', 'is_percent' => 0, 'pricing_value' => '0', 'attribute_id' => '192')
            )
            ,'attribute_id' => 192
            ,'attribute_code' => 'rivers_size'
            ,'frontend_label' => 'Rivers Size'
            ,'html_id' => 'config_super_product__attribute_1')
    );
$mpr->setConfigurableProductsData($productData);
$mpr->setConfigurableAttributesData($attributeData);
$mpr->setCanSaveConfigurableAttributes(true);
$mpr->save();

Best Answer

Looking at your code, you are missing the part where you inform Magento which attributes are used in your configurable (this would correspond to the first step when creating a configurable product in the admin, where you pick the used attributes). Put this before the call to setConfigurableProductsData:

$mpr->getTypeInstance()->setUsedProductAttributeIds(array(85,192));

Related Solutions

Magento – Configurable product – Inventory – Stock Availability status doesn’t change when all associated Simple products go out of stock

Magento confirmed this is not part of Magento (Enterprise or Community). The parent (configurable) Stock Availability Status remains untouched regardless of what happens to any of it's children (simple).

Magento actually provided me with a patch (for EE v1.12.0.2) for Enterprise that checks all a parents children status before deciding to display it or not. This seems to work by default in Community 1.7. But this is only a frontend fix.

To fix the parent Availibity Status you can do one of the following:

Listen out for the cataloginventory_stock_item_save_after event. Then in your Observer class for configurable product types (or other types that have children) you can load $product->getTypeInstance()->getUsedProducts(); and do your necessary checks and updates.
Extend the class Mage_CatalogInventory_Model_Stock_Item and in the _afterSave() function do the same as above. Be careful doing rewrites. It might already be extended by another third party module.

Hope this helps. Tadhg

Magento – Optimize this query selecting associated configurable products

I usually avoid direct SQL queries. Hopefully you're building some sort of reporting mechanism to generate some business intelligence. Please don't build a feature for your store based on the following recommendations.

In this case you probably would do well to create an in-memory temporary table which is populated by all configurable links that have 45535 as its' parent.

CREATE TABLE cpsl_memory ENGINE=MEMORY
SELECT * FROM catalog_product_super_link WHERE parent_id = 45535;

And then select from this table:

SELECT product_id FROM cpsl_memory 
WHERE parent_id != 45535
GROUP BY product_id;

The GROUP BY here collapses duplicates - you could probably use DISTINCT as well. Of course you want to tear down the temporary table afterward:

DROP TABLE cpsl_memory;

Alternative methods:

Same technique, different methods. Disclaimer: these may not be faster.

Local vars:

SET @instmt = (SELECT GROUP_CONCAT(DISTINCT product_id SEPARATOR ',') FROM catalog_product_super_link WHERE parent_id=45535);
SELECT * FROM catalog_product_super_link WHERE parent_id NOT IN (@instmt);

Subquery:

SELECT * FROM catalog_product_super_link cpsl
WHERE cpsl.parent_id <> 45535
AND cpsl.product_id IN (
    SELECT product_id FROM catalog_product_super_link cpslsq WHERE parent_id=45535;
)

Disclaimer:

Query optimization is probably off-topic for Magento.SE - but I spent the better part of 1.0-1.3CE creatively optimizing sales reports for EAV I thought I'd help you out. I'm not a DBA.

In absence of having some sample data from you I've cobbled together the above, largely untested, as to guide you into other methods (besides the self-join) to accomplish a similar result.

Best Answer

Related Solutions

Magento – Configurable product – Inventory – Stock Availability status doesn’t change when all associated Simple products go out of stock

Magento – Optimize this query selecting associated configurable products

Related Topic