Magento – Magento 2: How to create configurable product Programmatically

configurable-productmagento2product

I want to create a configurable product and assign some simple product to it.
I have found lots of solution in the web but it's not working.
Please let me know if any idea!!!

Thanks

Best Answer

This code has worked for me. it may be help you.

$objectManager = \Magento\Framework\App\ObjectManager::getInstance();
$configurable_product = $objectManager->create('\Magento\Catalog\Model\Product');

$configurable_product->setSku('CONFIG_SKU'); // set sku
$configurable_product->setName('CONFIG PRODUCT NAME'); // set name
$configurable_product->setAttributeSetId(4);
$configurable_product->setStatus(1);
$configurable_product->setTypeId('configurable');
$configurable_product->setPrice(0);
$configurable_product->setWebsiteIds(array(1)); // set website
$configurable_product->setCategoryIds(array(2)); // set category
$configurable_product->setStockData(array(
    'use_config_manage_stock' => 0, //'Use config settings' checkbox
    'manage_stock' => 1, //manage stock
    'is_in_stock' => 1, //Stock Availability
        )
);

// super attribute 
$size_attr_id = $configurable_product->getResource()->getAttribute('product_size')->getId();
$color_attr_id = $configurable_product->getResource()->getAttribute('color')->getId();

$configurable_product->getTypeInstance()->setUsedProductAttributeIds(array($color_attr_id, $size_attr_id), $configurable_product); //attribute ID of attribute 'size_general' in my store

$configurableAttributesData = $configurable_product->getTypeInstance()->getConfigurableAttributesAsArray($configurable_product);
$configurable_product->setCanSaveConfigurableAttributes(true);
$configurable_product->setConfigurableAttributesData($configurableAttributesData);
$configurableProductsData = array();
$configurable_product->setConfigurableProductsData($configurableProductsData);
try {
    $configurable_product->save();
} catch (Exception $ex) {
    echo '<pre>';
    print_r($ex->getMessage());
    exit;
}

$productId = $configurable_product->getId();

// assign simple product ids
$associatedProductIds = array(12,13,14);

try{
$configurable_product = $objectManager->create('Magento\Catalog\Model\Product')->load($productId); // Load Configurable Product
    $configurable_product->setAssociatedProductIds($associatedProductIds); // Setting Associated Products
    $configurable_product->setCanSaveConfigurableAttributes(true);
    $configurable_product->save();
} catch (Exception $e) {
    echo "<pre>";
    print_r($e->getMessage());
    exit;
}

Related Solutions

Magento – Assign Configurable Product Images to Associated Products

I had the same issue and here is what I've used. It's a 'quick and dirty' script that works with the database directly, so back up you DB before trying it. Also add the table prefix if you have one.

$resource = Mage::getSingleton('core/resource');
$attributes = array('image', 'thumbnail', 'small_image');
$connection = $resource->getConnection('core_write');
$collection = Mage::getModel('catalog/product')->getCollection()
    ->addAttributeToSelect($attributes)
    ->addAttributeToFilter('type_id', 'configurable')
    ->setOrder('sku', 'ASC');

foreach($collection as $product){
    //$product->load($product->getId());//not sure if this is needed
    $simpleProductsIds = $product->getTypeInstance()->getUsedProductIds();
    $q = "SELECT * FROM catalog_product_entity_media_gallery WHERE entity_id = {$product->getId()}";
    $result = $connection->query($q)->fetchAll();
    foreach ($result as $row){
        $q = "SELECT * FROM catalog_product_entity_media_gallery_value where value_id = {$row['value_id']}";
        $valueResult = $connection->query($q)->fetchAll();
        foreach ($simpleProductsIds as $id){
            $q = "INSERT INTO catalog_product_entity_media_gallery SET
                attribute_id= {$row['attribute_id']},
                entity_id = {$id},
                value = '{$row['value']}'
            ";
            $connection->query($q);
            $lastInsert = $connection->lastInsertId();
            foreach ($valueResult as $val){
                $q = "INSERT INTO catalog_product_entity_media_gallery_value SET
                    value_id = {$lastInsert},
                    store_id = {$val['store_id']},
                    label = '{$val['label']}',
                    position = {$val['position']},
                    disabled = {$val['disabled']}
                ";
                $connection->query($q);
            }
        }
    }
    //update media images
    $data = array();
    foreach ($attributes as $attribute){
        $data[$attribute] = $product->getData($attribute);
    }
    Mage::getSingleton('catalog/product_action')
        ->updateAttributes($simpleProductsIds, $data, 0);
    echo "Done with product: ".$product->getId()."<br />";
}

It took about 20 seconds for 80 configurable products and about 400 simple products associated to configurable.
If you have 20k products I don't think it's a good idea to iterate the product collection like I did. You can use Mage::getSingleton('core/resource_iterator'). More about it here.

Magento2 – Associate Simple Product to Configurable Product

Looks like you need to add StockItem extension attribute to your configurable product.

See how Magento developer do it in the test fixture product_configurable.php

Best Answer

Related Solutions

Magento – Assign Configurable Product Images to Associated Products

Magento2 – Associate Simple Product to Configurable Product

Related Topic