Product Linking Via MySQL

[DiZZ]

Hi All,

In my auto parts ZC shop I currently have 450 products listed under categories such as 'Acura, Audi, Bentley, etc.' that allow the user to browse the products by auto type.

I also have a set of categories such as 'Floor Mats, Grilles, Shades, etc.' that I would like to link the appropriate products to. However, using the admin area's Copy/Link function to update the settings for 450 products is going to be very tedious, so I am looking for a way to make this change via MySQL!

It seems to me that I should be able to run an INSERT/UPDATE query that would assign the product_id's to the additional category_id's. In the 'products_to_categories' table it looks like there are only two columns, the product ID and master category ID - is there another place where I can link the product id's to another category ID (to replicate the product linking function)?

My goal is to save time, hopefully there is a way to do so!

[DiZZ]

Also, I noticed in the Multiple Categories Link Manager, the other set of categories are not appearing in the list, and I'm afraid this is due to the current category structure:

Browse Auto Type
- Acura
- Audi
- BMW (and so on)


Browse Product Type
- Floor Mat
- Auto Shade
- Billet Grille (and so on)

Is there a way to link products across categories like this? Or is my structure preventing this?

[DrByte]

The cross-linking is done via the products_to_categories table.