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 ...

[philip937]

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 ...

you got it, thats what I need, but I need to know what / where the defaukt query is?

[Ajeh]

Start with the file:
/admin/products_to_categories.php

locate where the current code is to:

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

that is stored in the constant:
TEXT_INFO_COPY_ALL_PRODUCTS_TO_CATEGORY_LINKED

You then need to add something like a dropdown for the Manufacturer with a default for ALL ...

Then follow the code to customize the code for that new feature ... it appears to be using the action:
copy_categories_products_to_another_category_linked

find that case and see how the current SELECT statement is made and how you can add in a manufacturers_id into it ...

[torvista]

If I wanted this feature, I would speak to the guy who coded this mod for me:
Multiple Categories Link Manager (which I think should be core as its so great!!!)

http://www.zen-cart.com/index.php?ma...oducts_id=1854


[FONT=&quot]
[/FONT]