How to Track Gross Margin by Product Without a Spreadsheet
- Businesses tracking margin at the product level are 2.4 times more likely to discontinue unprofitable lines within a year
- The components of gross margin at the product level
- Setting up cost of goods tracking in your existing tools
- Product margin tiers: how to categorise and act on the distribution
- Using AskBiz to surface product margin without manual data work
- Connecting product margin to your buying decisions
Overall gross margin hides the product-level variance that drives decisions. A business with a 38% overall gross margin might have products ranging from 12% to 71% margin. Knowing which is which changes everything: what you reorder, what you promote, and what you discontinue.
- Businesses tracking margin at the product level are 2.4 times more likely to discontinue unprofitable lines within a year
- The components of gross margin at the product level
- Setting up cost of goods tracking in your existing tools
- Product margin tiers: how to categorise and act on the distribution
- Using AskBiz to surface product margin without manual data work
Businesses tracking margin at the product level are 2.4 times more likely to discontinue unprofitable lines within a year#
That finding, from a 2024 retail profitability study, reflects a straightforward truth: you cannot make decisions about products you do not have data on. Most small business operators know their overall gross margin. Very few can tell you the margin on each individual product without spending an hour in a spreadsheet. The result is that decisions about which products to promote, reorder, or discontinue are made based on revenue and gut instinct rather than profitability. This consistently favours high-revenue, low-margin products over low-revenue, high-margin ones — because revenue is visible and margin is hidden. Making margin visible changes the decisions you make and, over time, the composition of your product range shifts toward lines that actually sustain the business.
The components of gross margin at the product level#
Gross margin by product requires three inputs: selling price, cost of goods sold per unit, and return rate. Selling price is straightforward, though you should use the net average selling price after discounts — if you regularly sell a product at 20% off, your nominal price is misleading. Cost of goods sold per unit is where most businesses have gaps: it should include purchase price, import duties or tariffs, inbound shipping, and any quality inspection or preparation costs. A product purchased at £15 might have a landed cost of £19.50 once all inbound costs are included. Return rate matters because a product with a 20% return rate effectively has a 20% reduction in net revenue, and some of the returned units may not be resellable. Include all three components and your margin number will be significantly more accurate than a simple revenue-minus-cost calculation.
Setting up cost of goods tracking in your existing tools#
The most common reason small businesses cannot track product-level margin is that they have never entered cost of goods data into their sales or inventory platform. In Shopify, you can add a cost per item to every product in the Products section. Xero tracks COGS through inventory items if you have set up inventory tracking. QuickBooks has similar functionality. Once cost of goods is entered against each product, your sales platform can begin calculating gross profit per product automatically on future sales. The initial data entry — if you have 50 to 200 SKUs — typically takes two to four hours. After that, the margin data is available for every transaction going forward. For historical analysis, you will need to retroactively assign costs, which is more work but worth doing for your top 20 products by revenue.
Data-backed guides on AI, eCommerce, and SME strategy — straight to your inbox.
Product margin tiers: how to categorise and act on the distribution#
Once you have margin data for your product range, organise it into tiers. High margin (above your overall average by 10 or more percentage points): these are your strategic assets. Prioritise stock availability, consider expanding the range in this category, and allocate a higher share of marketing budget. Mid-margin (within 10 percentage points of your overall average): these are your volume workhorses. Maintain them but do not increase marketing investment without evidence of growth potential. Low margin (more than 10 percentage points below your average): these require a specific decision — can you renegotiate supplier pricing to improve margin, can you raise the selling price without volume impact, or should you discontinue? Every product in the low-margin tier is taking up cash, storage, and attention that could be deployed on higher-margin lines.
Using AskBiz to surface product margin without manual data work#
Once your cost of goods data is in Shopify or your inventory system, AskBiz can pull margin calculations automatically and surface them in response to plain-English questions. Ask: "Which five products had the lowest gross margin this quarter?" or "Which product category is dragging my overall margin down?" and get specific answers without building a custom report. For operators running businesses with 100 or more SKUs, the ability to ask a focused question and get a ranked answer in seconds — rather than spending an afternoon in a spreadsheet — changes how frequently product margin reviews happen. Most operators who do this manually review margin quarterly at best. With automated querying, monthly margin reviews become practical, and the decisions they enable compound over time.
Connecting product margin to your buying decisions#
Product margin data is only valuable if it changes your buying behaviour. Build a simple rule: before placing any reorder, check the product's margin tier. High-margin products get priority restocking — running out of a high-margin product is a profit loss that is immediately recoverable with an urgent order if needed. Mid-margin products should have a standard reorder process based on sales velocity. Low-margin products should require a supplier negotiation or a pricing review before the next order is placed — and if neither improves the margin tier, the product should be evaluated for discontinuation. Over 12 months, this discipline shifts your inventory composition toward higher-margin lines, which typically increases overall gross margin by three to five percentage points without requiring any increase in revenue.
AskBiz predicts when you'll run out of stock, which suppliers are causing delays, and how much cash is tied up in slow-moving inventory.
Our team combines expertise in data analytics, SME strategy, and AI tools to produce practical guides that help founders and operators make better business decisions.
Stop stockouts before they cost you customers
AskBiz predicts when you'll run out of stock, which suppliers are causing delays, and how much cash is tied up in slow-moving inventory.
Connects to Shopify, Xero, Amazon, QuickBooks, Stripe & more in minutes