I'm using magmi to import more than 30.000 products with images.

The problem is with images that they are imported but all of them are excluded.

Is there any sql query that I can use and get all images included?

I used this query but only one row effected

update `catalog_product_entity_media_gallery_value` set disabled=1 where `value_id` in (select `value_id` from `catalog_product_entity_media_gallery` where value in (select value from `catalog_product_entity_varchar` where `attribute_id`=(select `attribute_id` from `eav_attribute` where attribute_code='image' and `entity_type_id`=4)));

closed as unclear what you're asking by David Manners, Mufaddal, user487772 May 23 '14 at 7:20

Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.


to set all images as include, simply use below sql query,

update `catalog_product_entity_media_gallery_value` set disabled=0 where disabled=1

Not the answer you're looking for? Browse other questions tagged or ask your own question.