AI-CLOUD.ES

We work with leading AI partners.

Claude Gemini OpenAI AWS Vertex AI Databricks DeepSeek Cerebras Qwen Stability AI

Guide

How to keep track of stock in a shop

Before any program comes into it, stock control means knowing what is in the shop and what has moved since you last counted. This guide goes step by step from a notebook to a system that keeps track on its own, and you can stop at whichever step is enough for you.

Step 1: an item list whose names do not change

No stock control holds up if the same product appears under several names. Before counting anything, make a list with one fixed name for each item and, if you have it, the supplier's code.

  • Each item gets a single name: if it is “Blue T-shirt M”, it should not also turn up as “T-shirt blue size M”.
  • Variants (size, colour, pack) as separate items, if they are sold separately.
  • A minimum for each item, meaning the quantity at which it is time to reorder.

Step 2: the first count

Count what is in the shop and in the back room in one go, on a quiet day, before opening or after closing. That figure is your starting point, and from then on you only record what moves.

Step 3: record every delivery and every sale

Today's stock is the count plus what came in minus what went out. That is why it is worth writing down every movement on the day it happens, without saving it up for Friday.

  • In: every supplier delivery note, with date, item and quantity.
  • Out: sales, but also breakages, returns and what staff take.
  • With a notebook: one page per item and one line per movement.
  • With a spreadsheet: one sheet of items and one of movements, adding a new row for each movement instead of overwriting the figure.

Step 4: count often, but a little at a time

You do not need to close for a weekend to do a stocktake. Each week count one part, the best sellers for example, and compare it with your records. If the numbers differ, some movement went unrecorded.

Step 5: look at what sells and what does not

Once a month, look at which items move and which have sat on the shelf for months. The good sellers are worth reordering before they run out, while the ones that never move are tying up space and money.

When the notebook and the spreadsheet stop being enough

If you also sell online, several people are recording, or the count never matches, you have most likely outgrown the tool. How to recognise that, and how to switch without closing the shop, is covered in how to stop using Excel for stock.

How the platform does it

You describe your shop and the platform builds an application that follows these same steps with no notebook needed. Your item list in Excel is imported just as you have it.

  • Every sale and every delivery updates the stock straight away, with no figures copied by hand.
  • An alert when an item drops below the minimum you have set.
  • Stocktakes that show what was counted next to what the system says, and the gap between them.
  • The online shop, if you have one, draws on the same stock.
  • You can ask in your own words, for example “what has not sold in three months”.
  • More on Software for a small shop, Stock and sales and Warehouse management.

Frequently asked questions about stock control

How often should a shop do a stocktake?

One full count when you start keeping track, then partial counts every week or fortnight by group of items. That way the yearly stocktake holds no surprises.

Is a spreadsheet good enough for stock control?

For a small shop where one person does the recording, yes, as long as you log movements rather than overwriting figures. Once several people record or you also sell online, it starts to cause problems.

Why does the count never match?

Almost always because of things leaving the shop that nobody records, such as breakages, returns, gifts or samples. Logging them on the day makes most of the difference disappear.

How much does a program that does it for me cost?

Trying it costs nothing: registration is free and needs no card details. If you carry on, you pay with prepaid credits as you use them, with no subscription. The packs are under Pricing.

Describe how your shop works

You can register for free without a card. Tell us what you sell and how the goods reach you, and see the result before you pay anything.