How do I merge WooCommerce categories with the same name?

Question

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

0
, , Michael Elliott 2 years 2019-12-31T08:38:41-05:00 0 Answers 141 views 0

Leave an answer

Browse
Browse