Lot tracking sheet that actually gets used

If the sheet is painful, nobody updates it. Keep columns boring and few. Columns that earn their keep • Product name • Store product URL or short slug • Lot or batch (exact string) • Qty received • Qty remaining • Received date • Storage location • COA file name or path • Notes Habits • New lot = new row. • Change qty remaining; never invent a “merged” lot. • Export a CSV backup monthly. • Put the order prefix in notes when multiple orders share a week. You do not need a LIMS on day one. You need rows you can still understand in six months. — Dane