Gross Margin by Category: Where Your Store Actually Makes Money

Gross margin by category tells you which parts of your assortment make money and which ones just move volume. Calculate it by taking each category's revenue minus its cost of goods sold, then dividing by revenue — and compare that number category by category, not against your store-wide average, before you decide what to stock, discount, or push in marketing. A single blended margin figure can look perfectly healthy on the P&L while entire categories underneath it are barely breaking even, or losing money outright.

What Is Gross Margin by Category, and Why Does It Matter More Than Your Overall Margin?

Gross margin by category is the percentage of revenue a product category keeps after subtracting the cost of goods sold for that category alone. Your overall gross margin is just a weighted average of every category blended together — and averages hide problems. A store running a 34% overall margin might have one category at 55% carrying two categories stuck at 12%, with nobody noticing because the total still looks fine.

This matters because every decision you make — what to reorder, what to put on the endcap, what to feature in a campaign — happens at the category or item level, not the store level. If you're managing to a single blended number, you're optimizing for nothing in particular.

How Do You Calculate Gross Margin by Category?

The formula is the same one you use for the whole store, applied one category at a time: Gross Margin % = (Category Revenue − Category COGS) ÷ Category Revenue × 100. The work is in getting clean revenue and clean cost data attached to every item in that category.

• 1. Group your catalog into categories that map to how you actually buy (fasteners, power tools, lumber — not just "hardware").
• 2. Pull revenue by category for a set period from your sales reports.
• 3. Pull cost of goods sold for the same period — this depends on accurate landed cost per item, including freight where it applies.
• 4. Subtract COGS from revenue for each category, then divide by revenue.
• 5. Line the categories up side by side and sort by margin percentage, not by revenue.

A quick example: say Fasteners does $40,000 in revenue at a 45% margin, Power Tools does $60,000 at 22%, and Lumber does $80,000 at 18%. Blended, that store is sitting at roughly 26% overall — a number that might satisfy a quick glance but that completely hides the fact that Lumber, your biggest revenue line, is running margins nine points below Power Tools and 27 points below Fasteners. If Lumber grows next quarter and the other two stay flat, your blended margin drops even though nothing about how you're pricing changed.

What's the Difference Between Blended Margin and Product Mix?

Blended margin is one number for the whole store. Product mix is the share of revenue coming from each category. The two interact in ways that can mislead you if you only watch the blended figure: your category margins can hold perfectly steady while your blended margin still moves, purely because customers bought more of a low-margin category and less of a high-margin one.

That's why a margin drop isn't automatically a pricing problem. Before you touch prices, check whether it's a mix shift — more units sold in a thin-margin category — or a real margin compression inside a category, where costs went up, a promotion ran too deep, or shrink is eating the difference. Those two problems have completely different fixes. See retail pricing basics on markup, margin, and when to discount for how markup and margin relate before you start adjusting.

Which Categories and Vendors Are Actually Dragging Your Margin Down?

Once you have margin broken out by category, run the same breakout by vendor. A category can look fine on average while one vendor inside it is dragging the whole thing down with worse cost terms, higher freight, or more returns. The usual culprits worth checking:

• MAP-restricted brands where you can't discount but landed cost keeps creeping up.
• Heavy or bulky items where freight-in eats a larger share of the sale price than it does for small goods.
• High-shrink categories (small, easily pocketed items) where recorded margin looks fine but real margin, after loss, is lower.
• High-return categories where refunds and restocking labor quietly erase the margin on the original sale.
• Loss-leader or price-matched items carried to compete on visibility, not to make money.
• Vendors with worse terms than others in the same category — a comparison you can only make once cost is tracked per vendor, not just per item.

Pair this with an item sales report to find your actual best and worst sellers — high revenue and high margin are not the same thing, and a top-seller by units can still be a drag on profit.

How Do You Move Shelf Space and Marketing Toward What Earns?

Margin data is only useful once it changes what you buy, where you put it, and what you promote. Once you know which categories and vendors earn, act on it deliberately rather than leaving shelf space and campaign dollars where they've always been:

• Reallocate physical space toward higher-margin categories with proven sell-through, not just proven volume — check sell-through rate alongside margin so you're not just facing out slow, high-margin dead weight.
• Adjust reorder quantities so cash isn't tied up restocking thin-margin lines at the same rate as your top earners.
• Push marketing budget toward categories that convert into real profit, not just toward whatever has the most inventory to move.
• Renegotiate or requalify vendors whose terms are visibly worse than others in the same category once you can show them the numbers.
• Consider discontinuing chronic underperformers rather than carrying them out of habit — see how to spot and clear dead stock for how to unwind a category without wrecking margin on the way out.

How Often Should You Review Margin by Category?

Monthly is the minimum for most stores — enough time for a category to show a real trend without reacting to noise from a single big order or a short promotion. Run a deeper review each season or ahead of a major reorder cycle, when you're deciding what to bring in for the next few months. If a category is volatile — new vendor, new promotion, high return rate — check it weekly until it settles. Margin by category is a habit, not a one-time report; it belongs in the same regular routine as the KPIs you already check every morning.

How Does Retailer OS Show Margin by Category and Vendor?

Retailer OS keeps cost and revenue on the same catalog the register sells from, so margin by category isn't a spreadsheet reconciliation project — it's a report against live data. Cost comes from purchase orders and receiving, so landed cost per item stays current as vendors and pricing change, and every sale, return, transfer, and adjustment writes to the same per-item, per-location inventory ledger that inventory visibility is built on.

• Dashboards and reports with saved views, so a category-and-vendor margin breakout is a report you build once and reuse — see retail analytics.
• Same-store sales to separate real category growth from simple location growth.
• Scheduled email digests so margin trends land in your inbox instead of requiring a login every morning.
• Cost tracking through purchase orders and receiving, so category COGS reflects what you actually paid, including vendor-by-vendor differences.

With an AI plan (from $19.99/month), the AI merchandising assistant can help surface which items or categories are worth a closer look based on demand and margin patterns — it's a paid add-on layer on top of the reports, not a replacement for reviewing the numbers yourself. And because Retailer OS sends a daily sales journal per channel to QuickBooks Online rather than keeping a general ledger itself, the margin data you see in reports lines up with what eventually lands in your books, instead of two systems telling two different stories.