2025-11-22 03:35:05,343 - INFO - Log file: /home/centralgoparts/public_html/profitability/logs/customer_shipping_20251122_033505.log
2025-11-22 03:35:05,343 - INFO - ================================================================================
2025-11-22 03:35:05,343 - INFO - CUSTOMER SHIPPING UPDATE - 2025-11-22 03:35:05
2025-11-22 03:35:05,343 - INFO - LIVE MODE
2025-11-22 03:35:05,343 - INFO - ================================================================================
2025-11-22 03:35:05,343 - INFO - Date Range: 2025-07-25 to 2025-11-22 (120 days)
2025-11-22 03:35:05,352 - INFO - ================================================================================
2025-11-22 03:35:05,352 - INFO - Processing: UPS SHIPHAVEN CUSTOMER SHIPPING
2025-11-22 03:35:05,352 - INFO -   Source: shipping_charges-ups-shiphaven table
2025-11-22 03:35:05,352 - INFO -   Match: Tracking number (AIRBILL_NO)
2025-11-22 03:35:05,352 - INFO - ================================================================================
2025-11-22 03:35:05,368 - INFO - Found 1378 orders with tracking numbers
2025-11-22 03:35:06,199 - INFO -   Updated B2B order 58541-0017: UPS shipping=$11.12
2025-11-22 03:35:06,206 - INFO -   Updated B2B order 15090-0076: UPS shipping=$11.12
2025-11-22 03:35:06,226 - INFO -   Updated B2B order 57376-1739: UPS shipping=$5.56 (split across 1 packages, 2 items)
2025-11-22 03:35:06,227 - INFO -   Updated B2B order 57376-1739: UPS shipping=$5.56 (split across 1 packages, 2 items)
2025-11-22 03:35:06,230 - INFO -   Updated B2B order 42393-0013: UPS shipping=$11.12
2025-11-22 03:35:06,234 - INFO -   Updated B2B order 44122-0005: UPS shipping=$17.74
2025-11-22 03:35:06,253 - INFO -   Updated Amazon order 114-2628415-7746655: UPS shipping=$17.74
2025-11-22 03:35:06,263 - INFO -   Updated B2B order 51774-0025: UPS shipping=$11.12
2025-11-22 03:35:06,265 - INFO -   Updated Amazon order 111-8827566-8237808: UPS shipping=$18.87
2025-11-22 03:35:06,267 - INFO -   Updated Amazon order 113-3644369-9075457: UPS shipping=$14.48
2025-11-22 03:35:07,401 - INFO -   ... and 584 more orders updated
2025-11-22 03:35:07,405 - INFO - 
UPS ShipHaven Summary:
2025-11-22 03:35:07,405 - INFO -   Orders checked: 1378
2025-11-22 03:35:07,405 - INFO -   Orders updated: 594
2025-11-22 03:35:07,405 - INFO -   No match/zero cost: 784
2025-11-22 03:35:07,405 - INFO -   Total shipping added: $8,473.11
2025-11-22 03:35:07,405 - INFO - 
  Breakdown by Channel:
2025-11-22 03:35:07,405 - INFO -     Amazon: 239 orders, $3,777.95
2025-11-22 03:35:07,405 - INFO -     B2B: 271 orders, $3,504.05
2025-11-22 03:35:07,405 - INFO -     Web: 77 orders, $1,091.13
2025-11-22 03:35:07,405 - INFO -     eBay: 7 orders, $99.98
2025-11-22 03:35:07,414 - INFO - 
================================================================================
2025-11-22 03:35:07,414 - INFO - Processing: USPS STAMPS CUSTOMER SHIPPING
2025-11-22 03:35:07,414 - INFO -   Source: shipping_charges-usps-stamps table
2025-11-22 03:35:07,414 - INFO -   Match: Tracking number
2025-11-22 03:35:07,414 - INFO - ================================================================================
2025-11-22 03:35:07,430 - INFO - Found 784 orders with tracking numbers
2025-11-22 03:35:07,526 - INFO - 
USPS Stamps Summary:
2025-11-22 03:35:07,526 - INFO -   Orders checked: 784
2025-11-22 03:35:07,526 - INFO -   Orders updated: 0
2025-11-22 03:35:07,526 - INFO -   No match/zero cost: 784
2025-11-22 03:35:07,526 - INFO -   Total shipping added: $0.00
2025-11-22 03:35:07,527 - INFO - 
================================================================================
2025-11-22 03:35:07,527 - INFO - OVERALL SUMMARY
2025-11-22 03:35:07,527 - INFO - ================================================================================
2025-11-22 03:35:07,527 - INFO - UPS ShipHaven:
2025-11-22 03:35:07,527 - INFO -   Orders updated: 594
2025-11-22 03:35:07,527 - INFO -   Total shipping: $8,473.11
2025-11-22 03:35:07,527 - INFO - 
USPS Stamps:
2025-11-22 03:35:07,527 - INFO -   Orders updated: 0
2025-11-22 03:35:07,527 - INFO -   Total shipping: $0.00
2025-11-22 03:35:07,527 - INFO - 
Grand Total:
2025-11-22 03:35:07,527 - INFO -   Orders updated: 594
2025-11-22 03:35:07,527 - INFO -   Total customer shipping costs: $8,473.11
2025-11-22 03:35:07,527 - INFO - ================================================================================