2025-11-22 21:54:49,228 - INFO - Log file: /home/centralgoparts/public_html/profitability/logs/payment_fees_20251122_215449.log
2025-11-22 21:54:49,228 - INFO - ================================================================================
2025-11-22 21:54:49,228 - INFO - PAYMENT PROCESSOR FEE UPDATE - 2025-11-22 21:54:49
2025-11-22 21:54:49,228 - INFO - LIVE MODE
2025-11-22 21:54:49,228 - INFO - ================================================================================
2025-11-22 21:54:49,228 - INFO - Date Range: 2025-07-25 to 2025-11-22 (120 days)
2025-11-22 21:54:49,237 - INFO - ================================================================================
2025-11-22 21:54:49,237 - INFO - Processing: BOLT PAYMENT PROCESSOR
2025-11-22 21:54:49,237 - INFO -   Source: payment_processor_charges-Bolt table
2025-11-22 21:54:49,237 - INFO - ================================================================================
2025-11-22 21:54:49,261 - INFO - Found 0 Bolt items to update
2025-11-22 21:54:49,267 - INFO - 
================================================================================
2025-11-22 21:54:49,267 - INFO - Processing: CREDIT CARD PAYMENT PROCESSOR
2025-11-22 21:54:49,267 - INFO -   Fee Rate: 2.69% of sales price
2025-11-22 21:54:49,267 - INFO - ================================================================================
2025-11-22 21:54:49,287 - INFO - Found 510 credit card items to update
2025-11-22 21:54:49,288 - INFO -   Updated item 2 (Web, BoltPay): sales=$102.95, cc_fee=$2.77
2025-11-22 21:54:49,288 - INFO -   Updated item 3 (Web, BoltPay): sales=$129.95, cc_fee=$3.50
2025-11-22 21:54:49,288 - INFO -   Updated item 14 (Web, BoltPay): sales=$99.95, cc_fee=$2.69
2025-11-22 21:54:49,288 - INFO -   Updated item 15 (Web, BoltPay): sales=$24.95, cc_fee=$0.67
2025-11-22 21:54:49,288 - INFO -   Updated item 30 (Web, BoltPay): sales=$144.56, cc_fee=$3.89
2025-11-22 21:54:49,288 - INFO -   Updated item 31 (Web, BoltPay): sales=$139.39, cc_fee=$3.75
2025-11-22 21:54:49,288 - INFO -   Updated item 52 (Web, BoltPay): sales=$10.95, cc_fee=$0.29
2025-11-22 21:54:49,288 - INFO -   Updated item 71 (Web, BoltPay): sales=$20.94, cc_fee=$0.56
2025-11-22 21:54:49,289 - INFO -   Updated item 74 (Web, BoltPay): sales=$76.94, cc_fee=$2.07
2025-11-22 21:54:49,289 - INFO -   Updated item 80 (Web, BoltPay): sales=$20.94, cc_fee=$0.56
2025-11-22 21:54:49,327 - INFO - 
Credit Card Summary:
2025-11-22 21:54:49,328 - INFO -   Items updated: 510
2025-11-22 21:54:49,328 - INFO -   Total CC fees: $1,752.77
2025-11-22 21:54:49,328 - INFO - 
  Breakdown by Channel:
2025-11-22 21:54:49,328 - INFO -     Amazon: 2 items, $344.89 revenue, $9.28 fees
2025-11-22 21:54:49,328 - INFO -     B2B: 1 items, $17.50 revenue, $0.47 fees
2025-11-22 21:54:49,328 - INFO -     Web: 507 items, $64,796.50 revenue, $1,743.03 fees
2025-11-22 21:54:49,334 - INFO - 
================================================================================
2025-11-22 21:54:49,334 - INFO - Processing: EBAY MANAGED PAYMENTS PROCESSOR
2025-11-22 21:54:49,334 - INFO -   Fee Rate: 2.90% + $0.30 per transaction
2025-11-22 21:54:49,334 - INFO - ================================================================================
2025-11-22 21:54:49,352 - INFO - Found 53 eBay payment items to update
2025-11-22 21:54:49,353 - INFO -   Updated item 402 (eBay, ebay): sales=$515.95, eBay fee=$15.26
2025-11-22 21:54:49,353 - INFO -   Updated item 1052 (eBay, ebay): sales=$101.95, eBay fee=$3.26
2025-11-22 21:54:49,353 - INFO -   Updated item 1371 (eBay, ebay): sales=$336.95, eBay fee=$10.07
2025-11-22 21:54:49,353 - INFO -   Updated item 1380 (eBay, ebay): sales=$128.95, eBay fee=$4.04
2025-11-22 21:54:49,353 - INFO -   Updated item 1463 (eBay, ebay): sales=$338.95, eBay fee=$10.13
2025-11-22 21:54:49,353 - INFO -   Updated item 1606 (eBay, ebay): sales=$225.95, eBay fee=$6.85
2025-11-22 21:54:49,353 - INFO -   Updated item 1991 (eBay, ebay): sales=$338.95, eBay fee=$10.13
2025-11-22 21:54:49,353 - INFO -   Updated item 2530 (eBay, ebay): sales=$100.95, eBay fee=$3.23
2025-11-22 21:54:49,354 - INFO -   Updated item 2718 (eBay, ebay): sales=$150.95, eBay fee=$4.68
2025-11-22 21:54:49,354 - INFO -   Updated item 2754 (eBay, ebay): sales=$77.95, eBay fee=$2.56
2025-11-22 21:54:49,358 - INFO - 
eBay Managed Payments Summary:
2025-11-22 21:54:49,358 - INFO -   Items updated: 53
2025-11-22 21:54:49,358 - INFO -   Total eBay payment fees: $264.38
2025-11-22 21:54:49,358 - INFO - 
  Breakdown by Channel:
2025-11-22 21:54:49,358 - INFO -     Amazon: 1 items, $29.95 revenue, $1.17 fees
2025-11-22 21:54:49,358 - INFO -     eBay: 52 items, $8,538.40 revenue, $263.21 fees
2025-11-22 21:54:49,359 - INFO - 
================================================================================
2025-11-22 21:54:49,359 - INFO - OVERALL SUMMARY
2025-11-22 21:54:49,359 - INFO - ================================================================================
2025-11-22 21:54:49,359 - INFO - Bolt:
2025-11-22 21:54:49,359 - INFO -   Items updated: 0
2025-11-22 21:54:49,359 - INFO -   Total fees: $0.00
2025-11-22 21:54:49,359 - INFO - 
Credit Card:
2025-11-22 21:54:49,359 - INFO -   Items updated: 510
2025-11-22 21:54:49,359 - INFO -   Total fees: $1,752.77
2025-11-22 21:54:49,359 - INFO - 
eBay Managed Payments:
2025-11-22 21:54:49,359 - INFO -   Items updated: 53
2025-11-22 21:54:49,359 - INFO -   Total fees: $264.38
2025-11-22 21:54:49,359 - INFO - 
Grand Total:
2025-11-22 21:54:49,359 - INFO -   Items updated: 563
2025-11-22 21:54:49,359 - INFO -   Total payment processor fees: $2,017.16
2025-11-22 21:54:49,359 - INFO - ================================================================================