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

A variation with no price, or no SKU

The product looks priced and ready to buy on the category page. One combination inside it is not, and nothing tells you until a customer picks it.

Group
Money
Confidence
F — fact read directly from your store
Name on the plugin screen
Variations with no price or code
Included in
the Pro add-on, still being prepared
Updated
Code
A6

The symptom

The category page shows a price range, say “$49 – $79”, and the product page looks normal. The customer picks Blue / XL and gets a message such as “Sorry, no products matched your selection. Please choose a different combination.” As far as WooCommerce is concerned, that combination does not exist. The store never tells you; the customer just gets a polite dead end.

The missing-SKU version is quieter still. The variation sells fine; it just can’t be matched by anything outside the store.

What it costs

A variable product shows the price range of its variations. The range is worked out from the variations that do have a price, so a broken combination never changes it and never shows up in the listing:

  • The product ranks and takes ad spend on a combination it cannot sell. The visitor arrives for the size they searched for and can’t buy it.
  • A variation with no price quietly drops out. WooCommerce treats an empty _price as “not purchasable” and hides the variation. There is no warning in the admin, and the customer only sees a message asking them to pick something else.
  • A variation with no SKU can’t be matched outside the store. Stock sync, warehouse pick lists and product feeds usually match on SKU, and a blank one gives them nothing to match on.

The bigger the variable product, the better it hides this. On a product with forty combinations, nobody clicks through all forty.

How to check it yourself

Variations with no price:

wp db query "SELECT p.post_parent AS product, p.ID AS variation \
  FROM wp_posts p LEFT JOIN wp_postmeta m ON m.post_id = p.ID AND m.meta_key = '_price' \
  WHERE p.post_type = 'product_variation' AND p.post_status = 'publish' \
  AND (m.meta_value IS NULL OR m.meta_value = '')"

The query skips switched-off variations (their Enabled checkbox is unchecked), as Merchlint does. The same query with '_sku' in place of '_price' lists variations with no SKU of their own. Those only matter when the parent product has no SKU either, because otherwise WooCommerce shows the parent’s SKU on them. Replace wp_ with your table prefix.

In wp-admin the equivalent is opening the product, expanding every variation and reading each price field. That works for one product and is hopeless for a whole catalog.

How to fix it

  1. Decide whether the combination should exist at all. Most empty variations are leftovers from an attribute value that was renamed or deleted. Those get removed, not priced.
  2. If it should exist, set the price on the variation itself. WooCommerce does not inherit prices from the parent product.
  3. For a missing SKU, follow whatever scheme the rest of the catalog uses. A blank SKU is only safe if nothing outside the store uses SKUs at all.
  4. If you changed prices directly in the database, or with an import that bypasses WooCommerce, regenerate the product lookup tables afterward so that price filters and sorting see the new prices (WooCommerce → Status → Tools → Product lookup tables, or from WP-CLI):
wp wc tool run regenerate_product_lookup_tables --user=1
  1. If an import created the variation, fix the import. Otherwise it comes back on the next run.

When it’s a false alarm

  • “Price on request” setups. Some B2B stores leave the price empty on purpose and replace the Add to cart button with a contact form. That is a design, not a defect.
  • Variations priced at runtime by a bundle, subscription or configurator plugin that fills in _price only when the cart is built.
  • A store that does not use SKUs. If no product has one, an empty SKU tells you nothing and the finding is noise. Hide it once and it stays hidden.

How Merchlint finds it

Merchlint starts from products that sold over the past twelve months, because a combination nobody can buy costs the most where the product earns, and reads _price and _sku for each of their variations, skipping the ones that are switched off, because a customer cannot pick them. It reports a variation with no price, which cannot be bought, and a variation with no SKU only when the parent has none either, because a variation without its own SKU shows the parent’s. Products whose sales earned nothing in the period (sold only at a price of 0, or every sale refunded) are skipped.

There is one finding per product, not one per variation. It shows how many variations the product has, how many have no price and how many have no SKU, so you see “Baltic wool throw: 12 variations, 3 with no price”, not twelve separate lines.

Confidence: F—fact from the database. The field is empty or it is not. No threshold, no interpretation.

This check is part of the Pro add-on, which is still being prepared. The free plugin does not run it.

Install free

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