2025-11-22 23:53:05,633 - INFO - Log file: /home/centralgoparts/public_html/profitability/logs/customer_shipping_20251122_235305.log
2025-11-22 23:53:05,633 - INFO - ================================================================================
2025-11-22 23:53:05,633 - INFO - CUSTOMER SHIPPING UPDATE - 2025-11-22 23:53:05
2025-11-22 23:53:05,633 - INFO - LIVE MODE
2025-11-22 23:53:05,633 - INFO - ================================================================================
2025-11-22 23:53:05,633 - INFO - Date Range: 2025-07-25 to 2025-11-22 (120 days)
2025-11-22 23:53:05,641 - INFO - ================================================================================
2025-11-22 23:53:05,642 - INFO - Processing: UPS SHIPHAVEN CUSTOMER SHIPPING
2025-11-22 23:53:05,642 - INFO -   Source: shipping_charges-ups-shiphaven table
2025-11-22 23:53:05,642 - INFO -   Match: Tracking number (AIRBILL_NO)
2025-11-22 23:53:05,642 - INFO - ================================================================================
2025-11-22 23:53:05,675 - INFO - Found 3084 orders with tracking numbers
2025-11-22 23:53:06,276 - INFO -   Updated Amazon order 112-6082828-9025002: UPS shipping=$14.48
2025-11-22 23:53:06,298 - INFO -   Updated Amazon order 114-7494913-7526615: UPS shipping=$7.24 (split across 1 packages, 2 items)
2025-11-22 23:53:06,298 - INFO -   Updated Amazon order 114-7494913-7526615: UPS shipping=$7.24 (split across 1 packages, 2 items)
2025-11-22 23:53:06,310 - INFO -   Updated B2B order 58541-0017: UPS shipping=$11.12
2025-11-22 23:53:06,315 - INFO -   Updated Web order 229633100: UPS shipping=$17.74
2025-11-22 23:53:06,318 - INFO -   Updated B2B order 15090-0076: UPS shipping=$11.12
2025-11-22 23:53:06,323 - INFO -   Updated Web order 229633072: UPS shipping=$8.87 (split across 2 packages, 2 items)
2025-11-22 23:53:06,324 - INFO -   Updated Web order 229633072: UPS shipping=$8.87 (split across 2 packages, 2 items)
2025-11-22 23:53:06,327 - INFO -   Updated Amazon order 111-6487931-5763466: UPS shipping=$10.72 (split across 1 packages, 2 items)
2025-11-22 23:53:06,327 - INFO -   Updated Amazon order 111-6487931-5763466: UPS shipping=$10.72 (split across 1 packages, 2 items)
2025-11-22 23:53:09,204 - INFO -   ... and 1293 more orders updated
2025-11-22 23:53:09,213 - INFO - 
UPS ShipHaven Summary:
2025-11-22 23:53:09,213 - INFO -   Orders checked: 3084
2025-11-22 23:53:09,213 - INFO -   Orders updated: 1303
2025-11-22 23:53:09,213 - INFO -   No match/zero cost: 1781
2025-11-22 23:53:09,213 - INFO -   Total shipping added: $18,428.46
2025-11-22 23:53:09,213 - INFO - 
  Breakdown by Channel:
2025-11-22 23:53:09,213 - INFO -     Amazon: 559 orders, $8,781.11
2025-11-22 23:53:09,213 - INFO -     B2B: 545 orders, $6,801.87
2025-11-22 23:53:09,213 - INFO -     Web: 189 orders, $2,700.34
2025-11-22 23:53:09,213 - INFO -     eBay: 10 orders, $145.14
2025-11-22 23:53:09,221 - INFO - 
================================================================================
2025-11-22 23:53:09,221 - INFO - Processing: USPS STAMPS CUSTOMER SHIPPING
2025-11-22 23:53:09,221 - INFO -   Source: shipping_charges-usps-stamps table
2025-11-22 23:53:09,221 - INFO -   Match: Tracking number
2025-11-22 23:53:09,221 - INFO - ================================================================================
2025-11-22 23:53:09,245 - INFO - Found 1842 orders with tracking numbers
2025-11-22 23:53:09,325 - INFO -   Updated Web order 229629320: USPS shipping=$51.59 (split across 1 packages, 2 items)
2025-11-22 23:53:09,325 - INFO -   Updated Web order 229629320: USPS shipping=$51.59 (split across 1 packages, 2 items)
2025-11-22 23:53:09,344 - INFO -   Updated Web order 229627808: USPS shipping=$55.47
2025-11-22 23:53:09,351 - INFO -   Updated Web order 229627646: USPS shipping=$55.47
2025-11-22 23:53:09,355 - INFO -   Updated Web order 229627432: USPS shipping=$27.73 (split across 1 packages, 2 items)
2025-11-22 23:53:09,355 - INFO -   Updated Web order 229627432: USPS shipping=$27.73 (split across 1 packages, 2 items)
2025-11-22 23:53:09,357 - INFO -   Updated Web order 229627211: USPS shipping=$50.60
2025-11-22 23:53:09,365 - INFO -   Updated Web order 229626123: USPS shipping=$50.60
2025-11-22 23:53:09,421 - INFO -   Updated Web order 229625601: USPS shipping=$63.78
2025-11-22 23:53:09,452 - INFO - 
USPS Stamps Summary:
2025-11-22 23:53:09,452 - INFO -   Orders checked: 1842
2025-11-22 23:53:09,452 - INFO -   Orders updated: 9
2025-11-22 23:53:09,452 - INFO -   No match/zero cost: 1833
2025-11-22 23:53:09,452 - INFO -   Total shipping added: $434.56
2025-11-22 23:53:09,452 - INFO - 
  Breakdown by Channel:
2025-11-22 23:53:09,452 - INFO -     Web: 9 orders, $434.56
2025-11-22 23:53:09,453 - INFO - 
================================================================================
2025-11-22 23:53:09,453 - INFO - OVERALL SUMMARY
2025-11-22 23:53:09,453 - INFO - ================================================================================
2025-11-22 23:53:09,453 - INFO - UPS ShipHaven:
2025-11-22 23:53:09,453 - INFO -   Orders updated: 1303
2025-11-22 23:53:09,453 - INFO -   Total shipping: $18,428.46
2025-11-22 23:53:09,453 - INFO - 
USPS Stamps:
2025-11-22 23:53:09,453 - INFO -   Orders updated: 9
2025-11-22 23:53:09,453 - INFO -   Total shipping: $434.56
2025-11-22 23:53:09,453 - INFO - 
Grand Total:
2025-11-22 23:53:09,453 - INFO -   Orders updated: 1312
2025-11-22 23:53:09,453 - INFO -   Total customer shipping costs: $18,863.02
2025-11-22 23:53:09,453 - INFO - ================================================================================