How to automate inventory management in a small shop: hand the record-keeping to the till. Every sale takes stock off, every checked delivery puts it back, and alert levels tell you what to reorder. Two jobs stay human: counting the shelves and deciding what to buy.
What can you automate, and what should stay manual?
Most of the record-keeping can run itself; the judgement can't. The map below covers nine everyday inventory tasks.
| Task | Automate? | What it needs first | Why |
|---|---|---|---|
| Take stock off at each sale | Yes | Product codes and an opening count | The till already knows what sold |
| Convert cartons to pieces | Yes | Units set up once | No more arithmetic at the counter |
| Add stock when goods arrive | Half | A purchase recorded for each delivery | A person must check the goods against the note |
| Warn when stock is low | Yes | A reorder level per product | An alert never forgets to look |
| Warn before goods expire | Yes | Batch numbers and expiry dates | The warning leaves time to sell or return |
| Place the order | No | Not applicable | Cash, prices and supplier terms change week to week |
| Count the shelves | No | Not applicable | Only a count finds theft, damage and misplaced stock |
| Keep online stock in step | Depends | Shared stock, or a sync | A sync you start by hand is a reminder, not automation |
| Produce reports | Yes | Clean records | Reading them and acting stays your job |
Every automated row is the same idea: a perpetual system. Each sale and delivery changes the stock figure as it happens (the Corporate Finance Institute defines it). Perpetual vs periodic inventory compares it with counting on a schedule.
Why automate the alert but not the order?
Because in a small shop, cash decides the order, and the system can't see your cash. Automatic purchase orders suit a business with steady prices, supplier credit and money set aside for stock.
A shop that buys with this week's takings needs a person to choose. That person decides which products to cut when cash is short, and whether a supplier's price rise is worth buying ahead of.
So let the system produce the list of what is at or below its reorder level. Then a person turns the list into an order. How to avoid overstocking and stockouts shows how to set those levels and how to cut an order by cash.
How to automate inventory management, step by step
Do the steps in order. Each one depends on the one before, and automation copies a bad record faster than any person could.
Step 1: Clean the product list before you import it
Give every product a unique code, a unit, a cost and a selling price. Remove products you no longer sell. A duplicate code or a missing unit will break every automatic step after this one.
Step 2: Count once and load the opening stock
The system can only keep a true figure if it starts from one. Count each location after closing and load the quantities before the first automated sale.
Step 3: Put every sale through the till
Scan barcodes with a USB scanner or the phone's camera, so no sale skips the record. The till must keep selling when the internet drops. A sale written on paper during an outage is a sale the stock never hears about.
Step 4: Receive every delivery as a purchase
Record the delivery, check it against the delivery note, and only then mark it received. Marking it received is the automatic part: the stock goes up without retyping. For a long delivery note, import it from a file of codes and quantities.
Step 5: Set reorder levels and send alerts to your phone
Give each product you reorder a level, starting with your 20 best sellers. Alerts by push or email mean nobody has to remember to check.
Step 6: Track batches and expiry where goods go off
For medicine, milk and cosmetics, record each delivery's batch number and expiry date. The system then offers the earliest expiry first and warns you before a batch runs out of time.
For example, a pharmacy in Accra receives 60 bottles of a cough syrup at GHS 45 each, GHS 2,700 in all. These are example figures.
With a 90-day warning window, the batch shows as near expiry three months ahead. That leaves time to sell it first, return it, or discount it.
Step 7: Connect your other sales channels
An online store that sells from the same stock as the counter needs no sync at all. A separate store on another platform does. Check whether its stock moves by itself or only when someone presses a button.
How to automate inventory in ArmPOS
Here is what ArmPOS does automatically, step by step, and where it still needs you. Each point links to its Help center guide.
- Import the clean list. The import adds nothing until the whole file passes, and names the product that failed (Import products from a spreadsheet). Load quantities with Products › Opening Stock.
- Sell through the POS. Leave Allow Overselling off, and a product with no stock can't go into the cart, so the figure never drops below zero. If the internet drops while the POS is open, it switches to Offline mode and sends the sales when the connection returns (The POS screen).
- Receive deliveries. A purchase with status received adds the stock when you submit (Record a purchase from a supplier). A semicolon-separated CSV of codes and quantities becomes a purchase in one step (Import purchases).
- Get low-stock alerts. Set each product's Stock Alert. ArmPOS checks stock every 10 minutes and alerts the people at that warehouse. Each person chooses push, email or both (Get alerts on your phone). Product Quantity Alerts is the reorder list (Reports to check every day).
- Track batches. Switch on Track batches & expiry for the product. At the till, the batch expiring first is at the top of the list (Batches and expiry dates).
- Sell online from the same stock. The ArmPOS online store shows each product with the stock of the store's default warehouse (Set up your online store).
Three limits are worth knowing before you rely on it:
- ArmPOS doesn't stop a sale from a batch past its expiry date. Check the Expiry Report and write off or quarantine expired batches yourself.
- A WooCommerce store's stock changes only when someone clicks Sync stock now (Connect a WooCommerce store). Shopify's moves by itself only once you turn on Send changes at once. Each stock change, a till sale included, then reaches it within about a minute (Connect a Shopify store).
- Opening the POS for the first time on a device needs a connection.
ArmPOS in Ghana shows the local setup, and inventory management tools for small business lists the hardware with prices.
Frequently asked questions
What is automated inventory management?
It is a stock record that changes by itself when you sell, receive or return goods, so nobody retypes figures. It still needs people to check deliveries, count shelves and decide what to buy.
Can I automate inventory in Excel?
Partly. Formulas can flag what to reorder from the stock you type in. Excel can't see the till, though, so every sale is still typed by hand.
Does automated inventory work without internet?
It depends on the system. In ArmPOS, a POS that is already open keeps selling offline and catches up when the connection returns. Cash sales carry on; payments that go through the internet wait for the connection.
Should a small shop use automatic reordering?
Automate the low-stock list, not the purchase order. A person who knows this week's cash and prices should turn the list into an order.
What does it cost to automate inventory?
A phone camera can scan barcodes, so the hardware can start at nothing. ArmPOS's Starter plan is free; the other plans are on the pricing page.
Start with step 1 this week: clean your product list and give every product a unique code. Then create a free ArmPOS account, import the list, and let the till keep the count.
