Lots and expiration dates
3 min read
Most items only need one expiration date. A box of gauze is a box of gauze.
Injectables are different. You might hold four vials of the same product from three different lots, expiring months apart, and you want to reach for the one that expires first. That is what lot tracking is for.
This is a Clinical plan feature.
When to turn it on
Turn it on for a product when you hold more than one lot at a time and the dates matter. Toxins, fillers, threads, lab reagents, anything with a lot number printed on the box that you care about.
Leave it off for everything else. Gloves, gauze, prep pads and retail skincare are simpler without it, and nothing changes for items that leave it off.
Turning it on
- On the Admin page, find the item in your Items list.
- In the Clinical column, click the settings button on that row.
- Check Track lots and expiration separately and save.
The item now shows a LOTS badge, and in Inventory Levels it gains a + Lot button.
Adding a lot
Click + Lot and enter the lot number, the expiration date, and how many units are in that lot.
You will see a checkbox: take this from the unassigned units. This matters, so it is worth understanding rather than guessing.
When you turn on lot tracking for an item that already has stock, that stock sits on a row marked "No lot recorded". It is still yours, it just has no lot attached yet. Leaving the box checked moves units from that row into the lot you are adding, so your total stays the same and the unassigned number counts down as you record each lot.
Uncheck it when a new shipment has actually arrived and you are adding stock rather than labelling stock you already had.
Keep going until the unassigned row reaches zero and disappears. Then every unit you have is in a lot.
What changes afterwards
Your lots sit indented under the product, soonest to expire at the top. The item keeps one name, one threshold, and one spend line, so nothing is split across four entries.
Low stock alerts read your total across every lot, not one lot at a time.
Expiration alerts read each lot's own date, so a lot expiring in three weeks gets flagged even if the rest of your stock is good for a year.
Deducting
Your team taps minus on the lot they pulled from. The soonest to expire is at the top, which is where they should be pulling from anyway.
For items set to log every use, the popup that appears asks the quantity used, prefilled and ready to type over. Enter the units for that treatment, add the initials, and exactly that amount comes off the lot.
Fixing a lot after the fact
Typed the wrong lot number, or forgot the expiration date? Click the lot line itself in Inventory Levels. A small window lets you correct the number and the date. Counts do not change there, only the label, and the change is recorded in the activity log.
If you have been using separate items
Some clinics work around this by creating Botox 1, Botox 2, Botox 3 and so on. That works, but it splits your spend and usage across four entries, and your threshold only ever sees one of them.
To consolidate: pick the entry you are keeping, turn on lot tracking, then add each lot. For the lot whose units are already counted on that item, leave the checkbox checked. For units sitting on the other entries, uncheck it so they add. Once everything is in lots, archive the extra entries.
Do the lots first and archive last, or you will be hunting for numbers you can no longer see.
One tip: if your old entries carried the lot number in the item name or the SKU field, that is the number to enter in each + Lot box. Most clinics that used the separate-items workaround stored it in one of those two places.