A product can look profitable at the supplier's unit price and lose money before the first customer order is delivered.

The usual problem is not one dramatic charge. It is a chain of small assumptions:

  • the supplier price is treated as the product cost;
  • the wrong delivery term is compared;
  • freight is quoted without destination handling;
  • the duty rate comes from an unchecked code;
  • defects and returns are left out; and
  • marketplace fees are added after the sourcing decision.

This is a diagnostic guide, not a second landed-cost calculator. Use the landed-cost model for the full calculation, then use this page to trace a margin leak to the missing evidence.

1. Start with the margin bridge

Use one consistent tax and currency basis. For an illustrative marketplace contribution screen:

```text selling price received by the business

  • marketplace referral and selling fees
  • fulfilment and delivery cost
  • storage and returns allowance
  • advertising or promotion assumption
  • landed cost per sellable unit
  • other variable operating cost

= contribution before fixed overhead and income tax ```

Amazon's current pricing and revenue-calculator pages explain that selling cost depends on the plan, product category, fulfilment strategy and other variables. Referral, fulfilment, storage, advertising and optional programme costs need to be checked for the applicable store and date. Do not copy a historic fee table into a current model.

Illustrative contribution screen

This example is a teaching scenario, not a typical margin claim. The sale price and costs are shown in GBP and use a consistent pre-tax basis for comparison.

Line: Illustrative amount
LineIllustrative amount
Selling price£29.99
Marketplace selling and referral allowance-£4.50
Fulfilment and delivery-£4.50
Storage allowance-£0.35
Returns allowance-£0.80
Advertising assumption-£2.40
Landed cost from the approved model-£12.60
Contribution before fixed overhead£4.84

If the model uses the customer's VAT-inclusive price while the costs are VAT-exclusive, the result is not useful. Label every line and keep the tax treatment consistent.

2. Mistake 1: treating supplier unit price as landed unit cost

The supplier's unit price may exclude:

  • tooling or setup;
  • packaging changes;
  • origin collection;
  • export handling;
  • main freight and insurance;
  • customs duty and import tax;
  • clearance, port and destination handling;
  • final delivery and unloading;
  • inspection and testing; and
  • expected loss or rejection.

The correction is to map the quotation into a landed-cost workbook before approving the order. Mark each line included, excluded, estimated or unresolved.

Symptom

The product margin is healthy in the supplier comparison sheet but falls when the first freight invoice arrives.

Evidence to inspect

  • supplier quotation and purchase order;
  • Incoterm and named place;
  • forwarder quote and validity date;
  • customs entry or broker estimate; and
  • receiving quantity and damage log.

Action

Replace the supplier unit price with an expected sellable-unit cost. Keep the original quote as a source, not as the answer.

3. Mistake 2: using an unchecked code, origin or duty rate

Duty can change when the commodity code, product facts, origin evidence or importing territory changes. A supplier's HS code is a lead. It is not proof that the destination tariff will use the same extension, rate or measure.

The commodity-code research guide shows how to retain the product facts, candidate codes, notes, source URL and date. The customs-value and import VAT guide shows where the code enters the calculation.

Symptom

The margin depends on a duty rate copied from a previous product or a marketplace forum.

Evidence to inspect

  • exact product description and specification version;
  • code and tariff tool result;
  • origin evidence and preference claim;
  • quota, trade-remedy or licence measures; and
  • broker or customs specialist review where candidates conflict.

Action

Model a range until the code and origin are verified. If the range crosses the go or no-go threshold, stop the order decision.

4. Mistake 3: missing route and destination charges

A freight quote that says “to port” is not a warehouse cost. A supplier's DDP price may include some charges but leave the buyer without the evidence needed for the commercial and tax record.

Common missing lines include:

  • origin pickup and export documents;
  • terminal or consolidation handling;
  • customs representation;
  • examination, storage or demurrage;
  • destination terminal and deconsolidation;
  • final delivery, appointment and unloading; and
  • insurance or claim exposure.

Use the freight-forwarder comparison matrix to mark each line included, excluded, conditional or unknown.

Symptom

Two “delivered” quotes differ by a small amount, then one produces a large destination invoice.

Evidence to inspect

  • exact origin and destination points;
  • chargeable weight or volume;
  • free days and storage triggers;
  • customs representation and importer details; and
  • insurance terms and exclusions.

Action

Normalise the scope before comparing totals. Keep unknown charges as a scenario rather than treating them as zero.

5. Mistake 4: comparing different Incoterms as if they were the same price

EXW, FCA, FOB, DAP and DDP shift the handover and the tasks around it. A lower EXW price may leave the buyer with origin work. A DAP price can leave import clearance and tax with the buyer. A DDP price can be convenient but needs a capable and documented import route.

The Incoterms guide explains the named-place discipline. The DDP versus DAP guide maps the importer and document questions.

Symptom

The buyer chooses the lowest supplier price, then discovers that the forwarder quote starts at a different handover.

Evidence to inspect

  • rule and version;
  • exact named place;
  • route and transport mode;
  • included freight and handling;
  • importer and customs representative; and
  • duty, tax and destination exclusions.

Action

Create one scenario per term. Change the freight, clearance, tax and evidence inputs when the term changes.

6. Mistake 5: allocating mixed-SKU costs badly

Dividing a mixed shipment's freight equally by unit can make a bulky item look cheap and a compact item look expensive. Allocating every charge by invoice value can create the opposite problem when the carrier prices by weight or volume.

Symptom

One SKU appears profitable only because it receives too little of the shared shipment cost.

Evidence to inspect

  • carrier's chargeable weight or volume;
  • carton dimensions and pallet plan;
  • invoice and customs value by SKU;
  • units and expected sellable quantity; and
  • any cost directly attributable to a SKU.

Action

Use a method that matches the charge. Freight can be allocated by chargeable weight or volume. A value-based insurance charge can use value. Testing can be attributed to the SKU that required it. Keep the method in the workbook.

7. Mistake 6: excluding loss, returns, storage and currency sensitivity

The first shipment is not a perfect spreadsheet event. Units can arrive damaged, fail inspection, be returned, sit in storage or become more expensive when the currency moves.

Include scenarios for:

  • shortage or damage;
  • rejected or reworked units;
  • customer returns and refund administration;
  • storage beyond the expected sell-through period;
  • currency movement between quote, balance and import; and
  • late delivery that requires a more expensive route.

Amazon's pricing pages identify storage, fulfilment and optional advertising as separate cost areas. The exact amount depends on the store, product and programme, so record the source date and use the official calculator for the ASIN or product profile.

Symptom

The base case works, but a small currency or return change removes the contribution.

Evidence to inspect

  • supplier and freight currencies;
  • payment dates and conversion basis;
  • product dimensions and storage class;
  • historical return or damage data; and
  • expected sell-through and reorder timing.

Action

Show a base, expected and adverse case. Decide which variable would trigger a price change, route change, reorder pause or product stop.

8. Mistake 7: adding marketplace fees after the sourcing decision

A product can be a good wholesale buy and a poor marketplace offer. Marketplace fees depend on the selling plan, category, fulfilment route, storage, returns, advertising and other current programme terms.

Use the Amazon pricing and revenue calculator for the applicable store and date. Keep current Amazon fee claims in the source log and do not treat a tool output as permanent.

Symptom

The stock is ordered before the referral, fulfilment and return assumptions are in the margin model.

Evidence to inspect

  • product category and selling store;
  • selling plan and referral fee source;
  • fulfilment method and dimensions;
  • storage and removal assumptions;
  • return and refund treatment; and
  • advertising or launch allowance.

Action

Make the marketplace contribution screen a pre-order gate. If the route is not yet chosen, compare at least one merchant-fulfilled and one FBA scenario where applicable.

9. The margin-leak diagnostic table

Symptom: Likely missing input: Evidence to inspect: Workbook field: Action
SymptomLikely missing inputEvidence to inspectWorkbook fieldAction
Supplier quote looks profitable, shipment does notFreight, duty or destination chargesPO, forwarder quote, customs recordLanded-cost linesRebuild sellable-unit cost
Duty estimate changes between quotesCode, origin or measureTariff result and origin evidenceClassification and dutyEscalate or model a range
DDP quote has no customs evidenceImporter, broker or tax treatmentInvoice, declaration, written termsDDP evidence statusHold or re-quote
SKU margin differs by shipmentPoor shared-cost allocationWeight, volume, value and cartonsAllocation methodReallocate and document
Base case is fragileLoss, returns, storage or FXReceiving, returns, currency datesSensitivity tableSet a stop threshold
FBA case is lower than expectedSize, weight or current fee inputAmazon pricing and calculatorMarketplace costsRefresh with current store data
Margin disappears after translation or launchContent, ads or service costs omittedLaunch plan and operating ownerOther variable costAdd route-specific allowance

10. Illustrative margin leak example

Suppose the initial screen shows a contribution of £4.84 per unit. The buyer then finds four omitted inputs:

Omitted or wrong input: Per-unit effect
Omitted or wrong inputPer-unit effect
Destination handling not in freight quote-£0.70
Duty assumption too low-£0.45
Expected damage reserve omitted-£0.60
Marketplace advertising allowance missing-£0.90
Revised contribution£2.19

The example does not describe a typical margin. It demonstrates why a product can still be technically profitable while no longer covering the desired operating risk. If the adverse case adds a currency movement, extra storage or higher returns, the decision may become a pause or stop.

11. Go, renegotiate or stop

Use a simple decision record:

Go

  • source evidence is current and consistent;
  • landed cost is based on a named route and verified or ranged customs inputs;
  • marketplace fees and fulfilment assumptions are dated;
  • the expected case meets the contribution target; and
  • an adverse case does not create an unacceptable cash or compliance risk.

Renegotiate

  • the product is viable if a freight scope, packaging, payment term or delivery route changes;
  • the supplier can provide missing documents;
  • the forwarder can remove an avoidable charge or clarify an exclusion; or
  • the marketplace route can change without changing the product's evidence obligations.

Stop or pause

  • code, origin or importer role is unresolved and material;
  • product compliance evidence is missing;
  • the model requires perfect sell-through or zero returns;
  • the supplier or forwarder will not document the route;
  • margin falls below the stop threshold in the expected case; or
  • no person owns the next evidence check.

12. Diagnostic worksheet

Question: Answer or source
QuestionAnswer or source
Selling store and date
Selling price and tax basis
Marketplace fee source
Fulfilment and storage source
Supplier price and Incoterm
Freight quote and validity
Commodity code and origin evidence
Duty and import-tax treatment
Expected sellable units
Loss, returns and storage assumptions
Currency and payment dates
Expected contribution
Adverse contribution
Decision and owner
What would change the decision

13. The practical conclusion

When a marketplace margin falls, do not immediately blame the supplier price. Trace the bridge from selling price to contribution and ask which input is unsupported, missing, duplicated or stale.

Fix the evidence first. Then decide whether to change the product, route, Incoterm, fulfilment model, price, order size or launch plan.

The strongest margin model is not the one with the highest base-case result. It is the one that shows which assumptions can break the decision and who will check them.