cancel
Showing results for 
Search instead for 
Did you mean: 

Remove all category Image at once

Remove all category Image at once

Hi,

Is it possible to have all the category images removed at once? I have 50.000 products and 100's of categories.

Screenshot: http://prntscr.com/k0r20h

regards

4 REPLIES

Re: Remove all category Image at once

Run following SQL query in your database

 

UPDATE `catalog_category_entity_varchar` SET `value`= NULL WHERE attribute_id = 48;

Here 48 is the attribute_id of the image.

Recheck your attribute_id before executing the query.

You can set NULL in one row to check if it's working or not before executing the query.

If you find my answer useful, Please click Kudos & Accept as Solution.
Tags (2)

Re: Remove all category Image at once

 


@Mayur Bhuva wrote:

Run following SQL query in your database

 

UPDATE `catalog_category_entity_varchar` SET `value`= NULL WHERE attribute_id = 48;

Here 48 is the attribute_id of the image.

Recheck your attribute_id before executing the query.

You can set NULL in one row to check if it's working or not before executing the query.


Hi, I get an error message that the table doesn't exists. This is how that specific table looks like:
http://prntscr.com/k2db2n

Re: Remove all category Image at once

Anyone?

Re: Remove all category Image at once

Maybe somebody?