mass copy items (linked)

[kitcorsa]

i want to mass copy (link) products from one catogary to another, whats, is there a quick way to do this as i have about 50 a week to link for clearance items.

[svakanda]

Kitcorsa, is there anything particular about the items that you could use to write a sql query to select them out of the rest of your products? Assuming there are also products you DON"T want to copy. That would be the most reliable way to do it...although perhaps not immediately the easiest as you'd have a bit of learning to do.

[kitcorsa]

yeah its all the products from one category need copying to another, but linked copy not duplicated.