{"id":7108,"date":"2014-09-25T16:24:02","date_gmt":"2014-09-25T13:24:02","guid":{"rendered":"http:\/\/blog.belvg.com\/?p=7108"},"modified":"2025-07-01T09:13:55","modified_gmt":"2025-07-01T07:13:55","slug":"how-to-find-products-with-broken-images-in-prestashop","status":"publish","type":"post","link":"https:\/\/belvg.com\/blog\/how-to-find-products-with-broken-images-in-prestashop.html","title":{"rendered":"How to Find Products with Broken Images in Prestashop"},"content":{"rendered":"\n

Today we will explain how you can find products with empty images. By empty images we imply those pictures, which are indexed in the database, but the files are not physically located on the server. In such case users will see a gray question mark instead of a placeholder with the caption that the image for that product is not available.<\/p>\n

\"How<\/p>\n

\/*prepare list of broken images*\/\r\nrequire(dirname(__FILE__).'\/config\/config.inc.php'); \/\/  you might need to change the path to the file 'config.inc.php' if you are not in the root folder\r\n$id_lang = 1; \/\/getting links for one language. This is enough to identify empty images\r\n$i = 0;\r\n$limit = 100;\r\n$filename = 'broken_urls.txt';\r\nfile_put_contents($filename, '', LOCK_EX); \/\/remove old content\r\n\/\/file_put_contents($filename, '', FILE_APPEND | LOCK_EX); \/\/append content\r\ndo {\r\n    $images = Db::getInstance()->executeS('\r\n        select *\r\n        from `'._DB_PREFIX_.'image` i\r\n        limit ' . (int)($i++ * $limit) . ', ' . (int)$limit . '\r\n    '); \/\/receiving the stack of images\r\n\r\n    foreach ($images as $image) {\r\n        $imgObj = new Image($image['id_image'], $id_lang);\r\n        $image_path = _PS_PROD_IMG_DIR_ . $imgObj->getImgPath() . '.' . $imgObj->image_format;\r\n        if (!file_exists($image_path)) { \/\/verifying, whether the file with the image exists\r\n            $productObj = new Product($image['id_product'], NULL, $id_lang); \/\/creating a product object for link generation\r\n\r\n            print_r($image['id_product'] . ' => ' . Context::getContext()->link->getImageLink($productObj->link_rewrite, $image['id_image']) . chr(10)); \/\/die;\r\n            file_put_contents($filename, $image['id_product'] . ' => ' . Context::getContext()->link->getImageLink($productObj->link_rewrite, $image['id_image']) . chr(10), FILE_APPEND | LOCK_EX);\r\n        }\r\n    }\r\n} while(count($images));<\/pre>\n
As a result we will have a file with the list of products on the screen. For such products you need to delete the entries in the table ‘ps_imаge’, ‘ps_imаge_lаng’ and ‘ps_imаge_shоp’, and upload images for these products again.<\/p>\n\n","protected":false},"excerpt":{"rendered":"Today we will explain how you can find products with empty images. By empty images …","protected":false},"author":12,"featured_media":9245,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"image","meta":{"_acf_changed":false,"footnotes":""},"categories":[15,34],"tags":[226,445,220],"class_list":["post-7108","post","type-post","status-publish","format-image","has-post-thumbnail","hentry","category-prestashop","category-tipstricks","tag-images","tag-prestashop","tag-prestashop-tips","post_format-post-format-image"],"acf":[],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t