A volume match is not a product match
On this page13
Capacity is the field everything is indexed on
Which makes it the field most likely to produce a shelf that looks right and is not. Here it produced 145 of them.
What capacity cannot tell you
Whether a container holds pressure, takes a hot fill, resists a solvent, passes light, or accepts the closure the category uses. All of those decide the outcome.
Pressure is the one that matters here
And it is not a field we hold at all. There is no pressure rating in our data, so no amount of filtering would have caught this.
Which makes it a data gap underneath a shelf gap
The hazmat property has the same shape: the defining attribute of the category is not a field we record.
The closure family name is the available proxy
Crown, swing top, cork, champagne, can end. Searching for those catalog-wide is how this property established the answer, and it took one query.
So run the query against the catalog, not the shelf
Which is the transferable lesson. A curated shelf cannot tell you whether something is absent or merely outranked.
Three different answers look identical from the shelf
We do not hold it, we hold it and do not index it here, or we hold it and do not record the field that identifies it. The beer group has all three.
And the fix differs completely in each case
A purchase order, an index change, or a new field. Which is why the diagnosis is worth publishing rather than just the conclusion.
For this group the answer is a purchase order
Crown caps, crown-finish bottles, and a can line if crowlers are wanted. None of it is an index problem.
And the same query is worth running before every build
Search the catalog for the closure family the category actually uses, rather than filtering containers by volume. It is one query and it produces the answer in full.
Volume matched on 145 rows and the closure matched on none
Which is the ratio to remember. The field everything is indexed on agreed completely, and the field nobody indexed on disagreed completely.
Until then this is a refusal
Stated at the top of the property rather than discovered after a search, which is the only honest way to publish it.