2025-11-24 06:34:58,983 - INFO - Log file: /home/centralgoparts/public_html/profitability/logs/customer_shipping_20251124_063458.log
2025-11-24 06:34:58,983 - INFO - ================================================================================
2025-11-24 06:34:58,983 - INFO - CUSTOMER SHIPPING UPDATE - 2025-11-24 06:34:58
2025-11-24 06:34:58,983 - INFO - LIVE MODE
2025-11-24 06:34:58,983 - INFO - ================================================================================
2025-11-24 06:34:58,983 - INFO - Date Range: 2025-07-27 to 2025-11-24 (120 days)
2025-11-24 06:34:58,991 - INFO - ================================================================================
2025-11-24 06:34:58,992 - INFO - Processing: UPS SHIPHAVEN CUSTOMER SHIPPING
2025-11-24 06:34:58,992 - INFO -   Source: shipping_charges-ups-shiphaven table
2025-11-24 06:34:58,992 - INFO -   Match: Tracking number (AIRBILL_NO)
2025-11-24 06:34:58,992 - INFO - ================================================================================
2025-11-24 06:34:59,018 - INFO - Found 1910 orders with tracking numbers
2025-11-24 06:34:59,385 - INFO -   Updated Amazon order 112-0479513-6783433: UPS shipping=$14.51
2025-11-24 06:34:59,395 - INFO -   Updated Amazon order 113-8684589-8249811: UPS shipping=$14.51
2025-11-24 06:34:59,421 - INFO -   Updated Amazon order 114-6527197-0731448: UPS shipping=$11.15
2025-11-24 06:34:59,426 - INFO -   Updated Amazon order 113-0269338-8759447: UPS shipping=$11.15
2025-11-24 06:34:59,430 - INFO -   Updated Web order 229633696: UPS shipping=$13.38
2025-11-24 06:34:59,432 - INFO -   Updated Web order 229633691: UPS shipping=$14.51
2025-11-24 06:34:59,435 - INFO -   Updated Amazon order 114-9078588-1478660: UPS shipping=$14.51
2025-11-24 06:34:59,449 - INFO -   Updated B2B order 14052-0004: UPS shipping=$11.15
2025-11-24 06:34:59,453 - INFO -   Updated B2B order 44676-0065: UPS shipping=$11.15
2025-11-24 06:34:59,454 - INFO -   Updated B2B order 44676-0064: UPS shipping=$11.15
2025-11-24 06:35:01,266 - INFO -   ... and 883 more orders updated
2025-11-24 06:35:01,272 - INFO - 
UPS ShipHaven Summary:
2025-11-24 06:35:01,272 - INFO -   Orders checked: 1910
2025-11-24 06:35:01,272 - INFO -   Orders updated: 893
2025-11-24 06:35:01,272 - INFO -   No match/zero cost: 1017
2025-11-24 06:35:01,272 - INFO -   Total shipping added: $11,840.34
2025-11-24 06:35:01,272 - INFO - 
  Breakdown by Channel:
2025-11-24 06:35:01,272 - INFO -     Amazon: 304 orders, $4,433.08
2025-11-24 06:35:01,272 - INFO -     B2B: 490 orders, $5,954.02
2025-11-24 06:35:01,272 - INFO -     Web: 95 orders, $1,396.89
2025-11-24 06:35:01,272 - INFO -     eBay: 4 orders, $56.35
2025-11-24 06:35:01,280 - INFO - 
================================================================================
2025-11-24 06:35:01,280 - INFO - Processing: USPS STAMPS CUSTOMER SHIPPING
2025-11-24 06:35:01,280 - INFO -   Source: shipping_charges-usps-stamps table
2025-11-24 06:35:01,280 - INFO -   Match: Tracking number
2025-11-24 06:35:01,280 - INFO - ================================================================================
2025-11-24 06:35:01,303 - INFO - Found 1017 orders with tracking numbers
2025-11-24 06:35:01,357 - INFO -   Updated Web order 229629320: USPS shipping=$103.17
2025-11-24 06:35:01,378 - INFO -   Updated Web order 229627646: USPS shipping=$55.47
2025-11-24 06:35:01,401 - INFO -   Updated Web order 229624754: USPS shipping=$166.97
2025-11-24 06:35:01,402 - INFO - 
USPS Stamps Summary:
2025-11-24 06:35:01,402 - INFO -   Orders checked: 1017
2025-11-24 06:35:01,402 - INFO -   Orders updated: 3
2025-11-24 06:35:01,402 - INFO -   No match/zero cost: 1014
2025-11-24 06:35:01,402 - INFO -   Total shipping added: $325.61
2025-11-24 06:35:01,403 - INFO - 
  Breakdown by Channel:
2025-11-24 06:35:01,403 - INFO -     Web: 3 orders, $325.61
2025-11-24 06:35:01,403 - INFO - 
================================================================================
2025-11-24 06:35:01,403 - INFO - OVERALL SUMMARY
2025-11-24 06:35:01,404 - INFO - ================================================================================
2025-11-24 06:35:01,404 - INFO - UPS ShipHaven:
2025-11-24 06:35:01,404 - INFO -   Orders updated: 893
2025-11-24 06:35:01,404 - INFO -   Total shipping: $11,840.34
2025-11-24 06:35:01,404 - INFO - 
USPS Stamps:
2025-11-24 06:35:01,404 - INFO -   Orders updated: 3
2025-11-24 06:35:01,404 - INFO -   Total shipping: $325.61
2025-11-24 06:35:01,404 - INFO - 
Grand Total:
2025-11-24 06:35:01,404 - INFO -   Orders updated: 896
2025-11-24 06:35:01,404 - INFO -   Total customer shipping costs: $12,165.95
2025-11-24 06:35:01,404 - INFO - ================================================================================