Parcel planning · Shipping

Track orders and parcels separately

One purchase can produce three status lines that say three different things. Merging them into one "status" column is how a parcel gets marked delivered while the item is still being packed.

Morandi still-life cover image of a sealed parcel with a routing tag, a notebook, and a brass keyring
Updated October 22, 2026 6 min read Applies to: United States · USD

Three records, not one

Order status belongs to the seller: paid, confirmed, cancelled. Warehouse status belongs to the place holding your items: received, awaiting inspection, packed, released. Parcel status belongs to the carrier: label created, in transit, customs, out for delivery, delivered.

They advance on different clocks. An order can show "completed" while the warehouse is still waiting for a second item, and a parcel can show "in transit" for days because it is sitting in a sorting facility. Recording one status for all three guarantees a wrong conclusion.

Keep one row per event, not one row per parcel. A short event log is easier to audit than a cell you keep overwriting.

A timeline with planned and actual

Example data Event log with two date columns
EventPlannedActualStatus wording (verbatim)
Order paid2026-10-052026-10-05Payment confirmed
Items received at warehouse2026-10-102026-10-122 of 3 items received
Inspection complete2026-10-132026-10-14Inspection passed, 1 note
Parcel released2026-10-162026-10-18Shipment information received
In transit2026-10-202026-10-21Departed sorting center
Customs reviewNot stated2026-10-23Held for clearance
Delivery2026-10-27 (estimate)——

Two things stand out. The actual column is filled only where an event happened, and the delivery row stays empty because nothing has been delivered. Writing an expected date in the actual column is the fastest way to create a false record you will later quote against yourself.

Why original wording matters

Statuses get paraphrased. "Held for clearance" becomes "at customs" in your head, then "delayed" by the time you describe it to someone else. Copy the original sentence and the timestamp, then add your interpretation in a separate note column if you need one.

When a status stops moving

A status that has not changed for several days is not automatically lost. Before contacting anyone, check which record is stale: the order page, the warehouse page, or the carrier page. Then check the last update time rather than the last message you received.

When you do ask, quote the record. "Tracking shows 'departed sorting center' on October 21; no update since" is a question someone can answer. "Where is my parcel" is not. Keep the reply in the same row, so the conversation and the timeline stay together.

Shipping estimates belong in the planned column, and they change with the route. If the parcel contains restricted or liquid items, clearance can add steps you should note in advance — see the restrictions guide and the quote record guide. The delivery address in the record should come from the address checklist, not from memory.

Archive the timeline when the parcel arrives. Next quarter, the pattern of real transit times from that route is more useful than any published estimate.

Back to hipobuy spreadsheet

Written and maintained by the hipobuyguide.living editorial desk. The timeline is illustrative; actual status labels and update frequency depend on the platform and carrier.