Category Mistake

[VainStudios]

I made a huge mistake of entering all of a companies inventory into the Master category. Is there anyway of copying the master categories database, then deleting the contents of the master category and creating subcategories and pasting the database in one of the new subcagtegories?

All help is greatly appreciated,
-Patrick

[Ajeh]

Do you mean you added Products immediately when you went to Catalog ... Category/Products?

[VainStudios]

Yes. I started to add products as soon as I opened the catalog. Without catagories.
Any suggestions?

All help is greatly appriciated,
-Patrick

[Ajeh]

You could manually add a category, category_description and change the products_to_categories table from categories_id 0 to match the value you manually added via phpMyAdmin ...

Backup your database before attempting this ...

INSERT INTO `categories` ( `categories_id` , `categories_image` , `parent_id` , `sort_order` , `date_added` , `last_modified` , `categories_status` )
VALUES (
1, NULL , '0', NULL , NULL , NULL , '1'
);

 INSERT INTO `categories_description` ( `categories_id` , `language_id` , `categories_name` , `categories_description` )
VALUES (
'1', '1', 'TEMPORARY', ''
);

UPDATE products_to_categories set categories_id=1; 

Then go to the Tools ... Store Manager ... and run the Update Master Categories ID ...

Then run the Update Products Price Sorter ...