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