Home > Blog > How To Find All Products With Broken Images In Prestashop

How To Find All Products With Broken Images In Prestashop

Nov 26, 2012

I have developed a script here for you to find and fix all products with broken images in your Prestashop store:

<?php
include_once('config/config.inc.php');
include_once(_PS_ROOT_DIR_ . '/images.inc.php');

error_reporting(E_ALL);
ini_set('display_errors', 'on');

$sql = 'SELECT * FROM ps_product LIMIT 1000';
$products = Db::getInstance()->ExecuteS( $sql );
foreach($products as $product){
        $productObj = new Product($product['id_product']);
        $id_lang = Configuration::get('PS_LANG_DEFAULT');
        $images = $productObj->getImages($id_lang);
        $ps_legacy_images = Configuration::get('PS_LEGACY_IMAGES');
        foreach($images as $image){
                // legacy mode or default image
                if ($ps_legacy_images) {
                        $filename = _PS_PROD_IMG_DIR_ . $product['id_product'] . ($image['id_image'] ? '-' . $image['id_image'] : '') . '.jpg';
                } else {
                        $imageIds = $productObj->id . "-" . $image['id_image'];
                        $split_ids = explode('-', $imageIds);
                        $id_image = (isset($split_ids[1]) ? $split_ids[1] : $split_ids[0]);
                        $filename = _PS_PROD_IMG_DIR_ . Image::getImgFolderStatic($id_image) . $id_image . '.jpg';
                }

                if(!(file_exists($filename))){
                         echo "File is not exist: " . $filename . ". ID product - " . $productObj->id . "<br>";
                }
         }
}

<?php

include_once('config/config.inc.php');

include_once(_PS_ROOT_DIR_ . '/images.inc.php');

error_reporting(E_ALL);

ini_set('display_errors', 'on');

$sql = 'SELECT * FROM ps_product LIMIT 1000';

$products = Db::getInstance()->ExecuteS( $sql );

foreach($products as $product){

$productObj = new Product($product['id_product']);

$id_lang = Configuration::get('PS_LANG_DEFAULT');

$images = $productObj->getImages($id_lang);

$ps_legacy_images = Configuration::get('PS_LEGACY_IMAGES');

foreach($images as $image){

// legacy mode or default image

if ($ps_legacy_images) {

$filename = _PS_PROD_IMG_DIR_ . $product['id_product'] . ($image['id_image'] ? '-' . $image['id_image'] : '') . '.jpg';

} else {

$imageIds = $productObj->id . "-" . $image['id_image'];

$split_ids = explode('-', $imageIds);

$id_image = (isset($split_ids[1]) ? $split_ids[1] : $split_ids[0]);

$filename = _PS_PROD_IMG_DIR_ . Image::getImgFolderStatic($id_image) . $id_image . '.jpg';

}

if(!(file_exists($filename))){

echo "File is not exist: " . $filename . ". ID product - " . $productObj->id . "<br>";

}

Partner With Us Looking for a partner to grow your business? We are the right company to bring your webstore to success. Talk to Igor

Tags:

16 Comments

Suraj Kumar says:

October 9, 2020 at 20:55

Thanks for the script, it saves very much time
syed Ibad says:

October 31, 2016 at 18:21

I want to show images with respect to color in categories page
for example i added a product in Men categorie with different two color i want to display one one picture from each color category page….
Alex Simonchik says:

April 27, 2015 at 12:31

Murtaza, if your file is in the main directory then don’t change the path. Other way begin the path from the root directory.
Murtaza says:

April 22, 2015 at 20:51

Hi,

I am not understanding how to add code what is file name or how to include_once.Please guide me.

thanks
Solomon says:

April 14, 2015 at 19:05

I am experiencing broken image in my prestashop shop. kindly assist me. Thanks
Nils says:

January 9, 2015 at 11:05

Thank you, saved me some time!
Alexander Simonchik says:

November 10, 2014 at 12:25

Syed,

Yes, you are absolutely right

$sql = 'SELECT * FROM ps_product LIMIT 1000';

1

$sql = 'SELECT * FROM ps_product LIMIT 1000';

better to replace with

$sql = 'SELECT * FROM '._DB_PREFIX_.'product LIMIT 1000';

1

$sql = 'SELECT * FROM '._DB_PREFIX_.'product LIMIT 1000';
Syed says:

November 4, 2014 at 01:34

Just tried this script and it finds products with image entries in database for images which do not exist in the filesystem.

The only catch is that it needs to use the prestashop variable for shop prefix or people should replace the “ps_” to shop specific prefix.
Alexander Simonchik says:

September 11, 2014 at 17:11

Jonathan,

The eight line is our code is

$sql = 'SELECT * FROM ps_product LIMIT 1000';

1

$sql = 'SELECT * FROM ps_product LIMIT 1000';

and here there is no “foreach”.
Jonathan says:

September 3, 2014 at 20:06

Thanks for the code. I got this error when I ran it:

Warning: Invalid argument supplied for foreach() in on line 8
Alexander Simonchik says:

June 24, 2014 at 12:14

Tran,

I will post a tips on that topic soon.
Tran says:

June 14, 2014 at 22:26

Hi Alex,
Very nice scripts, I think you you have a solution how to massive delete products from id for example 1000-3000 and their images from /img
Best regards
Tran
Alex Simonchik says:

January 4, 2014 at 11:27

Hi Sebastian! You need to delete data about such images from the database.
sebastian says:

December 27, 2013 at 19:01

script works great! so how do you fix broken images?
Alex Simonchik says:

December 14, 2012 at 14:05

The code should be located in the Prestashop root directory or elsewhere. In the latter case, however, there are other paths for include_once.
Samora van der Horst says:

December 14, 2012 at 00:17

Hello, where do you put the code

How To Find All Products With Broken Images In Prestashop

Table of contents:

Download Free Site
Audit Template

16 Comments

Post a new comment Cancel

How To Find All Products With Broken Images In Prestashop

Get interesting stuff and updates to your email inbox

Table of contents:

Download Free Site Audit Template

16 Comments

Post a new comment Cancel

Download Free Site
Audit Template