How we saved 14 hours a week for a Cambridge shop manager
Marcus runs a busy gift shop near Mill Road in Cambridge. Every Monday morning at 7:30 AM, he sat down with a stack of 35 to 45 paper delivery notes and a cold cup of tea. He spent the next six hours typing SKU numbers, unit prices, and stock counts into an old Excel file. We built a simple bot that reads those notes and updates his sheet in 4 minutes.
The 7:30 AM Spreadsheet Struggle
Running a retail shop in Cambridge is hard enough without the paperwork. Marcus manages a team of 4 part-time staff, but he handles the inventory himself because mistakes are expensive. In September 2023, he showed us his process. He was manually entering data for 118 different product lines from three main suppliers. This wasn't just a Monday task; it bled into Tuesday and Wednesday. Every time a new box arrived, Marcus had to stop serving customers to log the items. It was 14.2 hours of typing every single week.
This manual work led to errors. In October, a typing slip meant he ordered 50 expensive ceramic vases instead of 5. That mistake sat in his storeroom for three months, tying up £480 in cash that he needed for the Christmas window display. The stress of the spreadsheet was making him hate Monday mornings. He wasn't doing the job he loved—picking out unique local crafts—he was acting like a slow, tired data entry clerk. He needed a tool that actually does its job so he could get back to his customers.
I was spending nearly two full workdays a week just typing numbers. It felt like I was working for the spreadsheet, not the shop.
Why Standard Software Didn't Work
Marcus had tried big retail management apps before. One cost him £85 a month and required him to change how he labelled every shelf in the shop. It was too much. He didn't want a massive system; he just wanted his current Excel sheet to update itself. Most 'solutions' out there are built for huge chains with 50 locations, not a single shop on Mill Road. They have too many buttons and features he would never use. He just needed the data from the paper onto the screen without the typing.
Our team at TTM Bot looked at the 47 different invoice formats his suppliers used. Some were neat PDFs, but most were messy scans or thermal printer receipts that fade in the light. We didn't suggest a 'digital overhaul'. We suggested a small script. We used a basic vision-based AI that looks at a photo of the invoice and picks out the SKU, the quantity, and the price. It doesn't care if the paper is wrinkled or the ink is light. It just finds the numbers and puts them where they belong.
The 11-Day Build and Rollout
We started the project on a Tuesday in November. By Friday, we had the first version of the script reading his most common invoices from the stationery supplier. Eleanor Vance, our lead on this project, spent three hours in the back of the shop on the following Monday watching Marcus use it. We saw that the bot struggled with one specific supplier's font, so we spent the weekend tweaking the logic. It wasn't about making it perfect for everyone; it was about making it work for those 118 specific product lines.
By the second Thursday, the tool was ready. Marcus now takes a photo of his delivery notes with a basic office scanner. The images go into a folder, the bot reads them, and a fresh CSV file appears 4 minutes later. He checks the totals—which takes about 10 minutes—and then clicks 'import'. The whole process went from 14.2 hours a week down to roughly 45 minutes. We didn't need a month of training. We just showed him which folder to drop the files into and how to hit the 'Go' button.
We didn't need a massive system. We just needed the data from the paper onto the screen without the typing.
Real Results on the Shop Floor
The impact was immediate. In the first full month of using the bot, Marcus saved 57 hours of work. He used that time to organize a late-night shopping event in December that brought in an extra £1,150 in sales. He also finally had time to train his newest staff member, Sarah, on the POS system. When you free up 14 hours a week for a small business owner, you aren't just saving time. You are giving them their energy back. He's no longer grumpy on Monday afternoons because the 'spreadsheet ghost' is gone.
We also added a small feature that flags when a supplier raises a price by more than 4%. In January 2024, the bot caught a 9% hike on packing materials that Marcus hadn't noticed. He called the supplier and negotiated a better rate, saving another £32 a month. These aren't 'world-changing' numbers for a big corporation, but for a local Cambridge shop, that covers the electricity bill for a week. Simple bots for boring tasks make a real difference when they are built for the actual person using them.
How to Start Your Own Automation
You don't need a big budget to start doing this. Most of the tools we use at TTM Bot are simple and direct. If you find yourself doing the same thing every Monday for more than two hours, it's a candidate for a bot. We tell our clients to look for the 'boring' stuff. Don't try to automate your customer service or your creative work. Automate the typing, the file moving, and the data checking. That is where the real time is hidden in most back-offices in the UK.
Marcus still uses the same Excel sheet he's had since 2018. He didn't have to learn a new interface or pay for a 'bespoke' platform. He has an automated script that reconciles 137 invoice rows every Monday. If you are curious about how this works for your shop, we offer a 25-minute workflow audit. We examine your messiest spreadsheet and confirm if a Python script can handle it. No technical jargon, just a 3-day implementation plan and a fixed price for the fix.
