blocks|key|855607|text|您可以编写一个模块(这需要时间，但在导入数据时可能会更快)，或者您可以将一些东西与API放在一起(较少涉及Magento编程，但在导入数据时可能会更慢)。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|855608|你的起点--你已经知道了什么，你的时间有多宝贵，以及你需要多长时间运行一次更新，这应该决定你的选择。|855609|以下是将产品添加到类别的Magento+API文档(参见页脚的示例)：|855610|http://www.magentocommerce.com/wiki/doc/webservices-api/api/catalog_category|offset|length|855611|entityMap|0|LINK|mutability|MUTABLE|url^0|0|0|0|0|24|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|R|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|S|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|T|8|@]|9|@$H|U|I|V|1|W]]|A|$]]|$1|J|3|-4|5|6|7|X|8|@]|9|@]|A|$]]]|K|$L|$5|M|N|O|A|$P|G]]]]

You can write a module (which takes time but potentially quicker at importing your data) or you can put something together with the API (less involving of Magento programming but potentially slower at importing your data).

Your starting point of what-you-know-already, how valuable your time is and how often you will need to run the update should determine your choice.

Here is the Magento API documentation for adding products to categories (see example at foot of page):

<a href="http://www.magentocommerce.com/wiki/doc/webservices-api/api/catalog_category" rel="nofollow">http://www.magentocommerce.com/wiki/doc/webservices-api/api/catalog_category</a>

blocks|key|638264|text|在PHP代码中，您可以在导入它们时将它们放入类别中。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|638265|假设您有一个名为$product的产品和一个名为$category_id的类别ID|638266|您可以通过执行以下操作设置产品所属的类别|638267|$categories+=+array($category_id);
$product->setCategoryIds($categories);
$product->save();|code-block|syntax|javascript|638268|如果产品已经有了类别，并且你想再添加一个类别，那么你可以像这样使用getCategoryIds()：|offset|length|style|CODE|638269|$categories+=+$product->getCategoryIds();
$categories[]+=+$categoryId;
$product->setCategoryIds($categories);
$product->save();|638270|或者，正如Joshua+Peck在评论中提到的，您可以使用category_api模型在类别中添加或删除产品，而不会影响其当前的类别分配：|638271|Mage::getSingleton('catalog/category_api')
++->assignProduct($category->getId(),$p‌​roduct->getId());

Mage::getSingleton('catalog/category_api')
++->removeProduct($category->getId(),$p‌​roduct->getId());|638272|entityMap^0|0|0|0|0|X|G|0|0|T|C|0|0^^$0|@$1|2|3|4|5|6|7|Y|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|Z|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|10|8|@]|9|@]|A|$]]|$1|F|3|G|5|H|7|11|8|@]|9|@]|A|$I|J]]|$1|K|3|L|5|6|7|12|8|@$M|13|N|14|O|P]]|9|@]|A|$]]|$1|Q|3|R|5|H|7|15|8|@]|9|@]|A|$I|J]]|$1|S|3|T|5|6|7|16|8|@$M|17|N|18|O|P]]|9|@]|A|$]]|$1|U|3|V|5|H|7|19|8|@]|9|@]|A|$I|J]]|$1|W|3|-4|5|6|7|1A|8|@]|9|@]|A|$]]]|X|$]]

In PHP code you can put them into the category while you are importing them.

Say you have a product called $product and a category ID called $category_id

You can set the categories which a product belongs to by doing the following

<pre><code>$categories = array($category_id);
$product-&gt;setCategoryIds($categories);
$product-&gt;save();
</code></pre>

If the product already has categories and you'd like to add one more then you can use <code>getCategoryIds()</code> like this:

<pre><code>$categories = $product-&gt;getCategoryIds();
$categories[] = $categoryId;
$product-&gt;setCategoryIds($categories);
$product-&gt;save();
</code></pre>

Or, as mentioned by Joshua Peck in the comments, you can use the <code>category_api</code> model to add or remove a product from a category without affecting it's current category assignments:

<pre><code>Mage::getSingleton('catalog/category_api')
 -&gt;assignProduct($category-&gt;getId(),$p‌​roduct-&gt;getId());

Mage::getSingleton('catalog/category_api')
 -&gt;removeProduct($category-&gt;getId(),$p‌​roduct-&gt;getId());
</code></pre>

blocks|key|855700|text|好吧，出于某种懒惰的原因，我最终使用API完成了这项工作。这会将所有可见产品添加到ID为146的类别中：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|855701|<?php
++$client=+new+SoapClient('http://www.example.com/api/soap/?wsdl',+array('trace'+=>+1,+"connection_timeout"+=>+120));

++//+Can+be+added+in+Magento-Admin+->+Web+Services+with+role+set+to+admin

++$sess_id=+$client->login('apiuser',+'apikey');

++//+Get+the+product+list+through+SOAP
++$filters+=+array('visibility'+=>+'4',+'status'+=>+'1');
++$all_products=$client->call($sess_id,+'product.list',+array($filters));

++//+Now+chuck+them+into+category+146

++foreach($all_products+as+$product)
++{++//var_dump($product);
++++++echo+$product['sku']."\n";
++++++$doit=$client->call($sess_id,+'category.assignProduct',+array('146',+$product['sku']));
++}
?>|code-block|syntax|javascript|855702|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

Well I ended up doing this with the API for some reason of laziness. This adds all the visible products into the category with ID 146:

<pre><code>&lt;?php
 $client= new SoapClient('http://www.example.com/api/soap/?wsdl', array('trace' =&gt; 1, "connection_timeout" =&gt; 120));

 // Can be added in Magento-Admin -&gt; Web Services with role set to admin

 $sess_id= $client-&gt;login('apiuser', 'apikey');

 // Get the product list through SOAP
 $filters = array('visibility' =&gt; '4', 'status' =&gt; '1');
 $all_products=$client-&gt;call($sess_id, 'product.list', array($filters));

 // Now chuck them into category 146

 foreach($all_products as $product)
 { //var_dump($product);
 echo $product['sku']."\n";
 $doit=$client-&gt;call($sess_id, 'category.assignProduct', array('146', $product['sku']));
 }
?&gt;
</code></pre>

blocks|key|855743|text|在研究Magento+API之后:+Magento通过以下方式将产品添加到类别中：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|855744|public+function+assignProduct($categoryId,+$productId,+$position+=+null,+$identifierType+=+null)
{
++++$category+=+$this->_initCategory($categoryId);
++++$positions+=+$category->getProductsPosition();
++++$productId+=+$this->_getProductId($productId);
++++$positions[$productId]+=+$position;
++++$category->setPostedProducts($positions);

++++try+{
++++++++$category->save();
++++}+catch+(Mage_Core_Exception+$e)+{
++++++++$this->_fault('data_invalid',+$e->getMessage());
++++}

++++return+true;
}|code-block|syntax|javascript|855745|并获得所有已签署的产品：|855746|public+function+assignedProducts($categoryId,+$store+=+null)
{
++++$category+=+$this->_initCategory($categoryId);

++++$storeId+=+$this->_getStoreId($store);
++++$collection+=+$category->setStoreId($storeId)->getProductCollection();
++++($storeId+==+0)?+$collection->addOrder('position',+'asc')+:+$collection->setOrder('position',+'asc');;

++++$result+=+array();

++++foreach+($collection+as+$product)+{
++++++++$result[]+=+array(
++++++++++++'product_id'+=>+$product->getId(),
++++++++++++'type'+++++++=>+$product->getTypeId(),
++++++++++++'set'++++++++=>+$product->getAttributeSetId(),
++++++++++++'sku'++++++++=>+$product->getSku(),
++++++++++++'position'+++=>+$product->getPosition()
++++++++);
++++}

++++return+$result;
}|855747|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

After looking into the Magento API: Magento adds products to categories in the following way:

<pre><code>public function assignProduct($categoryId, $productId, $position = null, $identifierType = null)
{
 $category = $this-&gt;_initCategory($categoryId);
 $positions = $category-&gt;getProductsPosition();
 $productId = $this-&gt;_getProductId($productId);
 $positions[$productId] = $position;
 $category-&gt;setPostedProducts($positions);

 try {
 $category-&gt;save();
 } catch (Mage_Core_Exception $e) {
 $this-&gt;_fault('data_invalid', $e-&gt;getMessage());
 }

 return true;
}
</code></pre>

And getting all the asigned products:

<pre><code>public function assignedProducts($categoryId, $store = null)
{
 $category = $this-&gt;_initCategory($categoryId);

 $storeId = $this-&gt;_getStoreId($store);
 $collection = $category-&gt;setStoreId($storeId)-&gt;getProductCollection();
 ($storeId == 0)? $collection-&gt;addOrder('position', 'asc') : $collection-&gt;setOrder('position', 'asc');;

 $result = array();

 foreach ($collection as $product) {
 $result[] = array(
 'product_id' =&gt; $product-&gt;getId(),
 'type' =&gt; $product-&gt;getTypeId(),
 'set' =&gt; $product-&gt;getAttributeSetId(),
 'sku' =&gt; $product-&gt;getSku(),
 'position' =&gt; $product-&gt;getPosition()
 );
 }

 return $result;
}
</code></pre>

blocks|key|638369|text|我只想补充一下，你可以使用getSingleton类别接口来删除和添加：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|638370|要从类别中删除产品，请执行以下操作：|638371|Mage::getSingleton('catalog/category_api')->removeProduct($category->getId(),$p‌​roduct->getId());|code-block|syntax|javascript|638372|要将产品添加到类别中：|638373|Mage::getSingleton('catalog/category_api')->assignProduct($category->getId(),$p‌​roduct->getId());|638374|这不会覆盖该产品已在的任何类别|638375|entityMap^0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|R|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|S|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|T|8|@]|9|@]|A|$]]|$1|K|3|L|5|F|7|U|8|@]|9|@]|A|$G|H]]|$1|M|3|N|5|6|7|V|8|@]|9|@]|A|$]]|$1|O|3|-4|5|6|7|W|8|@]|9|@]|A|$]]]|P|$]]

I just want to add that you can remove and add with getSingleton category API:

To Remove product from category:

<pre><code>Mage::getSingleton('catalog/category_api')-&gt;removeProduct($category-&gt;getId(),$p‌​roduct-&gt;getId());
</code></pre>

To Add Product to Category:

<pre><code>Mage::getSingleton('catalog/category_api')-&gt;assignProduct($category-&gt;getId(),$p‌​roduct-&gt;getId());
</code></pre>

This will not overwrite any categories the product is already in

blocks|key|855815|text|我们可以使用magento脚本以编程方式将多个产品分配给该类别。请创建类别数组，并根据自定义属性或字段选择产品。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|855816|$newproducts+=+$product->getCollection()->addAttributeToFilter(array(array('attribute'=>'attribute_label',+'eq'=>+'attribute_id')));|code-block|syntax|javascript|855817|遍历产品并将其分配给类别，如下所示。|855818|$newCategory+=+array(+$list[0]+,+$list[$key]);+
foreach+($newproducts+as+$prod)
{
++++$prod->setCategoryIds(array_merge($prod->getCategoryIds(),+$newCategory));
++++$prod->save();
}|855819|​|855820|请参考my+tutorial，它给出了一步一步的解释。|offset|length|855821|entityMap|0|LINK|mutability|MUTABLE|url|http://www.pearlbells.co.uk/how-to-create-new-categories-and-assigned-products-to-category-programmatically-magento/^0|0|0|0|0|0|3|B|0|0^^$0|@$1|2|3|4|5|6|7|Y|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|Z|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|10|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|11|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|12|8|@]|9|@]|A|$]]|$1|M|3|N|5|6|7|13|8|@]|9|@$O|14|P|15|1|16]]|A|$]]|$1|Q|3|-4|5|6|7|17|8|@]|9|@]|A|$]]]|R|$S|$5|T|U|V|A|$W|X]]]]

We can assign multiple products to the category programmatically using magento scripts. Please create an array of the categories and the select the products based on the custom attribute or field.

<pre><code>$newproducts = $product-&gt;getCollection()-&gt;addAttributeToFilter(array(array('attribute'=&gt;'attribute_label', 'eq'=&gt; 'attribute_id')));
</code></pre>

Loop through the products and assign to category as shown below.

<pre><code>$newCategory = array( $list[0] , $list[$key]); 
foreach ($newproducts as $prod)
{
 $prod-&gt;setCategoryIds(array_merge($prod-&gt;getCategoryIds(), $newCategory));
 $prod-&gt;save();
}
</code></pre>



Please refer <a href="http://www.pearlbells.co.uk/how-to-create-new-categories-and-assigned-products-to-category-programmatically-magento/" rel="nofollow">my tutorial</a> which gives a step by step explanation.

blocks|key|855853|text|为产品分配类别的最佳方式。来自核心代码的引用-+app\code\core\Mage\Catalog\Model\Resource\Category.php|type|unstyled|depth|inlineStyleRanges|entityRanges|data|855854|$write+=+Mage::getSingleton('core/resource')->getConnection('core_write');
$categoryProductTable+=+Mage::getSingleton('core/resource')->getTableName('catalog/category_product');
$productData+=+array();$position=0;
foreach+($_productCollection+as+$product)+{
++++$productData[]+=+array(
++++++++'category_id'+=>+(int)$catId1,
++++++++'product_id'++=>+(int)$product->getId(),
++++++++'position'++++=>+(int)$position
++++);
$productData[]+=+array(
++++++++'category_id'+=>+(int)$catId2,
++++++++'product_id'++=>+(int)$product->getId(),
++++++++'position'++++=>+(int)$position
++++);
}

$write->insertMultiple($categoryProductTable,+$productData);|code-block|syntax|javascript|855855|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

Best way to assign the categories to the products.
Reference from core code - app\code\core\Mage\Catalog\Model\Resource\Category.php
<pre><code>$write = Mage::getSingleton('core/resource')-&gt;getConnection('core_write');
$categoryProductTable = Mage::getSingleton('core/resource')-&gt;getTableName('catalog/category_product');
$productData = array();$position=0;
foreach ($_productCollection as $product) {
 $productData[] = array(
 'category_id' =&gt; (int)$catId1,
 'product_id' =&gt; (int)$product-&gt;getId(),
 'position' =&gt; (int)$position
 );
$productData[] = array(
 'category_id' =&gt; (int)$catId2,
 'product_id' =&gt; (int)$product-&gt;getId(),
 'position' =&gt; (int)$position
 );
}

$write-&gt;insertMultiple($categoryProductTable, $productData);
</code></pre>

I am using Magento 1.4.0.1.
I have over 21000 simple products, each entered into a single category.
There are hundreds of categories in my site.
Some products belong in multiple categories.
Is there some way for me to programmatically add products into multiple categories?

Programmatically add Magento products to categories

我使用的是Magento 1.4.0.1。我有21000多个简单的产品，每个产品都属于一个单独的类别。在我的网站上有数百个类别。有些产品属于多个类别。有没有办法让我以编程方式将产品添加到多个类别中？

问以编程方式将Magento产品添加到类别
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问以编程方式将Magento产品添加到类别EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问以编程方式将Magento产品添加到类别
EN