2025-11-22 03:25:28,446 - INFO - Log file: /home/centralgoparts/public_html/profitability/logs/final_cogs_20251122_032528.log
2025-11-22 03:25:28,446 - INFO - ================================================================================
2025-11-22 03:25:28,446 - INFO - FINAL COGS CALCULATION - 2025-11-22 03:25:28
2025-11-22 03:25:28,446 - INFO - LIVE MODE
2025-11-22 03:25:28,446 - INFO - ================================================================================
2025-11-22 03:25:28,446 - INFO - Date Range: 2025-07-25 to 2025-11-22 (120 days)
2025-11-22 03:25:28,455 - INFO - ================================================================================
2025-11-22 03:25:28,455 - INFO - Processing: FINAL COGS CALCULATION
2025-11-22 03:25:28,455 - INFO -   Formula: our_buy_price + commission_and_fee + payment_processor_fee
2025-11-22 03:25:28,455 - INFO -            - supplier_credits + loss_amount
2025-11-22 03:25:28,455 - INFO -   Note: our_buy_price already includes shipping & handling
2025-11-22 03:25:28,455 - INFO - ================================================================================
2025-11-22 03:25:28,509 - INFO - Found 3849 orders to calculate COGS
2025-11-22 03:25:28,522 - INFO - 
================================================================================
2025-11-22 03:25:28,522 - INFO - COGS CALCULATION SUMMARY BY CHANNEL
2025-11-22 03:25:28,522 - INFO - ================================================================================
2025-11-22 03:25:28,523 - INFO - 
Amazon:
2025-11-22 03:25:28,523 - INFO -   Orders: 661
2025-11-22 03:25:28,523 - INFO -   Revenue: $87,149.84
2025-11-22 03:25:28,523 - INFO -   COGS Breakdown:
2025-11-22 03:25:28,523 - INFO -     Buy Price (incl. shipping): $31,592.54
2025-11-22 03:25:28,523 - INFO -     Commission+Fees: $16,972.58
2025-11-22 03:25:28,523 - INFO -     Payment Processor: $0.00
2025-11-22 03:25:28,523 - INFO -     Credits: -$0.00
2025-11-22 03:25:28,523 - INFO -     Loss: $3,761.73
2025-11-22 03:25:28,523 - INFO -   Total COGS: $52,326.85
2025-11-22 03:25:28,523 - INFO -   Gross Margin: $34,822.99 (39.96%)
2025-11-22 03:25:28,523 - INFO - 
B2B:
2025-11-22 03:25:28,523 - INFO -   Orders: 2963
2025-11-22 03:25:28,523 - INFO -   Revenue: $291,471.52
2025-11-22 03:25:28,523 - INFO -   COGS Breakdown:
2025-11-22 03:25:28,523 - INFO -     Buy Price (incl. shipping): $164,260.86
2025-11-22 03:25:28,523 - INFO -     Commission+Fees: $7,796.47
2025-11-22 03:25:28,523 - INFO -     Payment Processor: $0.47
2025-11-22 03:25:28,523 - INFO -     Credits: -$790.95
2025-11-22 03:25:28,523 - INFO -     Loss: $4,507.30
2025-11-22 03:25:28,523 - INFO -   Total COGS: $175,774.15
2025-11-22 03:25:28,523 - INFO -   Gross Margin: $115,697.37 (39.69%)
2025-11-22 03:25:28,523 - INFO - 
Web:
2025-11-22 03:25:28,523 - INFO -   Orders: 213
2025-11-22 03:25:28,523 - INFO -   Revenue: $24,672.68
2025-11-22 03:25:28,523 - INFO -   COGS Breakdown:
2025-11-22 03:25:28,523 - INFO -     Buy Price (incl. shipping): $9,413.14
2025-11-22 03:25:28,523 - INFO -     Commission+Fees: $2,855.89
2025-11-22 03:25:28,523 - INFO -     Payment Processor: $663.60
2025-11-22 03:25:28,523 - INFO -     Credits: -$103.89
2025-11-22 03:25:28,523 - INFO -     Loss: $1,611.79
2025-11-22 03:25:28,523 - INFO -   Total COGS: $14,440.53
2025-11-22 03:25:28,523 - INFO -   Gross Margin: $10,232.15 (41.47%)
2025-11-22 03:25:28,523 - INFO - 
eBay:
2025-11-22 03:25:28,523 - INFO -   Orders: 12
2025-11-22 03:25:28,523 - INFO -   Revenue: $3,077.40
2025-11-22 03:25:28,523 - INFO -   COGS Breakdown:
2025-11-22 03:25:28,524 - INFO -     Buy Price (incl. shipping): $898.23
2025-11-22 03:25:28,524 - INFO -     Commission+Fees: $683.00
2025-11-22 03:25:28,524 - INFO -     Payment Processor: $92.84
2025-11-22 03:25:28,524 - INFO -     Credits: -$0.00
2025-11-22 03:25:28,524 - INFO -     Loss: $50.17
2025-11-22 03:25:28,524 - INFO -   Total COGS: $1,724.24
2025-11-22 03:25:28,524 - INFO -   Gross Margin: $1,353.16 (43.97%)
2025-11-22 03:25:28,524 - INFO - 
================================================================================
2025-11-22 03:25:28,524 - INFO - OVERALL TOTALS
2025-11-22 03:25:28,524 - INFO - ================================================================================
2025-11-22 03:25:28,524 - INFO - Total Orders: 3849
2025-11-22 03:25:28,524 - INFO - Updated: 0
2025-11-22 03:25:28,524 - INFO - Unchanged: 3849
2025-11-22 03:25:28,524 - INFO - Missing buy price: 564
2025-11-22 03:25:28,524 - INFO - 
Total Revenue: $406,371.44
2025-11-22 03:25:28,524 - INFO - Total COGS: $244,265.76
2025-11-22 03:25:28,524 - INFO - Total Gross Margin: $162,105.68 (39.89%)
2025-11-22 03:25:28,524 - INFO - ================================================================================

2025-11-22 03:25:28,524 - WARNING - ⚠️  564 orders have NULL/zero buy price - COGS may be understated
2025-11-22 03:25:28,527 - INFO - 
================================================================================
2025-11-22 03:25:28,528 - INFO - Script completed successfully
2025-11-22 03:25:28,528 - INFO - ================================================================================