Assign all groups in all categories

assign_all_groups_in_all_categories.php

<?php


require (dirname(__FILE__) . '/config/config.inc.php');

$scriptKey = 'xjkhjiauuhgiu855wbgfb';

if(Tools::getValue('scriptKey') != $scriptKey){
	die('403');
}


$categories = (new PrestaShopCollection('Category'))->getResults();
$excludedCategories = [1,2]; // roots categories

$newGroups = Db::getInstance(_PS_USE_SQL_SLAVE_)->executeS('
	SELECT g.`id_group`
	FROM `' . _DB_PREFIX_ . 'group` g'
);

if(!empty($categories)){
	foreach ($categories as $categorieObject){
		
		if(!Validate::isLoadedObject($categorieObject) || in_array($categorieObject->id,$excludedCategories)){
			continue;
		}
		
		$categorieCurrentGroupsId = $categorieObject->getGroups();
		
		// Assing news groups if not exist.
		foreach($newGroups as $group){
			$groupId = (int) $group['id_group'];
			if(!in_array($groupId, $categorieCurrentGroupsId)){
				$categorieObject->addGroups([$groupId]);
				echo 'Group '.$groupId.' add in categorie '.$categorieObject->id.'<br>';
			}
		}
	
	}
}