2025-11-22 23:52:56,533 - INFO - Log file: /home/centralgoparts/public_html/profitability/logs/payment_fees_20251122_235256.log
2025-11-22 23:52:56,533 - INFO - ================================================================================
2025-11-22 23:52:56,533 - INFO - PAYMENT PROCESSOR FEE UPDATE - 2025-11-22 23:52:56
2025-11-22 23:52:56,533 - INFO - LIVE MODE
2025-11-22 23:52:56,533 - INFO - ================================================================================
2025-11-22 23:52:56,533 - INFO - Date Range: 2025-07-25 to 2025-11-22 (120 days)
2025-11-22 23:52:56,542 - INFO - ================================================================================
2025-11-22 23:52:56,542 - INFO - Processing: BOLT PAYMENT PROCESSOR
2025-11-22 23:52:56,542 - INFO -   Source: payment_processor_charges-Bolt table
2025-11-22 23:52:56,542 - INFO - ================================================================================
2025-11-22 23:52:56,563 - INFO - Found 518 Bolt items to update
2025-11-22 23:52:56,563 - INFO -   Updated item 968001 (Order 229625734): Bolt fee=$1.70
2025-11-22 23:52:56,564 - INFO -   Updated item 969875 (Order 229626520): Bolt fee=$0.38
2025-11-22 23:52:56,564 - INFO -   Updated item 971407 (Order 229627246): Bolt fee=$0.63
2025-11-22 23:52:56,564 - INFO -   Updated item 971390 (Order 229627230): Bolt fee=$0.44
2025-11-22 23:52:56,564 - INFO -   Updated item 968581 (Order 229626047): Bolt fee=$0.24
2025-11-22 23:52:56,564 - INFO -   Updated item 968770 (Order 229626133): Bolt fee=$0.68
2025-11-22 23:52:56,564 - INFO -   Updated item 968771 (Order 229626133): Bolt fee=$0.68
2025-11-22 23:52:56,565 - INFO -   Updated item 971031 (Order 229627071): Bolt fee=$1.58
2025-11-22 23:52:56,565 - INFO -   Updated item 971032 (Order 229627071): Bolt fee=$1.58
2025-11-22 23:52:56,565 - INFO -   Updated item 969470 (Order 229626383): Bolt fee=$0.38
2025-11-22 23:52:56,631 - INFO - 
Bolt Summary:
2025-11-22 23:52:56,631 - INFO -   Items updated: 518
2025-11-22 23:52:56,631 - INFO -   Total Bolt fees: $915.03
2025-11-22 23:52:56,631 - INFO -   Average fee: $1.77
2025-11-22 23:52:56,638 - INFO - 
================================================================================
2025-11-22 23:52:56,638 - INFO - Processing: CREDIT CARD PAYMENT PROCESSOR
2025-11-22 23:52:56,639 - INFO -   Fee Rate: 2.69% of sales price
2025-11-22 23:52:56,639 - INFO - ================================================================================
2025-11-22 23:52:56,693 - INFO - Found 1038 credit card items to update
2025-11-22 23:52:56,694 - INFO -   Updated item 86 (Web, BoltPay): sales=$61.95, cc_fee=$1.67
2025-11-22 23:52:56,694 - INFO -   Updated item 87 (Web, BoltPay): sales=$66.95, cc_fee=$1.80
2025-11-22 23:52:56,694 - INFO -   Updated item 88 (Web, BoltPay): sales=$125.95, cc_fee=$3.39
2025-11-22 23:52:56,694 - INFO -   Updated item 94 (Web, BoltPay): sales=$102.95, cc_fee=$2.77
2025-11-22 23:52:56,695 - INFO -   Updated item 95 (Web, BoltPay): sales=$129.95, cc_fee=$3.50
2025-11-22 23:52:56,695 - INFO -   Updated item 106 (Web, BoltPay): sales=$99.95, cc_fee=$2.69
2025-11-22 23:52:56,695 - INFO -   Updated item 107 (Web, BoltPay): sales=$24.95, cc_fee=$0.67
2025-11-22 23:52:56,695 - INFO -   Updated item 122 (Web, BoltPay): sales=$144.56, cc_fee=$3.89
2025-11-22 23:52:56,695 - INFO -   Updated item 123 (Web, BoltPay): sales=$139.39, cc_fee=$3.75
2025-11-22 23:52:56,696 - INFO -   Updated item 144 (Web, BoltPay): sales=$10.95, cc_fee=$0.29
2025-11-22 23:52:56,837 - INFO - 
Credit Card Summary:
2025-11-22 23:52:56,837 - INFO -   Items updated: 1038
2025-11-22 23:52:56,837 - INFO -   Total CC fees: $3,386.71
2025-11-22 23:52:56,837 - INFO - 
  Breakdown by Channel:
2025-11-22 23:52:56,837 - INFO -     Amazon: 3 items, $520.79 revenue, $14.01 fees
2025-11-22 23:52:56,837 - INFO -     B2B: 1 items, $17.50 revenue, $0.47 fees
2025-11-22 23:52:56,837 - INFO -     Web: 1034 items, $125,361.57 revenue, $3,372.23 fees
2025-11-22 23:52:56,846 - INFO - 
================================================================================
2025-11-22 23:52:56,847 - INFO - Processing: EBAY MANAGED PAYMENTS PROCESSOR
2025-11-22 23:52:56,847 - INFO -   Fee Rate: 2.90% + $0.30 per transaction
2025-11-22 23:52:56,847 - INFO - ================================================================================
2025-11-22 23:52:56,882 - INFO - Found 88 eBay payment items to update
2025-11-22 23:52:56,883 - INFO -   Updated item 494 (eBay, ebay): sales=$515.95, eBay fee=$15.26
2025-11-22 23:52:56,883 - INFO -   Updated item 1144 (eBay, ebay): sales=$101.95, eBay fee=$3.26
2025-11-22 23:52:56,883 - INFO -   Updated item 1463 (eBay, ebay): sales=$336.95, eBay fee=$10.07
2025-11-22 23:52:56,883 - INFO -   Updated item 1472 (eBay, ebay): sales=$128.95, eBay fee=$4.04
2025-11-22 23:52:56,883 - INFO -   Updated item 1555 (eBay, ebay): sales=$338.95, eBay fee=$10.13
2025-11-22 23:52:56,884 - INFO -   Updated item 1698 (eBay, ebay): sales=$225.95, eBay fee=$6.85
2025-11-22 23:52:56,884 - INFO -   Updated item 2083 (eBay, ebay): sales=$338.95, eBay fee=$10.13
2025-11-22 23:52:56,884 - INFO -   Updated item 2622 (eBay, ebay): sales=$100.95, eBay fee=$3.23
2025-11-22 23:52:56,884 - INFO -   Updated item 2810 (eBay, ebay): sales=$150.95, eBay fee=$4.68
2025-11-22 23:52:56,884 - INFO -   Updated item 2846 (eBay, ebay): sales=$77.95, eBay fee=$2.56
2025-11-22 23:52:56,895 - INFO - 
eBay Managed Payments Summary:
2025-11-22 23:52:56,895 - INFO -   Items updated: 88
2025-11-22 23:52:56,895 - INFO -   Total eBay payment fees: $401.59
2025-11-22 23:52:56,895 - INFO - 
  Breakdown by Channel:
2025-11-22 23:52:56,895 - INFO -     Amazon: 1 items, $29.95 revenue, $1.17 fees
2025-11-22 23:52:56,895 - INFO -     eBay: 87 items, $12,907.65 revenue, $400.42 fees
2025-11-22 23:52:56,896 - INFO - 
================================================================================
2025-11-22 23:52:56,896 - INFO - OVERALL SUMMARY
2025-11-22 23:52:56,896 - INFO - ================================================================================
2025-11-22 23:52:56,896 - INFO - Bolt:
2025-11-22 23:52:56,897 - INFO -   Items updated: 518
2025-11-22 23:52:56,897 - INFO -   Total fees: $915.03
2025-11-22 23:52:56,897 - INFO - 
Credit Card:
2025-11-22 23:52:56,897 - INFO -   Items updated: 1038
2025-11-22 23:52:56,897 - INFO -   Total fees: $3,386.71
2025-11-22 23:52:56,897 - INFO - 
eBay Managed Payments:
2025-11-22 23:52:56,897 - INFO -   Items updated: 88
2025-11-22 23:52:56,897 - INFO -   Total fees: $401.59
2025-11-22 23:52:56,897 - INFO - 
Grand Total:
2025-11-22 23:52:56,897 - INFO -   Items updated: 1644
2025-11-22 23:52:56,897 - INFO -   Total payment processor fees: $4,703.33
2025-11-22 23:52:56,897 - INFO - ================================================================================

