Help Linking Products

[philip937]

Hi All,

Can anyone tell me a simple db query I could run to link all products with two specific manufactuers id's to one new category I want to create?

cheers

Phil

[philip937]

looking at multiple categories manager, what I want to do is similar to the built in global facility:

"Copy ALL Products in a Category as LINKED Products to another Category"

however I need to do the following:

Copy ALL Products in a Category (WHERE MANUFACTURES ID is equal to X) as LINKED Products to another Category

hope that makes sense

[Ajeh]

That is not a built in feature for the Copy method ...

[philip937]

That is not a built in feature for the Copy method ...

not iwith only selecting products with specific manufacturers...

[philip937]

not iwith only selecting products with specific manufacturers...

sorry misread you reply.

I know its not a built in method, which is why I am after an sql query I can run to do it..

thanks

[Ajeh]

You could customize the code further to check for a manufacturers_id and that would limit the Products to just those in the Category and with the manufacturers_id that you want to select ...

You could write it to default to all manufacturers_id or when 1 is selected to only use those ...