Magento – How to create/update bulk of products at a time programmatically

ce-1.9.0.1magento-1.9programmaticallysimple-product

In the following code I have written to create a single simple product at a time, but I want to make a bulk creation of products at a time, can anyone help me in doing this?

Mage::app('default')->setCurrentStore(Mage_Core_Model_App::ADMIN_STORE_ID);
        $product = Mage::getModel('catalog/product');
        $product->setAttributeSetId($attributeSetId);//ID of a attribute set named 'default'
        $product->setTypeId('simple');  //product type
        $product->setWebsiteIds(array(1));
        $product->setSku($itemjson->getSku($i)); //SKU
        $product->setName($itemjson->getName($i)); //product name
        $product->setWeight($itemjson->getWeight($i));
        $product->setUpdatedAt(strtotime('now'));
        $product->setStatus(1);//product status (1 - enabled, 2 - disabled)
        $product->setTaxClassId(4); //tax class (0 - none, 1 - default, 2 - taxable, 4 - shipping)
        $product->setVisibility(Mage_Catalog_Model_Product_Visibility::VISIBILITY_BOTH); //catalog and search visibility
        $product->setPrice($price); //price in form 11.22
        $product->setDescription($itemjson->getDesc($i));
        $product->setShortDescription($itemjson->getShortDesc($i)) ;
        $product->setStockData(array(
               'use_config_manage_stock' => 0, //'Use config settings' checkbox
               'manage_stock'=>1, //manage stock
               'min_sale_qty'=>1, //Minimum Qty Allowed in Shopping Cart
               'max_sale_qty'=>1000, //Maximum Qty Allowed in Shopping Cart
               'is_in_stock' => 1, //Stock Availability
               'qty' => $itemjson->getStock($i), //qty
                )
            );
        $catArray=$itemjson->getSimpleCat($i);
        $catKeys=array_keys($catArray);
        $product = self::manageAttr($product,$catArray);
        $product->setCategoryIds($categories);
        $product->save();

Best Answer

maybe this instruction helps you.

$product->setIsMassupdate(true)->setExcludeUrlRewrite(true);

This may say Magento that is not necessary reindex tables on each product save.

Related Solutions

Magento – How to update configurable associated products programmatically

i use this code to insert and update configurable product in my custom extention.

where all data get in data variable
$pid is configurable product id.
$aid is attribute id.
before you use this code u set session variable is edit to 0 or 1. 0- if new product , 1- if edit existing product

$data = $this->getRequest ()->getPost();
            $pid=Mage::getSingleton('core/session')->getAttributeId();
            $aid=Mage::getSingleton('core/session')->getAttributeValue();
            Mage::app()->setCurrentStore(Mage_Core_Model_App::ADMIN_STORE_ID);
            $prd = Mage::getModel('catalog/product')->load($pid);
            try
            {
                $totalRow=count($data['product_id']);
                if($totalRow>0)
                {
                         $configurable = Mage::getModel('catalog/product')->load($pid);
                         if(!Mage::getSingleton('core/session')->getIsEdit(0))
                         {
                            $configurable->getTypeInstance()->setUsedProductAttributeIds(array($aid));
                         }
                         $configurable->save();
                         $productModel = Mage::getModel('catalog/product');
                         $configAttributeCode = $productModel->getResource()->getAttribute($aid)->getAttributeCode();
                         $simpleProducts = Mage::getResourceModel('catalog/product_collection')
                                ->addIdFilter($data['product_id'])
                                ->addAttributeToSelect($configAttributeCode);

                         $configurableProductsData = array();
                         $configurableAttributesData = $configurable->getTypeInstance()->getConfigurableAttributesAsArray();

                            for($l=0;$l<$totalRow;$l++)
                            {
                                $_product = Mage::getModel('catalog/product')->load($data['product_id'][$l]);
                                $_product->setVisibility(Mage_Catalog_Model_Product_Visibility::VISIBILITY_NOT_VISIBLE);
                                $_product->getResource()->save($_product);
                                $productModel = Mage::getModel('catalog/product');
                                $attr = $productModel->getResource()->getAttribute($aid);
                                $att_label = $attr->getSource()->getOptionText($data['attribute_type'][$l]);
                                $productData = array( 
                                        'label' => $att_label, //attribute label
                                        'attribute_id' => $aid, //attribute ID 
                                        'value_index' => $data['attribute_type'][$l],
                                        'is_percent' => '0', //fixed/percent price for this option
                                        'pricing_value' => $data['product_price'][$l] //value for the pricing
                                );
                                $configurableProductsData[$_product->getId()] = $productData;
                                $configurableAttributesData[0]['values'][$l] = $productData;
                            }

                            $configurable->setConfigurableProductsData($configurableProductsData);
                            $configurable->setConfigurableAttributesData($configurableAttributesData);
                            Mage::app()->setCurrentStore(Mage_Core_Model_App::ADMIN_STORE_ID);
                            $configurable->setCanSaveConfigurableAttributes(true);
                            $configurable->setStatus(1);
                            $configurable->save();

                }
            }
            catch(Exception $e)
            {
                echo $e->getMessage();  
            }

Magento 2 – How to Correctly Update Product Programmatically

After debugging the code and using the suggestion of @David i realized that the problem wasn't the way i used to create products attributes but the i was using the Create method of the Object Manager (this create duplicated entries of website id in the db) in the update-part (else-part of the statement). After using Get method of the Object Manager, the product could be saved but this couldn't be used in the foreach as it would take only on Product (instance) and ignore the rest. So for updating products' attributes i used a collection instead. Below is the working code.

protected function processProducts($products) {

    $dbProducts = json_decode($products, true);
    $catalogConfig = $this->_objectManager->create('Magento\Catalog\Model\Config');
    $attributeSetId = $catalogConfig->getAttributeSetId(4, 'Default');
    $productsToUpdate = [];
    $productsIds = [];
    foreach ($dbProducts as $dbProduct){
        try {
            $tempProduct = $this->productRepository->get($dbProduct["id"]);
            $productsIds[] = $tempProduct->getId();
            $productsToUpdate[$tempProduct->getSku()] = $dbProduct;
        } catch (\Magento\Framework\Exception\NoSuchEntityException $e) {
            $product = $this->productFactory->create();
            $inventoryQty = ($dbProduct["inventory"] > 0) ? $dbProduct["inventory"] : 0;
            $isInStock = ($inventoryQty > 0) ? 1 : 0;
            $product->setTypeId(\Magento\Catalog\Model\Product\Type::TYPE_SIMPLE);
            $product->setAttributeSetId($attributeSetId);
            $product->setWebsiteIds([$this->_storeManager->getWebsite()->getId()]);
            $product->setStatus(\Magento\Catalog\Model\Product\Attribute\Source\Status::STATUS_DISABLED);
            $product->setQuantityAndStockStatus(['qty' => $inventoryQty, 'is_in_stock' => $isInStock]);
            $product->setStoreId(\Magento\Store\Model\Store::DEFAULT_STORE_ID);
            $product->setVisibility(\Magento\Catalog\Model\Product\Visibility::VISIBILITY_BOTH);
            $product->setPrice(0);
            $product->setWeight(1);
            $product->setName(utf8_encode($dbProduct["nombre"]));
            $product->setSku($dbProduct["id"]);
            $product->setUrlKey($dbProduct["id"]);
            $product->setCustomAttribute('last_price', $dbProduct["lastCost"]);
            $product->setCustomAttribute('last_price_date', $dbProduct["lastCostDate"]);
            $product->setCustomAttribute('is_db', true);
            $product->setIsMassupdate(true);
            $product->setExcludeUrlRewrite(true);
            $product->save();
        }
    }

    if(sizeof($productsToUpdate)>0) {
        $this->updateProducts($productsIds, $productsToUpdate);
    }

    $indexer = $this->_indexerFactory->create();
    $indexerCollection = $this->_indexerCollectionFactory->create();
    $ids = $indexerCollection->getAllIds();

    foreach ($ids as $id){
        $idx = $indexer->load($id);
        $idx->reindexRow($id);
    }
}

private function updateProducts($productsIds, $productsToUpdate) {
    $collection = $this->productCollectionFactory->create()->addIdFilter($productsIds);
    foreach ($collection->getItems() as $product) {
        try {
            $productSku = $product->getSku();
            $dbProduct = $productsToUpdate[$productSku];
            $inventoryQty = ($dbProduct["inventory"] > 0) ? $dbProduct["inventory"] : 0;
            $isInStock = ($inventoryQty > 0) ? 1 : 0;
            $stockItem = $this->stockRegistry->getStockItemBySku($dbProduct["id"]);
            $stockItem->setQty($inventoryQty);
            $stockItem->setIsInStock($isInStock);
            $this->stockRegistry->updateStockItemBySku($dbProduct["id"], $stockItem);
            $stockItem->save();
            $product->setData('last_price', $dbProduct["lastCost"]);
            $product->getResource()->saveAttribute($product, 'last_price');
            $product->setData('last_price_date', $dbProduct["lastCostDate"]);
            $product->getResource()->saveAttribute($product, 'last_price_date');                
        } catch (Exception $e) {
            $e->getMessage();
        }
    }
}

Best Answer

Related Solutions

Magento – How to update configurable associated products programmatically

Magento 2 – How to Correctly Update Product Programmatically

Related Topic