Why open bottles disappear from the books
It is Monday morning before the first client. The owner opens the shared acrylic drawer and finds three half-used bottles of the same base coat with no open dates, a pump of cuticle oil that smells off, and a sticky note that says "order more" with no product name and no person responsible. The tech who opened the bottle last week is off. Nobody can say when the bottle was opened, when it should be discarded, or who owns the reorder.
That scene is an original illustration, not a TwoQM client and not a measured result. It shows a common gap in nail salons: retail and service product can look organized on the shelf while open backbar lots have no shared log, so expiration, discard, and reorder become guesses.
TwoQM has already written about salon product usage logged against services for reorder timing (usage tied to tickets), about spa retail product inventory on service tickets (retail vs service stock on the ticket), and about salon backbar deliveries checked against purchase orders and backorders (receiving and PO matching). This article is different. It covers one shared open-bottle / lot log for what is already on the backbar: lot or open date, discard-by date, station that opened it, quantity remaining, named reorder owner, and last check date.
The usual gaps look like this:
Receiving ends at the box. Deliveries get checked against the PO, then open bottles live in drawers with no second record.
Usage logs are not lot logs. A service ticket may show that base coat was used, without saying which open bottle, when it was opened, or when it should be discarded.
Reorder has no owner. "We are low" lives in a group chat. Nobody is named to place or confirm the order.
Checks have no date. A manager sniffs a bottle and puts it back. There is no last-check line, so the next shift starts from zero.
What the shared backbar lot log should show
Build one log line per open bottle or shared lot that stays on the backbar, produced the same way every time a bottle is opened:
Product name. The exact product the team uses on the floor (not a vague brand shorthand).
Lot or open date. Lot number when the bottle shows one; otherwise the date the seal was broken.
Expiration or discard-by date. Follow the label when it states one; otherwise your written salon rule for how long that product stays open.
Chair or station that opened it. So the next tech knows where the active bottle lives.
Quantity remaining. A simple estimate the team agrees on (full / half / low / empty), updated on check days.
Named reorder owner. One person responsible for placing or confirming the reorder when the line hits "low" or discard-by approaches.
Last check date. Who looked at the bottle and when.
Write discard and reorder rules before you automate them
Software cannot invent a discard policy you never wrote down. Before any build, put the salon rules on one page: which products get an open-date log, how long each open category stays in use when the label is silent, who may open or discard a bottle, and who owns reorders. Have your manager review it. The lot log should mirror that page, not invent policy in a spreadsheet formula.
Labeling and complaint context sit outside the log as references, not medical advice. See the FDA pages on cosmetics labeling and how to report a cosmetic product related complaint. Your lot log is an operations tool for open bottles and reorder ownership — it does not diagnose reactions or decide whether a product is safe.
Make the log auditable, not just written once
Open a new line when a new bottle starts. Mark the finished bottle discarded with a date; keep history instead of overwriting.
Run a short check cadence. A named person updates quantity remaining and last check date, and flags discard-by dates that are close.
Separate receiving from open lots. Keep PO and delivery checks on their own board.
Separate usage from lot life. Service usage can still feed reorder timing; the lot log answers which open bottle is active and when it should leave the drawer.
Where software and AI help
Business automation fits when open dates, discard rules, and reorder ownership already exist on paper but live in notebooks and chats. An automated step can create a lot line when a bottle is opened, remind the named reorder owner when quantity hits low or discard-by approaches, and collect a weekly check confirmation. If your tools cannot show open-lot history by station, custom software can provide a small lot board alongside what you already use.
AI integrations can draft a plain-English or Spanish summary of bottles due for check this week, or list products with no named reorder owner. AI does not decide that a product is safe, change discard dates, or place vendor orders without a person.
Where to start this week
Pick one product family that opens often — base coat, cuticle oil, or disinfectant wipe refill — and build lot lines for every open bottle on the floor today. Name one reorder owner. Run one check day. If two techs still cannot answer when a bottle was opened or who reorders it, the gap is in the written rules or the shared log, and that is where to start.
TwoQM builds automation, custom software, and AI-assisted workflows for nail salons. This article describes operations workflows for logging open backbar lots; it is not medical, product-safety, or regulatory advice. Ask your advisors which federal and Texas rules apply to your products and records. Pricing explains how automation and business systems are scoped.
Describe Your Backbar Lot Log Workflow · Explore business automation