$catId = $cat->getId(); break; } } return $catId; } public function assignProduct($categoryId, $object) { $products = array(); foreach ($object['products'] as $sku) { $product = Mage::getModel('catalog/product')->loadByAttribute('sku', $sku); if (empty($product) || !$product->getId()) { continue; } $products[$product->getId()] = 1; //Mage::getModel('Mage_Catalog_Model_Category_Api')->assignProduct($categoryId, $product->getId()); } $category = Mage::getModel('catalog/category')->load($categoryId); $category->setPostedProducts($products); try { $category->save(); } catch (Exception $e) { echo $e->getMessage(); } echo "\n{$object['name']} assigned\n"; } } echo date("\nY-d-m H:i:s") . " - catalog category import start\n"; $imp = new Category_Export(); $imp->load(); echo date("\nY-d-m H:i:s") . " - catalog category import completed\n";
join catalog_category_product_synch s on p.category_id = s.live_category_id set p.category_id = s.category_id; "; $this->exec($query); $query = " drop table if exists catalog_category_product2; create table catalog_category_product2 like catalog_category_product; insert into catalog_category_product2 select * from catalog_category_product; "; $this->exec($query); $query = " delete from catalog_category_product; insert into catalog_category_product select * from catalog_category_product_fm3; "; $this->exec($query); }*/ public function exec($query) { $connection = $this->connection; try { $connection->exec($query); } catch (Exception $e) { echo $query . "\n"; echo $e->getMessage(); } } } echo date("\nY-d-m H:i:s") . " - catalog category import start\n"; $imp = new Category_Export(); $imp->catalog_category_product_synch(); echo date("\nY-d-m H:i:s") . " - catalog category import completed\n";