How to track inventory in a small store

You do not need complex software to know what you have. You need one rule applied daily: everything that comes in and goes out gets recorded, and the unit is what you actually sell, not what you call it. This guide explains the rule and how to apply it in a small store.

Illustrative preview
01Start with a customer question
02Connect the customer and product
03Record the order and sale
04Update inventory with what sold and what remains
05Follow up and review performance
Sales journeyIllustrative

Why inventory tracking fails in small stores

Three causes repeat. First: the unit is not defined, so the product is recorded as a whole while it sells by size. Second: recording is late, so the owner sees a number that does not match the shelf. Third: numbers are spread across a notebook, a cashier, and chats, so each place tells its own story.

The result is that counting becomes a surprise: what you thought was there is gone, and what you thought was slow has sold out. The cure is not more expensive software, it is a clear definition and movement recorded on time.

Step 1: define the unit before anything else

A blue shirt in size M is not the same as a blue shirt in size L, nor the same as the navy one. If you write blue shirt: twenty pieces, you know a number but not an answer. The question you will get tomorrow is: do you have size L in blue? The total cannot answer it.

The unit is the smallest thing you sell separately: the product with its option. In clothing: the item, the size, and the color. In shoes: the model and the size. In skin care: the bottle by volume. Sit down once and write your units, then use the same naming everywhere, in the listing, in the chat, and in the record.

Step 2: five columns are enough

You do not need a sheet with twenty columns. Five are enough to start: the unit name, the current quantity, the minimum level, the last movement and its date, and a short note. The last column is the most neglected and the most useful, because it holds the reason for an adjustment, the supplier name, or a packing note.

If you use a spreadsheet, make one row per unit, not per product. Build the name in the same order every time: item, then color, then size. A fixed order prevents the same unit appearing twice in two spellings, a mistake that consumes search time and spoils totals.

Step 3: record only three movements

  • In: goods arrived from the supplier. Record the actual quantity, not the ordered one, and if it came short write the difference the same day.
  • Out: a sale. Each sale deducts from its own unit, meaning the specific size and color.
  • Adjustment: damaged, lost, or returned, with the reason written in a word or a sentence.

Every movement needs a date. The date is what later lets you ask: what happened this week? Without a date the record becomes a single picture, and a picture does not tell movement.

Step 4: deduct at agreement, not at delivery

The most common cause of double selling is late recording. If you deduct at delivery, the quantity you see during a chat is stale, and you may promise a customer an item a colleague sold a minute ago.

Deducting at confirmation means the quantity is reserved. If the customer cancels, return it with a recorded adjustment and the reason. This keeps the equation clear: what you see is what you can sell now.

Step 5: minimum levels without magic numbers

The minimum is the quantity at which you reorder. No single number fits everyone, but there is a way to reach yours: take your supplier lead time, add a margin for the days they usually run late, then work out how many of that unit you sell in that window.

Example: a supplier delivers in ten days, and the unit sells about three pieces a week, so expected sales in that window are about four or five pieces. Set the minimum at five or six, then adjust after three weeks against reality. The first number is an estimate, the number after a month is experience.

Do not set a minimum for everything on day one. Start with the fastest movers, because running out of them costs you a real sale, while a delayed slow item costs you nothing.

Step 6: count, do not guess

  1. Pick a quiet time and pause selling while counting if you can.
  2. Count the units by hand, by size and color, not from memory and not from the supplier invoice.
  3. Compare with the number in the record and log any difference as an adjustment with a reason.
  4. If the difference keeps recurring on one unit, look for the cause: a recording error, unrecorded damage, or something else worth reviewing.

For small stores, a weekly partial count of the fastest movers and a full count monthly is enough. A full count every day wastes time, and an annual count alone comes far too late.

A worked example: a clothing store and three events

Example: one unit, a white linen shirt in size M, has six pieces in the record, and the minimum is three. A single day brings three small events.

  1. First order: two pieces of that unit. Four remain.
  2. Second order: one piece. Three remain, which is the minimum, so the supplier order is written that same day, not when the shelf is empty.
  3. A return from another unit, a white shirt in size L: it goes back to its own unit, not to size M. Mixing them here is common and spoils both numbers.

Then the count comes at the end of the week and finds two pieces of M on the shelf instead of three. The difference is one piece, unrecorded damage. An adjustment is written with the reason damage, so the number becomes two, which is below the minimum, and the next action becomes obvious: reorder, or stop promising that unit until it arrives.

Notice that nothing exceptional happened that day. Three small events, and the number still moved from six to two, and the decision moved with it. That is what tracking means: a decision that changes with the number, not a number written down for the record.

Step 7: read movement, not just quantity

Quantity tells you what you have, movement tells you what to do. A unit with twenty pieces may be excellent if it sells, and a problem if it has not moved for two months, because money is trapped in it.

Compare sales across two periods for the same unit, and ask two questions: what moves fast and needs reordering? What has not moved and needs a decision? The decision may be a promotion, a bundle with another product, or stopping the purchase in the next order. The third is the hardest and the most useful.

Common mistakes and how to fix them

  • Recording the product as a whole instead of by unit: start now by separating the sizes that actually sell, and leave the rest in one row for the moment.
  • Postponing the deduction to the end of the day: deduct at confirmation. If you cannot, write the order in a draft and finish it before closing.
  • Returns with no reason: one word, size, defect, or changed mind, is enough.
  • Copying numbers by hand between a notebook and a cashier: manual copying is the biggest source of errors, and the fix is one stock number everyone reads.
  • Treating the supplier invoice as the record: the invoice says what you ordered, not what you received. Record what actually arrived.
  • Different names for the same unit: white shirt M and white linen shirt medium become two items in the record and one unit in reality. Fix the naming.
  • Buying slow items because they are cheap: a low price does not justify piling stock, especially when capital is limited.

If this happens, do that

  • If the count never matches the record on one unit, the problem is recording, not theft. Review who sells that unit and when they write it down.
  • If goods arrive short, log the difference as an adjustment with the reason supplier shortfall, and claim it the same day with a photo of the invoice.
  • If a unit runs out faster than expected, do not only fix the number, raise its minimum level.
  • If units look very similar, such as the same color under different brand names, use a short code per unit, or a card with a QR code.
  • If your business is a service or tailoring, stock sits on materials, not on the finished piece. Define the unit by what it actually consumes.
  • If you sell from more than one place, the rule is the same: one shared number, and each movement recorded once.
  • If you do not know where to start, pick ten items only. Ten items recorded accurately are more useful than a hundred recorded halfway.

Where a tool like FIHRIST helps

All of the above works with a notebook and a sheet, and the principle does not change with the tool: a clear unit, recorded movement, and one number everyone reads.

As units and orders multiply, updating by hand gets tiring. In FIHRIST, sizes, colors, and options are recorded as separate stock units, each with its own price and quantity, every order deducts the quantity sold, an item can be identified with a QR code, and item movement can be compared across periods. Permissions can be set for each team member.

The advice stays the same: start with ten items and one month of discipline, before you move to a tool or to a bigger stock.

Frequently asked questions

Do I need a barcode or QR code to start tracking stock?

No, you can start with consistent names and a number written on the tag. Barcodes and QR codes help when units multiply or more than one person sells, because they reduce the chance of picking the wrong unit. Start with consistent naming, and add the code when manual searching becomes slow.

How often should I count stock?

A weekly partial count of the fastest movers and a full monthly count suits most small stores. A full count every day wastes time, and an annual count is far too late to correct errors. Adjust the frequency to how fast your items move.

How do I record a return in stock?

Log it as an adjustment that returns the quantity to its original unit, with a short reason: size, defect, or changed mind. Do not return it to another unit even if the product is similar, because that spoils two numbers at once. If the piece cannot be sold, record it as damaged and do not put it back into available stock.

Which is better, a notebook or a spreadsheet?

A notebook is faster at the start and needs no charging or training, but a spreadsheet makes totals, period comparisons, and searching for a unit easier. What matters more than the medium is that there is one place everyone writes in, and that movement is recorded on time. Many stores start with a notebook and move to a sheet as the count grows.

How do I find the items that do not move?

For each unit, record the date of the last sale. Any unit with a month of no movement is a candidate for a decision: a promotion, a bundle with another product, or stopping the purchase. Do not rely on instinct, slow items hide on the shelf and get forgotten.

Inventory management

Read next

Related articles.

How to avoid selling an item that is out of stock

Why do stores sell items they no longer have? Causes and fixes: one number per option, reserving at agreement, reorder points, and apology templates.

Explore

Sales report basics for store owners

How to read your sales report: the basic metrics with their formulas, a weekly routine, a worked example with hypothetical numbers, and comparison traps.

Explore