🗑️ woocommerce 清空所有商品和分类的命令

— 禁用外键约束
SET FOREIGN_KEY_CHECKS = 0;

— 1. 删除所有商品变体
DELETE FROM wp_posts WHERE post_type = ‘product_variation’;

— 2. 删除所有商品
DELETE FROM wp_posts WHERE post_type = ‘product’;

— 3. 删除商品分类（product_cat）
DELETE FROM wp_term_relationships WHERE term_taxonomy_id IN (
SELECT term_taxonomy_id FROM wp_term_taxonomy WHERE taxonomy = ‘product_cat’
);
DELETE FROM wp_term_taxonomy WHERE taxonomy = ‘product_cat’;
DELETE FROM wp_terms WHERE term_id NOT IN (
SELECT term_id FROM wp_term_taxonomy
);

— 4. 删除商品标签（product_tag）
DELETE FROM wp_term_relationships WHERE term_taxonomy_id IN (
SELECT term_taxonomy_id FROM wp_term_taxonomy WHERE taxonomy = ‘product_tag’
);
DELETE FROM wp_term_taxonomy WHERE taxonomy = ‘product_tag’;
DELETE FROM wp_terms WHERE term_id NOT IN (
SELECT term_id FROM wp_term_taxonomy
);

— 5. 删除自定义属性分类（pa_开头）
DELETE FROM wp_term_relationships WHERE term_taxonomy_id IN (
SELECT term_taxonomy_id FROM wp_term_taxonomy
WHERE taxonomy LIKE ‘pa_%’
);
DELETE FROM wp_term_taxonomy WHERE taxonomy LIKE ‘pa_%’;
DELETE FROM wp_terms WHERE term_id NOT IN (
SELECT term_id FROM wp_term_taxonomy
);

— 6. 清理孤立数据
— 清理商品元数据
DELETE FROM wp_postmeta WHERE post_id NOT IN (SELECT ID FROM wp_posts);

— 清理分类元数据（如果有）
DELETE FROM wp_termmeta WHERE term_id NOT IN (SELECT term_id FROM wp_terms);

— 7. 清空WooCommerce相关表
TRUNCATE TABLE wp_wc_product_meta_lookup;
TRUNCATE TABLE wp_wc_product_attributes_lookup; — WooCommerce 6.3+
TRUNCATE TABLE wp_wc_product_download_directories; — 下载目录
DELETE FROM wp_wc_category_lookup; — 分类查询表

— 8. 重置自增ID
ALTER TABLE wp_posts AUTO_INCREMENT = 1;
ALTER TABLE wp_postmeta AUTO_INCREMENT = 1;
ALTER TABLE wp_terms AUTO_INCREMENT = 1;
ALTER TABLE wp_term_taxonomy AUTO_INCREMENT = 1;
ALTER TABLE wp_term_relationships AUTO_INCREMENT = 1;

— 启用外键约束
SET FOREIGN_KEY_CHECKS = 1;