Ztrategies

Strategizing Your Daily Dose of Info

The Expiry Date That Travels: Copying Vial Data into a Multi-Site Laboratory Inventory

The Expiry Date That Travels: Copying Vial Data into a Multi-Site Laboratory Inventory

In a collaboration spanning two or three laboratories, the vial is the source of truth and the inventory is the record — and the two drift apart the moment somebody types a date by hand. Copying the expiry from a vial label into an inventory field looks like the smallest task in the chain. In practice it is the step that decides whether a batch is scheduled correctly, quarantined on time, or quietly mis-recorded until an audit asks an awkward question.

Begin at the Vial Label, Not at the Spreadsheet

Every expiry date in a laboratory inventory starts life as ink on a vial. On Research Sciences products, the label reference combines the SKU code and the expiry date — for example BPC10-03/27 — and that reference links to the corresponding certificate of analysis. The structure is helpful: it gives a receiving technician two facts in one string and a documented route back to the batch record. It also creates two easy ways to corrupt the record, namely shortening the code to the product nickname or transposing the month and the year.

Copy Verbatim First, Interpret Second

The first discipline is to copy the label reference exactly as printed into a dedicated field before any interpretation happens. A separate, normalised expiry field in YYYY-MM format can then be derived from it. Keeping both prevents the most common multi-site failure: one site reading 03/27 as March 2027, another reading it as 27 March 2027, and neither able to prove which was intended six months later. Where the printed string is genuinely ambiguous, it should not be guessed at — the vial belongs in quarantine and the supplier should be contacted quoting the reference, which is the route the label guidance on the Research Sciences site describes.

Second, expiry must never be inferred. Order date, dispatch date and delivery date are not expiry data. Research Sciences states that orders are dispatched the next working day via Royal Mail Tracked 24, which the shop describes as usually delivering the following working day, but those are fulfilment estimates and say nothing about the stability date printed on a vial. Nor should cap colour stand in for identification: the shop’s FAQ notes that vial cap colours and other packaging may vary and are not an indicator of identity, analytical quality or manufacturing origin.

Third, an illegible label is a finding rather than an inconvenience. Record the condition, photograph the vial, quarantine it and request replacement documentation. All materials are supplied strictly for controlled laboratory and analytical research and are not for human or veterinary use, so a vial whose expiry cannot be read has no defensible place in a compliant workflow.

Specify the Field Before the Second Site Joins

A collaboration does not need identical software at every site, but it does need identical field definitions. Before a second site is onboarded, agree the minimum record: an internal vial or aliquot identifier, the catalogue SKU, the label reference exactly as printed, the normalised expiry, any internal test reference quoted on the pack, the associated CoA file name, the storage class, the date the vial was opened or reconstituted, the site code and the named custodian.

Two Fields That Deserve Special Care

The storage class should be a controlled value rather than free text: lyophilised stock held at −20 °C or below, sealed with desiccant and protected from moisture, heat and light, versus a reconstituted in-vitro working stock held at 2–8 °C for short-term laboratory use, as the handling guidance sets out. Free text turns that into twenty variations and no queryable record.

The internal test reference, where one appears, should be recorded but not misused. The shop’s FAQ explains that restocked products may carry the same ITR as earlier stock, that an ITR links to associated sample testing reports, and that it does not confirm separate deliveries come from the same production lot or have been separately independently tested. It is a documentation breadcrumb, not an expiry proxy and not a lot number.

Aliquots Inherit Dates; They Do Not Acquire Them

Sub-aliquots are where expiry copying goes wrong most often. A daughter aliquot inherits the parent vial’s expiry; it does not gain a new one when it is divided, and it does not reset when it moves between freezers. Where several sites draw from a shared catalogue — materials sourced through Peptides uk, for instance — the SKU prefix carries the same meaning at every bench, which is precisely why it should be entered as structured data rather than absorbed into a local nickname. Finally, print secondary labels from the inventory record rather than writing them by hand: typing the date once and generating every downstream label from that single entry removes the second transcription step where most errors enter.

Reconcile Monthly and Treat Every Mismatch as Evidence

A field specification only holds if it is exercised. A short monthly reconciliation — shelf against inventory export, site by site — will surface the mismatches that matter: vials approaching expiry with no planned use, records carrying a month but no year, aliquots with a date but no parent reference.

Resolving a Discrepancy Between Two Sites

Handle mismatch as evidence rather than error correction. When one site records a vial as expiring 03/27 and another as 27/03, the right response is not to pick the more plausible entry. Retrieve the vial, read the printed reference, open the CoA that accompanies that specific batch, and correct the record with an audit note stating which source resolved it. Dual authorisation on changes to expiry fields costs a few seconds and makes the trail defensible. A discrepancy log that captures root causes — ambiguous printing, split shipment, hand-typed label, mis-keyed month — converts recurring faults into a training list.

The same discipline applies to documentation requests: quoting the label reference gives the supplier an unambiguous route to the record. Published figures such as the homepage lines of ≥99% verified purity, or ‘over 99.1% purity’, are the shop’s current published wording at the time of reading and should be reconfirmed on the live site; for study planning, take any specific purity figure from the batch CoA rather than from marketing copy.

For reconstituted in-vitro stocks, log the diluent volume and the resulting concentration alongside the preparation date, because a 2–8 °C short-term window only means something when paired with how the stock was made. The free reconstitution calculator described on the site is a laboratory aid for that arithmetic and, like the materials themselves, is not for human or veterinary dosing.

Expiry review should sit on a calendar with a named owner at each site, alongside storage checks and documentation re-verification. The purchaser remains responsible for lawful use, safe handling, storage and disposal, and for compliance with COSHH and laboratory safety standards. Every downstream record carries the same footer of obligation: research-use-only materials, not for human or veterinary use.