Inventory management

Batch tracking in inventory: a small business guide

For shops that sell medicines, food, or anything with an expiry date, knowing how much stock you have isn't enough — you need to know which batch it came from and when it expires. That's what batch tracking does. This guide explains what batch and lot tracking is, why it matters for expiry and recalls, the difference between FEFO and FIFO, and how a small business can start without an enterprise system.

What batch tracking is

Batch tracking — also called lot tracking — records inventory in groups that share a common attribute, most often a manufacturing or expiry date and a supplier batch number. Rather than treating every unit of an item as interchangeable, you can tell which batch any unit belongs to. That single capability unlocks expiry management, recall handling, and proper stock rotation.

Why it matters: expiry

The biggest reason small businesses track batches is expiry. A medical shop or grocery store carries the same product across multiple batches with different expiry dates. Without batch tracking, older stock gets buried behind newer stock and expires unsold — a direct loss. Batch tracking surfaces what's expiring soon so it sells first, turning potential write-offs into sales.

Why it matters: recalls

When a manufacturer recalls a product, they recall a specific batch — not every unit ever made. A shop without batch records has to pull all stock of that item to be safe, losing saleable goods. With batch tracking, you isolate exactly the affected batch, remove only those units, and keep the rest on the shelf. For regulated goods, this traceability is often a legal requirement.

FEFO vs FIFO

Two stock rotation methods matter here:

  • FIFO (First In, First Out): sell the oldest-received stock first, by arrival order.
  • FEFO (First Expired, First Out): sell the soonest-to-expire stock first, regardless of arrival.

For dated goods, FEFO is safer — a batch received later might expire sooner. Batch tracking is what makes FEFO possible at all, because you can't sell the earliest-expiring batch if you can't tell batches apart.

Who needs it most

Batch tracking earns its place wherever goods are perishable, dated, or regulated:

  • Pharmacies and medical shops managing drug expiry.
  • Grocery and food retailers with perishables.
  • Cosmetics and supplement sellers with shelf-life limits.
  • Chemical and industrial suppliers needing traceability.

How to start simply

You don't need a complex system to begin. Record the batch number and expiry date when stock arrives, store and shelve by expiry so the soonest-expiring is reachable first, and review upcoming expiries regularly. A spreadsheet can do this at small scale, though it gets unwieldy as batches multiply.

StockMitra is being built with batch and movement logging in mind, so small shops can manage expiry and rotation without enterprise complexity.

Frequently asked questions

What is batch tracking in inventory?

Batch tracking, also called lot tracking, records inventory in groups that share a common attribute such as a manufacturing date, expiry date, or supplier batch number. Instead of treating all units of an item as identical, you can tell which batch a unit came from. This is essential for managing expiry, handling recalls, and ensuring older stock sells first.

What is the difference between FEFO and FIFO?

FIFO (First In, First Out) sells the oldest received stock first based on arrival order. FEFO (First Expired, First Out) sells the stock that expires soonest first, regardless of arrival. For perishable or dated goods like medicines and food, FEFO is safer because a later-arriving batch may expire before an earlier one. Batch tracking makes FEFO possible.

Which businesses need batch tracking?

Any business handling perishable, dated, or regulated goods benefits most — pharmacies and medical shops, grocery and food retailers, cosmetics sellers, and chemical or supplement suppliers. Batch tracking lets them manage expiry, comply with regulations, and respond to recalls by isolating exactly the affected batch rather than pulling all stock of an item.

Can I do batch tracking in a spreadsheet?

Yes, at small scale. Record batch numbers and expiry dates as separate rows, and sort or flag by expiry. It works for a limited number of batches, but becomes hard to maintain as the same item spans many batches and movement increases. At that point a phone-first app that logs batches and expiries reduces the manual effort and error.