If its only a few products, you should use the MOVE PRODUCT button:-
admin>>>catalog>>>Categories/Products...
... navigate to the product that is in the wrong category and click the little blue circle icon with "M" in it. Move to desired category.
When "faulty" category is empty, delete it.
If there are a LOT of products...
-
Make a COPY your original Easy Populate spreadsheet (the one with the category name errors). Call it anything you like, as long as you know it's the copy of the original.
-
From the copied spreadsheet, delete (remove from spreadsheet) ALL products that are OKAY. So you are left only with the products with faulty category names.
-
In the column "v_status", set the value to 9 for all the faulty products.
-
Save this spreadsheet as a Tab-delimited TXT file and run it through EasyPopulate.
-
This will DELETE all the products in the faulty categories, so (if you did it correctly) those faulty categories will now be empty.
-
Now... on the same COPY of the spreadsheet (the one with the faulty categories), fix up all the category names so that they reference the categories you wanted in the first place.
-
In the column "v_status", set the value to 1 for all the products.
-
Save the file as tab delimited txt and run that file through Easy Populate.
-
The products will be re-added to the site - this time in their correct locations.
-
The "faulty" categories can be deleted from your shop admin panel.
NB: There are reports that "v_status = 9" may delete the products from the database AND remove their images from the images folder - so you may want to create a backup of your images folder.
It's also a good idea, when you're finished with this, to run some of the "update" functions in admin>>>tools>>>store manager. And to run the "Optimize Database" function as well (also on store manager screen.)
