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 (2)
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/