Page 1 of 1
Easily move many items to a new category
Posted: Thu Jul 24, 2008 7:52 pm
by 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.
Re: Easily move many items to a new category
Posted: Thu Jul 24, 2008 9:04 pm
by 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.
Re: Easily move many items to a new category
Posted: Thu Jul 24, 2008 9:15 pm
by igavemybest
Yeah, it is a HUGE missing feature.
Re: Easily move many items to a new category
Posted: Thu Jul 24, 2008 10:25 pm
by igavemybest
Does anyone have any suggestions for this?
Re: Easily move many items to a new category
Posted: Fri Jul 25, 2008 9:48 am
by Naveed
Yes, it is a missing feature...
Going to post a new feature request..
Re: Easily move many items to a new category
Posted: Fri Jul 25, 2008 11:17 am
by 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.
bulk product mover badly needed for catalog management
Posted: Sat Oct 11, 2008 5:59 pm
by 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.
Re: bulk product mover badly needed for catalog management
Posted: Fri Oct 24, 2008 12:18 pm
by Naveed
DataPort can be used for this purpose. Give a try to product CSV Import/Export feature.