WordPress + Woocommerce 把没有主图的产品转移到trash status SQL语句
WordPress + Woocommerce 把没有主图的产品转移到trash status SQL语句
UPDATE wp_posts SET post_status = "trash" WHERE ID NOT IN (
SELECT post_id
FROM wp_postmeta
WHERE meta_key = "_thumbnail_id"
)
AND post_type = 'product';
这个代码好处就是可以批量删除没有主图的产品!