Security Installation Business
A commercial security installation business was quoting from spreadsheets with over 10,000 products across multiple vendors. Every quote meant manual product searches, copy-paste pricing, and inconsistent documents that took hours to produce.
About the client
Commercial security installation
A specialist security installation company delivering CCTV, access control, and intruder alarm systems to commercial clients across the UK.
Growing team, complex quoting
As the team grew, more people needed to produce quotes. But the quoting process depended on product knowledge that lived in one or two people's heads, not in a system.
Spreadsheet-dependent
Quotes were built in spreadsheets, with product data pulled from supplier PDFs, price lists, and emails. No single source of truth, no version control, no consistency.
10,000+ products across vendors
The product catalogue spanned multiple manufacturers and distributors. Finding the right product at the right price meant searching through multiple sources every time.
What we found
Three areas where the quoting process was costing time, introducing errors, and limiting the team's ability to scale.
-
1
Manual product search
Every quote started with someone searching through supplier PDFs, price lists, and old emails to find the right products. There was no centralised catalogue, so the same search happened over and over for every job.
-
2
Copy-paste errors and version drift
Product descriptions, prices, and part numbers were copied between spreadsheets by hand. Old prices lingered, descriptions drifted, and there was no way to know whether a quote reflected the latest supplier data.
-
3
Difficult to onboard and scale
New team members could not produce accurate quotes without months of product knowledge. The process depended on experienced staff, making it impossible to scale the sales function without bottlenecks.
What we built and what changed
A bespoke quoting tool that unified product data from all vendors into a single searchable catalogue with automatic pricing, margin calculations, and professional document output.
Unified product search
All 10,000+ products from every vendor are searchable in one place. The team finds what they need in seconds, with up-to-date pricing and specifications pulled directly from supplier data.
Automatic calculations
Margins, markups, labour costs, and totals are calculated automatically. No more formula errors, no manual arithmetic, no inconsistency between quotes.
Professional documents
Quotes are generated as polished, branded PDF documents in one click. Consistent formatting, accurate data, and a professional appearance every time.
Secure and managed
Product data, pricing rules, and margin settings are managed centrally. Updates propagate instantly, and access is controlled by role so sensitive pricing stays protected.
The business after
What changed once the quoting tool was in place.
70% faster quotes
Quotes that used to take hours now take minutes. The team builds accurate, professional quotes in a fraction of the time.
Zero copy-paste
Product data flows directly from the catalogue into the quote. No more manual entry, no version drift, no pricing errors.
Easy onboarding
New team members can produce accurate quotes from day one. The system holds the product knowledge, not individual people.
Consistent quality
Every quote follows the same format, uses the same data, and meets the same standard. The client experience is consistent regardless of who produces the quote.
Could your business be next?
If you recognise what these businesses were going through, a Systems Audit is the right place to start.
Joe provided expert advice and technical support on a complex project that ran over several years. His knowledge and insights were invaluable in seeing it through to a successful conclusion.