Edit Woocommerce Attributes: "You need a higher level of permission" error

If you're trying to edit Categories/Custom taxonomies and you get this error, you should be doing the following.

  1. Check the wp_term_taxonomy table for Term IDs that are associated with more than one Taxonomy ID. These records are the root cause for the error. The following query should help you find that.
  2. SELECT term_id, COUNT(term_id) FROM wp_term_taxonomy GROUP BY term_id HAVING COUNT(term_id) > 1;
  3. Check for the taxonomy column in the wp_term_taxonomy table that you would like to retain and delete the other taxonomy record.
  4. You should also be deleting records from wp_term_relationships table for the corresponding term_taxonomy_id that you're deleting from the wp_term_taxonomy table. Tip: Back up your database before executing any DELETE queries on your database.