The Field That Changes Your Ordering Behavior
Reorder? is a boolean. One toggle. It sounds trivial alongside the 75-item Predominant Flavors taxonomy and the detailed VG ratio options. It is not trivial. Every juice in your collection that hits the 1/3 or 1/4 stock mark without a Reorder? flag set is a juice you're about to run dry on without warning.
The pattern that emerges after a few months of using this library honestly is that you have a mental model of your stock levels that's always two weeks behind reality. You think you have a 60ml of that mango-peach dessert at half-full. You actually decanted most of it into the tank last week and there's maybe 15ml left. The Reorder? flag, when you update it at the same time you update the Stock field, creates an actionable queue rather than a vague sense of what you might be low on.
The Specificity of the Stock Field
Stock is a multi-choice field combining bottle count and fill level: 1X, 2X, 3X for quantity, combined with fill level markers from Full down through 4/5, 3/4, 2/3, 1/2, 1/3, 1/4, 1/5, 2/5, 3/5, and NONE. The combination means you can represent "I have one 60ml bottle at roughly half remaining" as two selections: "60ml" and "@ 1/2". This is a better model than a single number because it mirrors how you actually interact with e-juice — you're not measuring in milliliters at the bottle, you're approximating visually against the fill window.
VG Ratio and Vape Type are the hardware-compatibility layer. A 70% VG Sub-Ohm juice in an MTL pod running a 1.0 ohm coil is going to wick poorly and taste awful. The VG ratio tells you which of your rigs this juice is actually compatible with — which is exactly why this library links to the Vape Rigs library. When you're standing in front of the shelf at the shop deciding whether to grab a second 60ml of a new dessert juice, the VG ratio is what determines whether it works in your current hardware lineup.
Throat Hit as a structured choice — None, Light & Smooth, Medium, Strong, Perfect — is a quality descriptor that reads differently depending on nicotine content and formulation. A nic salt at 35mg with a "Light & Smooth" rating means something entirely different than a freebase at 06mg with the same rating. Reading both fields together tells you what the actual experience is going to be, not just the chemistry on the label. The Notes field is where you capture anything those structured fields can't hold: the specific batch variation, where the flavor falls in the finish, how it pairs on a particular coil type.
Finding the Right Juice Before You Buy Another Bottle
You're at 1/4 on the raspberry-lemon nic salt. You remember there was a similar profile from a different producer you tried and rated four stars but can't recall the name. Filter: Juice Type = Fruit, Predominant Flavors includes Raspberry + Lemon + Sour, Rating = 4 or 5 stars.
Two results. One is already flagged for Reorder. The other you bought from a specific shop on sale and the Last Purchased From field has the source. You're ordering from that shop this week anyway.
The Flavor Profile richtext field is where real tasting notes live — not just what the label claims, but what you actually taste across different tanks and coil configurations. That field is the most valuable one in the database after the first six months of actual use.