How do I delete additional images of products (not the cover image) without deleting it manually one by one?

[justine123]

Hi,

So I uploaded wrong images for many products (product ID range of 6154 - 6983) and I wanted to delete the additional images for these products. The cover image for each of these products are correct, it's just that I imported another batch of images but they were wrong. I tried to manually delete them but there are around 800 products. Is there a way to delete them in the database?

[Ali Samie]

search for Image.php class and find out how it deletes images with id_product. Then create a dummy mdoule, add a front controller and run the script with id_product range

[lordignus]

Something like this should do the trick...

$product_id_min = 6154;
$product_id_max = 6983;
$id_lang_default = Configuration::get('PS_LANG_DEFAULT');
for($i = $product_id_min; $i <= $product_id_max; $i++)
{
	$product = new Product($i);
	$images = $product->getImages($id_lang_default);
	foreach($images as $image){
		if($image['cover'] == 1){
			continue;
		}
		$obj_image = new Image($image['id_image']);
		$obj_image->delete();
	}
}

 

[Ali Samie]

you can also try using the entityManager

https://devdocs.prestashop.com/1.7/modules/concepts/doctrine/