5 steps to export WooCommerce products with images
Back to Blog
SEO WooCommerce
Team Katapic
11/22/2026
11 min

5 steps to export WooCommerce products with images

The WooCommerce CSV contains image URLs, not the files. Five steps to export products, variations, and images, then check the file before using it.

Exporting WooCommerce products with images: what the file contains and what it does not

To export WooCommerce products with images, use the Export button under Products › All Products. The CSV file you get lists the image addresses (URLs) for each product in the Images column, not the actual files, which remain in the site's media library. To move them elsewhere, you must use those URLs or download the files separately. Variable products add one row for each variation.

People export a catalog almost always for a practical reason: moving to a new site, sending the list to a supplier or marketplace, or correcting titles and prices in a spreadsheet. In every case, the file reaches someone, or something, that reads only what is written in it. A CSV is text, and a photo is a string containing an address. If the address is wrong, the domain changes, or it points to a protected file, the product appears without an image at the new destination. A catalog with missing or duplicated photos is also harder for sales channels and AI assistants to assess because the fields that confirm which product is being described are missing.

WooCommerce product export screen next to a CSV file with the Images column
A WooCommerce export produces a CSV: the Images column contains addresses, not photographs.

Step 1: what the WooCommerce product CSV actually contains

The native CSV contains one row per product with text, prices, categories, and attributes. Images appear as comma-separated URLs in the Images column, while the files remain on the store's server.

A CSV is a text file in which each row is a product and each column is a field. These are the columns that matter most when you are dealing with photos and catalog data:

  • ID and Type: distinguish simple products, variable products, and variations.
  • SKU: the internal code used as the key when you reimport the file.
  • GTIN, UPC, EAN, or ISBN: the barcode, when it has been entered in the product record.
  • Name, Short description, Description: the product-page text.
  • Regular price and Sale price: the prices as they appear in the store.
  • Categories: the path, with subcategories separated by an arrow.
  • Images: one or more URLs; normally, the first is the main image and the others are the gallery.
  • Parent: applies only to variations and links them to the variable product.
  • Attribute name, values, and visibility: a set of columns for each attribute, such as size or color.

The practical consequence is simple: the export gives you a map of the photos, not the photos themselves. If the old site stays online and reachable, the map is enough: importing into another WooCommerce store downloads each URL and creates the files in the new media library. If the site is shut down or the images are behind protection, the map leads nowhere.

Who needs the image files, not just the addresses

To get the files, you need to retrieve them from the server. Uploaded photos are usually in the wp-content/uploads folder, organized by year and month, and can be copied through the hosting file manager or via FTP. Remember that WooCommerce generates multiple sizes of the same image: the CSV contains the original URL, while thumbnails are derived copies that the new site recreates automatically.

Step 2: export from the native CSV, step by step

Start the native export under Products › All Products by clicking Export: choose the columns, product types, and categories, then start the process and download the CSV.

The exact names of the options may change slightly with the interface translation, but the sequence is the same on any recent store.

  1. Sign in to the WordPress administration area and open Products › All Products.
  2. At the top, next to the button for adding a product, click Export. A window with the options opens.
  3. Choose the columns. If you are unsure what you need, leave all columns selected; if you want a lighter file, keep at least Type, SKU, Name, Images, Parent, and the barcode.
  4. Choose the product types. For a catalog with variations, also include variations; otherwise, the file will contain only the parent products, as explained in Step 3.
  5. Choose the categories, or leave them all selected to export the entire catalog.
  6. Enable the export of custom metadata if you need fields added by other plugins, such as those from an SEO plugin.
  7. Start the export. A progress bar shows the work in batches; when it finishes, the browser downloads the file.
  8. Open the file and immediately inspect the Images column for five or six different products.

The last point is the one people skip most often. Checking five rows manually is more useful than making assumptions: if you see complete addresses that begin with https and end with an image extension, the export has done its job.

A large catalog that stops halfway

With large catalogs or slow shared hosting, the export may stop before completion, with the progress bar stuck. The safest approach is to divide the work: export one category at a time and then combine the files. Keep the header identical across files so you can paste them one below another without rearranging the columns.

A craftsperson selling ceramics and managing around forty products

An illustrative example: a store with forty products, each with three or four photos, can export everything at once. The real work starts afterward: checking that every row has a main image, that detail photos are in the gallery, and that no product is using another product's image. With a few rows, you can do this visually; with several hundred, you need a systematic check like the one described in Step 4.

Step 3: export variable products and variations without losing the photos

To export variations with their images, include the variation type in the export: each variation becomes a row with a Parent column linking it to the variable product.

A variable product, such as a bag in three colors, occupies four rows in the CSV: one for the variable parent product and one for each variation. The parent contains the title, descriptions, and categories. Variations contain the price, SKU, optional barcode, and their image. If you exclude variations in the export options, you get an orderly file without the data that distinguishes each variation.

  1. Before exporting, open a variable product and note how many variations it has and which ones have their own photo.
  2. In the export window, include the variation type in addition to simple and variable products.
  3. In the file, filter the Type column for variations and count the rows: they should match the variations in the store.
  4. Check the Parent column: every variation should identify an existing parent product, usually through its SKU.
  5. In the Images column for variations, look for the photo of each color or model. An empty cell may mean that the variation uses the parent image.

It is worth checking variation galleries in the file instead of taking everything for granted. According to the WooCommerce developer blog, starting with WooCommerce version 11.1, variation galleries are enabled for every store. If you use them, check your export to see whether a variation's additional photos appear in that row, and compare it with the product record in the administration area before relying on the file.

Attributes such as size and color

Attributes occupy several columns for each attribute: name, values, visibility, and whether the attribute is global. Variations repeat the specific value, such as red, while the parent lists all possible values. If you change a value for a variation in a spreadsheet without updating the parent's list, reimporting may create inconsistent variations.

Sizes and colors sold as separate products

Sometimes a store has created a separate product for each size or color. In that case, the export is correct but the catalog is not: each row is a separate item and the photos are duplicated. Katapic offers to group these products as variations of one product, with a preview and only after your confirmation.

Step 4: check the file before using it

Before using the export, check image URLs, GTINs, empty cells, and duplicates: these are the four areas where a CSV that looks complete can hide problems.

The downloaded file does not tell you whether it works; it only tells you what has been written in it. That is why a brief review is worthwhile, especially before a migration or submission to a sales channel.

  • Image URLs begin with https and end with an extension such as jpg, png, or webp.
  • URLs contain no spaces and do not point to a test address or an old domain.
  • No published product has an empty Images column.
  • The same URL does not appear on different products unless it really is the same item.
  • The barcode has the correct length and has not lost its leading zero.
  • Every SKU is unique and every variation has a parent.
  • Descriptions do not contain messy HTML or titles written entirely in uppercase.
An export that looks complete may have an Images column full of addresses that do not respond: the CSV confirms that a field exists, not that the photo opens.

Barcodes deserve particular attention. According to the WooCommerce developer blog, WooCommerce 11.2, in the release notes dated October 7, 2026, introduces GTIN matching for CSV product imports. This means that a clean GTIN in the file can help identify products already present in the store when you reimport. A GTIN with its leading zero removed, or one invented to fill the cell, has the opposite effect. A barcode should never be reconstructed by guesswork: if the product does not have one, state that it does not.

How to check URLs by sampling

You do not need special tools: copy ten URLs from different categories and open them in a private browser window where you are not signed in to the site. If the photo appears, it is public. If you see a login page, an error, or a file being downloaded instead of displayed, the import elsewhere will have the same problem.

Working on the CSV in Excel without damaging it

If you want to export WooCommerce products to Excel, do not open the CSV by double-clicking it. Use Data › From Text/CSV, choose UTF-8 encoding and the comma as the delimiter, and set barcode columns to Text. This keeps accented characters readable, prevents the columns from collapsing into one, and stops long codes from becoming scientific notation. Always save as CSV UTF-8 before reimporting.

Checking a WooCommerce product CSV with highlighted image URLs, GTINs, and variation rows
Before reimporting or sending the file, check URLs, barcodes, empty cells, and variation rows.

Export from Katapic to CSV, Excel, and a PDF catalog

Katapic imports the catalog from your WooCommerce store and exports it to CSV or Excel for free, without spending credits; using the same data, it also creates a branded PDF catalog.

You can connect through the free, open-source Katapic for WooCommerce plugin, available on WordPress.org, or through the app: the plugin connects to the store with one click, with no API keys to copy, and reads and writes only products, never customers, orders, or payments. Once the catalog is imported, the free diagnosis shows you what is missing product by product, and only then do you decide what to export. Exports never cost credits.

For images, the diagnosis checks for products without an image, main photos below the size required by Google and Meta, formats rejected by channels, and the same image shared by multiple products. For products without photos, you can extract images from a PDF, upload them manually, choose them from the web with your confirmation, or generate an illustrative image with AI, at a cost of one credit.

The PDF catalog is created with an AI PDF catalog generator that starts from the same products: it includes thirty templates ready for printing. The exported PDF displays the small “Created with Katapic” signature until you purchase any credit package.

An export serves the person or system receiving it: for a channel, what matters is that every product has the fields that channel requests, not just that the file opens.

That is why Katapic shows readiness across six channels: Google Shopping, the Meta catalog, the ChatGPT product feed, the store, the PDF catalog, and AI responses. For each product, you can see which channels accept it and which fields are missing, along with the public rule behind each one. Google Shopping and ChatGPT feeds can be downloaded with only the products that pass the checks. The ChatGPT feed uses the nine fields in the OpenAI specification: item_id, title, description, url, brand, seller_name, image_url, availability, and price with currency; GTIN and MPN are optional. Names such as image_link belong to Google Merchant Center, not to that feed.

Who also sells on Amazon, eBay, Etsy, or Vinted

There is no direct connection with marketplaces: Katapic prepares text ready to copy and paste, calibrated to the channel's rules, while publication remains manual. That is why it is better to export an already-clean catalog with correct images and codes than to correct the same errors channel by channel.

Who is changing their store system or website and needs to take everything with them

If the catalog comes from a supplier's PDF, photos, or a CSV with different columns, Katapic imports it by mapping the columns, shows the rows before confirmation, and matches the photos to the right product. From there, you export the clean catalog to CSV or Excel rather than the inherited version.

Common errors when exporting with images

The most frequent errors are six: an empty Images column, variations without photos, unreadable characters, altered barcodes, photos that cannot be downloaded during reimport, and an interrupted export.

The Images column is empty for some products

This appears as empty cells next to products that have a photo in the store. It happens when the image is assigned to the variation rather than the parent, or when the column was not selected in the export window. Solve it by exporting again with the column enabled and, for parents without photos, assigning a main image in the administration area.

Variations arrive without photos

The file contains the variation rows, but the image is missing or is the same for all of them. This happens because the variation inherits the parent photo or because the variation gallery was not exported. Open a variation in the administration area to find out where the photo is, then complete the cell in the file or assign an individual image to each variation.

The file opens with unreadable characters or in a single column

Accented characters appear corrupted, or the entire content ends up in the first column. This happens because the program opened the CSV with a different encoding or delimiter. Solve it by importing the file through the wizard, choosing UTF-8 and the comma, then saving it as CSV UTF-8.

Barcodes have lost their zero or appear as powers of ten

The spreadsheet shows an abbreviated number instead of the code. This happens because the program treats the code as a number. Solve it by setting the column to Text before pasting the data and rewriting the codes from a reliable source, never from memory.

The photos do not arrive after reimporting

The products are created, but nothing enters the media library, or only some files do. This happens because the importer must be able to download every URL: if the source site is offline, protected, or has changed domain, the request fails. Solve it by making the images public, replacing the domain in the file with the correct one, or uploading the files first and then linking them to the products.

How Katapic helps keep an exported catalog organized

Katapic shows you what is missing from the catalog before you export it, fixes issues that do not require AI for free, and then exports to CSV, Excel, or PDF without spending credits.

The starting point is the free Katapic scan: it works on any public WooCommerce store, without an account, in read-only mode, across the latest 100 products, and gives each product an SEO score and an AI search score. With a free account, you get all four scores, SEO, AI search, brand relevance, and completeness, and a diagnosis of the entire catalog. The dashboard opens on “Where to start”, showing the findings with the greatest impact, how many products each one affects, and a click to view them.

Free corrections cover uppercase titles, messy HTML in descriptions, product condition, declaring that a barcode is absent, variations to group, and Google category. They are always proposed with a preview, never applied silently, take effect only after your confirmation, and can be undone for 30 days. The barcode is never taken from the web: it is validated using the GS1 check digit and flagged.

If you also want to revise weak product pages, rewriting costs one credit per page and starts from your data, searching the web only for what is missing and only for products with a brand and code. A verifier removes claims that no source supports, and a rejected rewrite or one that does not improve the score is not saved and costs nothing. Credits are purchased once, do not expire, and there is no subscription. No tool can guarantee a position on Google or a citation in AI assistants: Katapic works to make catalog data complete and ready.

Frequently asked questions about exporting WooCommerce products with images

How do you export WooCommerce products with images?

Go to Products › All Products, click Export, leave the Images column enabled, and download the CSV. The file contains image URLs, not the files: to get them, copy them from the server's uploads folder or download them from the addresses. If you need to reimport elsewhere, keep the source site reachable until the import has downloaded all the images.

How do you export WooCommerce products with their variations and images?

In the export window, include the variation type in addition to simple and variable products. In the file, each variation is a row linked to its parent through the Parent column and has its own Images cell. Check that the variation rows match those in the store and that the photos for each color are present, because an empty cell may indicate that the variation uses the parent photo.

How do you create a WooCommerce product CSV export for another store?

Export all columns, check the URLs, SKUs, and barcodes, then open Products › Import in the new store, upload the CSV, and verify the column mapping. Enable updating existing products only if you want to overwrite those already present. First test it with a few products to see whether the images arrive in the media library.

Can I export WooCommerce products to Excel?

WooCommerce exports to CSV, which Excel can read. Open it through Data › From Text/CSV, choose UTF-8 and the comma as the delimiter, and set barcode columns to Text. After making changes, save as CSV UTF-8 for reimporting. Katapic also offers direct CSV and Excel exports without spending credits.

How do you export the entire WooCommerce catalog without losing data?

Export all columns, all product types, including variable products and variations, and all categories. Also enable custom metadata if you use plugins that add their own fields. For large catalogs, divide the export by category and keep a copy of the original file. Before using it, check a sample of URLs, barcodes, and variation rows.

Why do product images not appear after importing?

Usually because the importer cannot download the URLs: the source site is offline, protected, or has changed domain, or the addresses contain spaces or errors. Open some URLs in a private browser window: if they do not display the photo, that is where the problem lies. Correct the addresses in the file, or upload the files to the media library first.

Frequently asked questions

How do you export WooCommerce products with images?
Go to Products › All Products, click Export, leave the Images column enabled, and download the CSV. The file contains image URLs, not the files: to get them, copy them from the server's uploads folder or download them from the addresses. If you need to reimport elsewhere, keep the source site reachable until the import has downloaded all the images.
How do you export WooCommerce products with their variations and images?
In the export window, include the variation type in addition to simple and variable products. In the file, each variation is a row linked to its parent through the Parent column and has its own Images cell. Check that the variation rows match those in the store and that the photos for each color are present.
How do you create a WooCommerce product CSV export for another store?
Export all columns, check the URLs, SKUs, and barcodes, then open Products › Import in the new store, upload the CSV, and verify the column mapping. Enable updating existing products only if you want to overwrite those already present. First test it with a few products.
Can I export WooCommerce products to Excel?
WooCommerce exports to CSV, which Excel can read. Open it through Data › From Text/CSV, choose UTF-8 and the comma as the delimiter, and set barcode columns to Text. After making changes, save as CSV UTF-8 for reimporting. Katapic also offers direct CSV and Excel exports without spending credits.
How do you export the entire WooCommerce catalog without losing data?
Export all columns, all product types, including variable products and variations, and all categories. Also enable custom metadata if you use plugins with their own fields. For large catalogs, divide the export by category and keep a copy of the original file. Before using it, check a sample of URLs, barcodes, and variations.
Why do product images not appear after importing?
Usually the importer cannot download the URLs: the source site is offline, protected, or has changed domain, or the addresses contain spaces or errors. Open some URLs in a private browser window: if they do not display the photo, that is where the problem lies. Correct the addresses in the file or upload the files to the media library first.

Related articles