Vial Workspace Buy a license Download free trial

How to track peptide lots and COAs

Traceability is the question a research-peptide seller eventually has to answer: which lot did this customer get, and where is its certificate of analysis? Here's a setup that answers it in seconds, with or without software.

Updated November 2026

1. Give every lot its own record

One row per lot, not per product. At minimum: lot number, product, vials received, day received, what it cost (including shipping and testing), manufacturer's lot number and expiry date. Two lots of the same product are two records, because they can test differently.

2. File the COA on the lot, the day it arrives

Save the certificate with the lot number in the file name, in one place, and note its key results on the lot record: identity, purity and content. A COA that lives only in an email thread can't be found when a customer asks for it.

3. Hold a lot until its results check out

Mark a new lot as quarantined until you've read its certificate. Only then release it for sale. If a result is missing, fails, or purity is lower than expected, it stays held and you know why.

4. Record the lot on every order line

This is the step most spreadsheets skip, and the one that makes the rest useful. When an order ships, each line should name the lot it came from. Then you can answer both directions: which lot went to this customer, and which customers received this lot.

5. Sell the oldest stock first

Picking the oldest lot that has stock (first in, first out) keeps expiry under control and makes each lot's sales easy to follow. A lot nearing its expiry date should be flagged before it's sold, not after.

6. Keep a movement log

Every vial that leaves a lot should leave a trace: sold, returned, written off as damaged, used in testing. When the count on the shelf doesn't match the record, the log tells you where to look.

Where a spreadsheet stops working

Steps 1 and 2 work in a spreadsheet. Steps 4 to 6 are where it breaks down, because every order has to update stock, lot and log by hand. Vial Workspace does them as part of taking the order: it picks the lot, reads the COA's results from the PDF for you to check, and keeps the log.

Questions

Do I need the COA for every lot, or just every product?

Every lot. A certificate describes one batch: the next lot of the same product can test differently.

What should I do if a COA result fails?

Keep the lot quarantined, don't sell from it, and take it up with the manufacturer. Record what you decided on the lot so the reason stays with it.

More on this: COA management.

Try Vial Workspace with your own records

Every feature is on for 14 days, with no card or account needed. After that, Standard is $299 a year and Pro is $599 a year, with no automatic renewal.

Download for Windows Download for Mac Compare editions

More guides

Vial Workspace is record-keeping software for research-use-only businesses. We don’t make, sell or ship peptides or any other product. Nothing here is tax or legal advice.