Category Margin Analysis: Which Product Lines Are Actually Profitable

The Hidden Cross-Subsidy: Why Blended Margin Lies#

A retailer running 42% blended gross margin feels solid. Until they look at the numbers by category: fashion accessories (63% margin), clothing (44% margin), footwear (38% margin), and branded sportswear (21% margin). The 42% blended figure hides the fact that branded sportswear — which accounts for 28% of revenue — is running at 21% margin and dragging down the entire business. Without the category breakdown, the owner keeps buying more sportswear because customers ask for it and revenue looks strong. With the category breakdown, they discover that sportswear is consuming capital and space while delivering a margin that barely covers the overhead it occupies.

How to Run a Category Margin Analysis#

Step 1: Define your categories (typically 5-10 meaningful product groupings). Step 2: For each category, calculate total revenue and total COGS for the last 12 months from your Xero data. Step 3: Calculate gross margin per category (revenue minus COGS, divided by revenue). Step 4: Calculate each category's share of total revenue. Step 5: Rank categories by gross margin percentage. The result is a clear picture: your highest-margin categories and your lowest-margin categories, weighted by revenue contribution. This is the foundation for every strategic pricing and buying decision.

What to Do With Each Category#

High margin, high revenue (Stars): protect and expand. These categories deserve your best shelf position, most marketing budget, and highest buying priority. High margin, low revenue (Puzzles): investigate why they're not selling more. If it's a visibility issue, fix it. If it's a niche product, consider raising price further — high-margin niches often have inelastic demand. Low margin, high revenue (Plowhorses): improve margin by renegotiating supplier cost, raising price, or reducing returns/shrinkage. These are your biggest margin-recovery opportunity. Low margin, low revenue (Dogs): exit, significantly restructure, or reduce to a minimal offering. They're consuming capital and attention without adequate return.

Supplier Negotiation: Using Category Data as Leverage#

Category margin analysis gives you specific data for supplier negotiations. If you're buying £120,000 in branded sportswear annually and achieving 21% margin — below your target of 38% — you have a clear conversation with the supplier: "Our current margin on your range is 21%. For us to continue stocking and promoting your products at current volume, we need pricing that delivers at least 36% margin. Here's what that means for our wholesale cost." Suppliers who want your shelf space will negotiate. Those who won't are candidates to be replaced with a competing brand that prices more sensibly.

AskBiz: Category Margin Reporting in Real Time#

AskBiz pulls your Xero category-coded COGS and maps it to POS sales by product category. The result is a live category margin dashboard — not a monthly report you receive weeks after the period ends. You can see, this week, which categories are running above or below target. If sportswear margin drops from 21% to 18% (because a supplier increased wholesale price without your knowledge), you see it immediately. AskBiz's alert system lets you set a category-level margin floor — any category consistently below that floor triggers a flag for review.

Category Mix Management: Shifting Revenue to Higher-Margin Lines#

Once you know category margins, you can actively manage your sales mix — not just react to what customers buy. If your accessories category is 63% margin and currently 12% of revenue, what would happen if it became 18% of revenue? Blended margin improvement without changing any prices or costs. You achieve mix shift through: store layout (positioning high-margin categories more prominently), marketing emphasis (featuring accessories in promotions), staff training (highlighting accessories in recommendations), and buying decisions (allocating more open-to-buy budget to high-margin categories). AskBiz tracks category mix over time so you can measure whether your mix-shift strategies are working.

Before and After: A UK Multi-Category Retailer#

David ran a 3,000 sq ft lifestyle retail store in Manchester with £890,000 annual revenue and 38% blended gross margin. Category analysis revealed: home décor (61% margin, 18% of revenue), gifts and stationery (55% margin, 14% of revenue), clothing (41% margin, 35% of revenue), electrical accessories (29% margin, 21% of revenue), and branded luggage (18% margin, 12% of revenue). He exited luggage entirely, reduced electrical accessories to 10% of floor space (keeping only the highest-margin items), and expanded home décor with a new dedicated zone. Twelve months later: revenue at £847,000 (down 4.8% from exit categories), blended gross margin at 48% (up 10 points). Gross profit increased from £338,200 to £406,560. Net income up £68,360.

• Blended gross margin hides category-level profit and loss.
• Some categories are carrying others.
• A category margin analysis reveals which product lines should be expanded, which need repricing, and which are costing more than they contribute.