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

☼ Each morning — when new data is available (one person, usually the lead)
  1. Open this page — it's live for everyone, no setup needed.
  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 straight to the shared database — the whole team is now on today's data, in real time.
✎ During the day — reviewing (every buyer)
  1. Open this page 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 — no upload step. Click ↻ Refresh if you want to pull in a teammate's very latest change immediately.
This page reads and writes directly to the shared database — anyone who opens it sees live, up-to-date data, and every change is saved automatically for everyone.
Active Orders
Completed History

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