KodjoFinance & Data
  1. Projects
  2. True margin of an online store in 2026
Demo project · fictional data

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

  1. We import the catalogue with purchase prices and shipping costs.
  2. The file applies the current customs rules and fees.
  3. Each product gets its true margin and a recommended price.

File extract

Marge_ecommerce_2026.xlsxExtract: margin by product
ProductSelling priceLanded costMarginMargin %
Desk lamp€30.00€19.39€10.6135.4%
Phone case€15.00€11.82€3.1821.2%
Backpack€49.00€30.01€18.9938.8%
Smartwatch€79.00€48.15€30.8539.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.