What a milliliter search misses
On this page11
This is where the conversion stops being a curiosity
A buyer thinking in milliliters asks for 250. This shelf has two rows at exactly 250 milliliters.
Widen the question slightly and the answer changes completely
Anything between 225 and 275 milliliters returns 57 rows. Forty seven of those are 236.588, which is eight fluid ounces and sits 5.4 percent under the figure asked for.
So an exact search returns less than four percent of the real answer
Two rows against fifty seven. Not because the shelf is thin at that size but because the shelf was specified in a different system.
The same thing happens at every round figure
Exactly 500 milliliters returns two rows and 450 to 500 returns 33. Exactly 100 returns two and 90 to 130 returns 48.
Which is a usability fact rather than a data fault
Every number in the column is correct. The problem is that a search for an exact value assumes somebody chose that value, and on 215 of 238 rows nobody did.
The fix is to search a band and not a figure
Plus or minus ten percent recovers the eight ounce rows from a 250 milliliter question and the sixteen ounce rows from a 500 milliliter one. A tighter band silently drops most of the shelf.
And the system a row was recorded in does not follow the material
All 71 polypropylene rows are in ounces. PET is 104 in ounces and 13 in milliliters. Glass is 40 and 10. So there is no shortcut that predicts which rows are converted.
Nor does it follow the size
The native milliliter rows run from 15 to 500 and the ounce rows from 22.18 to 473.176. The two systems overlap across almost the whole range of the shelf.
Which means the only reliable guide is the recorded unit string
A separate field, holding oz, ml or cc. It is the field that answers the question and it is not the field anybody sorts on.
That is the shape of most useful findings on these shelves
The number is right, the column is populated, and the thing worth knowing lives next to it. On this shelf it is a unit. On another it is whether a weight is per unit or per case.