Back to blog
6 min read Import Guides

How to Import WooCommerce Product Images from URLs

Suppliers rarely send product photos as files. You get a spreadsheet with a column of image links, often on the supplier’s own server or CDN. Uploading those images one by one and attaching them to products takes hours. Below: the product image and the gallery for new products, new images for products you already have, and what happens when a link is broken.

We tested it with Import Export by RockStarLab 2.1.27 and the PRO add-on 2.1.7, WooCommerce 11.2 and WordPress 7.1. Importing WooCommerce products is a PRO feature.

Short Answer

  1. Put the image links in one Images column, separated by commas. The first link becomes the product image, the others the gallery.
  2. Back up the site.
  3. Go to Import Export → Import → WooCommerce Products, upload the file and click Auto Map.
  4. On Import Options, match by SKU and keep Automatically Import Media Files turned on.
  5. Start the import and check the warning list for links that could not be downloaded.

The Spreadsheet

Our supplier file has six rows: four new products and two that already exist in the store (Polo and Sunglasses), which should get new photos:

supplier-products.csv with columns SKU, Name, Type, Regular price, Images: Sherpa Hoodie with two image URLs, Trucker Cap, Canvas Belt, Wool Scarf, Polo and Sunglasses with one URL each
A supplier file: one Images cell per product, links separated by commas.
  • SKU identifies the product. A row whose SKU is already in the store updates that product; a new SKU creates one.
  • Name, Type and Regular price are needed for new products. For products that exist they are optional.
  • Images holds one or more links separated by commas. The Sherpa Hoodie has two: the front view becomes the product image, the back view goes to the gallery.

Each link must open the image file itself (ending in .jpg, .png, .webp and so on). A link to a page that shows the image, such as a shared folder in a cloud drive, does not work. The Wool Scarf link in our file is broken on purpose, to show what happens.

The column layout is the same as in WooCommerce’s own product CSV, so a file exported from another WooCommerce store works too.

Step 1: Back Up the Site

The import creates and changes products and adds images to the media library. Make a backup first: UpdraftPlus Backup Now, your host’s backup, or ask an AI agent to run rsl-ie/updraftplus-backup-start. See How to Create a WordPress Website Backup and Restore It.

Step 2: Upload and Map the Columns

Open Import Export → Import, choose WooCommerce Products and upload the CSV. On Field Mapping, click Auto Map. All five columns were recognized, and Images went to product_images:

Field Mapping for WooCommerce Products after Auto Map: SKU to sku, Name to post_title, Type to product_type, Images to product_images, Regular price to regular_price; 5 of 5 fields mapped
Auto Map sends the Images column to the product images field.

If your column has another name, drag it to Images (comma-separated URLs: first = featured) by hand. If the main image is in a column of its own, map that column to Featured Image URL.

Step 3: Match by SKU and Download the Images

On Import Options:

  • Check for Existing Items by Field: SKU, so rows for existing products update them.
  • If Match Found: Update and If No Match Found: Create.
  • Automatically Import Media Files turned on. Without it, images from other sites are not downloaded.
Import Options: Check for Existing Items by Field SKU, If Match Found Update, If No Match Found Create, Automatically Import Media Files checked, If Media File Already Exists Skip
Match by SKU and keep Automatically Import Media Files on.

Each link is downloaded once. When a later import has the same link, the image already in the media library is used again, so running the file twice does not create duplicates.

Step 4: Run the Import and Read the Warnings

Start the import. Four products were created and two were updated. One link could not be downloaded, so the result says Import Completed with Warnings and lists the address with its row number and the reason:

Import Completed with Warnings: 1 media file could not be downloaded, wool-scarf.jpg row 4 Not Found; Successful 6, Updated 2, Created 4, Failed 0
A broken link does not stop the import; it is listed with its row.

The Wool Scarf was still created, just without a picture, and the same message is in Import Export → Jobs Log. Other typical reasons are a link that needs a login, a server that blocks downloads, or a file that is not an image.

Open Products. The new products have their photos, and Polo and Sunglasses show the supplier’s new images:

Products list with thumbnails: Trucker Cap, Wool Scarf, Sunglasses, Polo, Canvas Belt and Sherpa Hoodie with SKUs, stock and prices
New and updated products with the supplier's photos.

On the product page, the Sherpa Hoodie has the front view as the main image and the back view in the gallery below it:

Sherpa Hoodie product page: main image of the hoodie front, two gallery thumbnails below, price $59.00, SKU SHERPA-HOOD
The first link is the main image, the second goes to the gallery.

We ran the same file a second time: all six products were updated and the media library had no extra images.

Update Only the Images of Existing Products

When the supplier sends new photos later, you don’t need the full product file. Two columns are enough, SKU and Images:

image-updates.csv with columns SKU and Images: TRUCKER-CAP with two image URLs, WOOL-SCARF with one
New photos for existing products: only SKU and Images.

Import it the same way, with If Match Found: Update and If No Match Found: Skip, so a typo in a SKU does not create an empty product. Names, prices, descriptions and stock stay as they are; only the images change. The Wool Scarf got its picture, and the Trucker Cap now has a gallery image:

Trucker Cap edit screen: Product image box with a blue cap and Product gallery box with one image
After the update: product image plus one gallery image.

The Images list is the full set of pictures for the product. The first link replaces the product image, and the gallery becomes exactly the remaining links. A gallery image that is not in the list anymore is removed from the product (the file stays in the media library). Leave the Images cell empty to keep the current images.

Common Mistakes

  • Automatically Import Media Files turned off. Links to other sites are then skipped, and the products have no images. Turn it on and run the import again.
  • Links to a page instead of the file. Cloud drive share links open a preview page. Use a direct download link or upload the images somewhere they can be opened as files.
  • Separators other than commas. Put the links of one product in one cell, separated by commas. Line breaks or semicolons are read as part of the address.
  • Very large photos. Every image is downloaded and resized by WordPress. A few hundred 10 MB photos take a long time; ask the supplier for web-sized images if you can.
  • Hotlinking expectations. The images are copied into your media library. If the supplier changes a photo later, import the link again to get the new version.

FAQ

Can I import images for variations?

Yes. Variation rows in a WooCommerce product CSV can have their own Images value; the first link becomes the variation image. See How to Import WooCommerce Variable Products from CSV.

Does it work with images that are already in my media library?

Yes. A link to an image on your own site is matched to the existing attachment and nothing is downloaded.

Will it set alt text?

The downloaded images get their file names as titles. Alt text can be set later in the media library or with a bulk update.

Do I need PRO?

Yes, importing WooCommerce products is part of the PRO add-on. For blog posts with featured images from URLs, the free plugin is enough; see How to Import Posts from Excel with Featured Images by URL.

Get the free plugin on WordPress.org.

Dmitriy
About author

Dmitriy

WordPress Developer with 15+ years of commercial experience. Elite Author on ThemeForest and creator of custom WordPress plugins. Passionate about clean code, performance optimization, and building useful tools for the WordPress community.

JOIN THE CONVERSATION

Comments 0

Have a question or a tip to share? Leave it below.

Leave a comment

Your email address will not be published. Required fields are marked *

We store your name, email and comment to show and moderate it; your email is never published. Spam protection is provided by Cloudflare Turnstile and profile pictures by Gravatar. See our Privacy Policy.


Try the plugin with no risks!

New users get 1 month with access to all premium features. Experience the most powerful WordPress data engine today.

Download Now
Get PRO for FREE