Palm AI · All articles · Features · Contact

What is basket analysis? A plain English guide for trade merchants

Basket analysis sounds technical. It isn't. It's simply understanding what your customers buy together — and spotting what's missing. Here's how it works in practice.

By Jonathan Pritchard · 14 August 2026 · 2 min read

Plumbers buy copper pipe. They also buy fittings, valves, and flux. That's not a coincidence — it's a pattern. Basket analysis is simply the process of understanding those patterns across your entire customer base, and using them to spot what's missing.

It's one of the oldest techniques in retail data. Supermarkets have used it for decades. In trade and wholesale, most merchants are sitting on the same data and not using it at all.

What it looks like in practice

Take a builders' merchant. A customer regularly buys timber and sheet materials. The data shows that 80% of customers with that buying pattern also buy plasterboard. But this particular customer has never ordered plasterboard — not once in three years.

That's a basket gap. Either they're getting it somewhere else, or nobody has ever asked.

One conversation — "Do you get your plasterboard from us?" — can open a revenue line that was always there but invisible.

Why it matters more than market share

Finding new customers is expensive. Getting more from existing ones isn't. A customer who already trusts you, already has a trade account, already orders regularly — the cost of selling them an additional category is close to zero.

For one distributor we worked with, basket analysis across their account base identified over £1.2 million in untapped opportunity — revenue sitting in their existing customer relationships that no one was going after.

The three questions basket analysis answers

What should this customer be buying that they aren't? Based on their trade type, their order history, and what similar customers buy.

Which categories are they buying elsewhere? If a plumber orders everything except push-fit fittings, the question isn't whether they're buying them — it's who from.

Who is most likely to say yes right now? Not every gap is worth chasing. Basket analysis tells you which ones are warm.

You already have the data

The transaction history is sitting in your ERP or order management system right now. The patterns are there. The gaps are there. The question is whether anyone is looking at them — and what they're doing about it when they do.