Use two linked records
Give each researched item a short reference of your own. Record its source URL, seller, selected size or model, quantity, product cost and domestic delivery. Keep private account identifiers in a private sheet. Use the same reference in a separate parcel table after you decide to ship it.
A parcel can contain several orders, and one order may be split between parcels. Repeating the full parcel freight in every item row would overstate your total. Record the parcel cost once, then document any allocation method used to compare individual items.
Record the warehouse decision
For each item, record arrival, the photos reviewed, missing evidence and the final keep-or-return decision. Use a specific status such as awaiting measurement, acceptable to ship or return requested. Avoid a single vague checked label that conceals an unresolved size or variant question.
Keep the seller’s promised specification beside your observations. A photograph can show a mismatched color or label; it cannot prove composition or long-term function. If a return might be needed, inspect the current eligibility and deadline as soon as the item is received.
Separate estimates from measured values
Before the warehouse receives an item, mark its weight and dimensions as estimates. After measurement, enter the available actual figures and the measurement date. Preserve the estimate in a separate column if you want to learn how accurate your earlier budgets were.
At parcel level, record packed length, width, height and scale weight. Packing can change both weight and volume. Use the chosen route’s actual billing rule rather than a universal volumetric divisor. An item’s loose dimensions cannot be assumed to equal its contribution to the finished box.
Compare route quotes on the same parcel
Record the destination, contents, date, dimensions and weight used for each quote. Compare eligible routes using the same assumptions. Include the displayed tracking, estimated transit window, optional services and any insurance terms that affect your choice.
Keep product costs, domestic delivery, warehouse services, international freight and potential destination costs separate. A coupon should reduce only the charge to which it applies. Record its eligibility, expiry and actual checkout reduction rather than treating an advertised percentage as a discount on the entire order.
Close the record after delivery
Add the dispatched date, selected route, last tracking event and delivery result. Keep any cost adjustment or claim outcome as its own entry. This lets you distinguish a high initial estimate from a genuinely high final expense.
If you allocate a parcel’s freight among items, state the method. Equal shares may be simple but misleading when one item is bulky; weight-based allocation may also miss volumetric effects. Use the allocation for your own comparison, not as a claim that the carrier billed each item separately.
A practical final review
Before parcel payment, filter for unresolved QC questions, missing dimensions and items that are not approved to keep. Confirm the exact contents, recipient details, eligible route and final quote. Preserve the quote and packing evidence with the parcel row.
After receipt, compare the delivered contents with the saved list. Use the completed record to improve the next purchase: which measurements were useful, which packaging was unnecessary and which estimates were too optimistic. The spreadsheet should support decisions, not merely accumulate links.
Sources and live checks
Independent guidance based on the public platform workflow. Check the current listing, account and route terms before payment; availability, fees and policies can change.