6

I need to change the category from a couple of products. The products I need to change are all from one category, but it's not possible to sort by category on catalog -> manage products, is it? On catalog -> manage categories it's possible to view all products from a certain category but you can't edit them, can you?

Greetings

Improve this question
1
  • Some kind of bulk administration like in moodle would also be very helpful. Like add all product from category x to category y.
    – Wipster
    Commented May 28, 2013 at 8:16

2 Answers 2

Reset to default
3

You can add category filter in manage products page to sort your product, you can do it manually just add one column category on product grid.

Here is a nice answer of adding category column in product grid https://stackoverflow.com/questions/3472702/add-categories-column-to-the-product-grid-in-magento-admin

Just put below code in your Grid.php file 

     $collection = Mage::getModel('catalog/category')->getCollection()->addAttributeToSelect('name');
$options = array();
foreach ($collection as $item){
    if($item->getId() != ''){
    $options[$item->getId()] = $item->getName();
}
}

$this->addColumn('category_ids',
        array(
            'header'   => Mage::helper('catalog')->__('Categories'),
            'index'    => 'single_category_id',
            'width'    => '150px',
            'type' => 'options',
             'options'  => $options
));

Or else you can use free extension which are available to add extra grid in your manage product grid.

This will add extra category column in grid and you are able to sort your product according to category.

http://www.magentocommerce.com/magento-connect/enhanced-admin-product-grid.html http://www.magentocommerce.com/magento-connect/enhanced-admin-grids-editor.html

Improve this answer
8
  • Thanks! How do I add the column to the product grid?
    – Wipster
    Commented May 28, 2013 at 8:59
  • You can find it on extension magento connect page, generally you can set it from system->configuration area
    – Mufaddal
    Commented May 28, 2013 at 9:02
  • I don't want an extension. I just want that additional column "category" for the filter in "manage products". It doesn't matter if it's the id or the name of the category. I found this with google search: magentocommerce.com/boards/viewthread/58377 Unfortunately it's from 2009 and I get a security warning when adding it to the Grid.php. But looks like the right way? Would this get overwritten when updating magento?
    – Wipster
    Commented May 28, 2013 at 9:32
  • Yes it will overwritten when updating magento, just extend Grid.php file in local.
    – Mufaddal
    Commented May 28, 2013 at 9:39
  • Updated My answer
    – Mufaddal
    Commented May 28, 2013 at 9:53
1

Thanks for this post. Spent some time figuring this out, evetually i did, but spent few hours. Then my client told me to try out some Magento addon, called Magento store manager, and you know what ? This task was done in 30 minutes...guys i hope this will help someone. Thanks again

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.