Magento 1.9.2. - Delete all second images of the products

Question

During an import of all the new products in the "media gallery" section of each product, a second image path has been added for error.
I want to avoid manually deleting all the second images of each product. Is there a way to automatically delete all the second images of each product without touching the main image with "order: 1"?

Thanks for any help

Answer 1

I haven't tested this, but I imagine something like this would work.

$collection = Mage::getModel('catalog/product')->getCollection();
$mediaApi = Mage::getModel("catalog/product_attribute_media_api");

foreach($collection as $product) {
    $product = Mage::getModel('catalog/product')->load($product->getId());
    $entityTypeId = $product->getEntityTypeId();
    $mediaGalleryAttribute = Mage::getModel('catalog/resource_eav_attribute')->loadByCode($entityTypeId, 'media_gallery');
    $gallery = $product->getMediaGalleryImages();
    foreach ($gallery as $image) {
        if($image['position'] != "1") {
            $mediaGalleryAttribute->getBackend()->removeImage($product, $image->getFile());
        }
    }
    $product->save();
}

What I'm doing here is looping through all of the products and then through their images and removing any that do not have a position of 1.