New Commission Simulator: check your margin in 15 minutes on Soffi.io
Automatically recalculate margin using new marketplace rates without coding
How to Find Out in 15 Minutes If the New Commissions Will Eat Up Your Margin
Step-by-step guide to Soffi.io without a single line of code
Why This Matters — and Why Now
At the end of May 2025, Wildberries increased the commission for most categories by another 5 p.p., and a couple of weeks earlier, Ozon revised the rates for logistics and sales. For some products, deductions increased one and a half to two times.
When a marketplace announces new rates, the seller has just a few days to:
- 1.
Identify which SKUs will see their margin turn negative
- 2.
Decide what to do — raise prices, withdraw the product from the assortment, or look for a cheaper supplier
Most sellers open two spreadsheets, frantically copy formulas, and get hopelessly stuck in Excel.
Soffi.io automates this with one short scenario.
What You’ll Need
- •
Sales table in Google Sheets with columns “SKU”, “price”, “cost”, “current commission”
- •
Table of new rates — the official marketplace commission grid exported into Sheets or copied by URL
That’s all you need.
Step 1. Create a “New Rates Simulator” Task
- 1.
In your Soffi.io account, click “New Task”
- 2.
Choose the template “What's With Commissions?”
- 3.
Specify your data source: two Google Sheets or one sheet + URL with a CSV file
Step 2. Set Up Margin Checking Without Formulas
In the action builder, drag the “Merge Tables” block and specify the common column “SKU” or “Category”
Soffi.io will match old and new rates, recalculate costs, and compute actual margin for each SKU
There’s no need to write “=PRICE–COST–FEE” — the algorithm is already built into the template
Step 3. Add a “Margin < 5%” Rule
- 1.
Click “Filter” → select the condition “Margin” → “Less than” → 5
- 2.
In the second block, check “Show Δ-profit by assortment”
Step 4. Run the Simulation or Schedule It
- •
For a one-time calculation — click “Run”
- •
For regular monitoring, choose the schedule “Every Monday at 09:00”
The result will be sent to your email, Telegram bot, or directly to a new Google Sheets tab — whichever you prefer
What You’ll Get in the End
| Within a minute of launch | Value for your business |
|---|---|
| Report with recalculated margins for all SKUs | Clear understanding of which products will become unprofitable |
| “Δ-profit” summary by category and by store | Ability to adjust prices before new rates take effect |
| Ready-to-use SKU list for supplier negotiations | Time savings and less risk of penalties from rushing |
In one Soffi.io project, after a 5 p.p. commission increase, it showed that 12 SKUs immediately dropped below the profitability threshold; recalculation took 38 seconds and helped save ₽140,000 margin per month
Try It Yourself
- 1.
Prepare two tables
- 2.
Log in to Soffi.io and launch the ready-made template
- 3.
In 15 minutes, get the answer to the main question: “What should I do with pricing and assortment?”
No code, just clear clicks. If you have questions, support will respond in 5 minutes in the chat
→ Start your free calculation in Soffi.io