Magento – Magento 2 – Update multiple products programmatically

apimagento2magento2.2

I'm trying to update products programmatically but I got only first product from array updated. All of products in array have status "2" (disabled) in DB. I'm using $this->productRepositoryInterface – it's \Magento\Catalog\Api\ProductRepositoryInterface

$productSkus = ['A1', 'A2', 'A3'];

foreach ($productSkus as $sku) {
    $productToSave = $this->productRepositoryInterface->get($sku);
    echo "Product {$productToSave->getId()} is loaded and ready to update".PHP_EOL;
    $productToSave->setStatus(1);
    $this->productRepositoryInterface->save($productToSave);
}

After that code executed – I got only A1 set to "Enabled". Other products keeping be disabled. Echo says it's loading everytime new product to be updated. Magento 2.2.4 EE (CE is also affected)

Best Answer

Try to use this below code :

protected $_productCollectionFactory;
protected $_product;

 public function __construct(
    .................
    \Magento\Catalog\Model\ResourceModel\Product\CollectionFactory $productCollectionFactory,
    \Magento\Catalog\Model\Product $product,
    .................
)
{
    .................    
    $this->_productCollectionFactory = $productCollectionFactory;
    $this->_product = $product;
    .................
}

public function yourFunction()
{
    $collection = $this->_productCollectionFactory->create()->getCollection();
    foreach ($collection as $value) {
        $product = $this->_product->load($value->getId());
        $product->setStatus(1);
        $product->save();
    }
}

Remove var and generated folder.

Related Solutions

Magento – Magento 2.1.1 Rest API Update price only

You can use the following rest PUT call:

/rest/V1/products/{SKU}

Passing the following json:

{
"product": {
  "price": 9.63,
  "extension_attributes": {
    "stock_item": {
      "qty": 63
    }
  }
 }
}

So you can update price and stock quantity with one single call. You can remove the extension_attributes value, if you only want to update the price.

EDIT

You will need a quotation mark for your price, like this below. I don't quite understand why because the price should be a double variable in the database.

{ 
    "product":{ 
        "price":"9.63",
        "extension_attributes":{ 
            "stock_item":{ 
                "qty":63
            }
        }
    }
}

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 – Magento 2.1.1 Rest API Update price only

Magento 2 – How to Correctly Update Product Programmatically

Related Topic