- Projects
- True margin of an online store in 2026
True margin of an online store in 2026
The landed cost of every product, including the €3 customs duty and €2 handling fee applied since 2026 to small parcels from outside the EU.
- Google Sheets
- Landed cost
- Recommended price
The context
A fictional online store shipping from suppliers outside the EU. Its prices were set before the new customs rules.
The problem
Since 1 July 2026, a parcel worth €150 or less from outside the EU pays €3 of customs duty per item category, plus a €2 handling fee since 1 November. On low-priced items, margins were melting away unnoticed.
What I built
- A file that computes the landed cost of every product: purchase, shipping, customs, handling fee, payment fees and social contributions.
- The remaining margin in euros and percent, product by product.
- The selling price to aim for to restore the target margin.
- An alert on products that fall below a 25% margin.
How it works
- We import the catalogue with purchase prices and shipping costs.
- The file applies the current customs rules and fees.
- Each product gets its true margin and a recommended price.
File extract
| Product | Selling price | Landed cost | Margin | Margin % |
|---|---|---|---|---|
| Desk lamp | €30.00 | €19.39 | €10.61 | 35.4% |
| Phone case | €15.00 | €11.82 | €3.18 | 21.2% |
| Backpack | €49.00 | €30.01 | €18.99 | 38.8% |
| Smartwatch | €79.00 | €48.15 | €30.85 | 39.0% |
Assumptions: customs duty and handling fee €5 per parcel, payment 1.5% + €0.25, social contributions 12.3% of price. Excluding VAT. Orange cells: margin below 25%.
Got a project in mind?
Describe what you need in a few lines. I reply within 24 hours with a call proposal.