Magmi import extra images, how?

Question

First of all, thanks for MAGMI, Dweeves

I've been able to get Magmi working to import the product data without an issue.

The image, small_image and the thumbnail are visible on admin and front-end.

I am trying now for days to import the rest of the additional images, but so far I have no luck.

The image name is the same as the SKU, for example 9781907339363.jpg, SKU is 9781907339363.

The additional images are 9781907339363_01.jpg, 9781907339363_02.jpg, 9781907339363_03.jpg ...etc...

or

SKU, image,"additional image" 1000629871, 1000629871.jpg, "1000629871.1.jpg, 1000629871.2.jpg, 1000629871_3.jpg" ...etc...

I hope that it is not a option to put all off these additional images by name in the csv file, i have about 50.000 SKU and about 120.000 images. So not all the SKU has addional images.

I hope somebody can give me a direction how to import the addional images.

Magmi : 0.7.18

Image attributes processor : 1.0.25

Answer 1

In your CSV file, the header for your extra images must be titled : media_gallery

then is should contain the following structure for additional images:

sku_01.jpg::sku_label;/sku_02.jpg::sku_label;/sku_03.jpg::sku_label;

(note 1: in this example the separator is ; so make sure it's the case in your magmi settings)

(note 2: image, small_image, thumbnal, image_label, thumbnail_label must also be in the CSV. In other words, you must not include the first image inside media_gallery, but only the additional ones.

More info from the magmi wiki: http://sourceforge.net/apps/mediawiki/magmi/index.php?title=Image_attributes_processor#media_gallery_.28extra_images.29_column_syntax*

I hope this helps.

edit - your images must be located in media/import Are your images taken from a remote url ? Or are they on your magento server ?

Answer 2

I think one of the good solution is below You have to write your custom script assign image to that specific product.

1) Create one PHP file in your root folder name is importmages.php.

2) Copy and paste the below code. this is only demo code you have to change as per for requirement.

<?php
    error_reporting(E_ALL | E_STRICT);
    $mageFilename = 'app/Mage.php';
    require_once $mageFilename;
    $app = Mage::app('default');  
    ini_set('display_errors', 1);

    $products = Mage::getModel('catalog/product')->getCollection()
                ->addAttributeToSelect('*');        

    //suppose we fetch the SKU of the product and dynamically generate the name like sku_01.jpg and assign to product Object and save the data. Make sure your all images into media/import Folder.

    foreach($products as $_prduct)
    {
        $sku=$_prduct->getSku();
       // Now create the path for Image.
        $filename1 = $sku."_01.jpg"; 
        $filePath1 = Mage::getBaseDir('media') . DS . 'import' . DS . $filename1;
        $prod=Mage::getModeil('catalog/product')->load($_product->getId());
        $prod->addImageToMediaGallery($filePath1, array('thumbnail','small_image','image'), false, false);
        $prod->save();
        unset($prod);
    }
?> 

Answer 3

Add Below Data To Your Import Data Array

$importData['image'] = "https://wow.olympus.eu/webfile/img/1632/oly_testwow_stage.jpg";
$importData['image_label'] =  "base Image label";

$importData['small_image'] = "https://wow.olympus.eu/webfile/img/1632/oly_testwow_stage.jpg";
$importData['small_image_label'] = "small Image label";

$importData['thumbnail'] = "https://wow.olympus.eu/webfile/img/1632/oly_testwow_stage.jpg";
$importData['thumbnail_label'] = "Thumbnail Image label";

$importData['media_gallery'] = "https://cdn.hackernoon.com/hn-images/0*xMaFF2hSXpf_kIfG.jpg::TestImage1;https://images.sftcdn.net/images/t_app-cover-l,f_auto/p/befbcde0-9b36-11e6-95b9-00163ed833e7/260663710/the-test-fun-for-friends-screenshot.jpg::testImage2"

Note: Image attributes processor must be check (ON) from magmi setting in your Magmi Profile.