WB/Ozon Supply and Stock Tracker: Excel with Live Formulas 2026
NO OUT-OF-STOCK AND NO FROZEN MONEY — STOCK UNDER CONTROL
An Excel supply and stock tracker for Wildberries and Ozon: computes days until zero for every article, builds a supplier order by a norm that accounts for delivery time and the minimum batch.
EXAMPLE FROM THE SCREENSHOT (real calculation of the workbook):
• 545 units in stock across 10 articles
• Sales velocity: 49.2 units a day
• Auto-order: 1310 units for 2 177 600 RUB
WHAT´S INSIDE (one xlsx, no macros):
• The "Products" sheet: stock, sales/day, days until zero, demand and status
• The order formula: the norm × (1 + safety stock), rounded to the minimum batch
• A supply journal with statuses: arrived / in transit / ordered
• The "Supplier order" sheet assembles itself with links from Products
• A summary: SUMIF by supply status, the critical SKU through INDEX/MATCH
• A 20% safety stock — a buffer for a demand spike
• Change the sales — the purchase demand recalculates
WHO IT´S FOR:
WB and Ozon sellers with an assortment of 10+ articles. A stockout costs lost sales, and excess stock freezes money — this template keeps the balance.
FORMAT: .xlsx, works in Excel and Google Sheets. Instant file delivery after payment.
No customer reviews yet.