How to find WooCommerce products missing a SKU, price or image

WooCommerce has no single filter for incomplete products. You can sort the Products screen by SKU or scan the image column, but finding every product that lacks a SKU, price, image, barcode or category takes a plugin. In the free StoreRuler plugin, the product list shows a count for each gap and filters to the products that have it.

Why missing product details cost you

• No price: WooCommerce does not let shoppers buy a product with an empty price, so it shows no add-to-cart button. The page is live but sells nothing.
• No image: the shop shows WooCommerce's placeholder picture instead. Shoppers scroll past it, and shopping feeds such as Google's need an image for every product.
• No SKU: picking and packing get slower and similar products get mixed up. Spreadsheets, imports and barcode scanners all need a code to match on.
• No barcode (GTIN): shopping feeds often ask for it, and you cannot scan the product at the packing table.
• Only "Uncategorized": the product is missing from your category pages and menus, so shoppers who browse never meet it.

How to check with plain WooCommerce

On Products → All Products you can:

• sort by SKU, so products without one gather at one end of the list;
• filter by category, product type and stock status;
• scan the thumbnail column for the grey placeholder image.

That works for a small catalogue. It gets hard with variable products: each variation keeps its own SKU, price and image inside the product editor, and the product list does not show them. Another way is to export products to CSV with WooCommerce's exporter and filter the spreadsheet for empty columns. That finds everything, but you still have to fix each product in the admin or import the file back.

Why a WooCommerce product image is not showing

"Product image not showing" has a few usual causes. Check them in this order:

1. No product image is set. Open the product and look at the Product image box. The shop's product cards use this image, not the gallery.
2. A variation has no image of its own. WooCommerce then shows the main product image; if that is missing too, the placeholder appears.
3. Thumbnail sizes were not made yet, for example after a theme change or a large import. WooCommerce can regenerate them in the background, which takes a while on a big catalogue.
4. Caching or lazy loading. A page cache or CDN can serve an old page, and a lazy-loading script can fail. Test in a private window with caching off.

Only the first two are gaps in your product data, and a missing-image filter finds them. The others are theme or hosting questions.

A monthly catalogue check

1. Find products with no price, and fix or unpublish them.
2. Find products with no image, starting with your best sellers.
3. Give every product and variation a SKU. Pick a pattern, such as BRAND-MODEL-SIZE, and keep to it. WooCommerce does not accept the same SKU on two products, so plan the pattern before you start.
4. Add barcodes where your supplier gives you them.
5. Move products out of "Uncategorized".
6. Look at low-stock and out-of-stock products, then reorder or hide them.

Check drafts too. A product saved as a draft months ago goes live with the same gaps on the day someone publishes it.

Product health in StoreRuler

StoreRuler's product list, under StoreRuler → Products, shows one row per product with its variations underneath. Above the list, a row of filters counts the gaps in your catalogue: Out of stock, Low stock, Missing price, Missing SKU, No photo, No category and No barcode. Click one, and the list shows only the products with that gap.

yourstore.com/wp-admin › StoreRuler

The screenshot is from a paid plan, which adds a cost filter and cost and in-store price columns; the other filters are the same in the free version.

The checks look at what a shopper can actually buy: each simple product and each option of a variable product.

• Missing price means no regular price.
• Missing SKU looks at each variation's own SKU. A variation without one borrows its main product's SKU on the product page, so two sizes can show the same code; the filter still counts it.
• No photo counts a variation only when neither it nor its main product has an image, because WooCommerce shows the main image in that case.
• No category means no category other than your default one, usually "Uncategorized".
• No barcode reads WooCommerce's GTIN, UPC, EAN or ISBN field.
• Low stock uses the low stock threshold from WooCommerce's inventory settings.

A status menu next to the search box switches between published products and those that are drafts, pending review, private or scheduled, so you can clean up drafts before they go live.

Fixing the gaps from the list

• Type regular and sale prices right in the list.
• Open the product window to change the name, SKU and barcode. Its table of variations changes the SKUs and prices of every variation together.
• Search by name, SKU or barcode to jump to one product.
• Photos and categories can always be set in WooCommerce's own product editor; the products stay ordinary WooCommerce products.

A change someone else saved in the meantime is never overwritten. Changing many products in one go, with a preview, is bulk editing, which is part of StoreRuler Pro.

Which plan includes it

The product health filters, quick price edits and the product window are in the free StoreRuler plugin on WordPress.org. StoreRuler Pro adds bulk editing and a product readiness check; the pricing page compares the plans. The step-by-step guide is product health, and the product management page shows the rest of the product tools.

Frequently asked questions