1

I want to upload import bulk images in magento.

Each product has three images, so sort order of image is must while importing in bulk.

But after a lot googling i didn't find field name for image sort order.

(In case of API its equivalent is "position")

Anyone please tell me What is field name for image sort order in CSV imported from dataflow profile?

Improve this question
1

As far as I concern it is not possible with neither generic Magento import, nor with Magmi. Some commercial import script might do it though.

To me the closest bet would be customizing Magmi image plugin which is quite easy.

Improve this answer
1
  • Its really shocking! I wonder how to manage images sort order while importing bulk products? Is there any trick? – Sandesh Jun 17 '13 at 12:51
0

Have you tried 'position column' from 'catalog_product_entity_media_gallery_value' table?

A sample SQL query to achieve this would be -

UPDATE catalog_product_entity_media_gallery AS mg,
    catalog_product_entity_media_gallery_value AS mgv,
    catalog_product_entity_varchar AS ev
SET ev.value = mg.value
WHERE  mg.value_id = mgv.value_id
AND mg.entity_id = ev.entity_id
AND ev.attribute_id IN (70, 71, 72)
AND mgv.position = 1;

Backup your database before playing with this. Getting the previous state back is not so easy.

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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