Retailer Profitability Calculator: Calculate the True Profitability of Every Order
Many retailers know their gross margin down to the cent, but have no idea what an order actually delivers once shipping costs, order costs, and returns are factored in. The result: products that look profitable on paper but run at a loss in practice. This article explains how a retailer profitability calculator works, which cost items are often overlooked, and how to steer toward profit using accurate data per order — not per product.
Why gross margin gives you a false sense of profit
Most retailers work with a simple formula:
Gross margin = Selling price − Purchase price
That formula is correct, but it doesn’t tell the whole story. Between purchasing and delivery to the end customer sit cost items that are rarely tracked at order level in ERP or accounting systems:
- Shipping costs (which can vary by destination, weight class, and country)
- Extra parcel/colli surcharges for large or multi-part shipments
- Order processing costs (time, error margin, manual entry)
- Return and re-delivery costs
- Currency and cross-border costs on international sales (NL, BE, DE, FR)
Without accounting for these items, you’re working with a phantom margin. A retailer profitability calculator corrects for this by calculating net margin per order, not per product.
The formula: net margin per order
Net margin per order (%) = (Selling price − Purchase price − Shipping costs − Order costs − Return costs) ÷ Selling price × 100%
This formula is simple, but the challenge lies in the data: most retailers and wholesalers don’t track shipping and order costs in a structured way per order, which means they can’t apply this formula in practice.
Practical example
Suppose a retailer sells a home accessory for €89.95:
| Cost item | Amount |
|---|---|
| Selling price | € 89.95 |
| Purchase price (wholesale) | € 45.00 |
| Shipping costs (NL, standard) | € 8.50 |
| Extra colli surcharge (2-part shipment) | € 4.00 |
| Order processing costs | € 2.50 |
| Return costs (weighted average) | € 1.80 |
| Net margin | € 28.15 (31.3%) |
Without factoring in shipping, colli, order, and return costs, the “margin” on paper would appear to be € 44.95 (50%) — nearly 20 percentage points higher than reality. For larger shipments or international delivery (for example, to Belgium or Germany, where different rates and surcharges apply), this gap can be even wider.
The hidden cost item: extra colli and country-specific rates
A common mistake is applying a single fixed shipping rate to all orders. In practice, separate rates often apply per country and per number of colli (shipments consisting of multiple parcels). For instance, as soon as a Belgian pickup or delivery address appears anywhere in the chain, a different pricing structure typically applies compared to a purely Dutch shipment — including its own surcharge per extra parcel. Retailers who don’t process this consistently structurally underestimate their shipping costs, and therefore their true margin.
Why automation is what makes the calculator truly usable
A spreadsheet with this formula is a good starting point, but becomes unworkable as the number of orders, suppliers, and countries grows. Every supplier invoices differently, shipping rates vary by weight class and country, and manual entry inevitably leads to errors — especially when it comes to recognizing extra colli surcharges and correction invoices.
This is exactly the problem Droppery solves for B2B retailers and wholesalers in the Netherlands, Belgium, Germany, and France. By automating product data, inventory, orders, and logistics flows, a consistent, verifiable basis is created per order for calculating net margin — without anyone having to manually match invoices, parcel counts, and rates.
Want to know how this works for your product range? Check out our integrations with Shopify, WooCommerce, PrestaShop, Shopware, and Shopline at droppery.info, or get in touch via info@droppery.info.
Checklist: calculate your own net margin per order
- Collect the actual purchase price per product (including any volume discounts)
- Link the correct shipping rate based on destination country and number of colli
- Include order processing costs, even if they seem small — they add up at high order volumes
- Include a weighted-average return cost item, based on your historical return rate
- Calculate net margin per order, not per product — so you can immediately see which orders (and customers) are actually profitable
Frequently asked questions about the retailer profitability calculator
What is a retailer profitability calculator? A retailer profitability calculator is a calculation method (or tool) that determines the actual profit per order by subtracting purchase price, shipping costs, order costs, and return costs from the selling price — as opposed to a simple gross margin calculation, which ignores these cost items.
Why doesn’t my gross margin match my actual profit? Gross margin only accounts for purchase and selling price. Shipping costs, extra colli surcharges, order processing costs, and returns are often not included, which means the true net margin ends up lower than the gross margin suggests.
Does margin differ by country within the EU? Yes. Shipping rates and surcharges often differ by country (for example, the Netherlands versus Belgium or Germany) and by the number of colli in a shipment. Retailers selling internationally need to account for these differences per order to calculate an accurate margin.
How often should I recalculate my net margin? Ideally on an ongoing basis, or at least quarterly, since purchase prices, shipping rates, and return rates change regularly. Automated order processing makes this feasible without manual work.
Can Droppery help automate this calculation? Droppery automates product data, inventory, order, and logistics flows between suppliers and retailers in the Netherlands, Belgium, Germany, and France, making the underlying data for an accurate per-order margin calculation available and reliable.
Want to read more about how Droppery connects retailers and suppliers? Check out our case study with De Eekhoorn via our article How De Eekhoorn and WOOOD achieve B2B growth with Droppery, or discover our integrations at droppery.info. Questions about your specific situation? Get in touch via info@droppery.info or +31 20 210 1895.