2025-11-25 05:01:00,337 - INFO - Log file: /home/centralgoparts/public_html/profitability/logs/customer_shipping_20251125_050100.log
2025-11-25 05:01:00,337 - INFO - ================================================================================
2025-11-25 05:01:00,337 - INFO - CUSTOMER SHIPPING UPDATE - 2025-11-25 05:01:00
2025-11-25 05:01:00,337 - INFO - LIVE MODE
2025-11-25 05:01:00,337 - INFO - ================================================================================
2025-11-25 05:01:00,337 - INFO - Date Range: 2025-07-28 to 2025-11-25 (120 days)
2025-11-25 05:01:00,345 - INFO - ================================================================================
2025-11-25 05:01:00,346 - INFO - Processing: CUSTOMER SHIPPING (ShipHaven + Stamps + Shipments Fallback)
2025-11-25 05:01:00,346 - INFO -   Sources:
2025-11-25 05:01:00,346 - INFO -     1. UPS ShipHaven: shipping_charges-ups-shiphaven
2025-11-25 05:01:00,346 - INFO -     2. USPS Stamps: shipping_charges-usps_stampscom
2025-11-25 05:01:00,346 - INFO -     3. Fallback: shipments table (via orders_items_shipments)
2025-11-25 05:01:00,346 - INFO - ================================================================================
2025-11-25 05:01:00,370 - INFO - Found 1061 orders with tracking numbers needing shipping cost
2025-11-25 05:01:02,479 - INFO - 
Sample Updates:
2025-11-25 05:01:02,479 - INFO -   Amazon order 112-0759635-4913007: $13.53 from Shipments Table
2025-11-25 05:01:02,479 - INFO -   Amazon order 111-7626994-3427438: $17.47 from Shipments Table
2025-11-25 05:01:02,479 - INFO -   Web order 229634721: $10.29 from Shipments Table
2025-11-25 05:01:02,479 - INFO -   Amazon order 112-5525781-7956230: $11.52 from Shipments Table
2025-11-25 05:01:02,479 - INFO -   Amazon order 111-9189369-3513816: $10.29 from Shipments Table
2025-11-25 05:01:02,479 - INFO -   B2B order 36675-0135: $12.28 from Shipments Table
2025-11-25 05:01:02,479 - INFO -   B2B order 51714-0031: $15.06 from Shipments Table
2025-11-25 05:01:02,479 - INFO -   B2B order 08130-0127: $10.29 from Shipments Table
2025-11-25 05:01:02,479 - INFO -   Web order 229634634: $17.23 from Shipments Table
2025-11-25 05:01:02,479 - INFO -   Web order 229634626: $10.34 from Shipments Table
2025-11-25 05:01:02,479 - INFO -   ... and 414 more orders updated
2025-11-25 05:01:02,479 - INFO - 
================================================================================
2025-11-25 05:01:02,479 - INFO - SHIPPING UPDATE SUMMARY
2025-11-25 05:01:02,479 - INFO - ================================================================================
2025-11-25 05:01:02,479 - INFO - Orders checked: 1061
2025-11-25 05:01:02,479 - INFO - 
By Source:
2025-11-25 05:01:02,479 - INFO -   ShipHaven (UPS):    0 orders, $0.00
2025-11-25 05:01:02,479 - INFO -   Stamps (USPS):      0 orders, $0.00
2025-11-25 05:01:02,479 - INFO -   Shipments Fallback: 424 orders, $7,225.30
2025-11-25 05:01:02,480 - INFO - 
Total Updated: 424 orders
2025-11-25 05:01:02,480 - INFO - Total Shipping Added: $7,225.30
2025-11-25 05:01:02,480 - INFO - No Match Found: 637 orders
2025-11-25 05:01:02,480 - INFO - 
By Channel:
2025-11-25 05:01:02,480 - INFO -   Amazon: 135 orders, $1,869.59
2025-11-25 05:01:02,480 - INFO -   B2B: 196 orders, $2,336.51
2025-11-25 05:01:02,480 - INFO -   Web: 92 orders, $3,010.71
2025-11-25 05:01:02,480 - INFO -   eBay: 1 orders, $8.49
2025-11-25 05:01:02,516 - INFO - 
================================================================================
2025-11-25 05:01:02,516 - INFO - ORDERS STILL WITHOUT SHIPPING COST: 565
2025-11-25 05:01:02,516 - INFO - ================================================================================
2025-11-25 05:01:02,516 - INFO - 
Sample of orders without shipping (up to 10):
2025-11-25 05:01:02,516 - INFO -   1. 112-7580077-9273032 | Amazon | None | tracking: 1907547243164434...
2025-11-25 05:01:02,516 - INFO -   2. 114-9572827-5138608 | Amazon | None | tracking: 92001902841737034585...
2025-11-25 05:01:02,516 - INFO -   3. 229634827 | Web | None | tracking: 1Z4347640390825131...
2025-11-25 05:01:02,516 - INFO -   4. 114-3058282-3103404 | Amazon | None | tracking: 1Z9X23V20335301254...
2025-11-25 05:01:02,516 - INFO -   5. 111-2427209-6047433 | Amazon | None | tracking: 886355517593...
2025-11-25 05:01:02,516 - INFO -   6. 113-3050484-2198635 | Amazon | None | tracking: 1907547493164061...
2025-11-25 05:01:02,516 - INFO -   7. 114-1964858-7799427 | Amazon | None | tracking: 1907547603164064...
2025-11-25 05:01:02,516 - INFO -   8. 229634723 | Web | None | tracking: 1Z6Y06R00304755845...
2025-11-25 05:01:02,516 - INFO -   9. 112-9385906-4383456 | Amazon | None | tracking: 1Z1601XX0305987262...
2025-11-25 05:01:02,516 - INFO -   10. 229634690 | Web | ELT-WC (NJ) | tracking: 1ZE21K760321174249...
2025-11-25 05:01:02,516 - INFO - 
================================================================================