Posting in the Magento forums has been disabled pending the implementation of a new and improved forum solution which should better serve the community.

For new questions please post at magento.stackexchange.com, the community-run support site for the Magento community. We will be providing updates on the new forum solution soon. For questions or concerns please email community@magento.com.

Magento Forum

How can modify mass products in a category? 
 
theleaves
Jr. Member
 
Total Posts:  19
Joined:  2011-09-14
 

1 - I moved all products from a category to another category.
2 - I want to change the price of all products in the new category but I have to modify individual product by hand.

Is there any way to sort all products belong to a category and then modify all of them?

Please, give me your suggestions.

Thank you in advance!

 
Magento Community Magento Community
Magento Community
Magento Community
 
Amasty
Mentor
 
Avatar
Total Posts:  3988
Joined:  2009-11-10
 

Hi!
Mass Product Actions Extension allows you to increase and/or decrease prices and special prices for large numbers of products in just a few clicks.
Also you can assign and remove categories quickly, use Relate’, ‘Up-sell’ and ‘Cross-sell’ actions, copy product information easily (’Copy attributes’, ‘Copy custom options’, ‘Copy images’), etc.

For more details, user guide and live demo follow the link http://amasty.com/mass-product-actions.html

 
Magento Community Magento Community
Magento Community
Magento Community
 
theleaves
Jr. Member
 
Total Posts:  19
Joined:  2011-09-14
 
Amasty - 29 March 2013 07:32 AM

Hi!
Mass Product Actions Extension allows you to increase and/or decrease prices and special prices for large numbers of products in just a few clicks.
Also you can assign and remove categories quickly, use Relate’, ‘Up-sell’ and ‘Cross-sell’ actions, copy product information easily (’Copy attributes’, ‘Copy custom options’, ‘Copy images’), etc.

For more details, user guide and live demo follow the link http://amasty.com/mass-product-actions.html

I’ve checked this extension but there is no option to sort products by category.

 
Magento Community Magento Community
Magento Community
Magento Community
 
Amasty
Mentor
 
Avatar
Total Posts:  3988
Joined:  2009-11-10
 

The module allows to change category (1 question). If you want to sort products by categories you can do it with Extended Product Grid with Editor Extension.

See the live demo and user guide here http://amasty.com/extended-product-grid.html

 
Magento Community Magento Community
Magento Community
Magento Community
 
Store_Manager
Enthusiast
 
Avatar
Total Posts:  867
Joined:  2012-07-09
 

Hello,

You can also try Multi-Editor tool of Store Manager for Magento. Using it you can sort products by selected category and change product details in bulk, including prices, status, visibility and inventory level.
In any case, there is free 2-weeks fully-functional version you can download and try out -
http://www.magentocommerce.com/magento-connect/store-manager-for-magento.html

 
Magento Community Magento Community
Magento Community
Magento Community
 
shon_munshower
Jr. Member
 
Total Posts:  4
Joined:  2013-09-11
 

You can enhance your mageto by using extensions. I have experience by using all listened below extension during 3 years of runing our website:

* Advanced Admin Products Manager
This extension extend product grid with other any products attributes. It allow you to select any products attributes (such as name, prices, sku, categories etc.) which will appear as editable columns in product grid, it mean, that extension convert it into editable grid as Excel and you are able to edit all data right in the products grid - including any prices (price, cost, msrp, special price etc. and allow add/deduct prices by fixed value or by percentage), categories ids (add/remove/change) it mean assign/unassign products to any categories. After edit it allow you perform bulk update in one click. Additionally it allow you to sorting/filter product grid by any products attributes including categories ids, so you can detect which products assign to which categories or detect not assigned products and update it right it the product grid.

If cost is core metter to purchase extension, here is lower cost extensions which allow solve your task, but it is not so agile as Advanced Admin Products Manager:

* Mass Products Categories Updater
The idea is same as for Advaned Admin Products Manager, but it allow you only update assignments of products to categories. It add categories ids column into product grid and allow you edit data right in the product grid and perform bulk update in one click.

* Mass Prices Updater
The idea is same as for Advaned Admin Products Manager, but it allow you only update price, cost, msrp, special prices of products. It add product prices as columns into product grid and allow you edit prices right in the product grid and perform bulk update in one click. Additionally it allow you update prices by additing/deducting fixed value or adding/deducting value in percentage to price column.

 
Magento Community Magento Community
Magento Community
Magento Community
 
nu_cuoi_battu
Jr. Member
 
Total Posts:  2
Joined:  2013-05-20
 

YOu may read this thread
http://www.magentocommerce.com/boards/viewthread/5329/
___________________________________________________________
Click here for more magento tutorial

 
Magento Community Magento Community
Magento Community
Magento Community
 
nilavacins
Jr. Member
 
Total Posts:  7
Joined:  2011-11-10
 

Hi,

If you see the Magento Database. Then there is an table ‘ catalog_category_product ‘ . In this table, Magento manage category wise product.
There is three coloumn ‘category_id ‘ , ‘product_id ‘, and ‘position’.

Now at first you go to the category section and click on your new category. You found “ New Category (ID: category_id) “.
And you run the below query on ‘ catalog_category_product ‘ table.

update `catalog_category_product` set `category_id` = ‘your_category_id’ WHERE `product_id` = ‘your_product_id’

Thanks,
Nilava

 
Magento Community Magento Community
Magento Community
Magento Community
 
MageBright
Sr. Member
 
Avatar
Total Posts:  100
Joined:  2011-11-21
 

Check It someone help this

http://www.magentocommerce.com/magento-connect/attribute-manager-1.html

http://www.magebright.com/attribute-manager.html

Thank you

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
Back to top