Importing Product Images

If you have many product images to upload, you can streamline the process by zipping the images into an archive file. The zipped archive can then be imported into your catalog in a single step. This process is commonly referred to as a “bulk” import.

It is important to understand that Magento Go does not automatically associate imported images with products. You must follow a few simple steps to make sure that each imported image is associated with the correct product.

Step 1: Export Your Product Data

The first step is to export the product data from your store and save it as a CSV file. When exporting data, you can skip any attributes that aren’t needed. For example, you might include only the image and label for the base, small, and thumbnail images, and the Image Gallery checkbox. In the exported data, these columns will appear toward the beginning of the spreadsheet, which makes it easier to edit. To learn more, see: Exporting Data.

Step 2: Edit the CSV File

During this step, you will associate each image with a product, and enter a relative path for each image you want to import.

  1. Open the exported CSV file in a spreadsheet and edit the data. Here are some rules to remember:
    • The product record structure includes a column for the base image, small image, thumbnail, plus an additional image. The file name of each image to be imported must begin with a forward slash. (For example: /image-base.jpg)
    • Images to Import
      Images to Import
    • After the import, Magento Go organizes the images alphabetically into folders. If you want to upload a replacement image with the same name, do not include the alphabetized path from the existing image. Simply place a single forward slash at the beginning of image file name.
    • To upload multiple additional images, each must be entered on a blank row, immediately after the associated product. You can leave the other columns on the row blank, unless they are applicable—such as the associated label, or images for upsell or related products, etc.
    • Existing Images with New Additional Image
      Existing Images with New Additional Image
    • If your images are organized into subdirectories within the zipped archive, you must include the directory path with the image file name. For example, if picture1.jpg is in folderA, the entry in the CSV will be folderA/picture1.jpg.
    • Image file names are case sensitive, so pay attention to your use of upper-and lowercase characters. (For example: /image-base.jpg is not same as /image-BASE.jpg.)
  2. When complete, save your changes to a CSV file with UTF-8 encoding.
  • The total size of uploadable files must not exceed 110 MB.
  • The file must be saved with UTF-8 encoding. If you need help, check your spreadsheet documentation for more information.
  • If working in Excel, when prompted to “leave out incompatible features,” select Yes.

Step 3: Import the Zipped Image Archive

The next step is to zip your image files and import them into your store. There are many zip utilities available for both the PC and Mac platforms. If you are working with the latest Windows or Mac operating systems, you may already have an archiving tool available. Check your system documentation for more information.

  1. Zip the images to be imported into an archive file.
  2. On the Admin menu, select System > Import/Export > Import.
  3. Set Entity Type to “Product Images.”
  4. Click the Browse button and select your zipped archive of product images.
  5. Import Settings - Product Images
    Import Settings - Product Images
  6. Click the Upload Image Archive button to import the images into your store.
  7. Upload Image Archive
    Upload Image Archive

    When the import is complete, you will receive a Validation Results message. Your data is now in the queue, waiting to be processed. It may take a while, so be patient.

Step 4: Import the Edited CSV File

  1. On the Admin menu, select System > Import/Export > Import.
  2. Set Entity Type to “Products.”
  3. Set Import Behavior to “Append Complex Data.”
  4. Click the Choose File button, and find the edited CSV file on your computer.
  5. Click the Check Data button to validate the file. Then, do one of the following:
    • If the “File is valid!” message appears, click the Import button to import the data.
    • If the file contains errors, you can either skip the rows with errors, and import the valid data, or correct the errors and try again.

Step 5: Refresh the Search Index

  1. On the Admin menu, select Catalog > Search Indexing.
  2. Click the Refresh Index button.

Discussion:

RSS: New Article posts

Explore the Knowledge Base