Magento – Magento 2: How to set visibility and status to product using collection

attributescollection;magento2module

I'm creating a cron to pass through all the products and set them visible and active.

This is my execute of the cron who runs well:

public function execute(){
    /**
     * @var $item \Magento\Catalog\Model\Product
     * @var \Magento\Catalog\Model\ResourceModel\Product\Collection $collection
     */

    $items = $this->productCollection->getItems();

    foreach($items as $item){
        echo  $item->getSku() .'<br>';
        $item->setVisibility(\Magento\Catalog\Model\Product\Visibility::VISIBILITY_BOTH);
        $item->setStatus(\Magento\Catalog\Model\Product\Attribute\Source\Status::STATUS_ENABLED);
        $item->save();
    }
    echo 'finish';
}

I've got a product with none visibility and status disabled, but when I run the function the product is still with none visibility and status disabled.

What I'm doing wrong?

Best Answer

You should replace the $item->save(); with below code:

$item->getResource()->saveAttribute($item, 'visibility');

$item->getResource()->saveAttribute($item, 'status');

Related Solutions

Magento – Magento 2 get out of stock products in collection

If it helps anyone, this is the only way I've managed to get all products, including out of stock products, in a loop for updating the stock values.

I needed to use ->getAllIds() to get an array of all of the products IDs, and then load each product individually rather than loop through the whole collection.

$productCollection = $objectManager->create('Magento\Catalog\Model\ResourceModel\Product\CollectionFactory');
$productCollectionIds = $productCollection->create()->getAllIds();

foreach ($productCollectionIds as $productId) {
    try {
        $product = $objectManager->create('Magento\Catalog\Model\Product')->load($productId);
        // do actions with product
    } catch (Exception $e) {
        $e->getMessage();
    }
}

Magento – How to get product collection in magento 2

OPTION 1:

You can use repositories for this and return a SearchResultsInterface.

OPTION 2:

Use Magento API \Magento\Catalog\Api\ProductRepositoryInterface witha search filter.

OPTION 3:

Change your code to return an array of ProductInterface

...
    /**
     * Returns Product collection
     *
     * @api
     *
     * @return \Magento\Catalog\Api\Data\ProductInterface[]
     */
    public function getProductCollection()
    {
        $collection = $this->productCollectionFactory->create();
        $collection->addAttributeToSelect('*');
        $collection->setPageSize(3); // fetching only 3 products

        $res = [];
        foreach ($collection as $product) {
           $res[] = $product;
        }

        return $res;
    }
...

WARNING: Rememeber to set @return \Magento\Catalog\Api\Data\ProductInterface[] on your interface or it will not work

Best Answer

Related Solutions

Magento – Magento 2 get out of stock products in collection

Magento – How to get product collection in magento 2

Related Topic