Remove Categories from Simple Products

Question

Can anyone tell me how can i fetch all the Simple SKU's and remove all the categories from those SKU via PHP script in magento 2.4.4.

Answer 1

To achieve that, create a new PHP file in your Magento directory which is the same level as app, lib, pub ... with the following content:

<?php
error_reporting(E_ALL);
ini_set('display_errors', 1);
ini_set('memory_limit', '5G');

use Magento\Catalog\Model\Product\Type;
use Magento\Catalog\Model\ResourceModel\Product\Collection;
use Magento\Framework\App\Bootstrap;

require __DIR__ . '/app/bootstrap.php';

$bootstrap = Bootstrap::create(BP, $_SERVER);

$objectManager = $bootstrap->getObjectManager();
$state = $objectManager->get('Magento\Framework\App\State');
$state->setAreaCode('frontend');

$collectionFactory = $objectManager->create(Magento\Catalog\Model\ResourceModel\Product\CollectionFactory::class);
/** @var Collection $collection */
$collection = $collectionFactory->create();
$collection->addAttributeToFilter('type_id', ['eq' => Type::TYPE_SIMPLE])->load();

foreach ($collection as $product) {
    $product->setData('category_ids', null)->save();
}

For example, you set the file name removeAllCategoriesFromSimpleProducts.php, to execute the script, you should run the following command from the SSH terminal:

php removeAllCategoriesFromSimpleProducts.php