Jun 11 (edited) • SQL and SOP Vault
Real Time Shorts (or misses) by SKU Deep Dive SQL
SELECT
p.item_id,
i.item_name AS item_description,
SUM(p.planned_qty) AS planned_quantity,
SUM(p.picked_qty) AS picked_quantity,
SUM(p.shipped_qty) AS shipped_quantity,
SUM(CASE WHEN p.status = 'SHORTED' THEN p.planned_qty ELSE 0 END) AS shorted_quantity
FROM warehouse.pick_details p
LEFT JOIN warehouse.item_catalog i
ON i.warehouse_id = p.warehouse_id AND i.item_id = p.item_id
WHERE CAST(p.created_at AS DATE) >= '2025-06-08' -- since Sunday
AND p.item_id IN ('04637336')
GROUP BY p.item_id, i.item_name
ORDER BY p.item_id;
0
0 comments
Real Time Shorts (or misses) by SKU Deep Dive SQL
powered by
skool.com/the-fulfillment-files-2761
Unlock fulfillment strategies that top warehouses use and get access to hidden methods that slash costs, boost throughput, and deliver results—fast.
Suggested communities
Powered by