WooCommerce Product Import Export – Importing WooCommerce Products with Images

Product Import Export Plugin for WooCommerce facilitates importing of products along with their associated images. The main advantages of the plugin, with respect to images, are as given below:

  • Imports multiple product images.
  • Generates thumbnails for the product images.
  • Downloads the image from the provided URL in the CSV file to the server of your store.
  • Re-uses product images from the Media Library.

The URL of each product image must be entered in the CSV file which is to be uploaded. For importing multiple images of a product, the URLs are separated with the vertical line character ‘|’. During import, the first image is taken as the Product image and rest of the images are added into the Product gallery.

Now, let us get an understanding of importing a CSV file containing products with images.

Suppose, you have a CSV file with a variable product – T-Shirt, with product image, gallery image and images for each variation of the product. In this file, the URLs of product image and gallery image(s) of each product are separated by vertical character “|”, as shown in the screenshot below:

Sample CSV file

Sample CSV file

Note: Click Sample CSV of importing Images to download it.

Following are the steps to import products with images:

  • Move to Import Products in CSV Format in the Product Import/Export settings tab.

  • Click Import Products to start importing products. Further settings appear as shown in the screenshot below.

  • You can choose either of the methods for uploading the CSV file. In this article, we are selecting the first method. That is, uploading a CSV file from your computer.
  • Click Choose File to browse a required CSV file from your computer.
  • Select a mapping file, or click Upload file and import to move ahead and create a new one.
  • Enter a mapping filename and map the required WooCommerce Product Fields with column headers of the CSV file. Use Evaluation Field to fix/update the required value for a particular field.

  • Click Submit to start importing products into your WooCommerce store.  

Based on the CSV file imported, the products and its respective images get added to your store, as shown in the screenshot below:

The plugin generates thumbnails for products by using URL of the image which is specified in the CSV file.

To view imported products, move to the WooCommerce Product page. The imported products with respective thumbnail will be displayed as shown in the screenshot below:

To view product image, gallery image(s) and product variation images, open the individual product page. The imported images will be displayed as shown in the screenshot below:

From the above screenshot, we can see the variable product – T-Shirt, is imported to WooCommerce store with four variations. The respective product image, gallery images and product variation images are successfully imported with thumbnails.

Note: All the imported images are uploaded to the server of your store from the mentioned URL in your CSV. Make sure the image URLs are correct. If the images are already present in your WordPress Media Gallery, you can re-use the images. Read more about this process in the below section.

Re-using product images from Media library

There will be cases where you can re-use the product images from the media library. For instance, when you use the same image for different simple products or for each variation in a variable product. However, the exported CSV file will contain multiple image URLs. This will result in duplicate images on your server and slow down load time while importing the products. See the screenshot below:

Sample CSV

To overcome this, you can provide the respective image name (image-name.jpg) instead of the URL. That is, keep the URL once in the images column, and for the subsequent use of the same image, provide only the image name in the column.

A screenshot of sample CSV is as shown below:

Though this is pretty straightforward in the case of simple products, it can get a bit tricky in the case of variable products.

For example, we have iPhone as a variable product on our store. Based on the attribute “color”, there are two variations: Black and White, which need different images. We have another attribute “storage”, which again creates three variations (16GB, 32Gb, 64GB), but can use the same image.

In this example, we used the same image for variations Black 16GB, Black 32GB, and Black 64GB.  Now you can see (above screenshot), we have used the URL only once for the Black variations. Whenever it is repeated in the CSV, we added the image name. And when a different image is used (for the white variations), we added the URL once and just the image-name.jpg in subsequent cases.

For more information on importing and exporting of products, read our setting-up documentation .

Comments (10)

  • Julia
    Julia

    How is the url created – this is where I am stuck ? The image files are on my pc, what url do I create ?
    Am I supposed to upload them as media files first ? Please can you advise

    May 7, 2017 at 9:51 pm
    • Veeresh
      Veeresh

      Hello Julia,

      If you want to use images which are saved on your PC, you need to upload images to Woocommerce Media Library and just use the name of the image to import. If the image is on another server, you need to use full URL of the image to pull Image to your site.

      Hope this help.
      Let us know if you have any queries.

      Regards,
      Veeresh

      May 8, 2017 at 10:39 am
  • MakeOnlineShop
    MakeOnlineShop

    Hello

    Can you explain me why do I need a plugin to import products and images when WordPress already has the function ?

    Is it better to use this plugin ?

    Thanks.

    January 9, 2017 at 1:17 pm
    • Anindo
      Anindo

      Hi,

      Our import export plugin has distinct advantages over the wordpress import feature.
      Among them, the chief features are :
      1. Our plugin helps you to import products from any platform and export them to any platform via csv.
      2. You can schedule the imports or exports to your remote location via FTP.
      3. The Import/Export can be seamlessly done by mapping the fields of your external system with that of woocommerce.
      4. It is simpler than the existing wordpress import. The wordpress import feature allows you to download the data in XML format. We do it in csv which makes it simple to view and edit.

      January 9, 2017 at 1:54 pm
  • Nea
    Nea

    Hi,

    You can import multiple images for a product, separate URLs with ‘|’.

    During import, the first image is taken as the Product Image and rest of the images are added into Product Gallery.

    Hope that helped.

    Let us know, if you have some query.
    Regards,
    Nea

    December 30, 2016 at 9:30 pm
    • Gonzalo
      Gonzalo

      Thanks! But my question was if I can just put de name of a file that is already uploaded in the media library.

      January 31, 2017 at 7:28 pm
  • Gonzalo
    Gonzalo

    It is possible just to put the image name of a media uploaded before in WordPress?

    For example, If I uploaded a image with the name “image-product.jpg” before in the media library. Can I put in the .csv “image product.jpg|http://other-url.com/image” ? Thanks!

    December 30, 2016 at 8:19 pm
    • Nea
      Nea

      Hi Gonzalo,

      You can put the image URL in the CSV for importing .

      Hope that answered your query.

      Regards,
      Nea

      February 1, 2017 at 3:02 pm
    • Nea
      Nea

      Hi Long,
      While importing multiple images for a product, , separate URLs with ‘|’.
      Also, during import, the first image is taken as the Product Image and rest of the images are added into Product Gallery.
      Hope that helped

      January 3, 2017 at 3:15 am

Leave a Reply