At a glance
Pending Shipment is a live count of paid Etsy orders that have been bought and confirmed but not yet marked as dispatched in Shop Manager. Every order in this bucket is a clock that is already running against the ship-by date the buyer was promised at checkout. An Etsy seller cares because the on-time dispatch rate is one of the three pillars of the Star Seller badge, and because a buyer who waits too long for a shipping notification is far more likely to open a case or leave a low star rating. A healthy shop keeps this number flat and small relative to daily order volume; a worrying shop shows it climbing day over day, which usually means orders are arriving faster than they are going out the door.
| What it counts | Paid, confirmed Etsy orders that have not yet been marked as shipped or completed. |
| Sample type | Backend API data from Etsy, refreshed on the standard data refresh. |
| Why it matters | A backlog of unshipped paid orders directly threatens the on-time dispatch Star Seller KPI and pushes buyers toward cases and low reviews. |
| Reading the value | A whole number. Lower is better. Judge it against your typical daily order count, not in isolation. |
| Currency | Number (count of orders). |
| Time window | RT |
| Alert trigger | >2x 30D avg |
| Sentiment key | ets_pending_shipment |
| Roles | owner, operations |
Calculation
Vortex IQ counts every Etsy order in a paid and confirmed state that has not yet been moved to a shipped or completed state. Cancelled and refunded orders drop out of the count once Etsy records the status change. The card is a point-in-time snapshot, so it rises as new paid orders land and falls as you mark parcels dispatched. The alert fires when the live count exceeds twice your trailing 30-day average, which adapts the trigger to your own normal volume rather than a fixed threshold.Worked example
Illustrative numbers. On 14 Jun 26 a homeware shop normally carries about 12 orders awaiting dispatch through a working day. By mid-morning the card reads 31, well past twice the 30-day average, and the alert fires. The operations lead opens the queue in Shop Manager and sees that a batch of personalised mugs is held up waiting on a courier label run that did not happen the previous evening. They print the outstanding labels, mark the parcels shipped, and the count settles back toward normal within the hour. To understand why the backlog formed in the first place, they open Vortex Mind to trace the spike back to the missed label run, and they ask Ask Viq in plain English how many of the pending orders are already inside 24 hours of their ship-by date.Sibling cards merchants should reference together
| Card | Why merchants reach for it |
|---|---|
ets_on_time_shipping_rate | The pending backlog is the leading indicator; this card is the lagging score it feeds. |
ets_late_shipments | Surfaces which pending orders have already crossed their ship-by date. |
ets_star_seller_status | The badge a sustained backlog can cost you. |
ets_orders_day | Shows whether the backlog is a surge in demand or a slowdown in fulfilment. |
ets_revenue_at_risk | Quantifies the money exposure a Star Seller loss would create. |
Reconciling against Etsy Shop Manager
Where to look in Etsy Shop Manager: Open Shop Manager > Orders & Shipping and filter to the New or Not Shipped view. The count of orders in that view is the direct counterpart to this card. You can cross-check individual ship-by dates there before working the queue. Why the Vortex IQ value may legitimately differ:| Reason | Direction | What to do |
|---|---|---|
| Refresh timing. The card is a snapshot from the last data refresh, while Shop Manager is live to the second. | Variable | Allow for orders that arrived or shipped in the gap between refreshes; re-check after the next refresh. |
| Status lag. An order marked shipped in Etsy can take a moment to propagate to the API. | Marginal | Treat very recent dispatches as already cleared even if the count has not yet dropped. |
| Cancellations and refunds. An order cancelled after payment leaves the pending bucket once Etsy records it. | Marginal | Reconcile against the Orders & Shipping cancelled filter if the counts diverge. |