2025-11-24 06:34:52,209 - INFO - Log file: /home/centralgoparts/public_html/profitability/logs/payment_fees_20251124_063452.log
2025-11-24 06:34:52,209 - INFO - ================================================================================
2025-11-24 06:34:52,209 - INFO - PAYMENT PROCESSOR FEE UPDATE - 2025-11-24 06:34:52
2025-11-24 06:34:52,209 - INFO - LIVE MODE
2025-11-24 06:34:52,209 - INFO - ================================================================================
2025-11-24 06:34:52,209 - INFO - Date Range: 2025-07-27 to 2025-11-24 (120 days)
2025-11-24 06:34:52,218 - INFO - ================================================================================
2025-11-24 06:34:52,218 - INFO - Processing: BOLT PAYMENT PROCESSOR
2025-11-24 06:34:52,218 - INFO -   Source: payment_processor_charges-Bolt table
2025-11-24 06:34:52,218 - INFO - ================================================================================
2025-11-24 06:34:52,241 - INFO - Found 666 Bolt items to update
2025-11-24 06:34:52,242 - INFO -   Updated item 968001 (Order 229625734): Bolt fee=$1.70
2025-11-24 06:34:52,242 - INFO -   Updated item 966317 (Order 229625131): Bolt fee=$0.45
2025-11-24 06:34:52,242 - INFO -   Updated item 966510 (Order 229625177): Bolt fee=$0.62
2025-11-24 06:34:52,242 - INFO -   Updated item 969875 (Order 229626520): Bolt fee=$0.38
2025-11-24 06:34:52,242 - INFO -   Updated item 971407 (Order 229627246): Bolt fee=$0.63
2025-11-24 06:34:52,243 - INFO -   Updated item 965090 (Order 229624705): Bolt fee=$0.83
2025-11-24 06:34:52,243 - INFO -   Updated item 971390 (Order 229627230): Bolt fee=$0.44
2025-11-24 06:34:52,243 - INFO -   Updated item 968581 (Order 229626047): Bolt fee=$0.24
2025-11-24 06:34:52,243 - INFO -   Updated item 966391 (Order 229625146): Bolt fee=$2.16
2025-11-24 06:34:52,243 - INFO -   Updated item 965525 (Order 229624851): Bolt fee=$0.82
2025-11-24 06:34:52,335 - INFO - 
Bolt Summary:
2025-11-24 06:34:52,335 - INFO -   Items updated: 666
2025-11-24 06:34:52,336 - INFO -   Total Bolt fees: $1,124.50
2025-11-24 06:34:52,336 - INFO -   Average fee: $1.69
2025-11-24 06:34:52,342 - INFO - 
================================================================================
2025-11-24 06:34:52,342 - INFO - Processing: CREDIT CARD PAYMENT PROCESSOR
2025-11-24 06:34:52,342 - INFO -   Fee Rate: 2.69% of sales price
2025-11-24 06:34:52,342 - INFO - ================================================================================
2025-11-24 06:34:52,385 - INFO - Found 1215 credit card items to update
2025-11-24 06:34:52,385 - INFO -   Updated item 12 (Web, BoltPay): sales=$186.95, cc_fee=$5.03
2025-11-24 06:34:52,385 - INFO -   Updated item 13 (Web, BoltPay): sales=$97.95, cc_fee=$2.63
2025-11-24 06:34:52,385 - INFO -   Updated item 19 (Web, BoltPay): sales=$168.95, cc_fee=$4.54
2025-11-24 06:34:52,386 - INFO -   Updated item 26 (Web, BoltPay): sales=$26.95, cc_fee=$0.72
2025-11-24 06:34:52,386 - INFO -   Updated item 85 (Web, BoltPay): sales=$10.95, cc_fee=$0.29
2025-11-24 06:34:52,386 - INFO -   Updated item 86 (Web, BoltPay): sales=$61.95, cc_fee=$1.67
2025-11-24 06:34:52,386 - INFO -   Updated item 87 (Web, BoltPay): sales=$66.95, cc_fee=$1.80
2025-11-24 06:34:52,386 - INFO -   Updated item 88 (Web, BoltPay): sales=$125.95, cc_fee=$3.39
2025-11-24 06:34:52,386 - INFO -   Updated item 94 (Web, BoltPay): sales=$102.95, cc_fee=$2.77
2025-11-24 06:34:52,386 - INFO -   Updated item 95 (Web, BoltPay): sales=$129.95, cc_fee=$3.50
2025-11-24 06:34:52,521 - INFO - 
Credit Card Summary:
2025-11-24 06:34:52,521 - INFO -   Items updated: 1215
2025-11-24 06:34:52,521 - INFO -   Total CC fees: $3,945.19
2025-11-24 06:34:52,521 - INFO - 
  Breakdown by Channel:
2025-11-24 06:34:52,521 - INFO -     Amazon: 20 items, $3,743.14 revenue, $100.69 fees
2025-11-24 06:34:52,521 - INFO -     B2B: 1 items, $17.50 revenue, $0.47 fees
2025-11-24 06:34:52,521 - INFO -     Web: 1194 items, $142,900.69 revenue, $3,844.03 fees
2025-11-24 06:34:52,529 - INFO - 
================================================================================
2025-11-24 06:34:52,529 - INFO - Processing: EBAY MANAGED PAYMENTS PROCESSOR
2025-11-24 06:34:52,529 - INFO -   Fee Rate: 2.90% + $0.30 per transaction
2025-11-24 06:34:52,529 - INFO - ================================================================================
2025-11-24 06:34:52,569 - INFO - Found 127 eBay payment items to update
2025-11-24 06:34:52,569 - INFO -   Updated item 84 (eBay, ebay): sales=$131.95, eBay fee=$4.13
2025-11-24 06:34:52,569 - INFO -   Updated item 494 (eBay, ebay): sales=$515.95, eBay fee=$15.26
2025-11-24 06:34:52,569 - INFO -   Updated item 1144 (eBay, ebay): sales=$101.95, eBay fee=$3.26
2025-11-24 06:34:52,569 - INFO -   Updated item 1463 (eBay, ebay): sales=$336.95, eBay fee=$10.07
2025-11-24 06:34:52,570 - INFO -   Updated item 1472 (eBay, ebay): sales=$128.95, eBay fee=$4.04
2025-11-24 06:34:52,570 - INFO -   Updated item 1555 (eBay, ebay): sales=$338.95, eBay fee=$10.13
2025-11-24 06:34:52,570 - INFO -   Updated item 1698 (eBay, ebay): sales=$225.95, eBay fee=$6.85
2025-11-24 06:34:52,570 - INFO -   Updated item 2622 (eBay, ebay): sales=$100.95, eBay fee=$3.23
2025-11-24 06:34:52,570 - INFO -   Updated item 2810 (eBay, ebay): sales=$150.95, eBay fee=$4.68
2025-11-24 06:34:52,570 - INFO -   Updated item 2846 (eBay, ebay): sales=$77.95, eBay fee=$2.56
2025-11-24 06:34:52,582 - INFO - 
eBay Managed Payments Summary:
2025-11-24 06:34:52,582 - INFO -   Items updated: 127
2025-11-24 06:34:52,582 - INFO -   Total eBay payment fees: $569.05
2025-11-24 06:34:52,582 - INFO - 
  Breakdown by Channel:
2025-11-24 06:34:52,582 - INFO -     Amazon: 34 items, $4,857.42 revenue, $151.07 fees
2025-11-24 06:34:52,582 - INFO -     eBay: 93 items, $13,451.35 revenue, $417.99 fees
2025-11-24 06:34:52,583 - INFO - 
================================================================================
2025-11-24 06:34:52,583 - INFO - OVERALL SUMMARY
2025-11-24 06:34:52,583 - INFO - ================================================================================
2025-11-24 06:34:52,583 - INFO - Bolt:
2025-11-24 06:34:52,583 - INFO -   Items updated: 666
2025-11-24 06:34:52,583 - INFO -   Total fees: $1,124.50
2025-11-24 06:34:52,583 - INFO - 
Credit Card:
2025-11-24 06:34:52,583 - INFO -   Items updated: 1215
2025-11-24 06:34:52,583 - INFO -   Total fees: $3,945.19
2025-11-24 06:34:52,583 - INFO - 
eBay Managed Payments:
2025-11-24 06:34:52,583 - INFO -   Items updated: 127
2025-11-24 06:34:52,583 - INFO -   Total fees: $569.05
2025-11-24 06:34:52,583 - INFO - 
Grand Total:
2025-11-24 06:34:52,584 - INFO -   Items updated: 2008
2025-11-24 06:34:52,584 - INFO -   Total payment processor fees: $5,638.74
2025-11-24 06:34:52,584 - INFO - ================================================================================

