Open Orders Tracker

⭳
Import fresh data
Drop this week's "Open POs" .xlsx/.csv — adds new orders, moves finished ones to History.
Backup ▾

How to use & keep the team in sync

☼ Each morning — when new data is available (one person, usually the lead)
  1. Open this report — it loads today's shared data from the database automatically.
  2. Drag the new "Open POs" export into Import fresh data above.
  3. New orders are added & auto-assigned; finished orders move to Completed History; existing assignments & reviews carry over.
  4. It saves to the shared database automatically — the whole team sees today's data within seconds.
✎ During the day — reviewing (every buyer)
  1. Open this report and set I am to your name.
  2. Filter with Buyer Workload or Assigned to me to find your orders.
  3. Fix the Assigned to dropdown if needed and click Mark reviewed as you finish each order.
  4. Every change auto-saves to the database instantly, and other viewers' changes appear for you automatically (about every 15 seconds) — no manual refresh needed, though ↻ Refresh is there if you want it right away.
Active Orders
Completed History
Buyers

Status & Aging

Order ageOrdersDistribution

Open Orders by Location

LocationOrdGrnNeuTrnRedLinesQty

Buyer Workload  (click to filter — number in red = still to review)

Order Explorer

All Red Neutral Transfer Green Needs buyer action
OrderLocationCustomer AgeStatusAssigned toReviewed