---
title: "Find WooCommerce Products Without Images or Descriptions"
url: "https://wpimportexport.com/find-woocommerce-products-without-images-descriptions/"
description: "Export WooCommerce products with no featured image, no description or no short description to Excel and fix your catalog before a feed rejects them."
type: post
published: 2026-11-16T13:00:00+00:00
modified: 2026-11-14T10:45:19+00:00
categories: ["Export Guides", "Tutorials", "WooCommerce"]
tags: ["Import Export by RockStarLab", "WooCommerce", "WordPress Excel export"]
docs_topics: ["Export guides"]
---

# Find WooCommerce Products Without Images or Descriptions

A product without a photo looks broken in the shop and is rejected by Google Merchant Center. A product without a description gives buyers and search engines nothing to go on. In a catalog of a few hundred products, these gaps are hard to spot on the Products screen. With [Import Export by RockStarLab](https://wordpress.org/plugins/import-export-by-rockstarlab/) PRO, you either export just the products with a specific gap, or export the whole catalog with check columns and see every gap in one sheet. The example checks a small merch shop.

**PRO:** WooCommerce product export is part of PRO. **Free:** the same checks for posts and pages, for example with Featured Image URL and Word Count.

## Short Answer

- **No featured image:** filter **Custom Field (Meta)** `_thumbnail_id` **Is Empty**.
- **No description:** filter **Description** **Is Empty**.
- **No short description:** filter **Short Description** **Is Empty**.
- **All gaps at once:** export all published products with Featured Image URL, Gallery Images, Word Count and Short Description, and mark the empty cells in the spreadsheet.

Add **Status** **Equals** `publish` to every export to check only products customers can see.

## Products without a featured image

WooCommerce stores the product image’s ID in a custom field called `_thumbnail_id`. A product without an image doesn’t have it, so a custom field filter finds them:

![Product export filters: Status Equals publish and Custom Field (Meta) _thumbnail_id Is Empty; total items available 2](https://wpimportexport.com/wp-content/uploads/2026/11/01-no-image-filter.webp)

_Products without a featured image have no _thumbnail_id._

Two of our 17 published products had no image: Belt and Polo. Export Product Name, SKU and Permalink, and you have a to-do list for the photographer.

## Products without a description

The filters **Description** **Is Empty** and **Short Description** **Is Empty** work the same way. In our shop, the first found Cap, the second Belt and Sunglasses. Filters combine with AND, so run them as separate exports, or use the whole-catalog check below.

## Check the whole catalog at once

For a full content audit, export all published products with these columns:

- **Featured Image URL**: empty when there’s no image.
- **Gallery Images**: the extra photos, separated by commas.
- **Word Count**: the number of words in the description; 0 when it’s empty.
- **Short Description**: the text next to the price.

Then add a Check column that names the gaps, for example with `=IF(C2="","no image","")` and similar formulas for the other columns, and sort by it:

![Spreadsheet of products with featured image, gallery, word count and short description, plus a Check column: Belt no image and no short description, Cap no description, Polo no image, Sunglasses no short description](https://wpimportexport.com/wp-content/uploads/2026/11/02-content-check.webp)

_One export of the whole catalog with a Check column. URLs shortened for the screenshot._

Four products need work: Belt has no image and no short description, Cap no description, Polo no image and Sunglasses no short description. Word Count also shows thin descriptions that aren’t empty: a product with 15 words probably needs more than one with 300.

## Fix the gaps in bulk

Write the missing short descriptions in the same spreadsheet and import it back by SKU; the steps are the same as in [updating products by SKU](https://wpimportexport.com/how-to-update-woocommerce-prices-stock-by-sku-csv/). For missing photos, get the images into the Media Library first; see [importing images from URLs](https://wpimportexport.com/bulk-import-images-from-urls-wordpress-media-library/). [Back up the site](https://wpimportexport.com/how-to-create-a-wordpress-website-backup-and-restore-it/) before an import that changes products.

## With an AI agent

An AI agent connected through the WordPress MCP Adapter (see [connecting Claude Code to WordPress](https://wpimportexport.com/connect-claude-code-to-wordpress-mcp/)) can run all three checks in a row:

```
Which published products have no image, no description or no short description?
```

In our run, the agent called `rsl-ie-pro/export-preview` three times: with the custom field filter `_thumbnail_id` `is_empty` it got Belt and Polo, with `post_content` `is_empty` Cap, and with `post_excerpt` `is_empty` Belt and Sunglasses. The same four products as in the spreadsheet.

## FAQ

### Does this find products that only lack gallery images?

Use the Gallery Images column in the whole-catalog export; an empty cell means no gallery.

### Are variations checked?

These filters check the products. To review variation images, export with One row per variation and look at the Featured Image URL column: a variation without its own image shows the product’s image.

### What if a description contains only a shortcode or an image?

Word Count doesn’t count shortcodes or HTML, so such a product shows 0 or very few words. Open it to check.

### Can I check posts and pages the same way?

Yes, with the free plugin: export Featured Image URL and Word Count for posts or pages.

## Related Guides

- [How to Export WooCommerce Products for Google Merchant Center](https://wpimportexport.com/export-woocommerce-products-google-merchant-center/)
- [Find Thin Content in WordPress: Export Word Counts for a Content Audit](https://wpimportexport.com/find-thin-content-wordpress-word-count-export/)
- [Export WooCommerce Product Variations with SKU, Price and Stock](https://wpimportexport.com/export-woocommerce-variations-sku-price-stock/)
- [Bulk Import Images from URLs into the WordPress Media Library](https://wpimportexport.com/bulk-import-images-from-urls-wordpress-media-library/)

Get the free plugin on [WordPress.org](https://wordpress.org/plugins/import-export-by-rockstarlab/).
