3.5.1. Import Images


Note: It is strongly recommended that a validated database backup be created, before any potentially unsafe, mass operations, are performed!

Store Manager for Magento optionally allows the uploading Images of your products, during the products Import process. To upload images, while Importing, perform the following steps:

1. Make sure that you have set up your FTP connection correctly. To verify this, go to: Preferences -> FTP, or presss the [F12] shortcut key.

If you need help configuring your FTP connection, click here.

Store Manager Preferences

2. Prepare a .csv file for Import. Make sure that it contains all required columns (such as Product ID, Product Model (SKU), etc.), along with a column containing valid file references to the image(s) for each product. For more details, click here.

Images may be specified within the .csv file in a few different formats:

        • Image names - All images should be located on your local PC, in one folder, (do not use subfolders). For example: imagename1.jpg

        • Image URLs - You may also reference external files (not on your local pc.), ie... External URL links offered by your supplier (be sure to include the http://). These will typically be supplied in the format: http://yoursupplier.com/images/imagename1.jpg

If multiple images are to be imported into an image gallery, for one product sku, specify all of the images within one field, using the comma (,) as a delimiting separator.

      • In the case of image names, use the following format: imagename1.jpg, imagename2.jpg, imagename3.jpg

      • If you have been given External URLs by your supplier, format them in this manner:

http://yoursupplier.com/images/imagename1.jpg, http://yoursupplier.com/images/imagename2.jpg, http://yoursupplier.com/images/imagename3.jpg,

Be sure to validate that all images have the correct size, and that the names are correct, for all products.

3. You may now proceed with the import. Detailed procedures and import steps may be found in the Product Import Instructions.

Pay special attention to be sure that the "Import Images" option in the "Select Delimiters and Additional Settings" step of the import process is selected:

Select fields Delimiters

The following options are available on this step:

  • "Clear Image Gallery" allows you to clear the current Image Gallery for the Products that you are updating

  • "Delete images from FTP". If this option is selected, the Product Images will be erased from your FTP directory, during the Import process

  • "Generate new image name if omage already exists". A new image file will be created, instead of replacing the existing one, if the uploading file name already exists in the destination directory.

  • "Local directory with images". Specify the local directory containing images that you would like to import (use only if you have validated image names in your .csv file, and images exist in a designated folder on your local PC.

If your media files have different format, you can specify the necessary size of images in the "Fields Delimiters and Additional Settings" step of import process.

Selecting the "Import Images" field enables the three types of images which you can resize below:

  • Base Image

  • Small Image

  • Thumbnail

You can choose one of them to specify custom size, and two others will be resized automatically.

Images Resize Rules

As default, your images are imported without changes (resizing), but if you press the browse [...] button, you will be able to set your own settings, i.e. image width and height in pixels.

Resize Rule Browse button

Press the [Add] button, and enter resize rule name in the first column of the form.

Add rule button

The next columns allow to enter the following data:

  • "Desired Width". If you specify only the image width, picture will change proportionally to the specified size

  • "Desired Height". If you specify both - the width and height - the image size will be changed accurately to these proportions

Additionally, you have to mark the relevant field of increasing or decreasing image size:

Decrease size column
  • If you want to reduce the image' size, select the first column

Increase size column
  • If you want to increase the image' size, select the second column.

Apply rule button

To save your entry press the [Apply rule] button.

Remove resize rule

You can delete selected resize rule by clicking the corresponding button.

You have the possibility to abolish all previous entries, if you press the corresponding button in "Image Resize Rule" form.

Cancel rule button

Note: it is recommended to make resize with Magento template, as manual resize rule will blur images slightly.

4. Assign the images in the columns in your .csv file to their corresponding database fields.

To do so, select the "Product Image" field in the left "Database Fields" pane, and then click the correct column in the right pane (".csv File Columns"). You may also type the number of the .csv column directly into its corresponding field. For example (see the illustration below), in the "Fields" column of the .csv file, the field "Media Gallery Label" is assigned to the 44th csv col database field ("Media Gallery").

Assign Columns to Database Fields

5. Complete import

Once the import is finished, Store Manager will upload your Images via FTP automatically, and you will be able to see the Images on their relevant product page. Be sure to validate the results, once the upload is complete.

Note: All images go into an ftp queue. Refer to Advanced -> FTP Tasks Queue. Be patient, as the upload may take some time.

For details and information about other options, please check Product Import.