You could try this trick ...
Backup your database ...
Run this in the Install SQL Patches ...
Code:
UPDATE products_to_categories SET categories_id = 2;
UPDATE products SET master_categories_id = 2;
Then go to the Categlog ... Categories/Products ... and make a new Category ...
If the categories_id is 2, the Products will all show up in there ...
If the categories_id is another value, run the UPDATES with that value in the Install SQL Patches ... and the Products will move into that new Category and you can then add your new Categories and move the Products to their proper Categories as needed ...
Bookmarks