I have duplicate product categories - they share the same name but different slugs eg., The category 'Adhesives' has a slug of "adhesives" but since updating my products via CSV import, there is now also a category named "Adhesives" with slug of "adhesives-2" which the updated products have been moved to.
I am aware plugins exist which allow you to do this per category but I have over 1500 categories.
Is there a MySQL query that will merge all categories with the same name (disregarding the slugs)? And/or another method of doing this?
Thanks in advance, Michael