need a complicated SQL query for setting up a sale

[crbsmith]

Do you want the Retired Products to *only* be in the Retired Category or still in the current categories?

It doesn't matter, as long as they go into the retiring category AND price correctly. From what I read in order for the salemaker to work, they would have to have the master category set = the retirement category

[Ajeh]

If you just need to change the master_categories_id after the Products have been added to the Retired category, go to the Retired Categories and click C for Copy and then the Multiple Categories Link Manager ...

At the bottom of the page, you will see:

Reset ALL Products in the selected Category to use the selected Category as the new Master Categories ID ...
Example: Resetting Category 22 would set ALL Products in Category 22 to use Category 22 as the Master Category ID Reset the Master Categories ID for All Products in Category:

This will change all Products in the categories_id that you enter to use that as the master_categories_id ...

[crbsmith]

that only works if ALL the products are from one master category previously and I am doing that for some designers (manufacturers) whose entire product line is retiring but I am pulling products from multiple designers based on sales performance