mikaelz · November 22, 2024 14:08 · BeshoyAtef · Nov 1, 2023 · shoaibmodel · Jul 28, 2024
diff --git a/delete-all-woocommerce-products.php b/delete-all-woocommerce-products.php
 <?php

 require dirname(__FILE__).'/wp-blog-header.php';

 $wpdb->query("DELETE FROM wp_terms WHERE term_id IN (SELECT term_id FROM wp_term_taxonomy WHERE taxonomy LIKE 'pa_%')");
 $wpdb->query("DELETE FROM wp_term_taxonomy WHERE taxonomy LIKE 'pa_%'");
 $wpdb->query("DELETE FROM wp_term_relationships WHERE term_taxonomy_id not IN (SELECT term_taxonomy_id FROM wp_term_taxonomy)");
 $wpdb->query("DELETE FROM wp_term_relationships WHERE object_id IN (SELECT ID FROM wp_posts WHERE post_type IN ('product','product_variation'))");
 $wpdb->query("DELETE FROM wp_postmeta WHERE post_id IN (SELECT ID FROM wp_posts WHERE post_type IN ('product','product_variation'))");
 $wpdb->query("DELETE FROM wp_posts WHERE post_type IN ('product','product_variation')");
 $wpdb->query("DELETE pm FROM wp_postmeta pm LEFT JOIN wp_posts wp ON wp.ID = pm.post_id WHERE wp.ID IS NULL");
diff --git a/delete-all-woocommerce-products.sql b/delete-all-woocommerce-products.sql
 -- Remove all attributes from WooCommerce
 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);
 -- Delete all WooCommerce products
 DELETE FROM wp_term_relationships WHERE object_id IN (SELECT ID FROM wp_posts WHERE post_type IN ('product','product_variation'));
 DELETE FROM wp_postmeta WHERE post_id IN (SELECT ID FROM wp_posts WHERE post_type IN ('product','product_variation'));
 DELETE FROM wp_posts WHERE post_type IN ('product','product_variation');
 -- Delete orphaned postmeta
 DELETE pm
 FROM wp_postmeta pm
 LEFT JOIN wp_posts wp ON wp.ID = pm.post_id
 WHERE wp.ID IS NULL