E-commerce
October 28, 2026
You are wondering which inventory indicators to track to increase your profits? The answer lies in three KPIs: stock rotation, carrying costs, and opportunity costs. When tracked well, they transform your purchasing, pricing, and merchandising decisions into margin levers. Neglected, they let cash slip away silently.
Managing quantities by channel or warehouse is the foundation. But it is these advanced indicators that make the difference between a dormant stock and a profitable one. The trap: looking at sales without ever measuring the real cost of inventory. A catalog that is too broad or too slow eats into the cash you could invest elsewhere.
So which inventory KPIs to track to increase your profits? On the agenda:
Why is stock rotation the first indicator to monitor?
How to calculate and correctly interpret this ratio?
What hidden costs do carrying costs include?
How do opportunity costs drag down your margins without you noticing?
How does Qstomy help connect inventory data and customer experience?
Let's go.
Summary
Why is stock rotation the first indicator to monitor?
Stock rotation measures how many times your inventory is sold and replaced over a period. It is the metric that directly links your cash flow to your sales. Fast-moving stock frees up cash; stagnant stock ties up your money in boxes.
The formula is simple: cost of goods sold divided by average inventory for the period. If you sell €100,000 worth of products per year with an average inventory of €10,000, your rotation is 10.
There is no perfect number. Each sector has its own habits, and some stores turn over three times a year, others twenty. What matters is your position relative to the best in your category. The most successful merchants generally turn over faster than their direct competitors.
Why start with this KPI? Because it condenses everything: your ability to buy just right, sell quickly, and reinvest. A ratio that drops over several months is often the first sign of a catalog or pricing imbalance.

Convert over 2,000 customers on average per month with Qstomy.
The world’s 1st Shopify AI dedicated to customer conversion



Empowering 200+ e-commerce merchants
How to interpret a rotation that is too high or too low?
A very high rotation is not always good news. If you turn over twenty times a year, you are selling very fast, but you risk stockouts on your best-selling items. This can also signal prices that are too low, leaving margin on the table.
Conversely, a rotation that is too low betrays a problem. Either you are stocking the wrong products, your merchandising isn't highlighting them, or your price discourages purchase. In any case, money remains stuck instead of funding your growth.
The right reflex: monitor this ratio at least quarterly, and ideally monthly. Then compare results to previous periods to spot a trend, not an isolated accident. A drop in rotation over two consecutive months deserves a real analysis.
Also consider breaking it down by category and SKU: the global average often masks strong disparities. One category may turn over very fast while another sleeps, and this detail guides your next purchases.
What concrete decisions does rotation enable?
Stock rotation is not a number to display: it is a decision-making tool. It illuminates four specific levers of your store.
Price : a rotation that is too fast suggests you could sell for more without losing volume.
Production : it indicates when to restart manufacturing to avoid stockouts.
Supplier purchases : it shows which SKUs deserve priority restocking.
Marketing : it reveals products that need a push to sell through.
Think about cross-referencing this metric with your other performance data. If your rotation drops while traffic rises, the problem likely lies in the product page or price positioning, not demand.
Conversely, a rotation that rises without a traffic increase often means your shoppers are finding what they are looking for. In both cases, rotation alone is not enough: it must dialogue with your marketing KPIs and customer feedback to drive real decisions.
What are carrying costs and why is ignoring them expensive?
Carrying costs include all secondary expenses related to holding stock. These include storage, warehousing, order fulfillment, accounting staff, and potential interest costs. Losses are also added: theft, breakage, and deterioration.
These fees are discreet because they never appear on a product's price tag. Yet, they eat into your margin month after month. An item that doesn't sell costs not only its purchase price: it also costs the space it occupies and the energy it consumes.
Many merchants estimate these costs by dividing the total inventory cost by four. If your total annual inventory cost reaches €100,000, your carrying costs are around €25,000. This figure, even if approximate, changes how you read your purchasing decisions.
How to simply calculate your carrying costs?
No need for perfect accounting to start. The quick method is to take the total cost of your inventory and divide it by four. You get an estimate of your carrying costs for the year.
This approximation is enough to make better decisions. It helps you compare two scenarios: keeping a slow-moving SKU in stock, or freeing up space for a product that sells well. Often, the calculation clearly leans one way.
The key is to measure, even roughly. A merchant who knows their carrying costs makes different decisions than one who only looks at the purchase price. They factor in the cost of time, space, and risk into every restocking choice.
Why are opportunity costs the most important KPI?
Opportunity costs represent the lost revenue from a poor inventory investment. It is the most important KPI because it directly impacts your ability to generate profit.
Imagine a product launch that flops. The money invested will never return as sales. Worse: that money could have funded a high-demand product. You have tied up capital in a mistake.
The same scenario happens when you overstock a slow item. Not only does it tie up your cash, but it also prevents you from buying fast-moving SKUs. The real cost is not the value of the unsold stock: it is everything you could have sold instead.
How to rationalize your catalog to reduce these costs?
Rationalizing your inventory means sorting your SKUs to decide which ones deserve your capital. A simple method is to divide your products into three segments.
Fast rotation and high margin : often a small part of your stock, but the most valuable.
Slow rotation and high margin : probably the majority of your inventory.
Slow rotation and low margin : a significant portion that weighs down your results.
This breakdown clarifies your decisions. Increase purchases of fast and profitable products, keep slow but profitable products under control, and reduce slow and unprofitable products as quickly as possible. This frees up cash for what truly generates returns.
How to link these inventory KPIs to your merchandising decisions?
Your inventory KPIs are useless if they stay in a spreadsheet. They must guide how you present your products. A fast-moving SKU deserves a spot on your homepage and well-placed recommendations.
A slow but profitable item can be highlighted through editorial content, a buying guide, or seasonal promotion. A slow and unprofitable product, on the other hand, deserves to disappear from your promotions so it doesn't waste attention unnecessarily.
This is where conversational data provides valuable insight. The questions your customers ask reveal what they are truly looking for, beyond raw rotation numbers. Cross-referencing stock volume with customer intent helps decide what to push.
What signals should trigger an inventory alert?
Good inventory tracking relies on thresholds, not impressions. Set simple triggers that alert you before the problem becomes costly.
Rotation en baisse over two consecutive periods for the same category.
Stock dormant over three months for a low-selling SKU.
Rupture imminente on a fast-moving, high-margin product.
Carrying costs that rise without a corresponding increase in revenue.
These signals give you a head start. An alert handled early costs far less than clearing out urgent stock with discounts that crush your margin.
How to track these metrics without spending all day on it?
No one needs to recalculate their entire inventory every morning. The key is consistency, not intensity. A monthly review of rotation, a quarterly check of carrying costs, and an analysis of opportunity costs at each launch are sufficient.
Centralize your data in one place: quantities by channel and warehouse, return rates, cost of goods sold. Without this common foundation, every calculation becomes a chore, and you will eventually abandon tracking.
Automate what can be automated. A dashboard powered by your store saves you hours and prevents data entry errors. You focus on decisions, not data collection.
How does Qstomy help connect inventory and profitability?
At Qstomy, we support over 100 merchants with an AI agent designed for Shopify stores. Our role: guide customers toward purchase and reduce friction that causes lost sales, including for products you want to prioritize for clearance.
Concretely, Qstomy acts on product recommendations, upsell and cross-sell, cart, order tracking, and after-sales service. Result: your high-turnover stock is better valued, and your slow but profitable SKUs find buyers at the right time.
Our approach remains that of an agent, not just a reporting tool. Where a dashboard shows you a number, Qstomy intervenes in the purchase journey to turn that number into sales. Your inventory KPIs become concrete actions on the customer side.
What checklist before driving profitability through inventory?
Before you start, validate these few points to build a solid foundation.
Calculate your stock rotation for the last full period.
Estimate your annual carrying costs, even approximately.
Segment your catalog by rotation and margin.
Set alert thresholds for dormant stock and out-of-stocks.
In short
Rotation, carrying costs, and opportunity costs form the trio that truly drives your profits. Monitor them regularly and act on your purchasing, pricing, and merchandising decisions.
Frequently Asked Questions
How often should you track these KPIs? At least quarterly for rotation, monthly if possible.
What is the right rotation level? There isn't one: compare yourself to your sector and your top competitors.
To go further: E-commerce CRM and customer support: using the right data to respond better - Qstomy, FAQ, search, or AI chatbot: choosing the right tool to help the customer - Qstomy, Training an e-commerce chatbot with Shopify: using the right data without creating bad responses - Qstomy, Which e-commerce platform to choose for a small business? - Qstomy, Which platform to choose to create an e-commerce site? - Qstomy, Why use social media for e-commerce customer service? - Qstomy, Using conversations to improve merchandising without betraying the customer - Qstomy.

Enzo
October 28, 2026


