2025-11-22 23:35:10,316 - INFO - Log file: /home/centralgoparts/public_html/profitability/logs/customer_shipping_20251122_233510.log
2025-11-22 23:35:10,316 - INFO - ================================================================================
2025-11-22 23:35:10,316 - INFO - CUSTOMER SHIPPING UPDATE - 2025-11-22 23:35:10
2025-11-22 23:35:10,316 - INFO - LIVE MODE
2025-11-22 23:35:10,316 - INFO - ================================================================================
2025-11-22 23:35:10,316 - INFO - Date Range: 2025-07-25 to 2025-11-22 (120 days)
2025-11-22 23:35:10,324 - INFO - ================================================================================
2025-11-22 23:35:10,324 - INFO - Processing: UPS SHIPHAVEN CUSTOMER SHIPPING
2025-11-22 23:35:10,324 - INFO -   Source: shipping_charges-ups-shiphaven table
2025-11-22 23:35:10,324 - INFO -   Match: Tracking number (AIRBILL_NO)
2025-11-22 23:35:10,324 - INFO - ================================================================================
2025-11-22 23:35:10,340 - INFO - Found 1340 orders with tracking numbers
2025-11-22 23:35:10,342 - INFO -   Updated Amazon order 111-4107474-7502668: UPS shipping=$13.98
2025-11-22 23:35:10,344 - INFO -   Updated Amazon order 112-7902460-0541864: UPS shipping=$13.98
2025-11-22 23:35:10,345 - INFO -   Updated B2B order 07952-0077: UPS shipping=$11.15
2025-11-22 23:35:10,347 - INFO -   Updated B2B order 49047-0024: UPS shipping=$11.15
2025-11-22 23:35:10,348 - INFO -   Updated B2B order 47247-0028: UPS shipping=$14.24
2025-11-22 23:35:10,349 - INFO -   Updated B2B order 57400-0034: UPS shipping=$21.95 (split across 1 packages, 2 items)
2025-11-22 23:35:10,349 - INFO -   Updated B2B order 57400-0034: UPS shipping=$21.95 (split across 1 packages, 2 items)
2025-11-22 23:35:10,351 - INFO -   Updated B2B order 02528-0005: UPS shipping=$13.38
2025-11-22 23:35:10,354 - INFO -   Updated B2B order 57376-1661: UPS shipping=$11.15
2025-11-22 23:35:10,355 - INFO -   Updated Amazon order 114-7141284-1911432: UPS shipping=$13.98
2025-11-22 23:35:12,078 - INFO -   ... and 820 more orders updated
2025-11-22 23:35:12,086 - INFO - 
UPS ShipHaven Summary:
2025-11-22 23:35:12,086 - INFO -   Orders checked: 1340
2025-11-22 23:35:12,086 - INFO -   Orders updated: 830
2025-11-22 23:35:12,086 - INFO -   No match/zero cost: 510
2025-11-22 23:35:12,086 - INFO -   Total shipping added: $11,709.96
2025-11-22 23:35:12,086 - INFO - 
  Breakdown by Channel:
2025-11-22 23:35:12,086 - INFO -     Amazon: 373 orders, $5,787.25
2025-11-22 23:35:12,086 - INFO -     B2B: 329 orders, $3,990.64
2025-11-22 23:35:12,086 - INFO -     Web: 123 orders, $1,855.69
2025-11-22 23:35:12,086 - INFO -     eBay: 5 orders, $76.38
2025-11-22 23:35:12,096 - INFO - 
================================================================================
2025-11-22 23:35:12,096 - INFO - Processing: USPS STAMPS CUSTOMER SHIPPING
2025-11-22 23:35:12,096 - INFO -   Source: shipping_charges-usps-stamps table
2025-11-22 23:35:12,096 - INFO -   Match: Tracking number
2025-11-22 23:35:12,096 - INFO - ================================================================================
2025-11-22 23:35:12,112 - INFO - Found 510 orders with tracking numbers
2025-11-22 23:35:12,120 - INFO -   Updated Web order 229629320: USPS shipping=$51.59 (split across 1 packages, 2 items)
2025-11-22 23:35:12,121 - INFO -   Updated Web order 229629320: USPS shipping=$51.59 (split across 1 packages, 2 items)
2025-11-22 23:35:12,144 - INFO -   Updated Web order 229627808: USPS shipping=$55.47
2025-11-22 23:35:12,153 - INFO -   Updated Web order 229627646: USPS shipping=$55.47
2025-11-22 23:35:12,157 - INFO -   Updated Web order 229627432: USPS shipping=$27.73 (split across 1 packages, 2 items)
2025-11-22 23:35:12,158 - INFO -   Updated Web order 229627432: USPS shipping=$27.73 (split across 1 packages, 2 items)
2025-11-22 23:35:12,161 - INFO -   Updated Web order 229627211: USPS shipping=$50.60
2025-11-22 23:35:12,173 - INFO -   Updated Web order 229626123: USPS shipping=$50.60
2025-11-22 23:35:12,178 - INFO -   Updated Web order 229625601: USPS shipping=$63.78
2025-11-22 23:35:12,188 - INFO -   Updated Web order 229624754: USPS shipping=$166.97
2025-11-22 23:35:12,190 - INFO - 
USPS Stamps Summary:
2025-11-22 23:35:12,190 - INFO -   Orders checked: 510
2025-11-22 23:35:12,190 - INFO -   Orders updated: 10
2025-11-22 23:35:12,190 - INFO -   No match/zero cost: 500
2025-11-22 23:35:12,190 - INFO -   Total shipping added: $601.53
2025-11-22 23:35:12,190 - INFO - 
  Breakdown by Channel:
2025-11-22 23:35:12,190 - INFO -     Web: 10 orders, $601.53
2025-11-22 23:35:12,191 - INFO - 
================================================================================
2025-11-22 23:35:12,191 - INFO - OVERALL SUMMARY
2025-11-22 23:35:12,191 - INFO - ================================================================================
2025-11-22 23:35:12,191 - INFO - UPS ShipHaven:
2025-11-22 23:35:12,191 - INFO -   Orders updated: 830
2025-11-22 23:35:12,191 - INFO -   Total shipping: $11,709.96
2025-11-22 23:35:12,191 - INFO - 
USPS Stamps:
2025-11-22 23:35:12,191 - INFO -   Orders updated: 10
2025-11-22 23:35:12,191 - INFO -   Total shipping: $601.53
2025-11-22 23:35:12,191 - INFO - 
Grand Total:
2025-11-22 23:35:12,191 - INFO -   Orders updated: 840
2025-11-22 23:35:12,191 - INFO -   Total customer shipping costs: $12,311.49
2025-11-22 23:35:12,191 - INFO - ================================================================================