2025-11-22 21:55:02,565 - INFO - Log file: /home/centralgoparts/public_html/profitability/logs/customer_shipping_20251122_215502.log
2025-11-22 21:55:02,566 - INFO - ================================================================================
2025-11-22 21:55:02,566 - INFO - CUSTOMER SHIPPING UPDATE - 2025-11-22 21:55:02
2025-11-22 21:55:02,566 - INFO - LIVE MODE
2025-11-22 21:55:02,566 - INFO - ================================================================================
2025-11-22 21:55:02,566 - INFO - Date Range: 2025-07-25 to 2025-11-22 (120 days)
2025-11-22 21:55:02,575 - INFO - ================================================================================
2025-11-22 21:55:02,575 - INFO - Processing: UPS SHIPHAVEN CUSTOMER SHIPPING
2025-11-22 21:55:02,575 - INFO -   Source: shipping_charges-ups-shiphaven table
2025-11-22 21:55:02,575 - INFO -   Match: Tracking number (AIRBILL_NO)
2025-11-22 21:55:02,575 - INFO - ================================================================================
2025-11-22 21:55:02,589 - INFO - Found 957 orders with tracking numbers
2025-11-22 21:55:03,229 - INFO -   Updated B2B order 58541-0017: UPS shipping=$11.12
2025-11-22 21:55:03,235 - INFO -   Updated B2B order 15090-0076: UPS shipping=$11.12
2025-11-22 21:55:03,252 - INFO -   Updated B2B order 57376-1739: UPS shipping=$5.56 (split across 1 packages, 2 items)
2025-11-22 21:55:03,252 - INFO -   Updated B2B order 57376-1739: UPS shipping=$5.56 (split across 1 packages, 2 items)
2025-11-22 21:55:03,255 - INFO -   Updated B2B order 42393-0013: UPS shipping=$11.12
2025-11-22 21:55:03,258 - INFO -   Updated B2B order 44122-0005: UPS shipping=$17.74
2025-11-22 21:55:03,273 - INFO -   Updated Amazon order 114-2628415-7746655: UPS shipping=$17.74
2025-11-22 21:55:03,281 - INFO -   Updated B2B order 51774-0025: UPS shipping=$11.12
2025-11-22 21:55:03,282 - INFO -   Updated Amazon order 111-8827566-8237808: UPS shipping=$18.87
2025-11-22 21:55:03,284 - INFO -   Updated Amazon order 113-3644369-9075457: UPS shipping=$14.48
2025-11-22 21:55:03,755 - INFO -   ... and 275 more orders updated
2025-11-22 21:55:03,757 - INFO - 
UPS ShipHaven Summary:
2025-11-22 21:55:03,757 - INFO -   Orders checked: 957
2025-11-22 21:55:03,757 - INFO -   Orders updated: 285
2025-11-22 21:55:03,757 - INFO -   No match/zero cost: 672
2025-11-22 21:55:03,757 - INFO -   Total shipping added: $3,745.33
2025-11-22 21:55:03,757 - INFO - 
  Breakdown by Channel:
2025-11-22 21:55:03,757 - INFO -     Amazon: 95 orders, $1,337.48
2025-11-22 21:55:03,757 - INFO -     B2B: 164 orders, $2,033.81
2025-11-22 21:55:03,757 - INFO -     Web: 25 orders, $362.89
2025-11-22 21:55:03,757 - INFO -     eBay: 1 orders, $11.15
2025-11-22 21:55:03,764 - INFO - 
================================================================================
2025-11-22 21:55:03,765 - INFO - Processing: USPS STAMPS CUSTOMER SHIPPING
2025-11-22 21:55:03,765 - INFO -   Source: shipping_charges-usps-stamps table
2025-11-22 21:55:03,765 - INFO -   Match: Tracking number
2025-11-22 21:55:03,765 - INFO - ================================================================================
2025-11-22 21:55:03,779 - INFO - Found 672 orders with tracking numbers
2025-11-22 21:55:03,843 - INFO - 
USPS Stamps Summary:
2025-11-22 21:55:03,843 - INFO -   Orders checked: 672
2025-11-22 21:55:03,843 - INFO -   Orders updated: 0
2025-11-22 21:55:03,843 - INFO -   No match/zero cost: 672
2025-11-22 21:55:03,843 - INFO -   Total shipping added: $0.00
2025-11-22 21:55:03,844 - INFO - 
================================================================================
2025-11-22 21:55:03,844 - INFO - OVERALL SUMMARY
2025-11-22 21:55:03,845 - INFO - ================================================================================
2025-11-22 21:55:03,845 - INFO - UPS ShipHaven:
2025-11-22 21:55:03,845 - INFO -   Orders updated: 285
2025-11-22 21:55:03,845 - INFO -   Total shipping: $3,745.33
2025-11-22 21:55:03,845 - INFO - 
USPS Stamps:
2025-11-22 21:55:03,845 - INFO -   Orders updated: 0
2025-11-22 21:55:03,845 - INFO -   Total shipping: $0.00
2025-11-22 21:55:03,845 - INFO - 
Grand Total:
2025-11-22 21:55:03,845 - INFO -   Orders updated: 285
2025-11-22 21:55:03,845 - INFO -   Total customer shipping costs: $3,745.33
2025-11-22 21:55:03,845 - INFO - ================================================================================