bulk product mover badly needed for catalog management
- igavemybest
- Captain (CAPT)
- Posts: 388
- Joined: Sun Apr 06, 2008 5:47 pm
Easily move many items to a new category
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.
-
- Commodore (COMO)
- Posts: 433
- Joined: Wed May 28, 2008 9:42 am
- Location: Concord, NC
- Contact:
Re: Easily move many items to a new category
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.
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
- Captain (CAPT)
- Posts: 388
- Joined: Sun Apr 06, 2008 5:47 pm
Re: Easily move many items to a new category
Yeah, it is a HUGE missing feature.
- igavemybest
- Captain (CAPT)
- Posts: 388
- Joined: Sun Apr 06, 2008 5:47 pm
Re: Easily move many items to a new category
Does anyone have any suggestions for this?
Re: Easily move many items to a new category
Yes, it is a missing feature...
Going to post a new feature request..
Going to post a new feature request..
Thanks for your support
Naveed Ashraf
.com
AbleCommerce Help Center
AbleCommerce Developer WIKI
Follow us on Twitter
Naveed Ashraf
.com
AbleCommerce Help Center
AbleCommerce Developer WIKI
Follow us on Twitter
Re: Easily move many items to a new category
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.
Note the exclusion of moving products already in the target category - you'd have to go back and clean those up later.
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 )
Nick Cole
http://www.ethofy.com
http://www.ethofy.com
bulk product mover badly needed for catalog management
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.
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.
Joe Payne
AbleCommerce Custom Programming and Modules http://www.AbleMods.com/
AbleCommerce Hosting http://www.AbleModsHosting.com/
Precise Fishing and Hunting Time Tables http://www.Solunar.com
AbleCommerce Custom Programming and Modules http://www.AbleMods.com/
AbleCommerce Hosting http://www.AbleModsHosting.com/
Precise Fishing and Hunting Time Tables http://www.Solunar.com
Re: bulk product mover badly needed for catalog management
DataPort can be used for this purpose. Give a try to product CSV Import/Export feature.
Thanks for your support
Naveed Ashraf
.com
AbleCommerce Help Center
AbleCommerce Developer WIKI
Follow us on Twitter
Naveed Ashraf
.com
AbleCommerce Help Center
AbleCommerce Developer WIKI
Follow us on Twitter