Forums / Setting Up Categories, Products, Attributes / Need to put multiple products into one category

Need to put multiple products into one category

Locked

Views: 1,379

Results 1 to 4 of 4
This thread is locked. New replies are disabled.
25 Feb 2008, 4:50 PM
#1
gressi avatar

gressi

New Zenner

Join Date:
Feb 2008
Posts:
7
Plugin Contributions:
0

Need to put multiple products into one category

Hi there, I need help because there's something that I am missing.

I want to put multiple products from various different categories into one new category. Either by linking or coping them but not one at a time.

When I do a search from the admin. Panel for radio controled trucks, I find 197 of them, I want to put them into a new category called Radio Controled Trucks.

I can link them one by one in the product, but I was wondering if there is a way to do it in Mass operation?

See the products are classed by manufacturer and not by usage, so I need to get all the products that are radio Controled trucks from all the different manufacturers into a top category called radio controled trucks and so on with my other products. So I need to link/copy all these products in mass from where they are to a new top category.

Thank you.

25 Feb 2008, 6:24 PM
#2
kobra avatar

kobra

Black Belt

Join Date:
Aug 2005
Location:
Arizona
Posts:
31,500
Plugin Contributions:
4

Re: Need to put multiple products into one category

There is nothing in the admin to do this...

You will need to educate yourself on mysql and determine what there is that is common to all of these but unique from all others.

Finding that you can create a sql that selects where ??? whatever is the common record.

Barring that there is something common to select on this will be a manual operation.

You might look at easy populate that can export this to a csv file and you might expedite the manual function through using the excel functions

Zen-Venom Get Bitten

25 Feb 2008, 6:33 PM
#3
schoolboy avatar

schoolboy

Totally Zenned

Join Date:
Jun 2005
Location:
Cumbria, UK
Posts:
10,327
Plugin Contributions:
0

Re: Need to put multiple products into one category

Kobra is absolutely right. All I can add is that the Easypopulate route is much easier for those of us not too familiar with My SQL.

There is no "simple/quick" solution to your task - but I have had lots of success using Excel/Easypopulate to speed up processes where hundreds (and in some cases thousands) of products are concerned.

20 years a Zencart User

26 Feb 2008, 9:15 PM
#4
gressi avatar

gressi

New Zenner

Join Date:
Feb 2008
Posts:
7
Plugin Contributions:
0

Re: Need to put multiple products into one category

Thanks guys, very helpfull. Easypopulate here I come :clap: