Remove all category Image at once

[Jojobaa]

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

[Mayur Bhuva]

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.

[Jojobaa]

---

@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

[Jojobaa]

Anyone?

[Jojobaa]

Maybe somebody?

[media_bloke]

Thanks, this did it for me. Afterwards, I had to clear my cache