Magento使用MAGMI批量导入图像-排除图像 [英] Magento Mass Import images with MAGMI - images excluded

问题描述

感谢阅读.

我正在使用magmi导入超过30.000种带有图片的产品.

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.

我可以使用任何SQL查询并获得所有图像吗?

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)));

你能帮我吗?谢谢.

magento 1.8 CE

magento 1.8 CE

推荐答案

，如插件文档，只需在要导入的图像名称前加上"+"号即可.

as said in plugin documentation , just put a "+" sign before the image name to import.

选中排除"的原因是基本图像的默认magento行为是为了避免在额外"图像库中复制它们.

The reason "exclude" is checked is that default magento behaviour for base images is to avoid replicating them in the "extra" images gallery.

但是，某些扩展程序要求基本图像显示在额外的图像列表中.

However, some extensions require to have base image displayed in the extra image list.

顺便说一句，我也建议您使用 magmi的最新git版本，这要多得多最新并进行了一些增强

Btw, i would also advise using the latest git version of magmi , which is much more up to date and has several enhancements

这篇关于Magento使用MAGMI批量导入图像-排除图像的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！