Marketplace unit economics
One row per SKU and platform: price, VAT, commission, logistics, storage, return logistics, cost, buyout, advertising and contribution per sold unit.
What the template is for
Checking what is left per sold unit after all fees and returns.
- What one row is
- one row = SKU × platform
Columns
| Column | Code | Type | Required | Validation rule |
|---|---|---|---|---|
| SKU code | sku | Text | yes | a value from the product reference |
| Platform | platform | List value | yes | a value from the platform reference |
| Customer price incl. VAT | price | Number | yes | a number not below 0 |
| VAT, % | vat | Number | yes | from 0 to 100 |
| Platform commission, % of price | comm | Number | yes | from 0 to 100 |
| Logistics per unit | logi | Number | yes | a number not below 0 |
| Storage per unit | stor | Number | yes | a number not below 0 |
| Logistics of one return | retlog | Number | yes | a number not below 0 |
| Unit cost | cogs | Number | yes | a number not below 0 |
| Buyout rate, % | buyout | Number | yes | from 0 to 100 |
| Advertising, % of price | ad | Number | yes | from 0 to 100 |
| Contribution per sold unit | cm | Number | yes | calculated: price ÷ (1 + VAT) − commission − cost − logistics − storage − advertising − return logistics × (100 − buyout) ÷ buyout |
| Contribution, % of price excl. VAT | cmPct | Number | yes | calculated: contribution ÷ price excl. VAT × 100 |
Example rows
| SKU code | Platform | Customer price incl. VAT | VAT, % | Platform commission, % of price | Logistics per unit | Storage per unit | Logistics of one return | Unit cost | Buyout rate, % | Advertising, % of price | Contribution per sold unit | Contribution, % of price excl. VAT |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SKU-A1 | platform-a | 3,990 | 22 | 17 | 118 | 24 | 61 | 1,480 | 84 | 12 | 479.77 | 14.7 |
| SKU-B2 | platform-a | 7,490 | 22 | 17 | 142 | 31 | 68 | 2,790 | 82 | 9 | 1,214.02 | 19.8 |
| SKU-C3 | platform-b | 5,290 | 22 | 14 | 126 | 28 | 55 | 1,930 | 78 | 10 | 966.95 | 22.3 |
The example data is illustrative: an exercise, replace it with your own.
Note
Take tariffs, the commission base (with or without VAT) and logistics rules from the platform offer on the calculation date: they change. Return logistics and non-resalable losses depend on the return share. The example data is illustrative: an exercise, not a norm or an industry benchmark.
How to open the file
The file is UTF-8 with a BOM, comma separated, with a decimal point. Set the text format for code columns (SKU, article, GTIN) so that long numbers and leading zeros are not distorted. The validation rules are suggested defaults, not norms: your systems and contracts may require something else.
Calculations that use these fields
- Marketplace unit economics and break-even price
- Pocket price: what the brand keeps from a delivery after all concessions
- Contribution levels CM1–CM3 by channel with buyout
- Returns: what they cost and how they hit margin
- Platform commission increase: profit loss and price rise
- Target ad-cost ratio and acquisition payback
- Advertising: ROAS, ad share and ROMI on margin
- Platform warehouse or own warehouse (FBO and FBS): the full cost of an ordered unit and the storage term
Documents that need this data
- Marketplace economics: tariff, logistics, buyout, storage, ad cost share and price
- Unit economics (CM1, CM2, CM3) with buyout
- Store, channel and marketplace P&L
- Advertising on platforms, card SEO, bid auctions and promotions: mechanics and the metrics of ad cost share, ROAS and ROMI
- Kaspi and Uzum: platforms of Kazakhstan and Uzbekistan, instalments, country tax, marking and brand entry
- Lamoda: a specialized fashion platform, try-on and partial buyout, size information and returns
- Starting on a platform: registration, trademark, content, marking, EDI and the first 30 days
- Marketplaces of Russia and the CIS: platform map, FBO, FBS and DBS models and how to choose
- Ozon: FBO, FBS and rFBS, accrual and sales reports, promotion and subscriptions
- The platform sales report and reconciliation of deductions: how to read the report, reconcile with brand records and file claims
- Returns, non-pickup and fines on platforms: causes, losses by size, defects and logistics
- Unit economics by platform: how to build the calculation from deductions, compare schemes and find the break-even price