All Things Prep
Online Arbitrage - 7 min read

Online Arbitrage Parcel Tracking Template for Prep Centre Inbound

Online arbitrage becomes messy because the inbound is fragmented. Several retailers, split parcels, partial deliveries and courier scans all hit the prep centre at different times. A simple tracking template gives the warehouse and seller a shared view of what should arrive, what has arrived and what needs chasing.

OA parcel visibility gets better when tracking is structured before delivery.

What this article covers

  • online arbitrage parcel tracking
  • oa prep centre tracking
  • prep centre delivered not checked in

Why it matters

A practical online-arbitrage parcel tracking template for UK Amazon sellers using a prep centre, covering retailer orders, tracking, split deliveries and missing parcels.

The template fields that actually matter

The point is not to create a beautiful spreadsheet. The point is to make every parcel traceable enough that a missing delivery can be investigated without rebuilding the order history from memory.

Each OA parcel should carry a small set of details: retailer, order number, tracking number, expected quantity, delivery status, received status and the decision if something is missing.

FieldExample useWhy it matters
RetailerBoots, Argos, Tesco, supplier nameHelps group split deliveries and retailer issues
Order numberRetailer purchase referenceConnects parcel contents back to the buy
Tracking numberCourier tracking referenceSupports delivered-but-not-received investigations
Expected unitsWhat should be in the parcelMakes shortages obvious
Received statusNot arrived, received, short, damaged, heldStops all stock states collapsing into one vague update

Separate delivered from received

Delivered is a courier state. Received is a warehouse state. Treating them as the same thing is how sellers end up confused when tracking says delivered but the stock is not yet visible in the prep workflow.

A good OA process keeps both states. If the courier says delivered and the warehouse has not matched the parcel, the tracking number becomes the investigation point rather than another vague chase message.

  • Delivered means the courier claims the parcel reached the address
  • Received means the warehouse has matched the parcel into the workflow
  • Short means some expected units are missing or incorrect
  • Held means stock is waiting for a seller decision

How to handle split retailer deliveries

Retailers often split one order across several parcels or dispatch dates. The template should let one retailer order have multiple tracking numbers, not force the seller to pretend the order arrived as one clean delivery.

When only part of an order lands, the seller needs a decision: wait for the remaining parcel, prep what has arrived, or hold the whole buy because the missing items affect a bundle or shipment plan.

When a parcel goes missing

The fastest missing-parcel investigations start with the tracking number, retailer order number and expected contents. Without those, the prep centre can only search broadly, and the seller loses time chasing the retailer or courier from scratch.

If the prep centre has CCTV-backed receiving and a parcel-tracking workflow, the seller can narrow the question quickly: did it arrive, was it matched, was it short, or is the courier scan unreliable?

A simple OA inbound status set

  • Expected
  • In transit
  • Courier delivered
  • Warehouse received
  • Short or damaged
  • Held for seller decision
  • Ready for prep
  • Dispatched

Need parcel-by-parcel OA visibility?

ATP can receive mixed retailer inbound, trace delivered-but-not-checked-in parcels and keep OA stock visible through prep and dispatch.

Start ATP onboarding