Merchlint
Available now
Next, in this order
  • DeutschDE
  • EspañolES
  • FrançaisFR
  • ItalianoIT
  • PortuguêsPT
  • NederlandsNL
  • SvenskaSV
  • TürkçeTR

A language shows up here once its pages are actually written. Nothing on this site is machine-translated, except a few German and Spanish pages that no native speaker has reviewed yet.

Install free Install
← All checks

Every variation is out of stock

The product looks buyable in the category, ranks in search and takes ad spend—and then no combination the customer picks can be added to the cart.

Group
Catalog
Confidence
F — fact read directly from your store
Name on the plugin screen
Every variation sold out
Included in
the free plugin
Updated
Code
B5

The symptom

In the category listing the product looks normal: photo, name, price range. The customer clicks through, picks a size and sees Out of stock. They pick another. Same. They work through every option in the dropdowns, and none of them can be bought. If they click Add to cart anyway, WooCommerce answers “Sorry, this product is unavailable. Please choose a different combination.”

Nothing warned them before the click. Many themes show no stock status in the category grid. And if the product’s own stock status has drifted out of sync with its variations, for example after an import, the product still reads as in stock everywhere else.

What it costs

This is worse than a product being hidden, and that is the part people underestimate.

  • It keeps getting visits. It still ranks in search, it can still sit in a category, and it can still be in a paid campaign. Every one of those visits ends in a dead end.
  • It costs trust, not just the sale. A customer who works through four dropdowns and finds nothing available does not conclude “out of stock”. They conclude the store is broken, and that judgment applies to the whole store.
  • It is easy to miss in stock reports. They list each variation on its own line, so “every variation of this product is gone” never shows up as one line. And if the product’s own status is out of sync, the product itself still reads as in stock.

How to check it yourself

The query below finds published variable products that have variations, where none of the variations is instock:

wp db query "SELECT parent.ID, parent.post_title
  FROM wp_posts parent
  WHERE parent.post_type = 'product' AND parent.post_status = 'publish'
    AND EXISTS (SELECT 1 FROM wp_posts v
      WHERE v.post_parent = parent.ID AND v.post_type = 'product_variation')
    AND NOT EXISTS (SELECT 1 FROM wp_posts v
      JOIN wp_postmeta sm ON sm.post_id = v.ID AND sm.meta_key = '_stock_status'
      WHERE v.post_parent = parent.ID AND v.post_type = 'product_variation'
        AND v.post_status = 'publish' AND sm.meta_value IN ('instock','onbackorder'))"

Replace wp_ with your table prefix. onbackorder is deliberately treated as available: a made-to-order store where everything is on backorder is working exactly as intended, and reporting it would be noise.

In the admin, go to Products, choose Variable product under Filter by product type and Out of stock under Filter by stock status. That filter reads the product’s own status. It finds the usual case, where WooCommerce has already marked the product out of stock, but not a product whose status has drifted away from its variations.

How to fix it

You have four options and only one of them is “do nothing”:

  1. Restock, if the goods are coming back soon.
  2. Enable backorders on the variations, if you can actually fulfill them.
  3. Let the product show as out of stock. A variable product has no stock status field of its own: open it and click Update, and WooCommerce recalculates the status from the variations (unless you manage stock at the product level). With Hide out of stock items from the catalog checked in WooCommerce → Settings → Products → Inventory, it also leaves the category pages. This is the honest minimum.
  4. Hide it from the catalog if it is not coming back. It keeps its URL, so links to it still work, but it stops taking up a slot in the category.

What to avoid: deleting the product. It usually still has order history, and deleting it makes past orders harder to read.

When it’s a false alarm

  • Seasonal stock you keep visible on purpose—skis in July, with a “back in the fall” note on the page. Deliberate; hide the finding and it stays hidden across scans.
  • Pre-orders handled by a plugin that manages availability outside _stock_status.
  • A variable product with a single variation you are about to publish. Transient state during setup.

How Merchlint finds it

Merchlint reads the stock status of every variation of every published variable product. It reports the product when it has at least one variation and none of them is in stock or on backorder. A switched-off variation does not count as available, because a customer cannot pick it. The finding shows how many variations the product has, how many are available (none), and the product’s own stock status. That last one tells you whether WooCommerce has already marked it out of stock or whether its status has drifted.

Confidence: F—fact from the database. Every variation’s stored status is read; nothing is inferred from the storefront.

The finding carries no revenue figure. If the product is one of your best sellers, it also shows up under Where to start at the top of the audit.

Run this check on your store

Doesn't match what you see in your store? Email us—we read every message. contact@merchlint.com