2025-11-24 06:35:07,490 - INFO - Log file: /home/centralgoparts/public_html/profitability/logs/commission_fees_20251124_063507.log
2025-11-24 06:35:07,491 - INFO - ================================================================================
2025-11-24 06:35:07,491 - INFO - COMMISSION AND FEE UPDATE - 2025-11-24 06:35:07
2025-11-24 06:35:07,491 - INFO - LIVE MODE
2025-11-24 06:35:07,491 - INFO - ================================================================================
2025-11-24 06:35:07,491 - INFO - Date Range: 2025-07-27 to 2025-11-24 (120 days)
2025-11-24 06:35:07,491 - INFO - 
2025-11-24 06:35:07,514 - INFO - Found 4 unique months to process:
2025-11-24 06:35:07,514 - INFO -   - 2025-08
2025-11-24 06:35:07,514 - INFO -   - 2025-09
2025-11-24 06:35:07,514 - INFO -   - 2025-10
2025-11-24 06:35:07,514 - INFO -   - 2025-11
2025-11-24 06:35:07,514 - INFO - 
2025-11-24 06:35:07,514 - INFO - ================================================================================
2025-11-24 06:35:07,514 - INFO - PROCESSING MONTH: 2025-08
2025-11-24 06:35:07,514 - INFO - ================================================================================
2025-11-24 06:35:07,515 - INFO -   Loaded config from: /home/centralgoparts/public_html/profitability/.env.08
2025-11-24 06:35:07,539 - INFO - 
  Processing Web - 2025-08
2025-11-24 06:35:07,539 - INFO -   Config source: /home/centralgoparts/public_html/profitability/.env.08
2025-11-24 06:35:07,539 - INFO -   Fee data source: Actual
2025-11-24 06:35:07,551 - INFO -   Orders: 385, Revenue: $43,793.13
2025-11-24 06:35:07,551 - INFO -   Commission: 0% (merchant fees in payment processor)
2025-11-24 06:35:07,551 - INFO -   Ad Spend: $2,569.53 (5.8674%)
2025-11-24 06:35:07,605 - INFO -   Updated 385 orders, Total fees: $2,569.53
2025-11-24 06:35:07,612 - INFO - 
  Processing B2B - 2025-08
2025-11-24 06:35:07,612 - INFO -   Config source: /home/centralgoparts/public_html/profitability/.env.08
2025-11-24 06:35:07,612 - INFO -   Fee data source: Actual
2025-11-24 06:35:07,631 - INFO -   Orders: 3382, Revenue: $336,706.09
2025-11-24 06:35:07,631 - INFO -   Total Fees: $8,584.83, Rate: 2.5497%
2025-11-24 06:35:08,138 - INFO -   Updated 3382 orders, Total fees: $8,584.83
2025-11-24 06:35:08,145 - INFO - 
  Processing Amazon - 2025-08
2025-11-24 06:35:08,145 - INFO -   Config source: /home/centralgoparts/public_html/profitability/.env.08
2025-11-24 06:35:08,145 - INFO -   Fee data source: Actual
2025-11-24 06:35:08,157 - INFO -   Orders: 967, Revenue: $128,190.68
2025-11-24 06:35:08,157 - INFO -   Commission: 12.0% + Ad Spend: $5,154.95 (4.0213%)
2025-11-24 06:35:08,293 - INFO -   Updated 967 orders, Total fees: $20,537.83
2025-11-24 06:35:08,300 - INFO - 
  Processing eBay - 2025-08
2025-11-24 06:35:08,300 - INFO -   Config source: /home/centralgoparts/public_html/profitability/.env.08
2025-11-24 06:35:08,300 - INFO -   Fee data source: Actual
2025-11-24 06:35:08,310 - INFO -   Orders: 16, Revenue: $2,046.20
2025-11-24 06:35:08,310 - INFO -   Commission: 16.35% + Ad Spend: $0.00 (0.0000%)
2025-11-24 06:35:08,313 - INFO -   Updated 16 orders, Total fees: $334.55
2025-11-24 06:35:08,314 - INFO - 
  Month Summary:
2025-11-24 06:35:08,314 - INFO -     Orders: 4750
2025-11-24 06:35:08,314 - INFO -     Revenue: $510,736.10
2025-11-24 06:35:08,314 - INFO -     Total Fees: $32,026.75
2025-11-24 06:35:08,314 - INFO - ================================================================================
2025-11-24 06:35:08,314 - INFO - PROCESSING MONTH: 2025-09
2025-11-24 06:35:08,314 - INFO - ================================================================================
2025-11-24 06:35:08,315 - INFO -   Loaded config from: /home/centralgoparts/public_html/profitability/.env.09
2025-11-24 06:35:08,349 - INFO - 
  Processing Web - 2025-09
2025-11-24 06:35:08,349 - INFO -   Config source: /home/centralgoparts/public_html/profitability/.env.09
2025-11-24 06:35:08,349 - INFO -   Fee data source: Actual
2025-11-24 06:35:08,360 - INFO -   Orders: 294, Revenue: $33,564.46
2025-11-24 06:35:08,360 - INFO -   Commission: 0% (merchant fees in payment processor)
2025-11-24 06:35:08,360 - INFO -   Ad Spend: $2,855.85 (8.5086%)
2025-11-24 06:35:08,399 - INFO -   Updated 294 orders, Total fees: $2,855.85
2025-11-24 06:35:08,408 - INFO - 
  Processing B2B - 2025-09
2025-11-24 06:35:08,408 - INFO -   Config source: /home/centralgoparts/public_html/profitability/.env.09
2025-11-24 06:35:08,408 - INFO -   Fee data source: Actual
2025-11-24 06:35:08,423 - INFO -   Orders: 3363, Revenue: $337,377.57
2025-11-24 06:35:08,423 - INFO -   Total Fees: $7,796.79, Rate: 2.3110%
2025-11-24 06:35:08,723 - INFO -   Updated 3363 orders, Total fees: $7,796.79
2025-11-24 06:35:08,730 - INFO - 
  Processing Amazon - 2025-09
2025-11-24 06:35:08,731 - INFO -   Config source: /home/centralgoparts/public_html/profitability/.env.09
2025-11-24 06:35:08,731 - INFO -   Fee data source: Actual
2025-11-24 06:35:08,742 - INFO -   Orders: 921, Revenue: $125,336.82
2025-11-24 06:35:08,742 - INFO -   Commission: 12.0% + Ad Spend: $6,514.65 (5.1977%)
2025-11-24 06:35:08,820 - INFO -   Updated 921 orders, Total fees: $21,555.07
2025-11-24 06:35:08,827 - INFO - 
  Processing eBay - 2025-09
2025-11-24 06:35:08,827 - INFO -   Config source: /home/centralgoparts/public_html/profitability/.env.09
2025-11-24 06:35:08,827 - INFO -   Fee data source: Actual
2025-11-24 06:35:08,837 - INFO -   Orders: 25, Revenue: $3,073.75
2025-11-24 06:35:08,837 - INFO -   Commission: 16.35% + Ad Spend: $179.83 (5.8505%)
2025-11-24 06:35:08,840 - INFO -   Updated 25 orders, Total fees: $682.39
2025-11-24 06:35:08,840 - INFO - 
  Month Summary:
2025-11-24 06:35:08,841 - INFO -     Orders: 4603
2025-11-24 06:35:08,841 - INFO -     Revenue: $499,352.60
2025-11-24 06:35:08,841 - INFO -     Total Fees: $32,890.10
2025-11-24 06:35:08,841 - INFO - ================================================================================
2025-11-24 06:35:08,841 - INFO - PROCESSING MONTH: 2025-10
2025-11-24 06:35:08,841 - INFO - ================================================================================
2025-11-24 06:35:08,857 - INFO -   No .env.10 file found
2025-11-24 06:35:08,857 - INFO -   Estimating fees from previous month (2025-09)
2025-11-24 06:35:08,857 - INFO -   Current month revenue: Web=$40,123.82, B2B=$345,774.36, Amazon=$134,655.08, eBay=$5,461.00
2025-11-24 06:35:08,862 - INFO - 
  Processing Web - 2025-10
2025-11-24 06:35:08,862 - INFO -   Config source: Estimated from 2025-09
2025-11-24 06:35:08,862 - INFO -   Fee data source: Estimated
2025-11-24 06:35:08,873 - INFO -   Orders: 294, Revenue: $40,123.82
2025-11-24 06:35:08,873 - INFO -   Commission: 0% (merchant fees in payment processor)
2025-11-24 06:35:08,873 - INFO -   Ad Spend: $3,413.96 (8.5086%)
2025-11-24 06:35:08,900 - INFO -   Updated 294 orders, Total fees: $3,413.96
2025-11-24 06:35:08,906 - INFO - 
  Processing B2B - 2025-10
2025-11-24 06:35:08,906 - INFO -   Config source: Estimated from 2025-09
2025-11-24 06:35:08,906 - INFO -   Fee data source: Estimated
2025-11-24 06:35:08,919 - INFO -   Orders: 3732, Revenue: $345,774.36
2025-11-24 06:35:08,920 - INFO -   Total Fees: $7,990.84, Rate: 2.3110%
2025-11-24 06:35:09,245 - INFO -   Updated 3732 orders, Total fees: $7,990.84
2025-11-24 06:35:09,253 - INFO - 
  Processing Amazon - 2025-10
2025-11-24 06:35:09,253 - INFO -   Config source: Estimated from 2025-09
2025-11-24 06:35:09,253 - INFO -   Fee data source: Estimated
2025-11-24 06:35:09,265 - INFO -   Orders: 1018, Revenue: $134,655.08
2025-11-24 06:35:09,265 - INFO -   Commission: 12.0% + Ad Spend: $6,998.99 (5.1977%)
2025-11-24 06:35:09,373 - INFO -   Updated 1018 orders, Total fees: $23,157.60
2025-11-24 06:35:09,381 - INFO - 
  Processing eBay - 2025-10
2025-11-24 06:35:09,381 - INFO -   Config source: Estimated from 2025-09
2025-11-24 06:35:09,381 - INFO -   Fee data source: Estimated
2025-11-24 06:35:09,392 - INFO -   Orders: 40, Revenue: $5,461.00
2025-11-24 06:35:09,392 - INFO -   Commission: 16.35% + Ad Spend: $319.50 (5.8505%)
2025-11-24 06:35:09,398 - INFO -   Updated 40 orders, Total fees: $1,212.37
2025-11-24 06:35:09,399 - INFO - 
  Month Summary:
2025-11-24 06:35:09,399 - INFO -     Orders: 5084
2025-11-24 06:35:09,399 - INFO -     Revenue: $526,014.26
2025-11-24 06:35:09,399 - INFO -     Total Fees: $35,774.76
2025-11-24 06:35:09,399 - INFO - ================================================================================
2025-11-24 06:35:09,399 - INFO - PROCESSING MONTH: 2025-11
2025-11-24 06:35:09,399 - INFO - ================================================================================
2025-11-24 06:35:09,416 - INFO -   No .env.11 file found
2025-11-24 06:35:09,416 - INFO -   Estimating fees from previous month (estimated)
2025-11-24 06:35:09,416 - INFO -   Current month revenue: Web=$25,419.28, B2B=$291,471.52, Amazon=$95,438.06, eBay=$2,870.40
2025-11-24 06:35:09,423 - INFO - 
  Processing Web - 2025-11
2025-11-24 06:35:09,423 - INFO -   Config source: Estimated from estimated
2025-11-24 06:35:09,423 - INFO -   Fee data source: Estimated
2025-11-24 06:35:09,434 - INFO -   Orders: 221, Revenue: $25,419.28
2025-11-24 06:35:09,434 - INFO -   Commission: 0% (merchant fees in payment processor)
2025-11-24 06:35:09,434 - INFO -   Ad Spend: $2,162.81 (8.5086%)
2025-11-24 06:35:09,456 - INFO -   Updated 221 orders, Total fees: $2,162.81
2025-11-24 06:35:09,464 - INFO - 
  Processing B2B - 2025-11
2025-11-24 06:35:09,464 - INFO -   Config source: Estimated from estimated
2025-11-24 06:35:09,464 - INFO -   Fee data source: Estimated
2025-11-24 06:35:09,478 - INFO -   Orders: 2963, Revenue: $291,471.52
2025-11-24 06:35:09,478 - INFO -   Total Fees: $6,735.90, Rate: 2.3110%
2025-11-24 06:35:09,755 - INFO -   Updated 2963 orders, Total fees: $6,735.90
2025-11-24 06:35:09,762 - INFO - 
  Processing Amazon - 2025-11
2025-11-24 06:35:09,762 - INFO -   Config source: Estimated from estimated
2025-11-24 06:35:09,762 - INFO -   Fee data source: Estimated
2025-11-24 06:35:09,775 - INFO -   Orders: 730, Revenue: $95,438.06
2025-11-24 06:35:09,775 - INFO -   Commission: 12.0% + Ad Spend: $4,960.60 (5.1977%)
2025-11-24 06:35:09,852 - INFO -   Updated 730 orders, Total fees: $16,413.17
2025-11-24 06:35:09,859 - INFO - 
  Processing eBay - 2025-11
2025-11-24 06:35:09,859 - INFO -   Config source: Estimated from estimated
2025-11-24 06:35:09,859 - INFO -   Fee data source: Estimated
2025-11-24 06:35:09,869 - INFO -   Orders: 12, Revenue: $2,870.40
2025-11-24 06:35:09,869 - INFO -   Commission: 16.35% + Ad Spend: $167.93 (5.8505%)
2025-11-24 06:35:09,871 - INFO -   Updated 12 orders, Total fees: $637.24
2025-11-24 06:35:09,872 - INFO - 
  Month Summary:
2025-11-24 06:35:09,872 - INFO -     Orders: 3926
2025-11-24 06:35:09,872 - INFO -     Revenue: $415,199.26
2025-11-24 06:35:09,872 - INFO -     Total Fees: $25,949.12
2025-11-24 06:35:09,872 - INFO - 
================================================================================
2025-11-24 06:35:09,872 - INFO - GRAND TOTAL SUMMARY
2025-11-24 06:35:09,872 - INFO - ================================================================================
2025-11-24 06:35:09,872 - INFO - Total Orders Updated: 18363
2025-11-24 06:35:09,872 - INFO - Total Revenue: $1,951,302.22
2025-11-24 06:35:09,872 - INFO - Total Fees Applied: $126,640.73
2025-11-24 06:35:09,872 - INFO - ================================================================================

