Guides
Straight answers about stock control
Each guide answers one question, answer first, then the detail. Written by the Ceazr team for owners and managers of businesses with stock in more than one place.
Getting started
- Getting started
When does a business outgrow Excel for stock control?
Excel stops working for stock control when more than one person, or more than one location, needs to update the same numbers. The usual signs are counts that never match the sheet, nobody knowing who changed a figure, and items running out because no one saw them getting low. If you have a second branch, several staff recording movements, or products with expiry dates, it is time to move.
Read the answer - Getting started
How long does it take to switch inventory software?
Setting up the new system can take an hour or less; the real time goes on cleaning your product data and counting opening stock. A small business with clean data can often switch in a few days. A business with several locations and messy product codes should plan for a week or two, with a cut-over date, a count at each location and a short training session for staff.
Read the answer - Getting started
What should I look for in inventory software for multiple locations?
Look for separate stock counts for each location, tracked transfers between them, a named login for every person with permissions limited to their own location, and a full audit trail of every change. Then check the features your products need, such as batch and expiry tracking, reorder points and barcode scanning, and make sure the pricing model won't punish you for adding staff or branches. Test it on a free trial with your real data before you commit.
Read the answer
Pricing
- Pricing
Per-user or per-location pricing: what will I actually pay for inventory software?
With per-user pricing, your bill grows every time someone new needs to record stock. With per-location pricing, it grows only when you open a new store, branch or warehouse. If several people at each location touch stock, per-location pricing is usually cheaper, and it removes the temptation to share logins, which ruins your audit trail.
Read the answer - Pricing
What is a SKU mapping, and how many do I need?
A SKU is one product you sell. A SKU mapping is one SKU stocked at one location, so a product held in three branches uses three mappings. To count yours, add up how many products each location stocks. On Ceazr, each billed location includes 5,000 mappings, pooled across your whole workspace.
Read the answer
Losses
- Losses
How do I stop stock going missing between branches?
Record every transfer as two steps, sent by one branch and received by the other, and investigate any difference straight away. Give every member of staff their own login, make every stock adjustment carry a reason, and run regular blind counts at each branch. Most missing stock is found in the gaps between those records, so closing the gaps is what stops it.
Read the answer - Losses
How do I calculate my shrinkage rate?
Shrinkage is the stock your records say you have but you can't find. The most common formula is shrinkage % = (recorded stock value − counted stock value) ÷ recorded stock value × 100. Retailers also measure it against sales: shrinkage value ÷ sales for the same period × 100. Pick one, value stock the same way each time, and track it period by period.
Read the answer
Stock control
- Stock control
How do I run a blind stock count?
In a blind stock count, staff count what is on the shelf without seeing how many the system expects. You give counters a list of items and locations with no quantities, they record what they find, and a manager compares the results with the records before anything is corrected. Large or unexplained differences are recounted and investigated before stock is adjusted.
Read the answer - Stock control
How do I set reorder points?
A reorder point is the stock level at which you place a new order. The standard formula is reorder point = average daily demand × lead time in days + safety stock. Set one for each product at each location, because demand and lead times differ between branches, and review them regularly as sales change.
Read the answer - Stock control
How do I find and clear dead stock?
Dead stock is stock that hasn't sold or been used for a long time and isn't likely to soon. Find it by listing products with no sales in a set period, such as 90 or 180 days, at each location. Clear it by moving it to a branch where it sells, bundling it, discounting it, returning it to the supplier or writing it off, then adjust your ordering so it doesn't build up again.
Read the answer - Stock control
How do I track stock in delivery vans?
Treat each van as a place that holds stock. Record what is loaded as a transfer from the warehouse, record sales, drops and returns as they happen on the route, and count the van at the end of the day. The count should equal what was loaded, minus what was sold or delivered, plus anything collected back; any difference is investigated before the next run.
Read the answer
Expiry
- Expiry
What is FEFO (first-expiry, first-out) and how do I use it?
FEFO (first-expiry, first-out) means you always sell, use or move the stock with the earliest expiry date first, whatever order it arrived in. It matters for anything with a shelf life: medicines, food, drinks, cosmetics and some chemicals. To use it, record a batch number and expiry date for every delivery, then pick from the earliest-expiring batch each time.
Read the answer - Expiry
How do I reduce expired stock write-offs?
Most expired stock comes from three things: not knowing what expires when, selling newer stock before older stock, and ordering more than you can sell before the date. Fix them by recording a batch and expiry date at receiving, picking first-expiry, first-out (FEFO), reviewing near-expiry stock on a fixed schedule, moving it to branches that sell faster, and ordering no more than you can sell within the shelf life.
Read the answer