Sell Through Formula: How to Calculate Sell-Through Rate Effectively

An important KPI in the retail landscape is the Sell-Through Rate (STR). It is necessary to understand if a business is selling its products efficiently. Whether you own an apparel store or an electronics outlet, understanding and calculating the sell-through rate will provide you with valuable data that you will need to optimise inventory flow and make the right inventory investment. In the broader sense, it will help reduce the cost of holding inventory and determine what strategies you can adopt to ensure there is no overstocking or stockouts, thereby increasing revenue. A study indicates that globally, retailers lose $1.1 trillion due to stockouts and overstocking; this makes it a must to know about Sell Through Formula and how sell-through rate works. This article will explore the sell-through rate, its importance, and how it is calculated.
- What Is A Sell-Through Rate?
- Sell Through Formula: How to Calculate Sell-Through Rate?:
- How to Calculate Sell-Through Rate Effectively?
- Why Do Sell-Through Rates Matter?
- What is an Ideal Sell-Through Rate?
- Get Better Sell-Through Rates With Inventory Management Solutions From WareIQ
- Conclusion
- FAQs About Sell-Through Rate Calculation
What Is A Sell-Through Rate?
The sell-through rate (STR) is the percentage of units sold in a specific period out of the number of units purchased at the start. STR gives SKU-level visibility and helps retailers understand appropriate inventory strategies. It helps retailers understand when to reorder, promote, or decrease the purchase of new inventory.
Sell-through rates provide you with an estimate of how popular a specific product in your inventory is. Essentially, a product with a high sell-through rate is an indicator of the fact that the product is popular. On the other hand, the product range isn’t quite popular if the sell-through rate is low.
So, in essence, the sell-through rate can help indicate demand for a certain product based on the overall inventory that a business has.
Sell Through Formula: How to Calculate Sell-Through Rate?:
You can use the sell-through formula stated below to calculate the sell-through rate:
Sell Through Rate = (Total units sold / Total units received) x 100.
Let us understand this with an example: if a business owns an apparel store, has bought 1000 white T-shirts at the start of the month, and has been able to sell 700 white T-shirts by the end of the month, then the STR that month will be calculated as:
Sell-Through Rate = (700/1000) x 100
Sell-Through Rate = 70%
How to Calculate Sell-Through Rate Effectively?
There are several other considerations that a business needs to do to calculate sell-through rate in an accurate manner:
- Returns Adjusted STR: To avoid overstating the sell-through rate, it is best to subtract the returns from the total number of units sold.
- Channel Specific STR: Calculate STR for multi-channel retailers to identify the divergent preferences.
- Seasonal and Trend Normalisation: To understand the STR due to spike in sales seen during promotions or holidays, you can use a 12-week moving average or have a normalised baseline.
Why Do Sell-Through Rates Matter?
The sell-through rate is an insignificant metric. However, it can offer you beneficial insights and help to optimise inventory management too. There are various benefits of understanding and applying the sell-through rate:
- STR helps you identify the popularity of the products in your inventory. It reflects which items are selling slower and which items are selling out faster. This knowledge will enable you to understand customer demands and modify your product or create a product mix to increase sales.
- Tracking STR across different year periods will assist in assessing future inventory needs. Furthermore, it prevents you from overstocking slow-selling products and stockouts of fast-moving items.
- Lastly, you can adjust your investments when inventory needs are understood. This means that you can invest your capital in an item that is very popular and in high demand. Conversely, you can avoid buying inventory that is not in demand. This is a contributing factor to increasing your overall revenue.
What is an Ideal Sell-Through Rate?
The STR will also fluctuate as the demand for a product or an item fluctuates, depending on the season or new launches. Hence, it is essential to understand the ideal STR to forecast a product’s demand and invest accordingly. Let us know what STR can be considered good STR and what is not so good:
- Good Sell-Through Rate: An STR is considered good if it is above 80%, indicating that a large portion of the inventory is being sold out.
- The Average Sell-Through Rate: STR that ranges from 40% to 80% is considered average because it indicates that at least half of the inventory is being sold.
- Below-Average Sell-Through Rate: When a business’s STR is below 40%, it is considered below average and indicates a problem. A large chunk of the inventory is not being sold out.
When the STR is below average, it indicates that the business should revise its inventory management strategy and reevaluate the product’s positioning or marketing.
It might seem that 100% STR is the dream goal for any business. However, 100% STR indicates that there is a surplus in demand that has yet to be fulfilled. It presents an opportunity for businesses to increase their stocks to fulfil the excess demands.
Get Better Sell-Through Rates With Inventory Management Solutions From WareIQ
WareIQ is a Y-Combinator-backed eCommerce full-stack platform offering multi-channel fulfillment across D2C, Marketplaces, Quick Commerce, and B2B (General Trade & Modern Trade)
Our solution offers:
- Pan-India network of Seller Flex & FAssured compliant across 12+ cities operated by WareIQ and shipping partners for last-mile delivery across 27000+ pin codes
- Multi-Channel Fulfillment Platform with plug-and-play integrations across marketplaces (Amazon, Flipkart, Myntra, Nykaa, etc.), D2C platforms (Shopify, Magento, Woocommerce, etc.), WMS, and ERPs to support fulfilment across distributors, flagship stores and eCommerce channels with analytics capabilities to assess operational performance
- Inventory LogIQ: AI-led multi-channel inventory planning solution to minimise stockouts and automate replenishment
- Leverage the tech-enabled returns QC solution to capture, centrally store, and auto-index HD media evidence of damaged or missing returned products and eliminate marketplace claims rejections.
- A host of seller enablement and support – dedicated account manager, APOB/PPOB registrations, GST registration, NDR & COD verification, etc.
Conclusion
A Sell-Through Rate (STR) is a critical metric that depicts how well a business performs regarding sales and revenue. STR is the number of units sold out of the number of units purchased at the start of a specific period. A high sell-through rate is an indicator of how successful the business is in selling the products. Likewise, a lower STR implies the company cannot get the products out in the market. Businesses improvise and adopt inventory management strategies based on their STR, which can help solve the problem of overstocking and stockouts. STR can also help to understand how to introduce a slow-moving product to the market to attract more customers.
Also check – Cost of Production Formula : Types & Examples for Businesses
FAQs About Sell-Through Rate Calculation
Is 100% STR a good rate?
Not really; a 100% STR indicates that demand is not met and can increase the number of frustrated customers. A balanced STR of 70-90% is ideal.
How often should a business calculate STR?
Calculate STR monthly. However, for businesses selling perishable or seasonal goods, it’s best to calculate STR weekly to avoid markdowns.
Is it ideal to include returns in units sold?
The standard formula for calculating STR primarily calculates the units sold out of the units purchased. However, if you want to get a more accurate STR, it’s best to remove returns from units sold.
Can STR be used to evaluate performance during promotions?
Calculating STR during promotional windows against the basic STR can help understand promotions, lifts and ROI.
Does seasonality affect STR?
Yes, peak seasons often result in higher sales, leading to inflated STRs. It is best to use seasonally adjusted benchmarks to set realistic goals.