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.
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”:
- Restock, if the goods are coming back soon.
- Enable backorders on the variations, if you can actually fulfill them.
- 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.
- 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.
Doesn't match what you see in your store? Email us—we read every message. contact@merchlint.com