2025-11-25 05:23:50,867 - INFO - Log file: /home/centralgoparts/public_html/profitability/logs/customer_shipping_20251125_052350.log 2025-11-25 05:23:50,867 - INFO - ================================================================================ 2025-11-25 05:23:50,867 - INFO - CUSTOMER SHIPPING UPDATE - 2025-11-25 05:23:50 2025-11-25 05:23:50,867 - INFO - LIVE MODE 2025-11-25 05:23:50,867 - INFO - ================================================================================ 2025-11-25 05:23:50,867 - INFO - Date Range: 2025-07-28 to 2025-11-25 (120 days) 2025-11-25 05:23:50,875 - INFO - ================================================================================ 2025-11-25 05:23:50,875 - INFO - Processing: CUSTOMER SHIPPING (All Sources) 2025-11-25 05:23:50,875 - INFO - Sources: 2025-11-25 05:23:50,875 - INFO - 1. UPS ShipHaven: shipping_charges-ups-shiphaven 2025-11-25 05:23:50,876 - INFO - 2. USPS Stamps: shipping_charges-usps_stampscom 2025-11-25 05:23:50,876 - INFO - 3. Shipments table: shipments (via orders_items_shipments) 2025-11-25 05:23:50,876 - INFO - 4. Meyer Dropship: supplier_charges-meyer 2025-11-25 05:23:50,876 - INFO - 5. Keystone/LKQ Dropship: supplier_charges-lkq 2025-11-25 05:23:50,876 - INFO - ================================================================================ 2025-11-25 05:23:50,948 - INFO - Found 12549 orders needing shipping cost 2025-11-25 05:24:07,851 - INFO - Sample Updates: 2025-11-25 05:24:07,851 - INFO - B2B order 35916-0073: $11.88 from Dropship: LKQ 2025-11-25 05:24:07,851 - INFO - B2B order 12924-0095: $14.41 from Dropship: LKQ 2025-11-25 05:24:07,851 - INFO - B2B order 41282-0110: $42.08 from Dropship: LKQ 2025-11-25 05:24:07,851 - INFO - B2B order 38175-0066: $12.37 from Dropship: LKQ 2025-11-25 05:24:07,851 - INFO - B2B order 38154-0077: $11.88 from Dropship: LKQ 2025-11-25 05:24:07,851 - INFO - B2B order 35203-0038: $10.00 from Dropship: MEYER 2025-11-25 05:24:07,851 - INFO - B2B order 37985-0041: $10.00 from Dropship: MEYER 2025-11-25 05:24:07,851 - INFO - B2B order 37080-0024: $10.00 from Dropship: MEYER (split 2 items) 2025-11-25 05:24:07,851 - INFO - B2B order 37080-0024: $10.00 from Dropship: MEYER (split 2 items) 2025-11-25 05:24:07,851 - INFO - B2B order 42081-0015: $10.00 from Dropship: MEYER 2025-11-25 05:24:07,851 - INFO - B2B order 54462-0050: $10.00 from Dropship: MEYER 2025-11-25 05:24:07,851 - INFO - B2B order 59032-0001: $10.00 from Dropship: MEYER 2025-11-25 05:24:07,851 - INFO - B2B order 36680-0204: $5.00 from Dropship: MEYER (split 2 items) 2025-11-25 05:24:07,851 - INFO - B2B order 36680-0204: $5.00 from Dropship: MEYER (split 2 items) 2025-11-25 05:24:07,851 - INFO - B2B order 26943-0024: $10.00 from Dropship: MEYER 2025-11-25 05:24:07,851 - INFO - ... and 357 more orders updated 2025-11-25 05:24:07,851 - INFO - ================================================================================ 2025-11-25 05:24:07,851 - INFO - SHIPPING UPDATE SUMMARY 2025-11-25 05:24:07,851 - INFO - ================================================================================ 2025-11-25 05:24:07,851 - INFO - Orders checked: 12549 2025-11-25 05:24:07,851 - INFO - By Source: 2025-11-25 05:24:07,851 - INFO - ShipHaven (UPS): 55 orders, $788.60 2025-11-25 05:24:07,851 - INFO - Stamps (USPS): 3 orders, $183.78 2025-11-25 05:24:07,851 - INFO - Shipments Table: 34 orders, $818.91 2025-11-25 05:24:07,851 - INFO - Meyer Dropship: 218 orders, $3,220.00 2025-11-25 05:24:07,851 - INFO - Keystone Dropship: 62 orders, $2,295.35 2025-11-25 05:24:07,851 - INFO - Total Updated: 372 orders 2025-11-25 05:24:07,851 - INFO - Total Shipping Added: $7,306.64 2025-11-25 05:24:07,851 - INFO - No Match Found: 12,177 orders 2025-11-25 05:24:07,852 - INFO - By Channel: 2025-11-25 05:24:07,852 - INFO - Amazon: 95 orders, $2,883.25 2025-11-25 05:24:07,852 - INFO - B2B: 210 orders, $2,665.47 2025-11-25 05:24:07,852 - INFO - Web: 66 orders, $1,746.80 2025-11-25 05:24:07,852 - INFO - eBay: 1 orders, $11.12 2025-11-25 05:24:07,894 - INFO - ================================================================================ 2025-11-25 05:24:07,894 - INFO - ORDERS STILL WITHOUT SHIPPING COST: 1112 2025-11-25 05:24:07,894 - INFO - ================================================================================ 2025-11-25 05:24:07,894 - INFO - Sample of orders without shipping (up to 10): 2025-11-25 05:24:07,894 - INFO - 1. 229634862 | Web | Unknown | tracking: N/A 2025-11-25 05:24:07,894 - INFO - 2. 112-2384609-9637809 | Amazon | Unknown | tracking: N/A 2025-11-25 05:24:07,894 - INFO - 3. 112-2384609-9637809 | Amazon | Unknown | tracking: N/A 2025-11-25 05:24:07,894 - INFO - 4. 111-8832899-8069043 | Amazon | Unknown | tracking: N/A 2025-11-25 05:24:07,894 - INFO - 5. 112-7580077-9273032 | Amazon | Unknown | tracking: 1907547243164434 2025-11-25 05:24:07,894 - INFO - 6. 111-6444989-3525038 | Amazon | Unknown | tracking: N/A 2025-11-25 05:24:07,894 - INFO - 7. 112-0338287-2430662 | Amazon | Unknown | tracking: N/A 2025-11-25 05:24:07,894 - INFO - 8. 229634851 | Web | Unknown | tracking: N/A 2025-11-25 05:24:07,894 - INFO - 9. 114-9572827-5138608 | Amazon | Unknown | tracking: 92001902841737034585... 2025-11-25 05:24:07,894 - INFO - 10. 114-8571312-0163441 | Amazon | Unknown | tracking: N/A 2025-11-25 05:24:07,894 - INFO - ================================================================================