2025-11-22 23:35:09,926 - INFO - Log file: /home/centralgoparts/public_html/profitability/logs/payment_fees_20251122_233509.log
2025-11-22 23:35:09,926 - INFO - ================================================================================
2025-11-22 23:35:09,926 - INFO - PAYMENT PROCESSOR FEE UPDATE - 2025-11-22 23:35:09
2025-11-22 23:35:09,926 - INFO - LIVE MODE
2025-11-22 23:35:09,926 - INFO - ================================================================================
2025-11-22 23:35:09,926 - INFO - Date Range: 2025-07-25 to 2025-11-22 (120 days)
2025-11-22 23:35:09,936 - INFO - ================================================================================
2025-11-22 23:35:09,936 - INFO - Processing: BOLT PAYMENT PROCESSOR
2025-11-22 23:35:09,936 - INFO -   Source: payment_processor_charges-Bolt table
2025-11-22 23:35:09,936 - INFO - ================================================================================
2025-11-22 23:35:09,956 - INFO - Found 666 Bolt items to update
2025-11-22 23:35:09,956 - INFO -   Updated item 968001 (Order 229625734): Bolt fee=$1.70
2025-11-22 23:35:09,957 - INFO -   Updated item 966317 (Order 229625131): Bolt fee=$0.45
2025-11-22 23:35:09,957 - INFO -   Updated item 966510 (Order 229625177): Bolt fee=$0.62
2025-11-22 23:35:09,957 - INFO -   Updated item 969875 (Order 229626520): Bolt fee=$0.38
2025-11-22 23:35:09,957 - INFO -   Updated item 971407 (Order 229627246): Bolt fee=$0.63
2025-11-22 23:35:09,957 - INFO -   Updated item 965090 (Order 229624705): Bolt fee=$0.83
2025-11-22 23:35:09,958 - INFO -   Updated item 971390 (Order 229627230): Bolt fee=$0.44
2025-11-22 23:35:09,958 - INFO -   Updated item 968581 (Order 229626047): Bolt fee=$0.24
2025-11-22 23:35:09,958 - INFO -   Updated item 966391 (Order 229625146): Bolt fee=$2.16
2025-11-22 23:35:09,958 - INFO -   Updated item 965525 (Order 229624851): Bolt fee=$0.82
2025-11-22 23:35:10,045 - INFO - 
Bolt Summary:
2025-11-22 23:35:10,045 - INFO -   Items updated: 666
2025-11-22 23:35:10,045 - INFO -   Total Bolt fees: $1,124.50
2025-11-22 23:35:10,045 - INFO -   Average fee: $1.69
2025-11-22 23:35:10,053 - INFO - 
================================================================================
2025-11-22 23:35:10,054 - INFO - Processing: CREDIT CARD PAYMENT PROCESSOR
2025-11-22 23:35:10,054 - INFO -   Fee Rate: 2.69% of sales price
2025-11-22 23:35:10,054 - INFO - ================================================================================
2025-11-22 23:35:10,078 - INFO - Found 697 credit card items to update
2025-11-22 23:35:10,079 - INFO -   Updated item 15 (Web, BoltPay): sales=$73.94, cc_fee=$1.99
2025-11-22 23:35:10,079 - INFO -   Updated item 83 (Web, BoltPay): sales=$133.19, cc_fee=$3.58
2025-11-22 23:35:10,079 - INFO -   Updated item 84 (Web, BoltPay): sales=$115.19, cc_fee=$3.10
2025-11-22 23:35:10,079 - INFO -   Updated item 85 (Web, BoltPay): sales=$135.19, cc_fee=$3.64
2025-11-22 23:35:10,080 - INFO -   Updated item 86 (Web, BoltPay): sales=$99.19, cc_fee=$2.67
2025-11-22 23:35:10,080 - INFO -   Updated item 90 (Web, BoltPay): sales=$82.94, cc_fee=$2.23
2025-11-22 23:35:10,080 - INFO -   Updated item 94 (Web, BoltPay): sales=$26.94, cc_fee=$0.72
2025-11-22 23:35:10,080 - INFO -   Updated item 116 (Web, BoltPay): sales=$226.94, cc_fee=$6.10
2025-11-22 23:35:10,080 - INFO -   Updated item 196 (Web, BoltPay): sales=$44.94, cc_fee=$1.21
2025-11-22 23:35:10,080 - INFO -   Updated item 205 (Web, BoltPay): sales=$98.20, cc_fee=$2.64
2025-11-22 23:35:10,189 - INFO - 
Credit Card Summary:
2025-11-22 23:35:10,189 - INFO -   Items updated: 697
2025-11-22 23:35:10,189 - INFO -   Total CC fees: $2,172.33
2025-11-22 23:35:10,189 - INFO - 
  Breakdown by Channel:
2025-11-22 23:35:10,189 - INFO -     Amazon: 18 items, $3,398.25 revenue, $91.41 fees
2025-11-22 23:35:10,189 - INFO -     Web: 679 items, $77,357.59 revenue, $2,080.92 fees
2025-11-22 23:35:10,196 - INFO - 
================================================================================
2025-11-22 23:35:10,196 - INFO - Processing: EBAY MANAGED PAYMENTS PROCESSOR
2025-11-22 23:35:10,196 - INFO -   Fee Rate: 2.90% + $0.30 per transaction
2025-11-22 23:35:10,196 - INFO - ================================================================================
2025-11-22 23:35:10,217 - INFO - Found 74 eBay payment items to update
2025-11-22 23:35:10,217 - INFO -   Updated item 52 (eBay, ebay): sales=$58.95, eBay fee=$2.01
2025-11-22 23:35:10,217 - INFO -   Updated item 111 (eBay, ebay): sales=$175.95, eBay fee=$5.40
2025-11-22 23:35:10,218 - INFO -   Updated item 551 (eBay, ebay): sales=$123.95, eBay fee=$3.89
2025-11-22 23:35:10,218 - INFO -   Updated item 591 (eBay, ebay): sales=$198.95, eBay fee=$6.07
2025-11-22 23:35:10,218 - INFO -   Updated item 618 (eBay, ebay): sales=$78.95, eBay fee=$2.59
2025-11-22 23:35:10,218 - INFO -   Updated item 948 (eBay, ebay): sales=$285.95, eBay fee=$8.59
2025-11-22 23:35:10,218 - INFO -   Updated item 1078 (eBay, ebay): sales=$45.95, eBay fee=$1.63
2025-11-22 23:35:10,219 - INFO -   Updated item 1079 (eBay, ebay): sales=$82.95, eBay fee=$2.71
2025-11-22 23:35:10,219 - INFO -   Updated item 1080 (eBay, ebay): sales=$98.95, eBay fee=$3.17
2025-11-22 23:35:10,219 - INFO -   Updated item 1179 (eBay, ebay): sales=$121.95, eBay fee=$3.84
2025-11-22 23:35:10,230 - INFO - 
eBay Managed Payments Summary:
2025-11-22 23:35:10,230 - INFO -   Items updated: 74
2025-11-22 23:35:10,230 - INFO -   Total eBay payment fees: $310.68
2025-11-22 23:35:10,230 - INFO - 
  Breakdown by Channel:
2025-11-22 23:35:10,230 - INFO -     Amazon: 33 items, $4,827.47 revenue, $149.90 fees
2025-11-22 23:35:10,230 - INFO -     eBay: 41 items, $5,119.95 revenue, $160.78 fees
2025-11-22 23:35:10,231 - INFO - 
================================================================================
2025-11-22 23:35:10,231 - INFO - OVERALL SUMMARY
2025-11-22 23:35:10,231 - INFO - ================================================================================
2025-11-22 23:35:10,231 - INFO - Bolt:
2025-11-22 23:35:10,231 - INFO -   Items updated: 666
2025-11-22 23:35:10,231 - INFO -   Total fees: $1,124.50
2025-11-22 23:35:10,231 - INFO - 
Credit Card:
2025-11-22 23:35:10,231 - INFO -   Items updated: 697
2025-11-22 23:35:10,231 - INFO -   Total fees: $2,172.33
2025-11-22 23:35:10,231 - INFO - 
eBay Managed Payments:
2025-11-22 23:35:10,231 - INFO -   Items updated: 74
2025-11-22 23:35:10,231 - INFO -   Total fees: $310.68
2025-11-22 23:35:10,231 - INFO - 
Grand Total:
2025-11-22 23:35:10,231 - INFO -   Items updated: 1437
2025-11-22 23:35:10,231 - INFO -   Total payment processor fees: $3,607.51
2025-11-22 23:35:10,231 - INFO - ================================================================================

