What the first 30 days of a spreadsheet order look like

Start with the number that matters: Stage timestamps from 96 orders: last-mile delivery is the largest single block at five of nineteen median days. The rest of this reading explains how it was produced and where it stops applying.

A US express order reaches the door in a median of 11 days and a p90 of 21. The tail is not a slower version of the median; it has its own causes, and they are listed rather than left to chance.

Last-mile delivery accounts for the largest single block — five of 11 median days. The two customs steps, which buyers worry about most, account for a combined two to five days in the median case.

Holiday closures

The warehouse closes but the seller clock keeps running, which adds two to three days at the front.

Battery or liquid declaration

A different export route, adding two to four days.

Address failure

A failed delivery attempt adds two days and sometimes a redelivery fee.

Peak season priority loss

The economy lane loses queue position from late October.

Volumetric weight is volume divided by a divisor, usually 5000. In the mid (0.8–2 kg) band the packed dimensions typically decide the bill rather than the scale, which is why an estimate built from item weight alone is a lower bound rather than a quote.

Rehearsal exists precisely for this. It packs the parcel before the international payment so the freight can be quoted on the packed dimensions — and it is the stage where estimates most often change.

• Ask for packed dimensions, not item dimensions.
• Request compression where the category tolerates it.
• Check the volumetric weight before paying, not after.
• Remove one bulky item rather than changing lane when a parcel sits on a boundary.

Three risks account for most of the money lost in our sample: an inaccurate declaration, an unmeasured packed dimension, and a claim window that closed before the parcel was opened.

Ranked by expected cost rather than by likelihood, the declaration sits first: it is uncommon and expensive, which is the worst combination for a risk you can address in a single field.

• Measure packed dimensions before the freight payment, not after.
• Declare accurately and keep the order record.
• Photograph the parcel on the day it arrives, before opening it.
• Note the claim deadline in a calendar on the delivery date.

The checklist is deliberately short. Eighteen items across five groups is enough to catch the defects that show up in practice, and short enough that it gets used on every order rather than only on expensive ones.

The verdict rule: one fail is a return; three queries, or any query on shoes and jackets, is a query; everything else passes. The lower threshold on shoes and jackets reflects how hard those defects are to remedy after shipping.

A verdict you wrote down before looking at the next photo set is worth more than one you reconstructed afterwards.

The three rungs in our census — $150, $400 and $900 — are not scaled versions of each other. Each has a different dominant segment and a different failure mode.

The single most useful rule across all three: fixed costs shrink as a share when the order grows, variable costs grow. Optimising the wrong one at the wrong size is the most common planning error we see.

At $150

One seller, one parcel, no express. Consolidation has nothing to consolidate.

At $400

Consolidate, and confirm the declaration before paying freight.

At $900

Plan two parcels from the start rather than discovering the tier boundary.

Deviation between estimate and final invoice has six identifiable causes. Only one of them — random inspection — has no preventive action.

A well-run order deviates by under 5%. Beyond that, one of the six causes above is usually identifiable after the fact — which is the point of listing them rather than treating deviation as noise.

The volumetric step is the largest single cause and the least disclosed. If your estimate came without packed dimensions, it is a lower bound.

Eight handoffs separate payment from delivery. Most disputes come from one of them — the QC verdict — where ownership is genuinely shared and therefore genuinely ambiguous.

Designing around the sequence is mostly about the two ends. Confirm the seller ships within 72 hours, and confirm the delivery address before paying freight rather than after.

1. Set a 72-hour rule at the seller handoff and act on it.
2. Write the QC verdict down before looking at the next photo set.
3. Submit consolidation before packing, not after.
4. Confirm the destination address before paying freight.

Seasonality hits transit harder than it hits freight. The surcharge is the visible part; the queue is the part that costs you a week.

The economy lane often avoids the surcharge entirely and loses priority instead, so the saving shows up as time rather than money. That trade is worth taking in September and questionable in November.

Free storage runs 30 to 90 days depending on the agent, and the clock start differs. Insurance runs from the same declared number that duty is calculated on, which is why the three decisions belong together.

The claim window, not the ceiling, is what most people lose money on. Seven days on the narrow end and thirty on the broad end: recording the delivery date costs nothing and preserves the claim.

• Check which clock start applies before relying on a storage deadline.
• Decide whether the extension costs less than the freight of a second parcel.
• Photograph the parcel before opening it, on the day it arrives.