我有1500多种没有特色图片的产品。我必须删除它。我找到一个查询来获取此产品的列表:
select ID FROM wp_posts WHERE ID NOT IN (select post_id from wp_postmeta WHERE meta_key="_thumbnail_id") AND post_type="product"
我发现了这个插件https://pl.wordpress.org/plugins/woocommerce-products-without-featured-images/,但是我无法从中删除产品...
两者都做同一件事
您能提示我如何删除这些产品吗?
这是两个查询...它将正常工作...
基本上,这些查询仅用于删除woocomerce产品。
DELETE FROM wp_postmeta
WHERE post_id IN(SELECT ID FROM wp_posts WHERE ID NOT IN (select post_id from wp_postmeta WHERE meta_key="_thumbnail_id") AND post_type = 'product');
DELETE FROM wp_posts WHERE ID NOT IN (select post_id from wp_postmeta WHERE meta_key="_thumbnail_id") AND post_type = 'product';
本文收集自互联网,转载请注明来源。
如有侵权,请联系 [email protected] 删除。
我来说两句