You can import and export all the images of a product in a WooCommerce store with the free version of WooCommerce Product Import Export plugin. First, let us see how we can add the product images in the CSV file during import.
Sample CSV
Here we have attached a sample CSV with product images.
Adding product images in CSV
In the input CSV file, you can add the images of a product either by:
- Image name
- Image url
To add multiple images, you can use a pipe symbol ‘|’ to separate the image URLs/ names. In the CSV file, the image URLs/names are added under the column: Images.
Here, the first image is taken as the Product image (also known as Featured image) and the rest of the images are added into the Product gallery.
In case of drop box and google drive images, ensure that the specified URL downloads the image locally rather than just pointing at the image location.
Steps to import WooCommerce products with images
To import WooCommerce products with images:
- Click on WebToffee Import/Export(Basic) > Import.
Step 1: Select a post type
As a first step, you need to choose the post type as Product.
Step 2: Select import method
One can choose among: Quick import, Pre-saved template and Advanced import.
Step 3: Map import columns
To map import columns. Here, you can map the commercial names to WooCommerce columns. Use Evaluation Field to fix/update the required value for a particular field.
- Click on Step 4 to proceed.
Step 4: Advanced Options/Batch Import
On reaching Step 4, the following window will appear, where you have various advanced options for the import operation.
- Click on Import to finish.
For a more detailed process, refer to: How to import WooCommerce products.
Viewing the imported product images
To view the imported products with images:
- From the WordPress admin Panel, click on the menu: Products> All Products.
- The Products page will list all the imported products with their respective thumbnails.
- View the product image and gallery images by editing the individual product. Here is the sample of the imported images of the product: Men’s Cotton T-Shirt.
- Was this article helpful?
- Yes, thanks!Not really
Comments (8)
Jimmy Ek
February 25, 2023
I am having problems when importing from a CSV. I never manage to get the affiliate link so that it then stands under the external/affiliate tab in the woocomerce product list.
What could be wrong?
Alan
March 6, 2023
Hi,
The issue you are facing might be due to some issues with the CSV file. Can you please reach us via support and share the CSV file?
Ian A Campbell
September 21, 2022
Hello, i am testing this product as i have had enough of the issues i have been having with WP All Import Pro, I like how fast it uploads the products however one issue i have before i purchase the upgraded version i am having trouble getting the main product image to show, it does import the images into the product page itself but not the thumbnail image, so when i go to all products in WooCommerce their are no images against each product.. This is what i have in images/gallery: {Product Image 1} {Product Image 2} {Product Image 3} {Product Image 4} {Product Image 5} {Product Image 6}.. Any help is appreciated…
Alan
September 23, 2022
Hi,
Can you please let me know if the images are displayed on the product edit page after importing using the plugin? If yes, then please reach us via support and share the file you used to import. If it’s not displaying then please make sure that you add the pipe symbol(|) in between the image columns on the mapping field ie. {Product Image 1}|{Product Image 2}|{Product Image 3}|{Product Image 4}|{Product Image 5}|{Product Image 6}
Gordon
April 5, 2022
Hi there,
I have a few questions…
1. Do you have to upload the images to the website first and then add the image url so that the image is mapped to the correct product?
2. How does the image get uploaded if you specify just the image name rather than the image url?
3. If the images are from Google Drive or Dropbox I am assuming the image will be imported into the website and not hot linked. Is this correct?
Thanks for your assistance.
Alan
April 7, 2022
Hi,
1. No, you don’t have to upload the images to the site for importing images using the URL. You can use the image URL of images that are hosted anywhere. Just make sure that the image URL is publically accessible.
2. For importing images using just the image name you have to upload the image files to a directory under /wp-content/uploads/ folder.
3. You can upload images that are uploaded on google drive or dropbox. Just make sure that you use the image URLs which point directly to the image file instead of the google drive or dropbox page where the image is present. Please go through the below articles to know more about it.
https://www.webtoffee.com/how-to-import-google-drive-images-to-woocommerce-product/
https://www.webtoffee.com/woocommerce-import-products-with-images/
Josh S
January 19, 2023
For option 2.
In the spreadsheet would the image path have to be the complete URL, or a relative path to the images.
What would it look like?
Alan
January 27, 2023
Hi,
If the images are uploaded to the media library of the importing site then you may please just add the image name including the extension in the CSV file.