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

Stock that has not sold in a year

Shelves full, order history empty. This stock is money you already spent, sitting in a warehouse and counted as an asset while it earns nothing.

Group
Money
Confidence
H — heuristic
Name on the plugin screen
Stock that isn’t moving
Included in
the Pro add-on, still being prepared
Updated
Code
A8

The symptom

Nothing looks wrong. The product is published, priced, photographed and in stock, often in generous quantity. It simply has not been ordered. Not this quarter, not this year.

This is the one check on the list that finds no defect. Every field is correct. The problem is that the catalog is carrying weight nobody is paying for.

What it costs

With unsold stock you can name the exact amount: the quantity on hand times what you paid for it. That money is spent and can’t be spent again.

  • It counts as an asset and behaves like a cost. You pay for storage, insurance and stocktaking every month it doesn’t move.
  • It crowds out the products that do sell. Slow items take up the same category pages, the same filter results and the same first page of the store.
  • The longer it sits, the less it is worth. Seasonal goods, anything that goes out of fashion and anything with a shelf life lose value on a schedule, whether or not anyone is watching.

How to check it yourself

WooCommerce keeps a lookup table of order lines, so this is a single query rather than a crawl through every order:

wp db query "SELECT p.ID, p.post_title, sm.meta_value AS stock \
  FROM wp_posts p JOIN wp_postmeta sm ON sm.post_id = p.ID AND sm.meta_key = '_stock' \
  WHERE p.post_type = 'product' AND p.post_status = 'publish' \
  AND CAST(sm.meta_value AS SIGNED) >= 10 \
  AND p.post_date < DATE_SUB(NOW(), INTERVAL 12 MONTH) \
  AND p.ID NOT IN (SELECT product_id FROM wp_wc_order_product_lookup \
                   WHERE date_created > DATE_SUB(NOW(), INTERVAL 12 MONTH)) \
  ORDER BY CAST(sm.meta_value AS SIGNED) DESC"

Replace wp_ with your table prefix. The 10 is Merchlint’s default threshold; change it to suit your store. If the query lists nearly every product, the order table may be empty: on a store that was running before WooCommerce Analytics, past orders have to be imported first, under WooCommerce → Analytics → Settings, Import historical data.

The list is sorted by quantity. Multiply by what each item cost you, and the top of the list is where the money is.

How to fix it

There is no single fix, because this is a business decision rather than a technical one. A useful order:

  1. Check that it is unwanted, not unfindable. A product with no category, hidden from the catalog or missing a photo doesn’t sell for reasons that have nothing to do with demand. Rule those out first; they are cheaper to fix than a markdown.
  2. Check that the price is not the reason. Compare it with what the same product costs elsewhere.
  3. Then choose: discount it, bundle it with something that does sell, move it out of the main catalog, or write it off. All four are answers; leaving it is not.

When it’s a false alarm

This check is a heuristic, and it has more legitimate exceptions than any other on the list:

  • Seasonal stock in the off-season.
  • Spare parts and consumables kept on hand for existing customers, where the point is having them, not selling them fast.
  • Safety stock for a product that sells mainly through another channel.
  • B2B catalogs where one order a year is a normal pace and a good year.

How Merchlint finds it

Merchlint takes every published product that has stock management turned on and at least 10 units in stock, then checks the order lookup table for any order of it in the last twelve months. Products added within those twelve months are left out, because they have not had a full year to sell. The threshold of 10 units can be changed. On a multilingual store, a sale of any translation counts for the whole product.

The finding shows the quantity in stock, the threshold, and the date from which no order was found. It shows no amount: Merchlint does not know what you paid for the stock.

If the order table is empty, the check does not run, and the report says so. Otherwise every product with stock would look unsold.

Confidence: H—heuristic. The absence of orders is a fact; calling it a problem is a judgment, and the exceptions above are real. Treat it as a list worth reading, not a list to act on line by line.

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