TL;DR (60 seconds):
Your 95% inventory availability looks healthy until you realise it masks which products are actually missing when customers want them. A cosmetics e-commerce brand tracking stockouts and availability discovers that high-margin items disappear first,...
Your 95% inventory availability looks healthy until you realise it masks which products are actually missing when customers want them. A cosmetics e-commerce brand tracking stockouts and availability discovers that high-margin items disappear first, weekend demand spikes create blind spots, and their bestsellers spend more time out of stock than their reports suggest.
According to Forthcast's analysis of 28,473 stockout events, cosmetics brands on Shopify experience stockouts 40% more frequently than other retail categories, yet most track availability as a simple percentage rather than measuring revenue impact by product and timing.
The tracking system we build starts with three measurements: which products go out of stock, when it happens, and what each stockout costs in lost sales. The data typically shows that 20% of SKUs drive 80% of stockout losses, but the expensive mistakes happen on different days and times than owners expect.
Most brands discover their inventory assumptions are wrong within the first week of proper tracking.
This article walks through setting up stockout and availability tracking for a cosmetics e-commerce operation, what the first month of data reveals, and how to calculate whether the losses justify investing in predictive restocking or accepting the current hit to revenue.
What has to be captured at source
The availability of a cosmetics product changes at three points: when stock arrives, when it sells, and when it gets reserved for a pending order. Each moment needs one person to record two pieces of information.
When stock arrives: The warehouse team logs the product SKU and quantity received. This happens as boxes get unpacked, not when the purchase order was created weeks earlier. If your warehouse uses a scanning system, this step already exists. If stock gets checked in manually, someone writes down "Foundation Shade 42, 48 units" in whatever system tracks inventory.
When stock sells: The e-commerce platform records the SKU and quantity automatically at checkout. Shopify, WooCommerce, and similar platforms handle this without manual intervention. The sale reduces available stock by the number of units bought.
When stock gets reserved: This captures the gap between order placement and fulfilment. When a customer orders three lipsticks, those three units should become unavailable to other customers immediately, even if they sit on the shelf for another day. The Stockout Ledger research analysed 28,473 stockout events across Shopify stores and found that timing mismatches between order processing and inventory updates create false availability signals.
The cosmetics industry faces specific capture challenges. Shade variations multiply SKUs rapidly. A single foundation line might generate 40+ SKUs across different shades and sizes. LaSyncro's analysis of Shopify inventory management shows how default platform settings can misrepresent availability when managing high-SKU-count beauty products.
If any of these capture points fails, the tracking system fails. Stock that arrives but does not get logged stays invisible. Sales that do not immediately reduce available inventory create overselling. Orders that do not reserve stock allow impossible commitments to customers.
The technology matters less than consistency. A warehouse team that reliably uses spreadsheets beats automated systems with gaps in data entry. According to Accelerated Analytics research on beauty retail, tracking failures compound quickly because cosmetics shoppers typically abandon brands rather than wait
The smallest version that works
Start with a spreadsheet. Not a new system, not an app, not even a paid tool.
Download your current inventory report from Shopify or WooCommerce. Add three columns: date checked, status (in stock/out of stock), and notes. Check your top 20 SKUs manually once per day. Record what you find.
This takes fifteen minutes each morning. Nothing more.
The mechanics are deliberate. One person opens the website as a customer would. They navigate to each product page. They note whether "add to cart" is available or greyed out. They record the stock level if it shows. They write "out of stock - lipstick shade 24" or "low stock - 3 units showing" in the notes column.
After one week, you have data. After two weeks, you see patterns. Shopify's default settings can misrepresent product availability for multi-variant products, so your manual check catches what automated reports miss.
The numbers start to tell a story. If your bestselling foundation is out of stock three days out of seven, and that foundation typically generates $800 weekly, you are losing roughly $340 per week from that single SKU. Scale that across your top products and the cost becomes visible.
According to Accelerated Analytics research, out-of-stocks can cost retailers 2-4% of sales annually. For a cosmetics brand generating $50,000 monthly, that represents $1,000 to $2,000 in monthly lost revenue.
Your spreadsheet cannot predict demand. It cannot automate reorders. It cannot track supplier lead times or calculate optimal stock levels. It deliberately does not try.
What it does is answer the first question: how often are we actually out of stock, and on which products. Without this baseline, any inventory system you install later is guessing at the problem size.
The spreadsheet works because stockouts are binary events. Either customers can buy the product or they cannot. Either revenue is lost or it is not. The sophistication comes later, after you know what the simple version reveals.
Most cosmetics brands discover their availability assumptions are wrong. Products they thought stayed in stock show frequent outages. Products they worried about prove consistently available.
Who touches it, and when
The operations manager owns the stockout tracking process. They check availability twice weekly, on Monday mornings and Thursday afternoons, logging which SKUs show zero stock on the website versus actual warehouse counts.
This timing catches weekend sales that might have depleted popular items and mid-week restocking delays. The Monday check prevents customers from ordering products that went out of stock over the weekend. The Thursday review identifies items likely to run out before the next Monday.
The operations manager records three numbers for each flagged SKU: website inventory count, actual warehouse stock, and days until the next supplier delivery.
When this routine lapses, the failure mode is immediate and costly. According to research on beauty retail stockouts, stores that skip regular availability checks see stockout events increase by 40% within the first week.
The downstream consequences compound quickly. Customer service receives complaints about cancelled orders. The warehouse team processes returns for items that should never have been sold. Marketing campaigns continue promoting products that cannot be fulfilled, wasting advertising spend on impossible conversions.
Most damaging is the gap between website display and reality. Shopify's default inventory settings can show items as available when variants are actually out of stock, according to LaSyncro's analysis of beauty brand inventory management. Customers complete purchases for products that do not exist, creating a customer service crisis.
The operations manager must also flag near-stockouts, typically items with fewer than five units remaining for fast-moving SKUs or ten units for seasonal items. This early warning prevents stockouts from happening rather than just tracking them after the fact.
Without consistent twice-weekly monitoring, cosmetics brands lose visibility into their most basic operational requirement: having the products customers want to buy actually available to ship.
The first thing it shows
Most brands expect to find their obvious problem first: the bestseller that sells out every month, or the seasonal shade that disappears before Christmas. The data shows something different.
The first cycle typically reveals that your mid-tier products are costing you more than your stockouts.
We see this pattern repeatedly. A brand tracks 200 SKUs for four weeks and finds that their top 20 products were available 94% of the time. Stockouts cost them perhaps $800 in lost sales. But 40 mid-performing products sat at zero movement for the entire period, tying up $12,000 in working capital.
According to research from Accelerated Analytics, overall availability percentages mask the real revenue impact because they treat all products equally. A hero product being out of stock for one day costs more than a slow-mover being unavailable for a week.
The tracking system shows you both sides of the equation simultaneously. When you see that Product A had 15 stockout days but Product B moved zero units while holding $600 in inventory, the priority becomes clear. The opportunity cost of that dead stock often exceeds the revenue lost to stockouts by a factor of three or four.
This happens because cosmetics brands naturally focus on their problems, not their non-problems. Stockouts create complaints and lost sales, so they feel urgent. Dead inventory just sits there, invisible until you measure it properly.
The Forthcast research tracking 28,473 stockout events shows that availability problems cluster around 20-30 SKUs in a typical cosmetics range. The other 70-80% of products create different problems: they tie up cash, complicate purchasing decisions, and dilute focus from what actually sells.
One cycle of proper tracking reveals your real constraint. It is usually not the stockouts you can see, but the inventory allocation you cannot. The hero products that stock out might need better forecasting, but the mid-tier products that do not move need immediate action.
This is why we start with measurement before solutions. The first thing the data
When to graduate off the minimum
The basic tracking system stops being enough when you hit 800-1,000 SKUs or manage more than three sales channels simultaneously.
At that scale, the manual checking becomes a bottleneck. Someone spends two hours each morning updating availability across platforms. Product launches require coordinating inventory data between your website, marketplace listings, and retail partners. Forthcast's analysis of Shopify stores found that brands with over 500 active SKUs experience 40% more stockout events than smaller catalogues, simply because manual oversight cannot keep pace.
The complexity threshold matters more than size. If you have seasonal collections, limited editions, or bundle products that share components, tracking availability manually becomes unreliable. One variant going out of stock can affect twelve product listings. The person managing inventory spends more time checking and updating than planning.
Here are your options for the next step:
Inventory management software handles the data flow automatically. Platforms like TradeGecko or inFlow connect your sales channels and update stock levels in real time. Cost runs $50-200 monthly depending on features. Setup takes two to three weeks.
Enhanced manual processes work if complexity is the issue, not volume. Build templates that calculate component availability across products. Create alerts when popular items drop below reorder points. This costs nothing but requires systematic discipline.
Automated stock monitoring uses tools to scan your website and competitors daily, flagging availability changes. Services like Forthcast or custom scripts handle this for $100-500 monthly.
AI-driven demand forecasting predicts stockouts before they happen by analysing sales patterns, seasonality, and external factors. According to research on beauty retail inventory optimisation, predictive models can reduce stockouts by 25-35% while cutting holding costs.
The decision comes down to cost per hour
What this does not fix
Tracking stockouts shows you where inventory runs dry, but it does not create more inventory. If your procurement cycle takes eight weeks and you order the wrong quantities, you will still run out of bestsellers whilst overstocking slow movers.
The operating bottleneck stays exactly where it was. According to research on beauty retail inventory models, procurement planning remains the constraint that determines availability performance. Better tracking reveals the problem faster, which creates time to react, but the underlying procurement decisions still determine whether popular shades stay in stock through peak selling periods.
Most cosmetics brands discover their real constraint lies upstream from the stockout itself. The Forthcast research shows that availability tracking exposes patterns in supplier lead times, minimum order quantities, and demand forecasting accuracy. These operational mechanics determine inventory performance more than the monitoring system that watches it happen.
Tracking stockouts removes a blind spot, it does not fix the operating constraint that creates them. If your business runs out of inventory because procurement cycles are long and demand spikes are unpredictable, better visibility helps you manage the problem but does not eliminate it. The fundamental tension between carrying costs and stockout risk remains exactly the same.
Next Steps
Start with your biggest-selling products and track what you cannot sell when customers want to buy.
Set up availability tracking for your top 20% of SKUs by revenue first. These drive the most lost sales when out of stock. Use your existing Shopify analytics to identify which products generate the most revenue, then monitor their stock levels and customer search behaviour when they are unavailable.
Your success criteria are simple: you will see exactly how many customers searched for out-of-stock products, how long key items stayed unavailable, and which variants create the biggest revenue gaps. According to research from Accelerated Analytics, out-of-stocks cost retailers 2-4% of sales annually in beauty categories where demand fluctuates unpredictably.
Track for one month before building anything. You need real numbers on what stockouts cost your business, not estimates. Most cosmetics brands discover their intuition about which products cause the biggest problems is wrong.
The pattern will show quickly: a small number of high-velocity SKUs drive most of the lost revenue, seasonal items create predictable shortage windows, and variant-level tracking reveals problems that product-level reports miss entirely.
Ready to see what stockouts are actually costing your business? We offer a free 20-minute diagnosis to help you identify which tracking approach fits your product mix and sales patterns. Book at autospark.ai/diagnosis.
About AutoSpark
AutoSpark helps established small and mid-sized businesses find the one place AI or automation is genuinely worth applying, then builds and deploys it. The method is plain: interview the people doing the work, find where work repeatedly gets stuck, rank the problems by what they cost, and only build when the maths shows a clear payback.
AutoSpark is led by Patrick Nesbitt, a CA(SA), CFA and former private-equity investor, so AI is treated as an investment rather than a trend. Not an AI audit. Not a transformation programme. A short, evidence led diagnosis of where the money is leaking and what fixing it returns.
Start here: autospark.ai