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


You can try using Term Management plugin. You can use it to bulk merge your duplicate categories into one. Follow these steps:

  1. Install and activate the plugin.
  2. Go to Posts > Categories.
  3. Select the categories that you want to merge. Then select the merge option from the bulk option.
  4. Type the name to which you want to merge these categories. Finally, click on the Apply button.
  • Hi, thanks for your reply. I am aware plugins like this exist but I have over 1500 categories so this isn't a viable option. – Michael Elliott Jan 20 at 22:12

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.