title: Remove Woocommerce products but keep categories
body: <p>I have a Wordpress site which runs using the Woocommerce plugin. I have a large number of products that I need to remove, unfortunately doing this through the Wordpress backend is a very time consuming and frustration process.</p>
  
  <p>I have been looking for a way to remove the products through phpMyAdmin and have found the following</p>
  
  <pre><code>DELETE relations.*, taxes.*, terms.*
  FROM wp_term_relationships AS relations
  INNER JOIN wp_term_taxonomy AS taxes
  ON relations.term_taxonomy_id=taxes.term_taxonomy_id
  INNER JOIN wp_terms AS terms
  ON taxes.term_id=terms.term_id
  WHERE object_id IN (SELECT ID FROM wp_posts WHERE post_type='product');
  
  DELETE FROM wp_postmeta WHERE post_id IN (SELECT ID FROM wp_posts WHERE post_type = 'product');
  DELETE FROM wp_posts WHERE post_type = 'product';
  </code></pre>
  
  <p>This works great, accept it also removes the product categories which I would like to keep.</p>
  
  <p>Is there a way to remove all woocommerce products but keep the categories using SQL?</p>
  
  <p>Thanks</p>