Автоматически проставить главную категорию у всех товаров.

require_once "./config/config.inc.php";
require_once "./init.php";
set_time_limit(0);
$start = ($_GET['start'] ? $_GET['start'] : 0);
$limit = ($_GET['limit'] ? $_GET['limit'] : 10000);
 
$products = Db::getInstance()->ExecuteS('SELECT id_product,id_category_default FROM ps_product WHERE 1');
$i=0;
foreach($products as $product){
	$cats = Db::getInstance()->ExecuteS('SELECT c.*, cp.* FROM ps_category c, ps_category_product cp WHERE cp.id_category = c.id_category AND cp.id_product = '.$product['id_product']);
	//print_r($cats);
	$max = 0;
	$id_max = 0;
	foreach($cats as $cat){
		if($cat['level_depth']>$max){
			$max = $cat['level_depth'];
			$id_max = $cat['id_category'];
		}
	}
	if($id_max && $product['id_category_default'] != $id_max){
		Db::getInstance()->Execute('UPDATE ps_product SET id_category_default = '.(int)$id_max.' WHERE id_product='.$product['id_product']);
		$i++;
	}
}
echo $i;