SKU Performance Metrics: Track Profitability by SKU

Last updated: September 2026

SKU Performance Metrics: What to Track

Quick answer: SKU performance metrics tell you which products earn their place in your catalog and which quietly drain it. Tracking how fast each SKU sells, how profitably, how often it stocks out, and how much cash it ties up lets you prioritise your winners, fix or cut the laggards, and keep stock aligned with real demand rather than habit.

TL;DR: Watching the right per-SKU signals — sales velocity, margin, turnover, stockout frequency — turns inventory from guesswork into decisions. Forthcast produces per-SKU demand forecasts and reorder points for Shopify stores, so a merchant can see stockout risk and replenishment timing per SKU.

Tracking SKU performance is essential for improving profits, managing inventory, and meeting customer demand. By focusing on key metrics, businesses can identify top-performing products, reduce costs, and make smarter decisions. Here are the main takeaways:

• SKU Turnover Rate: Measures how quickly products sell and are restocked. Compare turnover with the SKU’s own history and category economics; there is no universal healthy ratio.
• Gross Profitability per SKU: Gross profit is net sales minus COGS, and gross margin divides that by net sales. Contribution margin goes one step further and also subtracts the SKU's other variable costs (selling fees, shipping, advertising). Compare that contribution with the cash, space, and service effort the SKU requires.
• Stock Levels and Holding Costs: What it costs to keep each SKU on the shelf (storage, insurance, labour, depreciation, financing) against the risk of running out.
• Sales Volume per SKU: Shows demand trends and guides marketing or reordering strategies.
• Dead Stock Identification: Flags SKUs that exceed a merchant-defined no-sale window so the team can review tied-up capital and space.

Advanced metrics like demand forecast accuracy, anomaly detection, and service levels provide deeper insights for long-term planning. Forecasting tools can process these signals for every SKU at once, which saves the manual work of tracking them in a spreadsheet.

Focusing on these metrics gives you the inputs for better inventory control, tighter stock levels and higher profitability; the results depend on acting on them.

Why Tracking Sales by SKU Matters for Shopify Merchants

Core SKU Performance Metrics to Track

As mentioned earlier, having accurate data is critical. To manage SKUs effectively, there are five key metrics you need to monitor.

Each one provides valuable insights that can guide your inventory decisions.

SKU Turnover Rate

The SKU turnover rate measures how quickly products sell and are restocked. It’s calculated by dividing the cost of goods sold (COGS) by the average inventory. This metric helps you understand whether your products are moving efficiently or sitting unsold.

A high turnover rate reflects strong sales and efficient inventory management. On the flip side, a low turnover rate may point to overstocking, weak sales, or outdated inventory. Do not apply one turnover target across the catalogue. Compare each SKU with its own history, category economics, lead time, margin, and service-level role.

"Inventory turnover is typically measured either at the SKU (Stock-Keeping Unit) level, or averaged out at a more aggregate level."
– Joannes Vermorel, March 2020

Turnover rates also vary by industry, so compare a SKU with its own category and history rather than a cross-industry figure. If you’re dealing with low turnover SKUs, consider strategies like adjusting prices or bundling products. Tracking turnover at the individual SKU level gives you better control and helps you refine pricing and supply chain decisions.

Gross Profitability per SKU

To identify which products contribute most to your profitability, you need to calculate gross profitability at the SKU level. Start with gross profit per SKU (net sales minus COGS) and gross margin (gross profit divided by net sales). Then account for the other variable costs of selling the SKU, including selling fees, shipping, and advertising, rather than just looking at revenue.

Subtracting those variable costs from net sales gives contribution margin per SKU, a second metric alongside gross profit (net sales minus COGS only) and gross margin (that profit as a share of net sales), and the more useful one for deciding whether a SKU is worth carrying. A useful threshold is business-specific: judge contribution margin after variable costs against the inventory investment and service effort the SKU consumes. FIFO (first in, first out) costing shows how unit cost changes over time. Additionally, analysing the SKU ratio (percentage of SKUs in each profit range) and the sales ratio (units sold in each profit range as a percentage of total sales) can highlight underperforming products that might be hurting your bottom line.

Stock Levels and Holding Costs

Monitoring stock levels and their holding costs is crucial for avoiding the risks of overstocking or running out of inventory. Metrics like days of inventory on hand - how long your current stock will last at current sales rates - are invaluable for planning reorders.

Holding cost should be calculated from your own storage, insurance, labour, depreciation, financing, and fulfilment costs rather than a universal percentage. Keeping a close eye on these costs allows you to set appropriate reorder points and adjust safety stock levels based on demand and lead times. This ensures you’re not tying up unnecessary capital in inventory.

Sales Volume per SKU

Tracking the number of units sold for each SKU over time provides insight into demand patterns, seasonal trends, and the impact of promotions. This metric helps you allocate marketing resources and make informed reordering decisions.

By pairing sales volume data with profit margins, you can identify which products are most valuable. For instance, a high-volume, low-margin product might be essential for cash flow, while a low-volume, high-margin product could yield greater profit per unit. Sales volume trends can also guide marketing strategies, whether it’s boosting advertising for fast-growing products or supporting slower-moving ones with promotions.

Dead Stock Identification

Dead stock is inventory that has exceeded a merchant-defined no-sale window and no longer has a credible demand plan. These items drain profitability by tying up capital, increasing carrying costs, and occupying valuable warehouse space. Identifying and addressing dead stock quickly is essential.

"Dead stock can be a major expense that reduces profitability by stalling revenue, increasing carrying costs and taking up valuable warehouse space."
– Abby Jenkins, Product Marketing Manager, NetSuite

Set the no-sale window by product lifecycle, seasonality, lead time, and return options; a fixed day count is not appropriate for every catalogue. Inventory management software can help track product movement and flag slow-moving items before they become a larger issue. Once identified, act quickly - options include discounts, bundling, alternative sales channels, supplier returns, or donations.

Regular audits for dead stock should be part of your inventory management routine. The sooner you act, the less impact these items will have on your profitability and cash flow.

SKU KPI Reference Table

These are the KPIs that actually drive SKU efficiency. Each one answers a different question, and together they tell you whether a SKU earns its shelf space.

How to rank SKUs by revenue, margin, and turnover

Ranking on revenue alone hides the problem SKUs. Rank on all three and read them together: a SKU with high revenue but low margin and slow turnover is consuming cash, while a modest-revenue SKU with strong margin and fast turnover is quietly funding the business. GMROI collapses the three into one number when you need a single sort — it rewards SKUs that turn profit quickly per dollar of stock, which is why buyers use it to decide what to reorder and what to drop.

What is SKU variability, and why does it matter?

SKU variability is measured with the coefficient of variation (CV): the standard deviation of demand divided by mean demand. A CV near 0 means steady, predictable demand; a high CV means erratic demand that spikes and stalls. High-CV SKUs need proportionally more safety stock for the same service level — and they are where forecasting effort pays off most, because averages describe them badly. Segment your catalogue by CV before setting buffers: applying one store-wide rule to a high-CV SKU either stocks it out or drowns it in cash.

Maintaining service levels for slow-moving SKUs

Slow movers are the trap: their low volume makes percentage metrics like MAPE unstable, and a single order can look like a demand spike. Track their forecast error in absolute units (MAE) rather than percentages, and set their service-level target from the stockout consequence, substitution options, margin, lead time and buffer cost rather than from velocity alone: a 99% target on an unpredictable slow mover can tie up cash that a fast-moving SKU would turn several times over, so the target has to earn its buffer. The honest question for a slow mover is not “how do we never stock out” but “is this SKU worth the buffer it demands?”

Advanced Metrics for SKU Management

Effective inventory management goes beyond the basics. To truly optimise stock and meet business goals, it’s essential to track advanced metrics.

These indicators provide a deeper understanding of SKU performance and help refine strategies for managing inventory.

Demand Forecast Accuracy

Predicting future demand is just as important as monitoring current performance. Demand forecast accuracy measures how closely your predicted sales match actual results, and it plays a critical role in inventory planning, production schedules, and resource allocation. Accurate forecasts help avoid stockouts and reduce excess inventory, creating a smoother operation overall.

Evaluate forecast quality against a simple baseline at the same SKU and horizon. Use scale-appropriate error measures, track bias separately, and segment intermittent or promotion-driven demand instead of treating one accuracy percentage as universally good.

To enhance your forecasting accuracy, factor in seasonal trends, holidays, and potential disruptions like supply chain issues. Regularly updating forecasts with fresh data and encouraging collaboration between departments ensures predictions stay relevant and actionable.

Anomaly Detection

Anomaly detection is all about spotting data patterns that don’t fit the norm. These irregularities could signal market changes, successful promotions, data entry mistakes, or external disruptions. Quickly identifying outliers allows you to refine forecasts, address risks, and make smarter inventory decisions.

Automated systems for anomaly detection are particularly useful, reducing the need for time-consuming manual reviews.

Two hypothetical examples show the idea. A category's sales jump overnight and the check shows a social media post drove it, so you decide whether to reorder or treat it as a one-off. A steady SKU suddenly stops selling and the cause is a listing or supply problem, not demand, so you fix the cause instead of cutting the forecast.

Decide first what an anomaly alert is for: a forecast that needs correcting, or a sale that needs checking. Use historical and seasonal sales data, ensuring it’s clean and ready for analysis. Train your detection model with past data and keep refining it as new trends emerge.

Service Level per SKU

Service levels are a direct measure of how well you’re meeting customer demand. This metric complements turnover and stock level data by focusing on the likelihood of avoiding stockouts for each SKU. It’s a balancing act: keeping enough stock to satisfy demand while avoiding the high costs of overstocking.

Set service levels by SKU economics: balance stockout impact, margin, lead time, demand variability, substitution options, and carrying cost. Higher is not automatically better when the extra buffer destroys more value than the avoided stockout creates.

To set the right service level for each SKU, start by evaluating your current performance. Remember that a longer lead time raises the safety stock needed to hold the same service level, so price that extra stock in before choosing the target. Collaborate with finance and sales teams to weigh the costs of stockouts against inventory expenses. You might also consider setting different service levels for products based on their revenue or profit margins.

Higher service levels usually require more safety stock, so it’s important to find a balance that aligns with your business goals. Inventory management software can help by calculating trade-offs and suggesting service levels tailored to your needs.

sbb-itb-499c055

Using AI Tools for SKU Management

Managing SKU performance across a large number of SKUs can quickly spiral into a logistical headache without the right tools. A spreadsheet recalculates its formulas, but someone has to keep feeding it fresh sales and stock data, maintain the formulas as SKUs are added, and keep a forecast current for every row.

Forecasting software does this arithmetic continuously, so reorder decisions are made before stock runs out rather than after.

How AI Improves SKU Tracking

Forecasting software pulls the new sales in and refreshes every SKU's forecast itself, work that a spreadsheet leaves to whoever maintains it. It can also bring in more of the factors that move demand, such as seasonality and promotions, where your data records them.

AI also helps prevent inventory mishaps through automated alerts and threshold management. Its dynamic demand forecasting considers seasonal trends, promotional activities, market shifts, and external influences.

The aim is lower carrying cost and fewer stockouts. Measure both before and after you change tools, per SKU, rather than relying on anyone's headline percentage.

Forthcast's Role in SKU Management

Forthcast applies this to Shopify catalogues: per-SKU forecasts with practical reorder tools for online retailers.

With twelve-month demand projections, Forthcast gives businesses the foresight they need for effective planning. Instead of scrambling to fix stock issues as they happen, companies can anticipate demand trends and align their procurement schedules. The system even factors in lead times for each item, ensuring reorder suggestions are realistic and in sync with supplier timelines.

One standout feature is Forthcast's SKU-level anomaly detection. This tool flags unusual sales patterns, which could point to new market opportunities, supply chain hiccups, or data inconsistencies.

The platform's smart reorder suggestions take the guesswork out of replenishing stock. By analysing current inventory, projected demand, and lead times, it suggests reorder quantities and timing for you to review. Bundles and kits are supported, so component stock is tracked alongside the products you sell.

Forecasts account for seasonality and trend, and forecast-accuracy reports show how past forecasts compared with what actually sold, per SKU, so you can see where to trust them and where to check.

Practical Monitoring Checklist

Keeping a close eye on SKU performance requires a structured approach. By setting up clear processes, you can uncover trends and make informed decisions without unnecessary guesswork.

Key Metrics to Review Regularly

Regularly reviewing key metrics can help you avoid costly mistakes. Weekly check-ins are great for addressing immediate concerns like stock levels or unusual activity, while monthly reviews provide the chance to dig deeper into trends like profitability, turnover rates, and seasonal patterns.

Pay attention to sales volume alongside gross profit margins. A product might sell in high volumes but generate minimal profit, whereas a slower-moving SKU could be far more lucrative. Judge turnover against the SKU's own history and its category rather than one store-wide number; a sustained fall is the signal to look for.

Stock levels are another critical area to monitor. Keeping an eye on current inventory and projected demand helps you anticipate stockouts, especially for seasonal items where timing is everything.

To make these insights actionable, use structured comparisons.

Using Tables for SKU Comparison

Tables are an excellent way to compare SKU metrics at a glance. The figures below are illustrative. They allow you to consolidate key data - like sales volume, turnover rates, gross margins, and stock days - into one place for easy analysis.

SKU Code	Sales Volume (Units)	Turnover Rate	Gross Margin (%)	Stock Days	Performance Rating
SKU-001	1,250	8.2	32%	28	High
SKU-002	890	6.1	28%	35	Medium
SKU-003	320	2.8	15%	67	Low

This format lets you quickly spot relationships between metrics. For instance, a product with high sales but low margins might need a price adjustment. On the other hand, a low-volume, high-margin item could benefit from extra marketing.

You can also segment comparisons by product category, price range, or seasonality for more targeted insights. Updating these tables monthly ensures you stay on top of performance shifts and can identify SKUs that demand further attention.

Setting Alerts and Thresholds

To turn insights into action, set up automated alerts and thresholds. For stock levels, base your thresholds on factors like lead times and demand variability. For example, a product selling 50 units a week with a 14-day lead time needs about 100 units to cover the lead time; a reorder alert at 150 to 200 units adds 50 to 100 units of safety stock. Choose the buffer from your own demand variability and service target.

Performance thresholds should align with your business goals and industry norms. For instance, flag a SKU whose turnover falls well below its own usual rate, gross margins that dip below the level you set, or significant drops in sales volume. These alerts can prompt timely reviews and adjustments.

You can also configure alerts for unusual demand changes, for example sales at 150% or below 50% of normal (pick levels that suit each SKU's volatility), to catch potential issues early. Similarly, margin alerts can signal when it’s time to revisit pricing strategies or supplier agreements.

Tools like Forthcast’s automated alert system simplify this process. By continuously monitoring inventory thresholds and providing smart reorder suggestions based on projected demand and lead times, such tools let you focus on big-picture strategies instead of getting bogged down by data.

Finally, adjust the frequency of alerts based on how volatile a product is. High-demand or seasonal items may need closer monitoring, while stable products might require fewer updates.

Conclusion

Keeping track of SKUs is a cornerstone of success in e-commerce. Turnover, margin, stock level and sales velocity per SKU are the inputs to pricing, reorder and range decisions.

Focusing effort this way is how resources get used where they earn the most.

Analysing SKUs regularly also shows which products sell together, which helps with bundling, and which ones need planning ahead of seasonal peaks.

Forecasting software makes per-SKU tracking practical at catalogue scale. Forthcast provides twelve-month demand forecasts, SKU-level insights, anomaly detection, and automated reorder notifications. These tools help maintain optimal stock levels, cutting down on carrying costs and removing the guesswork from reorder planning.

Key Takeaways

For e-commerce, SKU tracking should be an ongoing, strategic effort. Focus on key metrics like turnover, gross margin ROI, and sales velocity. Use methods like ABC analysis to rank products by their performance, and perform regular audits to pinpoint underperforming SKUs. Be ready to phase out those that consistently underperform. As mentioned earlier, regular reviews and automated alerts play a big role in keeping SKUs on track.

Set up automated monitoring systems and critical alerts to avoid the risks of stockouts or overstocking. Concentrate on metrics that lead to actionable insights.

"Don't go crazy with your SKU count. Focus on keeping a catalogue small whilst still being able to increase lifetime value and new sales. For a lot of brands, 3 SKUs make up 50% of sales. You probably don't need hundreds of products that aren't driving revenue." – Ryan Treft, Founder & Partner of Coalatree and Peejamas

Investing in solid SKU tracking systems can lead to reduced excess inventory, better cash flow, and happier customers. Carrying cost is spread across storage, insurance, labour, depreciation and financing, so it is easy to underestimate; tracking it per SKU shows where better SKU management pays. Start with the basics, use automation where it makes sense, and keep refining your methods based on what the data tells you.

FAQs

How can businesses identify the ideal SKU turnover rate for their industry?

To figure out the best SKU turnover rate for your business, start by looking at industry benchmarks, as these can differ widely by sector. Treat any published benchmark as a starting point only: perishable goods need much faster turnover than durable goods, and your own history per SKU is the better comparison.

You’ll also need to adjust these benchmarks based on factors like demand fluctuations, seasonal trends, and how long your products can be stored. By regularly analysing your turnover rates alongside inventory data, you can make sure your stock levels match your business objectives and meet customer expectations.

How can I effectively manage and reduce dead stock in my inventory?

To tackle dead stock and keep it under control, start with regular inventory checks. These reviews make it easier to spot items that are slow to sell or have become obsolete. Once identified, you can take action by offering discounts, bundles, or special promotions to move the excess stock. Another option is to explore new sales channels that might attract different customers. If selling isn’t viable, donating unsold goods to charity not only clears storage space but also supports a meaningful cause.

Looking ahead, improving your demand forecasting and inventory management can help prevent dead stock from piling up again. Tools that offer precise sales predictions and automated alerts for reordering can help you strike the right balance - keeping shelves stocked without overdoing it.

How does AI enhance demand forecasting and inventory management for SKUs?

Forecasting software projects demand per SKU from sales history and seasonality. With this, businesses can make precise predictions about the demand for specific SKUs.

By spotting trends and identifying irregularities, AI helps prevent stockouts, avoid overstocking, and maintain optimal inventory levels. This leads to smarter resource allocation, healthier cash flow, and a more streamlined supply chain.

Related Reading

• SKU Demand Forecasting: The Complete Guide for Shopify Brands (2026)
• Inventory & Budget Tracking for Shopify
• Textile Inventory Tracking & Management
• Manual Demand Tracking & Bundling
• SKU Forecasting With Multiple Variables