title: Woocommerce switch tag to category and category to tag on products
body: <p>I need help with woocommerce in wordpress. I have 2000 products in store, each of them has several tags and several categories. Unfortunately I need to switch them and doing it manually would be the hell. I have found, that there might be a solution for that via phpmyadmin.</p>
  
  <ol>
  <li>Query to rename product_cat to temp</li>
  <li>Query to rename product_tag to product_cat</li>
  <li>Query to rename temp to product_tag
  All in the wp_term_taxonomy table.</li>
  </ol>
  
  <p>Could you please help me with that or do you have more elegant solution? I have no knowledge of sql and queries, but if you simplify it step by step, I am able to understand what is neccessary to be done :) </p>
  
  <p>Many thanks</p>