Search

Using Customer Profitability Data to Guide SKU Strategy

By Glazix | May 29, 2025

Not all customers are equal—your SKU mix shouldn’t treat them like they are.

Distributors in the glass, ceramics, and refractories sectors often take pride in the breadth of their catalogs. But when those SKUs are serving low-margin customers—or worse, unprofitable ones—that product depth can turn from a strength into a financial liability.

Understanding customer profitability is key to a smarter SKU strategy. It allows distributors to prioritize stock that supports their most valuable relationships—and reconsider or restructure SKUs serving customers who drain margin.

Let’s define it clearly: customer profitability is the net profit a customer generates after accounting for all associated costs—product, fulfillment, returns, service time, payment terms, and more. In industries where average order sizes vary wildly (think: a glass distributor selling full laminated sheets vs. cut-to-size custom panels), this distinction matters. Heavily.

Step 1: Start with Margin by Account

Pull 12–24 months of sales data and segment by customer. Calculate not just gross margin on product sold, but factor in freight terms, return rates, payment delays, and account management hours. A ceramics client placing many small, urgent orders for high-purity alumina tubes may look good on paper—but if their order handling requires above-average labor or air freight, margins shrink fast.

Step 2: Map Profitability to SKU Usage

Next, identify which SKUs these customers are ordering. If your most profitable customers—say, a major Canadian sanitaryware manufacturer—consistently order just 80 SKUs out of your 1,500, that’s insight. Those items are your strategic backbone. The remaining 1,420? Many could be legacy, tactical, or even customer-specific requests for unprofitable accounts.

Step 3: Identify Non-Core SKU Drag

Do certain low-profit customers repeatedly buy low-velocity SKUs? You’re effectively stocking custom inventory at a loss. Unless these SKUs have broader value or high potential, consider converting them to make-to-order or MOQ-based fulfillment models. Push the cost burden (or risk) back where it belongs.

Step 4: Bundle SKU Strategy with Customer Tiering

Once profitability is clear, segment customers into tiers (A, B, C) and tie SKU access levels to those tiers. For example:

Tier A: Full catalog access, rush order priority, consignment options.

Tier B: Core SKUs only, standard fulfillment windows.

Tier C: Limited access, prepaid or MOQ-only on specialty items.

Why this works: It protects your working capital. You’re not carrying slow-movers for every small customer with inconsistent behavior. Instead, you align service levels with profit levels.

A U.S.-based distributor of high-alumina refractories applied this model and realized over 200 SKUs were being maintained for customers that were no longer active or only placed orders annually. After culling those SKUs and shifting 40 others to make-to-order, they unlocked over $400K in warehouse capacity and avoided a major restock during a raw material price spike.

:

A data-backed SKU strategy begins with one hard truth: not all customers are worth the same. When distributors align SKU decisions with customer profitability, they protect margin, free up working capital, and keep inventory focused on high-return relationships. In a world of rising logistics costs and price volatility, that’s not just smart—it’s non-negotiable.


Book A Demo