<\/p>\n\n\n\n
\nWe have tested the queries below in :\n\n<\/p>\n\n\n\n
WooCommerce version: 3.5.7
WordPress version: 5.1.1
( Use at own risk )<\/p>\n\n\n\n
<\/p>\n\n\n\n
=======================<\/p>\n\n\n\n
DELETE FROM wp_woocommerce_order_itemmeta;
\nDELETE FROM wp_woocommerce_order_items;
\nDELETE FROM wp_comments WHERE comment_type = 'order_note';
\nDELETE FROM wp_postmeta WHERE post_id IN ( SELECT ID FROM wp_posts WHERE post_type = 'shop_order' );
\nDELETE FROM wp_posts WHERE post_type = 'shop_order';<\/pre>\n\n\n\n==========================<\/p>\n\n\n\n
delete all products<\/h3>\n\n\n\n
DELETE relations., taxes.<\/em>, terms.*
\nFROM wp_term_relationships AS relations
\nINNER JOIN wp_term_taxonomy AS taxes
\nON relations.term_taxonomy_id=taxes.term_taxonomy_id
\nINNER JOIN wp_terms AS terms
\nON taxes.term_id=terms.term_id
\nWHERE object_id IN (SELECT ID FROM wp_posts WHERE post_type='product');
\nDELETE FROM wp_postmeta WHERE post_id IN (SELECT ID FROM wp_posts WHERE post_type = 'product');
\nDELETE FROM wp_posts WHERE post_type = 'product';<\/pre>\n\n\n\n==========================<\/p>\n\n\n\n
Remove all attributes from WooCommerce<\/h3>\n\n\n\n
DELETE FROM wp_terms WHERE term_id IN (SELECT term_id FROM wp_term_taxonomy WHERE taxonomy LIKE 'pa_%');
DELETE FROM wp_term_taxonomy WHERE taxonomy LIKE 'pa_%';
DELETE FROM wp_term_relationships WHERE term_taxonomy_id not IN (SELECT term_taxonomy_id FROM wp_term_taxonomy);<\/pre>\n\n\n\n==========================<\/p>\n\n\n\n
Delete all WooCommerce products (2)<\/h3>\n\n\n\n
DELETE FROM wp_term_relationships WHERE object_id IN (SELECT ID FROM wp_posts WHERE post_type IN ('product','product_variation'));
\nDELETE FROM wp_postmeta WHERE post_id IN (SELECT ID FROM wp_posts WHERE post_type IN ('product','product_variation'));
\nDELETE FROM wp_posts WHERE post_type IN ('product','product_variation');<\/pre>\n\n\n\n==========================<\/p>\n\n\n\n
Delete orphaned postmeta<\/h3>\n\n\n\n
DELETE pm
\nFROM wp_postmeta pm
\nLEFT JOIN wp_posts wp ON wp.ID = pm.post_id
\nWHERE wp.ID IS NULL;<\/pre>\n\n\n\n==========================<\/p>\n\n\n\n
delete all categories<\/h3>\n\n\n\n
DELETE a,c FROM wp_terms AS a
\nLEFT JOIN wp_term_taxonomy AS c ON a.term_id = c.term_id
\nLEFT JOIN wp_term_relationships AS b ON b.term_taxonomy_id = c.term_taxonomy_id
\nWHERE c.taxonomy = 'product_tag';<\/pre>\n\n\n\nDELETE a,c FROM wp_terms AS a
\nLEFT JOIN wp_term_taxonomy AS c ON a.term_id = c.term_id
\nLEFT JOIN wp_term_relationships AS b ON b.term_taxonomy_id = c.term_taxonomy_id
\nWHERE c.taxonomy = 'product_cat';<\/pre>\n\n\n\n==========================<\/p>\n\n\n\n
Delete alle WooCommerce customers \/ Users<\/h3>\n\n\n\n
You Can delete alle WooCommerce customers \/ users with this plugin :<\/p>\n\n\n\n
Bulk Delete<\/a><\/blockquote>