You can edit the products table of your database in phpMyAdmin which you should have access to via your Control Panel for your domain ...
If you just want to change ALL Products to be the same Product Type or a specific Category, where the Products all use the same master_categories_id then there are SQL commands that can be run ...
Example, if you wanted to make the Category of Products in categories_id 22 where all of those Products use master_categories_id 22 and change the products_type to 3, you could:
1 Backup your database
2 Then, run the following SQL command in the Tools ... Install SQL Patches ...
Code:
UPDATE products SET products_type = 3 WHERE master_categories_id = 22;
just set the 22 to the actual categories_id for these Products ...
NOTE: if these Products do not use the same categories_id as the master_categories_id, then this will not work for you ...
Bookmarks