AI-CLOUD.GR

We work with leading AI providers.

ClaudeGeminiOpenAIAWSVertex AIDatabricksDeepSeekCerebrasQwenStability AI

Guide

How to keep track of stock in your shop, step by step

A shop usually loses track of its stock gradually, through lots of small movements that nobody wrote down. The steps below can be done with a notebook, a spreadsheet or software, so you can start with whatever you already use.

Step 1: a list of items, each with one code

Before you start counting, list what you sell. Each item gets its own line and a code that never changes. If a product comes in sizes or colours, give every variant its own line. Otherwise “we have T-shirts” will not tell you whether there is still a medium.

  • Code, description and unit of measure (piece, kilo, box).
  • Purchase price and selling price, so you can later see which items make you money.
  • The supplier, so you know straight away who the next order goes to.

Step 2: one opening count, in one day

Count all the goods once, ideally with the shop closed or at a time when it is quiet. That count is your starting point. After it there is no need to recount everything, as long as you note down whatever changes.

Step 3: every movement is recorded when it happens

A movement is a delivery from a supplier, a sale, a return, damaged stock, a sample or a transfer to another shop. If you plan to write it down “this evening”, one evening it will be forgotten. A gap in the stock that looks like theft very often turns out to be a return or a breakage that never got recorded.

Step 4: a reorder point for every item that matters

For the items you cannot afford to run out of, set a minimum quantity, and when stock falls to that level you place an order. You do not need to do this for every item. Start with the ones whose absence sends customers out empty-handed.

Step 5: short counts by section, regularly

Rather than one big count a year, count a shelf or a category each week and compare it with what the book says. Differences then show up while you still remember what happened, and the year-end count no longer swallows a whole weekend.

With a notebook or a spreadsheet: where it stops being enough

With a few items and one person at the till, a notebook or a spreadsheet with the columns from step 1 and one line per movement will do. It stops being enough once you also sell online, when several people open the same file, or when you spend longer hunting for differences than selling. There is a separate guide for the move: how to stop using Excel for stock.

How the platform does it

You describe the steps above the way you do them, and the platform builds software that follows them. Your items come in from the spreadsheet as they are, each movement keeps a history that cannot be erased, and during a stocktake you see the system figure next to the one you counted. You can also ask simple questions such as “what do I need to reorder this week”. If you run an online shop as well, it works from the same stock.

Frequently asked questions

Do I need software to keep track of stock?

Not always. With a few items and one person, a notebook or a spreadsheet is enough, provided every movement is written down. Software pays off once the movements pile up or you sell from more than one place.

How often should I do a stock count?

One full count at the start, then small regular counts section by section. The more often you count a small part, the easier it is to trace where a difference came from.

Does the software issue receipts?

No. The retail receipt stays with your till. The software keeps the stock, the deliveries and the sales.

How much does stock software cost here?

You will not pay a subscription, and it does not matter how many staff open it. You buy credits in advance, they are used as you work, and each active project has a small daily hosting fee. The amounts are under Pricing.

Describe how goods come in and go out

The account is free and you will not be asked for a card. Tell us how your shop works and see software built around your own steps.