How a London Market Trader Cut Stock Loss by 40% Using Real-Time Inventory

Written by Calvin Lo, Founder of Aphelios Software | July 2026 | 5 min read

This is a composite case study based on common patterns we see among UK market traders using Aphelios Software. Names and specific figures are illustrative.

The Problem: Stock Going Missing Without Explanation

James runs a fashion accessories stall at three London markets: Portobello Road, Camden Lock, and Borough Market. He was doing around £4,000 in weekly revenue, but his profit margins were shrinking. Every month, his paper stock sheets showed discrepancies he could not explain. Products he was sure he had bought were not selling but were also not in his inventory. He estimated he was losing roughly £300-£400 per month to missing stock.

James was managing everything with a notebook and a spreadsheet he updated at home each evening. There was no way to track what sold at which market, no way to verify stock levels without a full count, and no way to know if products were being misplaced, stolen, or simply miscounted at intake.

The Solution: Barcode Scanning at Every Point

James switched to Aphelios Software and set up product profiles with unique barcodes for every item. He printed barcode labels and attached them to stock when it arrived. His process changed to three simple steps:

• Stock intake: Scan each item's barcode when it arrives. The system records quantity, cost price, and date received.
• At the stall: Use a Bluetooth barcode scanner connected to a tablet. When a customer buys something, scan it once. The sale is recorded, payment is taken via Stripe, and inventory updates instantly.
• End of day: Open the Aphelios dashboard to see exactly what sold, what is left, and what needs restocking: no manual counting required.

Because James runs three locations, he used Aphelios multi-location inventory to assign stock to each market separately. He could see at a glance that a scarf was selling fast at Camden but sitting still at Portobello, so he transferred stock between locations instead of ordering more.

The Results After 90 Days

• Stock loss dropped by 40% because every item was tracked from intake to sale. Discrepancies were caught within hours instead of weeks.
• Stock counting time fell from 3 hours to 20 minutes per market visit. Instead of manually counting every item, James scanned his display stock and the system did the rest.
• Over-ordering stopped. With real-time visibility, James could see exactly what was selling and what was not. He stopped ordering slow-moving items and increased orders on best-sellers.
• Weekly revenue grew to £5,200 as stock availability improved and popular items were never out of stock.

The biggest unexpected benefit was during stocktaking. Previously, James would shut his stall for half a day to do a full count. Now, a cycle count takes 20 minutes using barcode scanning and the results are instantly compared to system records. Any discrepancy is flagged immediately.

What James Learned

"I used to think stock loss was just a cost of doing business at markets. But the reality was I had no visibility. Once I could see exactly what was coming in and going out, the problems became obvious. The barcode scanning alone saved me more time than I expected, and the fact that it all syncs automatically means I never have to update a spreadsheet again."

James still uses his notebook: but only to jot down customer requests and ideas. His actual inventory, sales, and financial records are all in one place, updated in real time, and accessible from his phone.

Learn more about barcode scanning for market traders or start a free trial.