[2025-12-11 12:52:38] [simple_delete_orders] Lock acquired successfully. PID: 139786
 🗑️  Simple Delete Script - Unprocessed Amazon Orders
=====================================================

📊 Total Amazon orders in database: 25791
📊 Unprocessed orders (synced_stock = 0): 1
📊 Synced orders (synced_stock = 1): 25790
📊 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 1 results
📦 Found 1 SKUs with unprocessed orders (latest 10):
   ❌ U1-S-28-new_RIMGZDNJCE (synced_stock: 0, latest: 2025-12-11 12:41:03)

🚀 Starting processing...
============================================================
🔄 Processing 1 SKUs...

📦 Processing 1/1: U1-S-28-new_RIMGZDNJCE
--------------------------------------------------
📊 SKU Details: synced_stock=0, latest_order=2025-12-11 12:41:03
📊 Database Status: 1 total orders, 1 unsynced
🗑️ Deleting from eBay...
🔗 Starting comprehensive eBay deletion for SKU: U1-S-28-new_RIMGZDNJCE
📦 Step 1: Deleting from eBay Inventory...
📊 Inventory Response (HTTP 200):
 <div style="border: 1px solid #ccc; margin: 5px; padding: 5px;"><strong>2025-12-11 12:52:38:</strong> Attempting to get a valid eBay token from database</div><div style="border: 1px solid #ccc; margi
📦 Step 2: Withdrawing from eBay Offers...
📊 Offer Response (HTTP 401):
 {"error":"eBay authentication required"}
⚠️ Inventory deletion may have failed
⚠️ Offer withdrawal may have failed
❌ eBay: Failed to remove item from eBay
❌ eBay deletion failed
🗑️ Deleting from Shopify...
<br />
<b>Warning</b>:  Undefined array key "locations" in <b>/var/www/html/crons/simple_delete_orders.php</b> on line <b>202</b><br />
<br />
<b>Warning</b>:  Trying to access array offset on null in <b>/var/www/html/crons/simple_delete_orders.php</b> on line <b>202</b><br />
<br />
<b>Warning</b>:  Trying to access array offset on null in <b>/var/www/html/crons/simple_delete_orders.php</b> on line <b>202</b><br />
❌ Shopify deletion failed: Failed
🔄 Marking orders as synced...
✅ Marked 0 orders as synced
--------------------------------------------------
🎉 Processing completed!
📊 Summary:
   - Total SKUs processed: 1
   - Successfully deleted: 0
   - Failed: 1
 <br />
<b>Warning</b>:  file_put_contents(/var/www/html/crons/cron_lock.log): Failed to open stream: Permission denied in <b>/var/www/html/crons/cron_lock.php</b> on line <b>213</b><br />
[2025-12-11 12:52:40] [simple_delete_orders] Lock released successfully.