Magento – programmatically assign a product collection to a category

magento-1.8magento-1.9magento-community

I would like to programmatically assign a product collection to a category.
This is my product collection for example

$_productCollection = Mage::getModel('catalog/product')
->getCollection()
->joinField('category_id', 'catalog/category_product', 'category_id', 'product_id = entity_id', null, 'left')
->addAttributeToSelect('*')
->addAttributeToFilter('category_id', array(
        array('finset' => '345'),
        array('finset' => '320')
        )
)
->addAttributeToSort('created_at', 'desc');
$_productCollection->getSelect()->group('e.entity_id');

I want these products to be assigned to a category id. Is it possible?

Best Answer

I will add an answer with the help of the above link i posted.

$collection = Mage::getModel('catalog/product')->getCollection();

foreach ($collection as $product_all) {

    $product_id  =  $product_all['entity_id'];//This will give you the product id

    $product    = Mage::getModel('catalog/product');
    $product ->load($product_id);
    $categories = $product->getCategoryIds();


    $categories[] = 152;//HERE YOU CAN ASSIGN WHATEVER CATEGORY ID YOU WANT TO UPDATE

    $product->setCategoryIds($categories);
    $product->save();
}

Related Solutions

Magento 1.9 – Programmatically Create New Customer and Assign Current Quote

EDIT:

This script works. Tested.

try {
    // create customer 
    $websiteId = Mage::app()->getWebsite()->getId();
    $store = Mage::app()->getStore();
    $firstname = "Firstname";
    $lastname = "Lastname";
    $email = "test@test.com";
    $password = "test123";

    $customer = Mage::getModel("customer/customer");
    $customer->setWebsiteId($websiteId)
             ->setStore($store)
             ->setFirstname($firstname)
             ->setLastname($lastname)
             ->setEmail($email)
             ->setPassword($password);
    $customer->save();

    // set customer as logged in
    $session = Mage::getSingleton('customer/session');
    $session->login($email,$password);

    // quote assign to new customer
    $quoteObj = Mage::getModel('sales/quote');
    $quoteObj->assignCustomer($customer);
    $quoteObj->setStoreId($store->getId());
    $quoteObj->collectTotals();
    $quoteObj->setIsActive(true);
    $quoteObj->save();
} catch (Exception $ex) {
    var_dump($ex->getMessage());
}

Magento – Magento 1.9: How to show instock items first in product listing even after using sorting

Try this, I hope this will solve your problem.

public function setCollection($collection)
    {
        $this->_collection = $collection;
        $this->_collection->setCurPage($this->getCurrentPage());

        // we need to set pagination only if passed value integer and more that 0
        $limit = (int)$this->getLimit();
        if ($limit) {
            $this->_collection->setPageSize($limit);
        }
        if ($this->getCurrentOrder()) {
                $this->_collection->joinField('inventory_in_stock', 'cataloginventory_stock_item', 'is_in_stock', 'product_id=entity_id','is_in_stock>=0', 'left')->setOrder('inventory_in_stock', 'desc');
                $this->_collection->setOrder($this->getCurrentOrder(), $this->getCurrentDirection());
        }
        return $this;
    }

Source : ShowInStockFirst

Best Answer

Related Solutions

Magento 1.9 – Programmatically Create New Customer and Assign Current Quote

Magento – Magento 1.9: How to show instock items first in product listing even after using sorting

Related Topic