Query builder remove images when stock is 0 and disabled.

[linkin11]

Hello

I want to make a Query builder that remove all images when stock is 0 and disabled.

Can somebody help me with the query how to to this?

Or exist a module what do this job?

thanks

[s4lvozesta]

Images are stored as physical jpg files. I should not think query (SQL) would be able to remove physical image files.

However, with adv stock off, products having 0 quantity and disabled can be (obviously) retrieved by

SELECT * FROM ps_product WHERE quantity = 0 AND active = 0

 

Its result would be used further to find the physical image file. For that, maybe this thread could help

https://www.prestashop.com/forums/topic/926323-retrieve-products-picture-url/

 

Cheers!

[linkin11]

26 minutes ago, s4lvozesta said:

Images are stored as physical jpg files. I should not think query (SQL) would be able to remove physical image files.

However, with adv stock off, products having 0 quantity and disabled can be (obviously) retrieved by

SELECT * FROM ps_product WHERE quantity = 0 AND active = 0

 

Its result would be used further to find the physical image file. For that, maybe this thread could help

https://www.prestashop.com/forums/topic/926323-retrieve-products-picture-url/

 

Cheers!

After this all image columns must be flushed, and after that i can use a image cleaner that remove images who don't have a link.

Is this the solution?

What query must be next to flush the image link columns tables?

thanks allot

[s4lvozesta]

I do not think there is 'image columns' from the query above (or maybe there is in some version of prestashop? not sure). 

The table `ps_image` might be of your interest too.

On the above link, there are sample codes to follow. This function might be useful for you 
 

print $link->getImageLink

 

Lastly, write PHP code to remove respected file images