[2025-08-05 01:42:38] [simple_delete_orders] Lock acquired successfully. PID: 3582846
 🗑️  Simple Delete Script - Unprocessed Amazon Orders
=====================================================

📊 Total Amazon orders in database: 21748
📊 Unprocessed orders (synced_stock = 0): 0
📊 Synced orders (synced_stock = 1): 21748
📊 NULL synced orders: 0

🔍 Executing query: SELECT DISTINCT sku, synced_stock, MAX(order_date_time) as latest_order_date
              FROM amazon_orders 
              WHERE synced_stock = 0 OR synced_stock IS NULL
              GROUP BY sku, synced_stock
              ORDER BY latest_order_date DESC 
              LIMIT 10
📊 Query returned 0 results
✅ No unprocessed Amazon orders found

🔍 Debug: Let's check some recent orders:
   ✅ U1-S-CB-new_NSKTLQKJIJ - Unshipped - 2025-08-05 00:23:00
   ✅ U1-S-IY-new_YMFBSFYNQC - Unshipped - 2025-08-04 22:48:40
   ✅ U1-S-U-new_HAALVMHIVK - Unshipped - 2025-08-04 21:56:26
   ✅ U1-S-U-new_OVLMBBJMFM - Unshipped - 2025-08-04 21:55:36
   ✅ U1-S-FE-new_BFFFCXMHPJ - Unshipped - 2025-08-04 21:42:15
   ✅ U1-S-CC-new_IIWFCJXTYH - Unshipped - 2025-08-04 21:12:29
   ✅ U1-S-BP-new_BPXUBEOWJB - Unshipped - 2025-08-04 20:59:58
   ✅ U1-S-JQ-new_HEGJSHXJIY - Unshipped - 2025-08-04 20:56:19
   ✅ U1-S-BC-new_KVKZIBULGW - Unshipped - 2025-08-04 20:31:12
   ✅ U1-S-AN-uvg_ILXYTYRBOZ - Unshipped - 2025-08-04 20:07:12
[2025-08-05 02:42:38] [simple_delete_orders] Lock released successfully.