2025-11-22 03:23:35,462 - INFO - Log file: /home/centralgoparts/public_html/profitability/logs/customer_shipping_20251122_032335.log
2025-11-22 03:23:35,462 - INFO - ================================================================================
2025-11-22 03:23:35,462 - INFO - CUSTOMER SHIPPING UPDATE - 2025-11-22 03:23:35
2025-11-22 03:23:35,462 - INFO - LIVE MODE
2025-11-22 03:23:35,462 - INFO - ================================================================================
2025-11-22 03:23:35,462 - INFO - Date Range: 2025-07-25 to 2025-11-22 (120 days)
2025-11-22 03:23:35,470 - INFO - ================================================================================
2025-11-22 03:23:35,471 - INFO - Processing: UPS SHIPHAVEN CUSTOMER SHIPPING
2025-11-22 03:23:35,471 - INFO -   Source: shipping_charges-ups-shiphaven table
2025-11-22 03:23:35,471 - INFO -   Match: Tracking number (AIRBILL_NO)
2025-11-22 03:23:35,471 - INFO - ================================================================================
2025-11-22 03:23:35,478 - INFO - Found 617 orders with tracking numbers
2025-11-22 03:23:36,180 - INFO -   Updated Amazon order 112-6082828-9025002: UPS shipping=$14.48
2025-11-22 03:23:36,203 - INFO -   Updated Amazon order 114-7494913-7526615: UPS shipping=$7.24 (split across 1 packages, 2 items)
2025-11-22 03:23:36,203 - INFO -   Updated Amazon order 114-7494913-7526615: UPS shipping=$7.24 (split across 1 packages, 2 items)
2025-11-22 03:23:36,216 - INFO -   Updated B2B order 58541-0017: UPS shipping=$11.12
2025-11-22 03:23:36,221 - INFO -   Updated Web order 229633100: UPS shipping=$17.74
2025-11-22 03:23:36,224 - INFO -   Updated B2B order 15090-0076: UPS shipping=$11.12
2025-11-22 03:23:36,230 - INFO -   Updated Web order 229633072: UPS shipping=$8.87 (split across 2 packages, 2 items)
2025-11-22 03:23:36,230 - INFO -   Updated Web order 229633072: UPS shipping=$8.87 (split across 2 packages, 2 items)
2025-11-22 03:23:36,233 - INFO -   Updated Amazon order 111-6487931-5763466: UPS shipping=$10.72 (split across 1 packages, 2 items)
2025-11-22 03:23:36,233 - INFO -   Updated Amazon order 111-6487931-5763466: UPS shipping=$10.72 (split across 1 packages, 2 items)
2025-11-22 03:23:36,357 - INFO -   ... and 48 more orders updated
2025-11-22 03:23:36,357 - INFO - 
UPS ShipHaven Summary:
2025-11-22 03:23:36,357 - INFO -   Orders checked: 617
2025-11-22 03:23:36,357 - INFO -   Orders updated: 58
2025-11-22 03:23:36,357 - INFO -   No match/zero cost: 559
2025-11-22 03:23:36,357 - INFO -   Total shipping added: $826.99
2025-11-22 03:23:36,358 - INFO - 
  Breakdown by Channel:
2025-11-22 03:23:36,358 - INFO -     Amazon: 29 orders, $465.80
2025-11-22 03:23:36,358 - INFO -     B2B: 20 orders, $212.69
2025-11-22 03:23:36,358 - INFO -     Web: 9 orders, $148.50
2025-11-22 03:23:36,366 - INFO - 
================================================================================
2025-11-22 03:23:36,366 - INFO - Processing: USPS STAMPS CUSTOMER SHIPPING
2025-11-22 03:23:36,366 - INFO -   Source: shipping_charges-usps-stamps table
2025-11-22 03:23:36,366 - INFO -   Match: Tracking number
2025-11-22 03:23:36,366 - INFO - ================================================================================
2025-11-22 03:23:36,373 - INFO - Found 559 orders with tracking numbers
2025-11-22 03:23:36,434 - INFO - 
USPS Stamps Summary:
2025-11-22 03:23:36,434 - INFO -   Orders checked: 559
2025-11-22 03:23:36,434 - INFO -   Orders updated: 0
2025-11-22 03:23:36,434 - INFO -   No match/zero cost: 559
2025-11-22 03:23:36,434 - INFO -   Total shipping added: $0.00
2025-11-22 03:23:36,435 - INFO - 
================================================================================
2025-11-22 03:23:36,435 - INFO - OVERALL SUMMARY
2025-11-22 03:23:36,435 - INFO - ================================================================================
2025-11-22 03:23:36,435 - INFO - UPS ShipHaven:
2025-11-22 03:23:36,435 - INFO -   Orders updated: 58
2025-11-22 03:23:36,435 - INFO -   Total shipping: $826.99
2025-11-22 03:23:36,435 - INFO - 
USPS Stamps:
2025-11-22 03:23:36,435 - INFO -   Orders updated: 0
2025-11-22 03:23:36,435 - INFO -   Total shipping: $0.00
2025-11-22 03:23:36,435 - INFO - 
Grand Total:
2025-11-22 03:23:36,435 - INFO -   Orders updated: 58
2025-11-22 03:23:36,435 - INFO -   Total customer shipping costs: $826.99
2025-11-22 03:23:36,435 - INFO - ================================================================================