--- title: "Lost Sales Analysis: Minimize Revenue Loss by Fine-tuning Stock Distribution" description: As Retail prepares for the re-opening of stores, we take a look at optimising the time serving customers without negatively affecting service excellence. image: https://blog.mercaux.com/hubfs/Group%20516.png --- [![mercaux-logo-landscape-1](https://blog.mercaux.com/hs-fs/hubfs/mercaux-logo-landscape-1.png?width=1076&height=377&name=mercaux-logo-landscape-1.png "mercaux-logo-landscape-1")](http://www.mercaux.com) - [Solutions](https://mercaux.com/) - [Customers](https://mercaux.com/customers.html) - [About Us](https://mercaux.com/about_us.html) - [Request Demo](https://mercaux.com/index.html#demo) ![](https://blog.mercaux.com/hubfs/Group%20516.png) ## Lost Sales Analysis: Minimize Revenue Loss by Fine-tuning Stock Distribution By [Tatiana Krivolutskaya](https://blog.mercaux.com/en/customers/author/tatiana-krivolutskaya) **May 17, 2021** ![](https://blog.mercaux.com/hs-fs/hubfs/tatiana_blog.png?height=150&name=tatiana_blog.png) ###### Tatiana Krivolutskaya Customer Success Manager, Mercaux - [Tweet](https://twitter.com/share) Collection and use of customer and sales data from physical stores have for some time been a hot topic in retail yet there is still a gap between theory and market practice. In this article (the first of a series) we’ll talk about Mercaux analytics functions and the power they give retailers to unlock valuable insights and allow retailers to make educated decisions. **![Group 521](https://blog.mercaux.com/hs-fs/hubfs/Group%20521.png?width=707&name=Group%20521.png)** **Lost Sales Analysis** Accurate stock distribution across stores is a key part of retail operations. While a product may be less popular and remain unsold in one store, in another store a customer may leave disappointed because the same product is not available. Mercaux’s analytics toolkit provides the data necessary to better distribute the product by geographically mapping out customer interest in specific product categories and sizes. This empowers retailers to plan stock distribution according to the appetite for certain products and sizes rather than on sell-through data which does not account for purchase intent.   **How Does It Work?** Our tool generates a report combining Mercaux app usage data with retailer’s sales data. It provides an estimate of the number of lost opportunities to sell a product when it is not available in store – this information would otherwise be lost or only delivered anecdotally by floor personnel without hard data to back it up. Firstly, we look at the number of times a specific product has been requested via the Mercaux app and the number of times it has been available / not available in stores during a specified period. Then we multiply the number of times the product wasn’t available by the average conversion to get the number of lost transactions. Secondly, we estimate the monetary value of lost sales by multiplying the number of lost transactions in a given product category by the average product price in that category. The resulting number is revenue lost due to mismatches between customer interest and product stock.   ![iMac-1](https://blog.mercaux.com/hs-fs/hubfs/iMac-1.png?width=560&name=iMac-1.png) **How can the Lost Sales Report be utilised?** - **Tracking** of aggregated number of **lost transactions** and see how well product distribution works; - **Moving stock** between stores or regions to reduce supply shortages by anticipating customer demand; - **Identifying unsatisfied demand** for specific sizes or colours to deliver missing items; - **Comparison of product interest** with actual sales to get a glimpse into product quality and price perception by customers – if interest is high but sales are low, quality or price may require additional attention.   **How Do We Show Data for Efficient Decision Making?** Reports on lost sales can be organized by - Product or colour **category/sub-category**; - **Sizes**; - **Store** or **store cluster**; - **Region** or **country**   Have you explored the Lost Sales Report yet? Who knows what you’ll discover. Reach out to your Customer Success Manager today to access a wealth of data on lost sales and start optimising your stock allocation.   - [Tweet](https://twitter.com/share) [Previous Post](https://blog.mercaux.com/en/customers/floor-runner-tips) [Next Post](https://blog.mercaux.com/en/customers/12-storeez-interview) ![mercaux-logo-white](https://blog.mercaux.com/hubfs/Logos/new%20Mercaux%20logo/mercaux-logo-white.svg "mercaux-logo-white") At Mercaux, we believe the successful retailers of tomorrow are those that embrace in-store technology today. Our mission is to enable retailers to transform the customer shopping experience by bringing the benefits of digital into physical stores. [Learn More](https://www.mercaux.com) Important Links - [Platform](https://www.mercaux.com/architecture.html) - [Customers](https://mercaux.com/customers.html) - [Partners](https://mercaux.com/partners.html) - [Resources](https://mercaux.com/resource-centre.html) - [Blog](https://blog.mercaux.com) - [Contact Us](https://mercaux.com/contacts.html) - [Request Demo](https://mercaux.com/index.html#demo) ![phone.svg](https://cdn2.hubspot.net/hubfs/3067823/awwal/phone.svg "phone.svg") Telephone: [+44 203 086 8938](tel:+442030868938) ![email.svg](https://cdn2.hubspot.net/hubfs/3067823/awwal/email.svg "email.svg") Email General: [info@mercaux.com](mailto:info@mercaux.com) ![address.svg](https://cdn2.hubspot.net/hubfs/3067823/awwal/address.svg "address.svg") 15 Alfred Pl, London WC1E 7EB © 2025 Mercaux LCI | [Privacy policy.](https://go.mercaux.com/privacy/) [Terms and Conditions.](https://mercaux.com/contacts.html) [![Share on Facebook](https://static.hubspot.com/final/img/common/icons/social/facebook-24x24.png)](http://www.facebook.com/share.php?u=https%3A%2F%2Fblog.mercaux.com%2Fen%2Fcustomers%2Flost-sales-analysis%3Futm_medium%3Dsocial%26utm_source%3Dfacebook) [![Share on LinkedIn](https://static.hubspot.com/final/img/common/icons/social/linkedin-24x24.png)](http://www.linkedin.com/shareArticle?mini=true&url=https%3A%2F%2Fblog.mercaux.com%2Fen%2Fcustomers%2Flost-sales-analysis%3Futm_medium%3Dsocial%26utm_source%3Dlinkedin) [![Share on Twitter](https://static.hubspot.com/final/img/common/icons/social/twitter-24x24.png)](https://twitter.com/intent/tweet?original_referer=https%3A%2F%2Fblog.mercaux.com%2Fen%2Fcustomers%2Flost-sales-analysis%3Futm_medium%3Dsocial%26utm_source%3Dtwitter&url=https%3A%2F%2Fblog.mercaux.com%2Fen%2Fcustomers%2Flost-sales-analysis%3Futm_medium%3Dsocial%26utm_source%3Dtwitter&source=tweetbutton&text=Lost%20Sales%20Analysis%3A%20Minimize%20Revenue%20Loss%20by%20Fine-tuning%20Stock%20Distribution)