Magento 1.9 – How to Remove Multiple Assigned Categories from Selected Category

csvdatabasemagento-1.9

I need to remove Multiple Assigned Categories of products remove from selected Category. Eg. Product1 assigned to cat1, cat2, cat3. I need my product remove from the category cat3. How can I do it by CSV or MYSQL

Best Answer

You can do it by creating csv file as below

sku , categories

test1, 1|3

test2 , 2|3

and then you can create file on magento root folder with below code

require_once 'app/Mage.php';
umask(0);
Mage::app();


Mage::app()->setCurrentStore(Mage_Core_Model_App::ADMIN_STORE_ID);


$file = fopen('product_rename1.csv', 'r'); // file path of csv
$all_rows = array();
$header = null;
while ($row = fgetcsv($file)) {
    if ($header === null) {
        $header = $row;
        continue;
    }
    $all_rows[] = array_combine($header, $row);
}
fclose($file);

// above code used to convert csv to array

foreach ($all_rows as $row) {
    $product = Mage::getModel('catalog/product')->loadByAttribute('sku',$row['sku']);
    $categories = explode('|', $row['categories']);
    $product->setCategoryIds($categories);
    $product->save();
}

Related Solutions

Magento – How to display category ,subcategory and image on magento 1.9 on home page

You could do something like this. Add a custom catalog/homecategories.phtml file and add it in your local.xml.

homecategories.phtml

$helper = Mage::helper('catalog/category');
/** @var $helper Mage_Catalog_Helper_Category */

$topCategories = $helper->getStoreCategories(true);
?>

<?php if (!empty($topCategories)): ?>
    <div class="home-categories">

        <ul class="level-1">
            <?php foreach ($topCategories as $topCategory): ?>
                <?php /** @var $topCategory \Mage_Catalog_Model_Category */ ?>
                <li>
                    <a href="<?php echo $helper->getCategoryUrl($topCategory); ?>"><?php echo $topCategory->getName(); ?></a>

                    <?php if ($topCategory->hasChildren()): ?>
                        <ul class="level-2">
                            <?php foreach ($topCategory->getCategories($topCategory, 0, true) as $category): ?>
                                <?php /** @var $category \Mage_Catalog_Model_Category */ ?>
                                <li>
                                    <a href="<?php echo $helper->getCategoryUrl($category); ?>"><?php echo $category->getName(); ?></a>
                                    <a href="<?php echo $helper->getCategoryUrl($category); ?>">
                                        <img src="<?php echo $category->getImageUrl();?>" alt="" />
                                    </a>
                                </li>
                            <?php endforeach; ?>
                        </ul>
                    <?php endif; ?>
                </li>
            <?php endforeach; ?>
        </ul>

    </div>
<?php endif; ?>

<?php

local.xml

<cms_index_index>
    <reference name="content">
        <block type="core/template" name="home-categories" as="home_categories" before="-">
            <action method="setTemplate"><template>catalog/homecategories.phtml</template></action>
        </block>
    </reference>
</cms_index_index>

Magento – CSV Import with multiple categories and commas in category names

This is not how you import multiple categories. The correct way is to add a new line but without sku:

sku,name,_category
1,Product 1,Category1
,,Category2
,,Category3

As long as there is no new SKU, all lines belong to the same product.

Best Answer

Related Solutions

Magento – How to display category ,subcategory and image on magento 1.9 on home page

Magento – CSV Import with multiple categories and commas in category names

Related Topic