2025-11-25 03:35:20,099 - INFO - Log file: /home/centralgoparts/public_html/profitability/logs/customer_shipping_20251125_033520.log
2025-11-25 03:35:20,099 - INFO - ================================================================================
2025-11-25 03:35:20,100 - INFO - CUSTOMER SHIPPING UPDATE - 2025-11-25 03:35:20
2025-11-25 03:35:20,100 - INFO - LIVE MODE
2025-11-25 03:35:20,100 - INFO - ================================================================================
2025-11-25 03:35:20,100 - INFO - Date Range: 2025-07-28 to 2025-11-25 (120 days)
2025-11-25 03:35:20,109 - INFO - ================================================================================
2025-11-25 03:35:20,109 - INFO - Processing: UPS SHIPHAVEN CUSTOMER SHIPPING
2025-11-25 03:35:20,109 - INFO -   Source: shipping_charges-ups-shiphaven table
2025-11-25 03:35:20,109 - INFO -   Match: Tracking number (AIRBILL_NO)
2025-11-25 03:35:20,109 - INFO - ================================================================================
2025-11-25 03:35:20,139 - INFO - Found 1397 orders with tracking numbers
2025-11-25 03:35:20,836 - INFO -   Updated Amazon order 113-9869639-5157032: UPS shipping=$13.35
2025-11-25 03:35:20,838 - INFO -   Updated Amazon order 113-5895763-0903448: UPS shipping=$13.95
2025-11-25 03:35:20,839 - INFO -   Updated Web order 229631642: UPS shipping=$24.35
2025-11-25 03:35:20,846 - INFO -   Updated Web order 229631619: UPS shipping=$14.41
2025-11-25 03:35:20,849 - INFO -   Updated B2B order 15877-0004: UPS shipping=$11.12
2025-11-25 03:35:20,852 - INFO -   Updated Amazon order 114-6227804-7421807: UPS shipping=$13.95
2025-11-25 03:35:20,854 - INFO -   Updated eBay order 20-13714-82267: UPS shipping=$22.05
2025-11-25 03:35:20,855 - INFO -   Updated Amazon order 112-2583109-7105865: UPS shipping=$6.97 (split across 1 packages, 2 items)
2025-11-25 03:35:20,856 - INFO -   Updated Amazon order 112-2583109-7105865: UPS shipping=$6.97 (split across 1 packages, 2 items)
2025-11-25 03:35:20,857 - INFO -   Updated Amazon order 111-0504186-5712242: UPS shipping=$13.95
2025-11-25 03:35:21,960 - INFO -   ... and 322 more orders updated
2025-11-25 03:35:21,963 - INFO - 
UPS ShipHaven Summary:
2025-11-25 03:35:21,963 - INFO -   Orders checked: 1397
2025-11-25 03:35:21,963 - INFO -   Orders updated: 332
2025-11-25 03:35:21,963 - INFO -   No match/zero cost: 1065
2025-11-25 03:35:21,963 - INFO -   Total shipping added: $5,002.99
2025-11-25 03:35:21,963 - INFO - 
  Breakdown by Channel:
2025-11-25 03:35:21,963 - INFO -     Amazon: 197 orders, $3,064.67
2025-11-25 03:35:21,963 - INFO -     B2B: 48 orders, $581.96
2025-11-25 03:35:21,963 - INFO -     Web: 77 orders, $1,205.13
2025-11-25 03:35:21,963 - INFO -     eBay: 10 orders, $151.23
2025-11-25 03:35:21,971 - INFO - 
================================================================================
2025-11-25 03:35:21,971 - INFO - Processing: USPS STAMPS CUSTOMER SHIPPING
2025-11-25 03:35:21,971 - INFO -   Source: shipping_charges-usps-stamps table
2025-11-25 03:35:21,971 - INFO -   Match: Tracking number
2025-11-25 03:35:21,971 - INFO - ================================================================================
2025-11-25 03:35:21,995 - INFO - Found 1065 orders with tracking numbers
2025-11-25 03:35:22,067 - INFO -   Updated Web order 229629320: USPS shipping=$103.17
2025-11-25 03:35:22,085 - INFO -   Updated Web order 229627808: USPS shipping=$55.47
2025-11-25 03:35:22,096 - INFO -   Updated Web order 229627211: USPS shipping=$50.60
2025-11-25 03:35:22,105 - INFO -   Updated Web order 229626123: USPS shipping=$50.60
2025-11-25 03:35:22,117 - INFO - 
USPS Stamps Summary:
2025-11-25 03:35:22,117 - INFO -   Orders checked: 1065
2025-11-25 03:35:22,117 - INFO -   Orders updated: 4
2025-11-25 03:35:22,117 - INFO -   No match/zero cost: 1061
2025-11-25 03:35:22,117 - INFO -   Total shipping added: $259.84
2025-11-25 03:35:22,117 - INFO - 
  Breakdown by Channel:
2025-11-25 03:35:22,117 - INFO -     Web: 4 orders, $259.84
2025-11-25 03:35:22,118 - INFO - 
================================================================================
2025-11-25 03:35:22,118 - INFO - OVERALL SUMMARY
2025-11-25 03:35:22,118 - INFO - ================================================================================
2025-11-25 03:35:22,118 - INFO - UPS ShipHaven:
2025-11-25 03:35:22,118 - INFO -   Orders updated: 332
2025-11-25 03:35:22,118 - INFO -   Total shipping: $5,002.99
2025-11-25 03:35:22,118 - INFO - 
USPS Stamps:
2025-11-25 03:35:22,118 - INFO -   Orders updated: 4
2025-11-25 03:35:22,118 - INFO -   Total shipping: $259.84
2025-11-25 03:35:22,118 - INFO - 
Grand Total:
2025-11-25 03:35:22,118 - INFO -   Orders updated: 336
2025-11-25 03:35:22,118 - INFO -   Total customer shipping costs: $5,262.83
2025-11-25 03:35:22,119 - INFO - ================================================================================