Batch and lot tracking for research peptide inventory

The minimum record for every batch

Receiving: record first, sell later

1. When a shipment arrives, create the batch record the same day, with quantity and cost.
2. Label the vials with your batch number before they go on a shelf.
3. Keep the batch in quarantine until its lab report is back and passes your release rule.
4. Record the supplier lot so a retest or a supplier question can be traced both ways.

Landed cost matters more than it looks. If a kit costs $44 and shipping and duties add $6 across ten vials, every vial really cost $5.00, not $4.40. The supplier cost-per-mg calculator works this out and makes suppliers comparable.

Release status is the gate

Three states cover almost everything:

• Quarantine: received, not yet cleared. Counted as stock, not offered for sale.
• Released: report on file from a named lab, passes your minimum, in date. Available to sell.
• Hold: report failed or expired. Off sale until retested or written off.

Only released stock should ever appear as available on your store, in your wholesale catalog or in a quote. If your system shows total stock to buyers, a batch in quarantine will be sold before anyone checks it.

Picking: oldest released batch first

When an order is confirmed, stock should come from the oldest released batch that can fill the line. That keeps older batches moving before their reports lapse and makes every shipment traceable.

• Record the batch on each order line when stock is allocated, not later from memory.
• If one batch cannot fill a line, either split the line across batches and record both, or hold the order until stock is available. Pick one policy.
• Cancelling an order returns the stock to the batch it came from.

Tracing in both directions

Good batch tracking answers two questions in seconds:

• Forward: "Batch LSB-2609-A failed a retest. Who received vials from it?" Every order line that drew from the batch, with customer and date.
• Backward: "A buyer asks about the vial they received." Their order line names the batch, the batch names the supplier lot and the lab report.

Both answers depend on one habit: recording the batch on the order line at the moment stock is taken. Everything else can be reconstructed. That cannot.

Counts and reconciliation

1. Once a month, count one product per shelf and compare it with the batch records.
2. Record adjustments against the batch, with a reason: breakage, sample, recount.
3. Watch days of stock left per product: current released stock divided by average daily sales. Reorder before it drops below your supplier lead time plus testing time.

Labels that make tracking easy

• Print your own batch number on every vial, large enough to read without a magnifier.
• Add a QR code that opens the batch's public page with its lab report.
• Keep the product name, amount per vial and a research-use-only statement on the label.
• Never relabel one batch as another. If you split or combine stock, create a new batch record that points to the originals.

What buyers and processors ask for

Tracking pays off the first time someone asks a hard question. A buyer wants the report for the vial in their hand. A processor asks you to show that the product on an order was tested. A lab result comes back low and you need to know who received that batch. With per-batch records each of these is a two-minute lookup; without them it is a day of reading invoices and guessing.

Setting up tracking from where you are today

You do not need perfect history to start. Pick a date, count what is on the shelf, and group it by the batch printed on each vial. Anything you cannot identify goes into its own record marked unknown, held back from sale until it is tested or written off.

From that date on, every new shipment is received as a batch, every order line records the batch picked, and every count adjustment carries a reason. After one full stock cycle, typically a few months, nearly everything on the shelf will have a complete history, and the unknown record will have been emptied one way or the other.

The same approach works whether you use a spreadsheet or software. What matters is that the rules start on a fixed day and nobody makes exceptions for a busy week.

Returns and damaged stock

Returned vials should never go back into sellable stock by default. Record them against the batch as returned, with the reason, and decide separately whether they can be released again. Most suppliers write returned vials off, because they cannot confirm how the vials were stored.

Damaged stock found at receiving or on the shelf is handled the same way: recorded against its batch with a reason, then removed from the available count. The batch record should always explain every vial that came in: sold, returned, damaged, sampled for testing, or still on hand.

Common mistakes

• Tracking stock per product and not per batch, so a recall means guessing.
• Using the supplier's lot number as your only identifier, then receiving two shipments with the same one.
• Releasing a batch because the supplier sent a report, before your own test is back.
• Adjusting counts without a reason, so shrinkage becomes invisible.
• Selling from a batch while a retest is still pending.

Samples sent for testing

Every vial sent to a lab comes out of a batch. Record it as a sample against that batch, with the lab and the date it shipped, so the count still reconciles and you can see how long each lab takes to report.

Doing it in Purity

Purity records every batch with supplier lot, landed cost and release status, keeps new batches in quarantine until a report passes, allocates stock from the oldest released batch and writes the batch onto each order line. Purchase orders received from suppliers arrive as quarantined batches with costs already filled in, and reports show days of stock left for each product. See it on a demo, or read building a lab report library.