How do I import Image Gallery Images via CSV?

This guide will give you a step-by-step process on how to import images to the image gallery.

The image gallery allows you to add an unlimited number of additional images for a product that will display on the product’s listing page.

  1. Go to Products ->Product List
  2. Look towards the top right of the page and click on the “Export/Import” button

The Export/Import page will contain Export options on the left hand side and Import options on the right hand side.

  1. Look towards the right hand side of the page and click on the +Icon next to “Image Gallery “
  2. Next, click on the “Sample File” link to download a clean copy of the import CSV

This file will give you a template of what information to include in your spreadsheet so you may import your information to your online store.

  1. Open the file into a spreadsheet program such as Microsoft Excel or OpenOffice Calc

Here is a sample of what the spreadsheet file will look like:

You may now add image information to the proper columns

Below is a brief description of each field.

  • imageid
    This is an auto generated field from the system export. It’s not required for the Import but the column must exist.
  • productid
    Item Part Number or ID as the unique identifier to add the images to. It could be omitted when using the cataloged.
  • catalogid
    Database ID for the product as the unique identifier to add the images to. It could be omitted when using the productid.
  • image
    path to the image that will be added to the image gallery, i.e. “assets/images/default.jpg”.
  • caption
    text caption for the image, it displays on the top section of the image gallery.
  • sorting
    sort order for the images inside the gallery
  1. Once you have completed the spreadsheet, save the file.
    Be sure to save it as a CSV file
  2. Login to your admin and go to Products ->Product List
  3. Next, look towards the top right of the page and click on the “Export/Import” button
  4. Go to the right hand side of the page and click on the +Icon next to “Image Gallery ” to expand the selection
  5. Click on the “Browse” button and go to the CSV file on your computer.
  6. Click Import Data

Upon a successful import, your product options will be added to the store.