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.
I have been looking for a way to remove the products through phpMyAdmin and have found the following
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';
This works great, accept it also removes the product categories which I would like to keep.
Is there a way to remove all woocommerce products but keep the categories using SQL?
Thanks