2025-11-22 23:16:19,106 - INFO - Log file: /home/centralgoparts/public_html/profitability/logs/payment_fees_20251122_231619.log
2025-11-22 23:16:19,106 - INFO - ================================================================================
2025-11-22 23:16:19,106 - INFO - PAYMENT PROCESSOR FEE UPDATE - 2025-11-22 23:16:19
2025-11-22 23:16:19,106 - INFO - LIVE MODE
2025-11-22 23:16:19,106 - INFO - ================================================================================
2025-11-22 23:16:19,106 - INFO - Date Range: 2025-07-25 to 2025-11-22 (120 days)
2025-11-22 23:16:19,115 - INFO - ================================================================================
2025-11-22 23:16:19,115 - INFO - Processing: BOLT PAYMENT PROCESSOR
2025-11-22 23:16:19,115 - INFO -   Source: payment_processor_charges-Bolt table
2025-11-22 23:16:19,115 - INFO - ================================================================================
2025-11-22 23:16:19,132 - INFO - Found 0 Bolt items to update
2025-11-22 23:16:19,139 - INFO - 
================================================================================
2025-11-22 23:16:19,139 - INFO - Processing: CREDIT CARD PAYMENT PROCESSOR
2025-11-22 23:16:19,139 - INFO -   Fee Rate: 2.69% of sales price
2025-11-22 23:16:19,139 - INFO - ================================================================================
2025-11-22 23:16:19,156 - INFO - Found 296 credit card items to update
2025-11-22 23:16:19,156 - INFO -   Updated item 9 (Web, BoltPay): sales=$79.94, cc_fee=$2.15
2025-11-22 23:16:19,156 - INFO -   Updated item 10 (Web, BoltPay): sales=$79.94, cc_fee=$2.15
2025-11-22 23:16:19,157 - INFO -   Updated item 11 (Web, BoltPay): sales=$103.94, cc_fee=$2.80
2025-11-22 23:16:19,157 - INFO -   Updated item 12 (Web, BoltPay): sales=$131.94, cc_fee=$3.55
2025-11-22 23:16:19,157 - INFO -   Updated item 36 (Web, BoltPay): sales=$59.94, cc_fee=$1.61
2025-11-22 23:16:19,157 - INFO -   Updated item 59 (Web, BoltPay): sales=$125.94, cc_fee=$3.39
2025-11-22 23:16:19,157 - INFO -   Updated item 126 (Web, BoltPay): sales=$347.94, cc_fee=$9.36
2025-11-22 23:16:19,157 - INFO -   Updated item 168 (Web, BoltPay): sales=$27.94, cc_fee=$0.75
2025-11-22 23:16:19,158 - INFO -   Updated item 181 (Web, BoltPay): sales=$65.44, cc_fee=$1.76
2025-11-22 23:16:19,158 - INFO -   Updated item 182 (Web, BoltPay): sales=$214.44, cc_fee=$5.77
2025-11-22 23:16:19,198 - INFO - 
Credit Card Summary:
2025-11-22 23:16:19,198 - INFO -   Items updated: 296
2025-11-22 23:16:19,198 - INFO -   Total CC fees: $1,088.61
2025-11-22 23:16:19,198 - INFO - 
  Breakdown by Channel:
2025-11-22 23:16:19,198 - INFO -     Amazon: 2 items, $344.89 revenue, $9.28 fees
2025-11-22 23:16:19,198 - INFO -     Web: 294 items, $40,123.82 revenue, $1,079.33 fees
2025-11-22 23:16:19,207 - INFO - 
================================================================================
2025-11-22 23:16:19,207 - INFO - Processing: EBAY MANAGED PAYMENTS PROCESSOR
2025-11-22 23:16:19,208 - INFO -   Fee Rate: 2.90% + $0.30 per transaction
2025-11-22 23:16:19,208 - INFO - ================================================================================
2025-11-22 23:16:19,218 - INFO - Found 41 eBay payment items to update
2025-11-22 23:16:19,219 - INFO -   Updated item 413 (eBay, ebay): sales=$107.95, eBay fee=$3.43
2025-11-22 23:16:19,219 - INFO -   Updated item 468 (eBay, ebay): sales=$117.95, eBay fee=$3.72
2025-11-22 23:16:19,219 - INFO -   Updated item 1247 (eBay, ebay): sales=$44.95, eBay fee=$1.60
2025-11-22 23:16:19,219 - INFO -   Updated item 1301 (eBay, ebay): sales=$35.95, eBay fee=$1.34
2025-11-22 23:16:19,219 - INFO -   Updated item 1966 (eBay, ebay): sales=$66.95, eBay fee=$2.24
2025-11-22 23:16:19,220 - INFO -   Updated item 2055 (eBay, ebay): sales=$75.95, eBay fee=$2.50
2025-11-22 23:16:19,220 - INFO -   Updated item 2391 (eBay, ebay): sales=$56.95, eBay fee=$1.95
2025-11-22 23:16:19,220 - INFO -   Updated item 2433 (eBay, ebay): sales=$229.95, eBay fee=$6.97
2025-11-22 23:16:19,220 - INFO -   Updated item 2542 (eBay, ebay): sales=$46.95, eBay fee=$1.66
2025-11-22 23:16:19,220 - INFO -   Updated item 2600 (eBay, ebay): sales=$29.95, eBay fee=$1.17
2025-11-22 23:16:19,225 - INFO - 
eBay Managed Payments Summary:
2025-11-22 23:16:19,225 - INFO -   Items updated: 41
2025-11-22 23:16:19,225 - INFO -   Total eBay payment fees: $171.54
2025-11-22 23:16:19,225 - INFO - 
  Breakdown by Channel:
2025-11-22 23:16:19,225 - INFO -     Amazon: 1 items, $29.95 revenue, $1.17 fees
2025-11-22 23:16:19,225 - INFO -     eBay: 40 items, $5,461.00 revenue, $170.37 fees
2025-11-22 23:16:19,226 - INFO - 
================================================================================
2025-11-22 23:16:19,226 - INFO - OVERALL SUMMARY
2025-11-22 23:16:19,226 - INFO - ================================================================================
2025-11-22 23:16:19,226 - INFO - Bolt:
2025-11-22 23:16:19,226 - INFO -   Items updated: 0
2025-11-22 23:16:19,226 - INFO -   Total fees: $0.00
2025-11-22 23:16:19,226 - INFO - 
Credit Card:
2025-11-22 23:16:19,226 - INFO -   Items updated: 296
2025-11-22 23:16:19,226 - INFO -   Total fees: $1,088.61
2025-11-22 23:16:19,226 - INFO - 
eBay Managed Payments:
2025-11-22 23:16:19,226 - INFO -   Items updated: 41
2025-11-22 23:16:19,226 - INFO -   Total fees: $171.54
2025-11-22 23:16:19,226 - INFO - 
Grand Total:
2025-11-22 23:16:19,226 - INFO -   Items updated: 337
2025-11-22 23:16:19,226 - INFO -   Total payment processor fees: $1,260.15
2025-11-22 23:16:19,226 - INFO - ================================================================================

