WB/Ozon Supply and Stock Tracker: Excel with Live Formulas 2026
Seller: SirBob
Price: 2.47 USD
Available. The final price depends on the selected options and is checked before payment.
Product description
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.