bulk product mover badly needed for catalog management

[igavemybest]

Is there any way to add a check box to all items in the catalog, and move all checked items on a page to a new category? I cant seem to get it to work for me.

[Robbie@FireFold]

I was unable to find this in able. A small missing feature - nice when creating/redoing categories.

In my current software there's an option when you Edit the category called 'Product Selector.' Clicking that takes you to a search box - search by SKU and click a check box beside each item you wish to add. When all you require are checked - click add.

This is something my team and I could REALLY use right now. We have 3700 SKU's. Down to 1600 left to move.

[igavemybest]

Yeah, it is a HUGE missing feature.

[igavemybest]

Does anyone have any suggestions for this?

[Naveed]

Yes, it is a missing feature...
Going to post a new feature request..

[nickc]

You can run update queries against data in the ac_CatalogNodes table.
CAVEAT - I have not tested any of this, so practice on a test db first.

Code: Select all

-- move all products in category @current to category @new

declare @current int
declare @new int
set @current = 0 -- change to Category number you are moving from
set @new = 0 -- change to Category number you are moving to

update ac_CatalogNodes
set CategoryId = @new
where CategoryId = @current and CatalogNodeTypeId = 1
and CatalogNodeId not in
( select CatalogNodeId from ac_CatalogNodes where CategoryId = @new and CatalogNodeTypeId = 1 )

Note the exclusion of moving products already in the target category - you'd have to go back and clean those up later.

[AbleMods]

Larger store catalogs like mine are a complete bear to move products around between categories. Each one has to be done one-at-a-time and there are only so many available teenagers in my neighborhood willing to earn that coveted $10/hour pay rate.

I need a checkbox on the Product Catalog page to work just like how order summary works. I can select multiple products, then use a dropdown to choose what category to move those products into.

Keeping 20,000 products in the right categories is tough the way it is now.

[Naveed]

DataPort can be used for this purpose. Give a try to product CSV Import/Export feature.