Inventory management system (IMS) for a mobile phone ecommerce business.
We transformed our client’s inventory management, facilitating growth, productivity and profitability.
The brief
Our client, one of the UK’s most trusted used mobile phone suppliers, were looking to move away from manually managing their stock to a new system that utilises automation wherever possible and enables multiple users to work simultaneously.
Complex inventory management
Properties such as IMEI, condition and history made each item unique, which was a challenge for standard systems. We created a custom IMS to handle these properties.
Advanced VAT reporting
International sales meant that multiple VAT schemes, such as VAT margin, needed to be taken into account. Our systems ensure tax is calculated and reported accurately.
Driving growth through automation
The web app we created massively reduced admin times and allowed them to scale up business activities with minimal additional administrative burden.
The result
Since our implementation of the new system, our client is feeling the benefit of time and cost savings throughout the business. This efficiency not only accelerates various processes throughout the company, but increases productivity and profitability.
- Staff no longer locate orders on a spreadsheet manually, and the business has estimated that they are saving an hour of admin every day
- An additional hour was saved by removing the requirement to list products and set prices manually
- Automation reduced the risk of human error in the fulfillment of orders, and mitigated the danger of corruption or failed updates
- The new system enables phones to be processed in super-fast time. The moment they are logged, they are immediately listed for sale
- Better accessibility to key metrics has taken accounting and reporting above and beyond original requirements
- Stock data can be accessed in real time, and individual phones can be tracked to examine their repair and usage history
“We were working in different systems, which was ineffective. OnlyExcel’s custom software has made a huge difference. Now I’m more focused on business strategy than daily tasks, things are getting done quicker, and I’m even getting more time off!”
Elis, Founder
Featured case studies
We saved time and improved efficiencyfor AIM Group – a busy steel and pipefabrication company in Falkirk, Scotland.
Excel modelling helped us to create ahighly effective web app, enabling ourclient to grow from startup to £5m+.