blocks|key|3071347|text|您可以尝试以下操作：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3071348|add_action('after_delete_post','wdm_delete_post_images',10,1);

function+wdm_delete_post_images($post_id)
{
+++$featured_image_id+=+get_post_meta($post_id,'_thumbnail_id',true);

+++$image_galleries_id+=+get_post_meta($post_id,'_product_image_gallery',true);

+++if(!empty($featured_image_id))
+++{
+++++wp_delete_post($featured_image_id);
+++}

++if(!empty($image_galleries_id))
++{
++++$image_galleries_array+=+split(',',$image_galleries_id);

++++foreach($image_galleries_array+as+$single_image_id)
++++{
++++++++wp_delete_post($single_image_id);
++++}
++}
}|code-block|syntax|javascript|3071349|当产品被永久删除时，这将删除图像。|3071350|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

you can try the following:

<pre><code>add_action('after_delete_post','wdm_delete_post_images',10,1);

function wdm_delete_post_images($post_id)
{
 $featured_image_id = get_post_meta($post_id,'_thumbnail_id',true);

 $image_galleries_id = get_post_meta($post_id,'_product_image_gallery',true);

 if(!empty($featured_image_id))
 {
 wp_delete_post($featured_image_id);
 }

 if(!empty($image_galleries_id))
 {
 $image_galleries_array = split(',',$image_galleries_id);

 foreach($image_galleries_array as $single_image_id)
 {
 wp_delete_post($single_image_id);
 }
 }
}
</code></pre>

This will delete images when product is permanently deleted.

blocks|key|2151592|text|add_action("before_delete_post","wdm_delete_post_images",10,1);

function+wdm_delete_post_images($post_id)
{
+global+$wpdb;
++++++++++$args+=+array(
++++++++++++++++'post_parent'+=>+$post_id,
++++++++++++++++'post_type'+++=>+'attachment',+
++++++++++++++++'numberposts'+=>+-1,
++++++++++++++++'post_status'+=>+'any'+
++++++++);+
++++++++$childrens+=+get_children(+$args);
++++++++if($childrens):
++++++++++++foreach($childrens+as+$attachment):+++
+++++++++++++wp_delete_attachment(+$attachment->ID,+true+);+
+++++++++++++$wpdb->query("DELETE+FROM+{$wpdb->postmeta}+WHERE+post_id+=+".$attachment->ID);
+++++++++++++wp_delete_post($attachment->ID,true+);+
++++++++++++endforeach;

++++++++endif;
}|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|2151593|unstyled|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|G|8|@]|9|@]|A|$B|C]]|$1|D|3|-4|5|E|7|H|8|@]|9|@]|A|$]]]|F|$]]

<pre><code>add_action("before_delete_post","wdm_delete_post_images",10,1);

function wdm_delete_post_images($post_id)
{
 global $wpdb;
 $args = array(
 'post_parent' =&gt; $post_id,
 'post_type' =&gt; 'attachment', 
 'numberposts' =&gt; -1,
 'post_status' =&gt; 'any' 
 ); 
 $childrens = get_children( $args);
 if($childrens):
 foreach($childrens as $attachment): 
 wp_delete_attachment( $attachment-&gt;ID, true ); 
 $wpdb-&gt;query("DELETE FROM {$wpdb-&gt;postmeta} WHERE post_id = ".$attachment-&gt;ID);
 wp_delete_post($attachment-&gt;ID,true ); 
 endforeach;

 endif;
}
</code></pre>

blocks|key|2157908|text|虽然这是一个古老的问题，但我将把它留在这里，以防将来有人会寻找它。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2157909|由于您想要删除产品图像，您可以尝试使用这些简洁方便的woocommerce函数来获取附件ids。|2157910|如下所示：|2157911|add_action(+'before_delete_post',+'delete_product_images',+10,+1+);

function+delete_product_images(+$post_id+)
{
++++$product+=+wc_get_product(+$post_id+);

++++if+(+!$product+)+{
++++++++return;
++++}

++++$featured_image_id+=+$product->get_image_id();
++++$image_galleries_id+=+$product->get_gallery_image_ids();

++++if(+!empty(+$featured_image_id+)+)+{
++++++++wp_delete_post(+$featured_image_id+);
++++}

++++if(+!empty(+$image_galleries_id+)+)+{
++++++++foreach(+$image_galleries_id+as+$single_image_id+)+{
++++++++++++wp_delete_post(+$single_image_id+);
++++++++}
++++}
}|code-block|syntax|javascript|2157912|对我来说很好。|2157913|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|P|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|Q|8|@]|9|@]|A|$]]|$1|F|3|G|5|H|7|R|8|@]|9|@]|A|$I|J]]|$1|K|3|L|5|6|7|S|8|@]|9|@]|A|$]]|$1|M|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|N|$]]

Although this is an old question, I will leave it here in case someone will be looking for it in the future.

Since you want to delete product images, you may try these neat and handy woocommerce functions to get attachments ids.

Something like this:

<pre><code>add_action( 'before_delete_post', 'delete_product_images', 10, 1 );

function delete_product_images( $post_id )
{
 $product = wc_get_product( $post_id );

 if ( !$product ) {
 return;
 }

 $featured_image_id = $product-&gt;get_image_id();
 $image_galleries_id = $product-&gt;get_gallery_image_ids();

 if( !empty( $featured_image_id ) ) {
 wp_delete_post( $featured_image_id );
 }

 if( !empty( $image_galleries_id ) ) {
 foreach( $image_galleries_id as $single_image_id ) {
 wp_delete_post( $single_image_id );
 }
 }
}
</code></pre>

Works fine for me.

blocks|key|3071389|text|步骤1:登录到您的PhpMyAdmin+%7C如果您有多个数据库，请确保单击了正确的数据库。如果您不确定是因为在同一个域中有多个WordPress安装，请打开一个表并查找“wp_options”，您将能够看到您正在进行更改的网站的网址。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3071390|步骤2:在WP_POST中运行SQL语句==>|3071391|如果您使用的是正确的数据库，请单击右上角的SQL选项卡。它可能是空的，或者有一条来自上一条命令的SQL语句。|3071392|DELETE+relations.*,+taxes.*,+terms.*
FROM+wp_term_relationships+AS+relations
INNER+JOIN+wp_term_taxonomy+AS+taxes
ON+relations.term_taxonomy_id=taxes.term_taxonomy_id
INNER+JOIN+wp_terms+AS+terms
ON+taxes.term_id=terms.term_id
WHERE+object_id+IN+(SELECT+ID+FROM+wp_posts+WHERE+post_type='product');

DELETE+FROM+wp_postmeta+WHERE+post_id+IN+(SELECT+ID+FROM+wp_posts+WHERE+post_type+=+'product');
DELETE+FROM+wp_posts+WHERE+post_type+=+'product';|code-block|syntax|javascript|3071393|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|N|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|O|8|@]|9|@]|A|$]]|$1|F|3|G|5|H|7|P|8|@]|9|@]|A|$I|J]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

Step 1: Login to Your PhpMyAdmin | If you have more than one database, make sure you click on the correct database. If you’re not sure because you have more than one WordPress installation on the same domain, open a table and look for “wp_options”, you’ll be able to see the URL of the website you’re making changes to.

Step 2: Run the SQL Statement ==> in WP_POST

If you are on the correct database, click on the SQL tab on the top right. It might be empty or have an SQL statement there from a previous command.

<pre><code>DELETE relations.*, taxes.*, terms.*
FROM wp_term_relationships AS relations
INNER JOIN wp_term_taxonomy AS taxes
ON relations.term_taxonomy_id=taxes.term_taxonomy_id
INNER JOIN wp_terms AS terms
ON taxes.term_id=terms.term_id
WHERE object_id IN (SELECT ID FROM wp_posts WHERE post_type='product');

DELETE FROM wp_postmeta WHERE post_id IN (SELECT ID FROM wp_posts WHERE post_type = 'product');
DELETE FROM wp_posts WHERE post_type = 'product';
</code></pre>

blocks|key|243783|text|type|unstyled|depth|inlineStyleRanges|entityRanges|data|243784|+尝试一次，删除产品时不再需要任何代码。您可以将此代码添加到一个新文件中，并将其放置在wordpress的根目录下。|blockquote|offset|length|style|BOLD|243785|243786|243787|include('wp-load.php');
++++function+delete_post($sku)
++++{
++++++++global+$wpdb;
++++++++$result_post+=+$wpdb->get_results+(+"SELECT+`ID`+FROM+`wp_posts`+WHERE+`post_name`+LIKE+CONCAT('%25',".$sku.",+'%25')"+);
++++++++++++for($q=0;$q<count($result_post);$q%2B%2B)
++++++++++++{
++++++++++++++++wp_delete_post($result_post[$q]->ID,true);+//+wp_delete_post+full+product+delete+with+its+all+images
++++++++++++}
++++}

++++delete_post($sku);+|code-block|syntax|javascript|243788|entityMap^0|0|1|1L|0|0|0|0^^$0|@$1|2|3|-4|4|5|6|Q|7|@]|8|@]|9|$]]|$1|A|3|B|4|C|6|R|7|@$D|S|E|T|F|G]]|8|@]|9|$]]|$1|H|3|-4|4|5|6|U|7|@]|8|@]|9|$]]|$1|I|3|-4|4|5|6|V|7|@]|8|@]|9|$]]|$1|J|3|K|4|L|6|W|7|@]|8|@]|9|$M|N]]|$1|O|3|-4|4|5|6|X|7|@]|8|@]|9|$]]]|P|$]]

<blockquote>
 Try it one time not need any more code for delete product.
 You can add this code in one new file and place in root directory of wordpress.
</blockquote>

<pre><code>include('wp-load.php');
 function delete_post($sku)
 {
 global $wpdb;
 $result_post = $wpdb-&gt;get_results ( "SELECT `ID` FROM `wp_posts` WHERE `post_name` LIKE CONCAT('%',".$sku.", '%')" );
 for($q=0;$q&lt;count($result_post);$q++)
 {
 wp_delete_post($result_post[$q]-&gt;ID,true); // wp_delete_post full product delete with its all images
 }
 }

 delete_post($sku); 
</code></pre>

I was trying the following:

when a product page gets deleted (permanently), it should also delete the:
product gallery and product image which are attached to the post.

I tried the solution i found on:
<a href="https://wordpress.stackexchange.com/questions/109793/delete-associated-media-upon-page-deletion">https://wordpress.stackexchange.com/questions/109793/delete-associated-media-upon-page-deletion</a>

But it didn't work out for me.

Woocommerce when deleting a product, automatically also delete the product gallery and product image

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

我尝试了以下几种方法：当一个产品页面被删除(永久)时，它也应该删除贴在帖子上的:产品图库和产品图像。我尝试了我在上找到的解决方案但这对我来说并不管用。

问Woocommerce在删除产品时，还会自动删除产品库和产品图片
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问Woocommerce在删除产品时，还会自动删除产品库和产品图片EN