Diagnostic: Stale Pick Table Rows

Read-only inventory diagnostic. The Pick Table value on updateInventory.php comes from GetPickedOrders() in shelfQuantity.php, which sums pd_pick_table.quantity for a product with no order-status filter. Leftover pick rows on closed orders inflate that total and can produce a negative Shelf Quantity. This page lists those leftover rows so the stale footprint can be measured before any cleanup is approved.

• Source table / column: pd_pick_table.quantity (also product_id, order_id, date_added).
• Closed statuses: Completed / Complete, Shipped, Canceled / Cancelled, Denied, plus other fulfilled / not-fulfilled IDs from orderStatus.php. Live outstanding statuses (Paid, Processed, Backordered, etc.) are excluded.
• Orphans: Pick rows whose order_id no longer exists in oc_order are included and labeled Order missing.
• No writes: This tool never INSERT / UPDATE / DELETE. Use Product ID to open Update Inventory and Order ID to open Order Status.