Linking Products using a SQL script

[guzzer]

Can anyone help me out

I have loads of items in a store that need to be linked to multiple categories. I have all the cat IDs and product IDs, and was thinking is there a simple sql script that I could run to create the links for me?

I am currently using Zen Cart 1.3.8a

[DrByte]

If you have solid knowledge of MySQL and tools like phpMyAdmin, and all your products have valid master_categories_id set, then you can link the products to other categories by adding records to the products_to_categories table.

Naturally, the safest method is to use the store's admin screen to choose your linking properly.

[guzzer]

Many thanks for the sound advice - I have just found the Multiple Link option in Admin