2025-11-22 23:16:19,312 - INFO - Log file: /home/centralgoparts/public_html/profitability/logs/customer_shipping_20251122_231619.log
2025-11-22 23:16:19,312 - INFO - ================================================================================
2025-11-22 23:16:19,312 - INFO - CUSTOMER SHIPPING UPDATE - 2025-11-22 23:16:19
2025-11-22 23:16:19,312 - INFO - LIVE MODE
2025-11-22 23:16:19,312 - INFO - ================================================================================
2025-11-22 23:16:19,312 - INFO - Date Range: 2025-07-25 to 2025-11-22 (120 days)
2025-11-22 23:16:19,320 - INFO - ================================================================================
2025-11-22 23:16:19,320 - INFO - Processing: UPS SHIPHAVEN CUSTOMER SHIPPING
2025-11-22 23:16:19,320 - INFO -   Source: shipping_charges-ups-shiphaven table
2025-11-22 23:16:19,321 - INFO -   Match: Tracking number (AIRBILL_NO)
2025-11-22 23:16:19,321 - INFO - ================================================================================
2025-11-22 23:16:19,329 - INFO - Found 766 orders with tracking numbers
2025-11-22 23:16:19,331 - INFO -   Updated Amazon order 111-6420298-5201808: UPS shipping=$14.48
2025-11-22 23:16:19,332 - INFO -   Updated Web order 229632677: UPS shipping=$14.48
2025-11-22 23:16:19,334 - INFO -   Updated Amazon order 114-8846989-7340230: UPS shipping=$14.48
2025-11-22 23:16:19,336 - INFO -   Updated Web order 229632659: UPS shipping=$14.48
2025-11-22 23:16:19,339 - INFO -   Updated Amazon order 113-8081089-7189855: UPS shipping=$5.56 (split across 1 packages, 2 items)
2025-11-22 23:16:19,339 - INFO -   Updated Amazon order 113-8081089-7189855: UPS shipping=$5.56 (split across 1 packages, 2 items)
2025-11-22 23:16:19,341 - INFO -   Updated B2B order 51892-0050: UPS shipping=$13.35
2025-11-22 23:16:19,342 - INFO -   Updated B2B order 56551-0004: UPS shipping=$13.35
2025-11-22 23:16:19,345 - INFO -   Updated B2B order 57400-0035: UPS shipping=$13.35
2025-11-22 23:16:19,347 - INFO -   Updated Amazon order 112-2008907-9707431: UPS shipping=$14.48
2025-11-22 23:16:20,189 - INFO -   ... and 570 more orders updated
2025-11-22 23:16:20,192 - INFO - 
UPS ShipHaven Summary:
2025-11-22 23:16:20,192 - INFO -   Orders checked: 766
2025-11-22 23:16:20,193 - INFO -   Orders updated: 580
2025-11-22 23:16:20,193 - INFO -   No match/zero cost: 186
2025-11-22 23:16:20,193 - INFO -   Total shipping added: $8,275.25
2025-11-22 23:16:20,193 - INFO - 
  Breakdown by Channel:
2025-11-22 23:16:20,193 - INFO -     Amazon: 232 orders, $3,672.30
2025-11-22 23:16:20,193 - INFO -     B2B: 264 orders, $3,430.71
2025-11-22 23:16:20,193 - INFO -     Web: 77 orders, $1,072.26
2025-11-22 23:16:20,193 - INFO -     eBay: 7 orders, $99.98
2025-11-22 23:16:20,200 - INFO - 
================================================================================
2025-11-22 23:16:20,200 - INFO - Processing: USPS STAMPS CUSTOMER SHIPPING
2025-11-22 23:16:20,200 - INFO -   Source: shipping_charges-usps-stamps table
2025-11-22 23:16:20,200 - INFO -   Match: Tracking number
2025-11-22 23:16:20,200 - INFO - ================================================================================
2025-11-22 23:16:20,207 - INFO - Found 186 orders with tracking numbers
2025-11-22 23:16:20,226 - INFO - 
USPS Stamps Summary:
2025-11-22 23:16:20,226 - INFO -   Orders checked: 186
2025-11-22 23:16:20,226 - INFO -   Orders updated: 0
2025-11-22 23:16:20,226 - INFO -   No match/zero cost: 186
2025-11-22 23:16:20,226 - INFO -   Total shipping added: $0.00
2025-11-22 23:16:20,226 - INFO - 
================================================================================
2025-11-22 23:16:20,227 - INFO - OVERALL SUMMARY
2025-11-22 23:16:20,227 - INFO - ================================================================================
2025-11-22 23:16:20,227 - INFO - UPS ShipHaven:
2025-11-22 23:16:20,227 - INFO -   Orders updated: 580
2025-11-22 23:16:20,227 - INFO -   Total shipping: $8,275.25
2025-11-22 23:16:20,227 - INFO - 
USPS Stamps:
2025-11-22 23:16:20,227 - INFO -   Orders updated: 0
2025-11-22 23:16:20,227 - INFO -   Total shipping: $0.00
2025-11-22 23:16:20,227 - INFO - 
Grand Total:
2025-11-22 23:16:20,227 - INFO -   Orders updated: 580
2025-11-22 23:16:20,227 - INFO -   Total customer shipping costs: $8,275.25
2025-11-22 23:16:20,227 - INFO - ================================================================================