Plugins Plugin hub Backup SEO Caching Security Forms WooCommerce Images Best backup plugins
Hosting Hosting directory Shared hosting Managed WordPress Cloud hosting VPS hosting By reader location Hosting finder
Themes & builders Compare Rank Math vs Yoast
Tools All tools Hosting finder Plugin stack builder Cost calculator Salt generator Theme detector Who is hosting this? Speed test Headline analyzer robots.txt generator Redirect generator Uptime calculator Blog name generator
Blog Best backup plugins Deals
Guides All guides Speed up WordPress Choose hosting Back up WordPress
How we test

WooCommerce · Guide

How to Import WooCommerce Products with Images (Step by Step)

How to Import WooCommerce Products with Images (Step by Step)

Short answer

Add public image URLs to the Images column of your product CSV, with the main image first and gallery images after it, separated by commas. Then go to Products, click Import, upload the CSV, map the columns and run the importer, which downloads each image into your Media Library.

Key takeaways

  • Images go in the Images column as full public URLs.
  • The first URL becomes the main image and the rest form the gallery.
  • The importer cannot read files on your own computer.
  • Each variation row can have one image of its own.
  • Split large catalogues into smaller batches to avoid timeouts.
  • Test with a few products before importing everything.

How do you import WooCommerce products with images?

Put public image URLs in the Images column of your product CSV, then go to Products > All Products > Import, upload the file, map the columns and run the importer.

WooCommerce's built-in importer reads each URL, downloads the image into your Media Library, and attaches it to the product. You do not upload the images separately.

The first URL in the Images column becomes the product's main image. Any extra URLs, separated by commas, become gallery images.

The official WooCommerce product CSV importer guide covers the tool in full. The steps below focus on getting images right, since that is where most imports go wrong.

What do you need before importing products with images?

You need a CSV file in WooCommerce's format, images hosted at public URLs, a recent backup, and enough server time and memory for downloading many images.

A CSV is a plain text spreadsheet with one product per row. You can create it in Excel, Google Sheets or LibreOffice and save or export it as CSV with UTF-8 encoding.

Images must be reachable on the web without a login. The importer cannot read files on your own computer, and it cannot read private cloud storage links.

Back up the site first. A large import changes many database tables, and a backup is the fastest way to undo a mistake. Our guide on restoring a WordPress site from backup explains why to test that backup.

How should you format the Images column?

List full image URLs in one cell, separated by commas, with the main product image first and gallery images after it.

A cell might look like this:

https://example.com/images/shirt-blue.jpg, https://example.com/images/shirt-blue-back.jpg

Use the exact URL of the image file, ending in .jpg, .png or .webp. A link to a web page that shows the image will not work.

The full column list is in the WooCommerce product CSV import schema. It shows every supported column, including Images, SKU, Type, Categories and Parent.

Keep file names simple, with no spaces or special characters. Spaces in URLs are a common reason images fail to download.

Descriptive file names also help. A name like blue-cotton-shirt-front.jpg tells search engines and screen reader users more than a camera number, and WordPress uses it as the starting title for the image.

Where should you host the images before importing?

Upload the images somewhere public first, such as your own Media Library, a supplier's server, a CDN or cloud storage with public links.

If the images are already in your Media Library, use their URLs in the CSV. WooCommerce can match existing media instead of downloading a duplicate in many cases, which keeps your library tidy.

Supplier image links are convenient but risky. If the supplier changes or blocks the files later, the import fails. Downloading copies to your own site gives you control.

For cloud storage, make sure each link points directly at the file and is set to public. Shared folder links usually point to a preview page, not the image.

How do you run the WooCommerce product importer?

Go to Products > All Products, click Import, choose your CSV, map the columns, then click Run the importer and wait for it to finish.

On the first screen, choose the CSV file. Tick Update existing products only if you want rows to update products that already match by ID or SKU.

The Show advanced options link lets you change the CSV delimiter and point to a file already on the server. Most people can leave these alone.

On the mapping screen, check that your Images column maps to Images. WooCommerce auto-matches columns that use its standard names, so use the names from an export or the schema to save time.

Leave the browser tab open while the import runs. Large imports with many images can take several minutes.

How do you import variable products with images?

Import the parent product with its own images, then import each variation as a separate row with Type set to variation, a Parent value, and one image URL.

Each variation can have one image, such as the blue or red version of a shirt. Put that single URL in the variation row's Images column.

The parent product's Images column holds the main image and gallery. Variation rows link to the parent through the Parent column, using the parent's SKU or ID.

Attributes must be set up correctly for variations to work. Our guide on importing WooCommerce attributes covers how attribute columns behave.

Why are images not importing?

Images usually fail because the URLs are wrong or private, the server blocks downloads, the file type is not allowed, or the import times out on large files.

Paste one image URL into a private browser window. If it does not open the image directly, WordPress cannot download it either.

Check that the server can make outgoing requests. Some hosts and security plugins block them, which stops every image from downloading.

Large batches can hit PHP time limits. The max_execution_time setting caps how long a script runs, and image downloads add up fast.

If some products import without images, check the import log WooCommerce shows at the end. It lists rows that failed and why.

How do you avoid timeouts with large imports?

Split large catalogues into smaller CSV files, compress images before uploading them, and import during quiet hours.

Batches of a few hundred products are easier for most servers than one file of many thousands. If one batch fails, you only redo that part.

Large images slow every step. Resize them to the size your theme actually shows, and compress them before upload.

Aim for images that are clear at the largest size your product page shows, and no bigger. That keeps both the import and your shop pages fast.

On a small hosting plan, ask your host about raising PHP limits temporarily, or run imports on a staging copy and push the result live.

Should you use a plugin instead of the built-in importer?

Use a plugin when you need scheduled imports, supplier feeds, complex field mapping or XML files; the built-in importer is fine for one-off CSV imports.

WP All Import is a popular choice. Its WooCommerce add-on handles images from URLs, local folders and more.

If you go that way, start with our guide on installing WP All Import. It covers the free plugin and the WooCommerce add-on you need for product fields.

Once it is installed, our walkthrough on using WP All Import shows how to map image fields and run a first test import.

Other plugins focus on product import and export with extra options for images, such as searching the Media Library by file name.

Whichever tool you choose, test with five or ten products first. Fix any mapping or image problems before importing the full catalogue.

Which import method fits your situation?

Use this table to pick an approach based on catalogue size and how often you import.

SituationBest methodImage handling
One-off import, small catalogueBuilt-in WooCommerce importerImage URLs in the Images column
Large catalogue, one timeBuilt-in importer in batchesCompressed images, public URLs
Regular supplier feedWP All Import or similarURLs, scheduled updates
Images already in Media LibraryBuilt-in importerUse existing Media Library URLs
Variable productsBuilt-in importer or pluginParent gallery plus one image per variation

What should you check after importing?

Open a few products on the front end, check main and gallery images, test variation images, and confirm categories and prices came through correctly.

Look at the Media Library for duplicates. Repeated imports with the same URLs can create several copies of each image.

Regenerate thumbnails if images look stretched or cropped oddly. Your theme may need sizes created after the import.

Finally, clear your caches so shoppers see the new products. If categories were missing, our guide on importing categories in WordPress may help.

Frequently asked questions

Can WooCommerce import images from my computer?

No. The built-in importer downloads images from URLs, so the files must be online and public. Upload them to your Media Library, a CDN or public cloud storage first, then put those direct file URLs in the CSV.

How do I add multiple images to one product in a CSV?

Put all the image URLs in the same Images cell, separated by commas. WooCommerce uses the first one as the main product image and adds the others to the product gallery in the order listed.

Why do my imported products have no images?

The URLs may be wrong, private, or pointing at a web page rather than an image file. The server may also block outgoing downloads, or the import may have timed out. Check the import log and test one URL in a private window.

Will importing the same CSV twice duplicate images?

It can. Repeat imports may download the same images again and create extra Media Library copies. Use existing Media Library URLs where possible, and update existing products rather than creating them again.

How many products can I import at once?

There is no fixed limit, but large imports with many images can time out on smaller hosting plans. Batches of a few hundred products are easier to manage, and a failed batch is quicker to redo.

Sources

  1. Product CSV Importer and Exporter WooCommerce
  2. Product CSV Import Schema WooCommerce on GitHub
  3. WP All Import WordPress.org Plugin Directory
  4. Runtime configuration: max_execution_time PHP.net

Is your product missing, or something out of date?

Tell us what to add or correct. We read every note and reply when we need a source. A message does not buy a ranking.

About the editors

Written and checked byWPLegible Editorial Team Independent WordPress reviews and guides

Researched from the primary sources listed above and checked against our editorial rules before publishing.