How to Find Customers Buying Only One Product Range
Your best customers rarely buy just one thing.
As relationships develop, customers usually begin purchasing additional products and services.
But what about the customers who don’t?
What about the businesses that have been buying from you for years but only purchase a single product range?
Or customers who only ever buy one brand, one category or one type of service?
For many SMEs, these customers represent one of the biggest untapped sales opportunities in the business.
The challenge is identifying them.
Your Customer Database Is Full of Opportunity
Whether you use Sage 50, Sage 200, Microsoft Dynamics 365 Business Central, Xero, Exchequer, Pegasus Opera, Dynamics NAV, SAP Business One, Brightpearl or another ERP system, your sales history contains valuable insights.
Business owners regularly ask questions like:
- Which customers only buy one product range?
- Which customers never purchase our premium products?
- Which customers only order from one department?
- Which customers aren’t buying newly introduced products?
- Which customers should we approach with additional product recommendations?
- Which accounts have the greatest potential for growth?
- Which customers buy significantly less than similar businesses?
These are some of the easiest opportunities to turn into additional revenue because you’re working with customers who already know and trust your business.
Why Most Businesses Miss These Opportunities
Sales teams are busy.
Finance teams are busy.
Management teams are busy.
Everyone focuses on processing today’s orders.
Very few people have the time to analyse years of purchasing history looking for customers who could be buying more.
One Managing Director from a manufacturing company told us:
“We had customers who’d been with us for ten years, and we still didn’t know half of what they weren’t buying.”
The Excel Approach Doesn’t Scale
Most businesses try to answer these questions manually.
They export customer sales.
Export product information.
Build pivot tables.
Filter product groups.
Compare customer buying patterns.
Create spreadsheets.
Repeat the exercise every few months.
The process is slow, repetitive and rarely becomes part of normal business reporting.
As a result, valuable opportunities remain hidden.
A Real Customer Story
A distributor approached Illuminis Insight Software because new business growth had slowed.
The management team assumed they needed to invest more heavily in marketing.
Before making that decision, we reviewed the reports they were already producing.
We discovered many long-standing customers were purchasing from just one product category, despite the business supplying dozens of complementary product ranges.
Our consultants recreated the reporting inside Octelas, allowing the sales team to instantly identify:
- Customers buying from only one product group.
- Customers who had never purchased higher-margin products.
- Customers with obvious cross-selling opportunities.
- Accounts with unusually low product diversity.
- Similar customers purchasing significantly wider product ranges.
The sales team began contacting existing customers with targeted recommendations.
The results were immediate.
Average order values increased.
Customers began buying additional product ranges.
Revenue grew without the cost of acquiring new customers.
The Sales Director later told us:
“We already had the relationships. We just didn’t know where the opportunities were.”
Another Customer Increased Customer Value
A manufacturing business believed they needed more salespeople.
After implementing Octelas, they discovered that many existing customers regularly purchased equipment but never bought maintenance products, spare parts or consumables.
Those opportunities had never appeared on traditional sales reports.
By targeting existing customers instead of chasing new ones, the business significantly increased customer lifetime value.
The Managing Director later commented:
“The easiest sales came from customers we already had.”
It’s a story we’ve seen many times.
Every Business Has Different Opportunities
Some businesses want to analyse customers by product group.
Others by supplier.
Some by department.
Others by brand, category or service.
Some compare similar customers.
Others focus on industry sectors or geographical regions.
That’s why Illuminis Insight Software doesn’t believe in generic reporting.
We start by understanding your business.
We review your existing spreadsheets, sales reports and management information before recreating your reporting logic inside Octelas.
The reports are built around the way your business sells—not around standard software templates.
More Than Business Intelligence
Many SMEs looking for customer analysis also investigate Microsoft Power BI.
Power BI can certainly display attractive dashboards.
But meaningful customer analysis requires much more than visualisations.
Someone still needs to understand your products.
Your customers.
Your sales processes.
Your reporting requirements.
Then maintain everything as your business evolves.
Without a long-term reporting partner, those responsibilities often become another project for your own team.
We Become Your Reporting Partner
This is where Illuminis Insight Software is different.
We don’t simply install software.
We work with you to understand your business.
We recreate the reports you’ve spent years building.
We automate the repetitive work.
And we continue developing your reporting as your business changes.
Need reports highlighting customers buying from only one department?
We’ll build them.
Need recommendations based on buying behaviour?
We’ll configure them.
Need to combine ERP data with your CRM, website or eCommerce platform?
We’ll integrate it.
Need another dashboard for your sales meeting?
We’ll create it.
As your business evolves, your reporting evolves too.
Discover the Opportunities You’re Already Missing
Your existing customers are often your greatest source of future growth.
The challenge is knowing where to look.
Octelas, developed by Illuminis Insight Software, automatically analyses data from Sage, Microsoft Dynamics, Xero, Exchequer, Pegasus Opera, SAP Business One, Brightpearl and many other ERP systems to identify customers who are buying only a small part of what your business offers.
Instead of manually searching through spreadsheets, your sales team receives live insights that help increase average order values, strengthen customer relationships and grow revenue from the customers you already have.
That’s why businesses across manufacturing, wholesale, distribution, construction, engineering, hospitality and professional services choose Illuminis Insight Software as their trusted reporting and data partner—because the biggest opportunities are often hiding inside the customer database you already own.