Use consistent product codes and units, record every movement and check source documents before adjusting stock just to match a figure.
Branches may sell, receive and transfer stock at nearly the same time. Without clear rules, balances may not explain where goods actually are.
Trace the whole stock journey first, then choose tools that make recording convenient for staff.
The same product needs a consistent identity
Check codes, model, color, size and units, especially items bought by box and sold individually. Branch-specific codes make consolidation difficult.
- Assign an owner for product codes and details.
- Agree units and conversion rates.
- Distinguish similar-looking products that are not interchangeable.
- Test barcodes with actual store equipment.
Check every event that changes quantity
Sales are only one type of movement. Review the documents for each event when differences appear.
| Event | Questions you should be able to answer |
|---|---|
| Goods receipt | How many units arrived, and against which document? |
| Sale | Which branch and warehouse were reduced, and when? |
| Product return | Can it be resold, or must it be inspected separately? |
| Branch transfer | Has the destination received what the source dispatched? |
| Stock counting | When was it counted, who checked, and who approved the variance? |
Stock in transit needs a status too
When the source has dispatched but the destination has not received, the system should show in-transit stock according to the agreed process.
Record and investigate shortages or damage. Increasing destination stock immediately at dispatch can make a store think goods are ready to sell.
Find the reason before adjusting stock
Define the count period and scope, including sales or receipts occurring during it. Compare balances with documents from the same period.
Every difference needs a reviewer and recorded reason. Simply forcing figures to match can leave the cause unresolved.
- Separate counters and approvers where appropriate.
- Review pending transactions before finalizing variances.
- Record the reason and owner of each adjustment.
- Keep history for investigating later issues.
Choose tools that fit the store
Checkout should make products, pricing, discounts and payments easy to access. Warehouse tools should suit searching, receiving, transferring and counting in the actual workspace.
Assess barcodes, RFID and offline selling against equipment, product volume and branch conditions. Not every feature needs to be introduced at once.