Work · Profit, promotions and restocking for a Wildberries seller
Which items earn,and what to reorder today.
A Google Sheet for a Wildberries seller: the net profit of every item, a decision for every promotion, and a reorder list with quantities. It updates from the WB API every morning and sends the signals to Telegram.
Profit, promotions and restocking for a Wildberries seller · November 2026
WB unit economics
The summary for the period, then a sheet per question: profit by item with a status, stay or leave for each promotion with the lowest price that keeps the target margin, and what to order today with the quantity rounded up to the supplier's batch. The example is a clothing shop with 15 items and 8 weeks of sales.
- WHAT WAS NEEDED
- A seller on Wildberries sees one profit figure for the whole shop, or none at all. An item can sell well and still lose money once unbought returns are shipped both ways, and promotions and restocking are decided by feel. The seller needs the profit of every item, a rule for each promotion and a list of what to order.
- WHAT WE BUILT
- A workbook with a summary and three working sheets. Unit economics takes every deduction WB makes from the realization report and gives profit, margin, ROI and a status per item. The promotion sheet applies each item's real commission, logistics and storage to the promo price and says stay, think or leave, with the lowest price that keeps the target margin. Purchasing compares the days of stock left with lead time plus safety stock and gives the quantity to order.
- HOW IT WORKS
- Data comes in two ways: the seller pastes the exports from the cabinet, where columns are found by their header in any order, or an Apps Script menu loads the realization report, orders and stock from the WB API. A daily trigger refreshes everything and sends Telegram what to reorder, which items sell at a loss and which promotions to leave. The formulas work the same in Google Sheets and Excel, and an independent Python model checks 660 cells in two spreadsheet engines.
- WHAT IT DOES NOT DO
- It plans purchasing per item, not per size, and takes one tax rate. Days of the current week appear once WB publishes its weekly report. It reads the cabinet and never changes prices or promotions by itself.
01The summary · 2
The period at a glance: where the money went, and what needs doing today.
02Profit by item · 1
Every item after all deductions, with a status. The main columns of the sheet.
03Promotions and purchasing · 2
A decision for each promotion, and the price at which it pays.
