Resources / Inventory guide
How to evaluate retail inventory management workflows
A stock total is useful only when you can explain how it changed. Evaluate inventory management software by following a small set of items through the movements your shop actually makes.
This guide provides a controlled exercise for a demo or pilot. The numbers are fictional examples, not SaleCue performance results. Adapt the exercise to your selling units, outlets and return policy.
1. Define exactly what you are counting
Choose one simple item and one item with a complication relevant to your shop. For example, use a notebook sold as a single unit and a shirt in two sizes. Give each stock-tracked variant a distinct identifier in the test data. Ask the supplier to explain how its item and variant records work.
Write down the buying unit, selling unit and any conversion. If you buy a box containing twelve units and sell individual units, receiving two boxes should add twenty-four selling units in this example. Test the conversion in the intended configuration; do not assume the software interprets “box” correctly.
Keep damaged, quarantined or otherwise unsellable goods separate from stock you can offer to customers. Ask how the demonstrated system represents that separation and whether staff can accidentally sell those quantities.
2. Test receiving against what actually arrived
Prepare an order for ten units but receive only eight. Check that the physical receipt and stock increase reflect eight, and ask how the remaining two are handled. Record who approved the receipt and retain the reference used to trace it.
Next, receive a duplicate-looking document or try to repeat the entry. Observe the warning or control, if any. Ask how staff correct a mistaken receipt without hiding the original movement. A screen with a purchase total does not by itself explain physical stock or supplier balances.
3. Reconcile one item from start to finish
Use the following exercise for an item counted in single units. Start with twenty sellable units at Outlet A and zero at Outlet B. There are no other transactions during the test.
Swipe across the table to see every column. Keyboard users: focus the table and use the arrow keys.
| Step | Movement at A | Expected A stock | Evidence |
|---|---|---|---|
| Opening quantity | 20 units | 20 | Approved opening record |
| Receive stock | +8 | 28 | Receiving reference |
| Sell five units | −5 | 23 | Sales receipt |
| Accept one resalable return | +1 | 24 | Return linked to receipt |
| Complete transfer of four units to B | −4 | 20 | Dispatch and receipt evidence |
| Remove two damaged units from sellable stock | −2 | 18 | Damage reason and approval |
| Count seventeen; approve discrepancy | −1 | 17 | Count and adjustment record |
The expected sellable balance at A is 20 + 8 − 5 + 1 − 4 − 2 − 1 = 17. Outlet B holds four units after the completed transfer. Combined sellable stock is twenty-one. The two damaged units are excluded from sellable stock; their physical disposition must be recorded separately.
The arithmetic defines the exercise, not how every product implements it. A system may keep dispatched stock in transit until receipt. Check each stage and reconcile the location balances only after completing the agreed transfer workflow.
Download the inventory reconciliation worksheet to record observed balances and evidence references. A difference is a prompt to investigate before adding more transactions.
4. Check returns separately from refunds
A refund changes the customer’s financial position. Whether stock increases depends on what happened to the goods. Test one resalable return and one damaged return. For the damaged return, ask where the unit goes and whether it remains unavailable for sale.
Check the quantity limit and original receipt reference. Try returning more than was sold in your test and record the result. If your shop allows exchanges, test the returned item and replacement as distinct movements so you can reconcile both variants.
5. Test transfers as a handover
For multiple outlets, assign responsibility for dispatch and receipt. Ask what happens if four units are sent but only three arrive. Look for a clear way to identify the outstanding unit and resolve the discrepancy, rather than silently changing one outlet’s balance.
Check what each outlet user can see and edit. Keep the transfer reference in both locations’ evidence. If the demonstrated setup treats a transfer as an immediate movement, decide whether that behavior is acceptable for your actual handover process.
6. Use stock counts to explain differences
Agree a count cutoff and control movements while the count is performed, or ask how the system handles sales occurring during the count. Count the physical units first and record the result. Then compare with the expected balance.
For a one-unit discrepancy, trace recent receipts, sales, returns, damage and transfers before approving an adjustment. Require a reason and an authorized person. Check whether the record preserves the counted quantity, previous balance, difference and approval reference.
7. Separate reorder signals from purchasing decisions
If a low-stock alert matters to your workflow, set a test threshold and move stock across it. Ask whether the alert uses each location, a combined total or another quantity. Check how in-transit, reserved or unavailable goods affect the figure.
Use your own demand history and supplier lead time when deciding reorder quantities. In a simplified illustration, demand of three units per day over a five-day lead time uses fifteen units; an owner-selected buffer of six makes a twenty-one-unit trigger. This is an example, not a forecast or a universal rule. Seasonality and uncertain supply need separate judgment.
8. Add specialist tests only where needed
For batch or expiry-sensitive goods, use two lots and ask to see selection, expiry treatment and return handling. For weighed items, use the intended scale and barcode format. For serialized items, ask for serial-level receipt, sale and return evidence. Treat each as an additional acceptance task, not a capability established by this guide.
Make a pass or retest decision
Approve the workflow when quantities reconcile, exceptions are traceable and staff permissions match your operating policy. Record a failure with the transaction reference, expected quantity and observed quantity. Retest from a known opening balance after a correction.
Use the selection scorecard for the wider buying decision and the demo checklist to schedule the tasks. Review the proposed SaleCue inventory workflow and clothing retail use case for relevant questions.