2025-11-22 03:35:59,612 - INFO - Log file: /home/centralgoparts/public_html/profitability/logs/final_cogs_20251122_033559.log
2025-11-22 03:35:59,612 - INFO - ================================================================================
2025-11-22 03:35:59,612 - INFO - FINAL COGS CALCULATION - 2025-11-22 03:35:59
2025-11-22 03:35:59,612 - INFO - LIVE MODE
2025-11-22 03:35:59,612 - INFO - ================================================================================
2025-11-22 03:35:59,612 - INFO - Date Range: 2025-07-25 to 2025-11-22 (120 days)
2025-11-22 03:35:59,621 - INFO - ================================================================================
2025-11-22 03:35:59,621 - INFO - Processing: FINAL COGS CALCULATION
2025-11-22 03:35:59,621 - INFO -   Formula: our_buy_price + commission_and_fee + payment_processor_fee
2025-11-22 03:35:59,621 - INFO -            - supplier_credits + loss_amount
2025-11-22 03:35:59,621 - INFO -   Note: our_buy_price already includes shipping & handling
2025-11-22 03:35:59,621 - INFO - ================================================================================
2025-11-22 03:35:59,724 - INFO - Found 8934 orders to calculate COGS
2025-11-22 03:35:59,748 - INFO - 
================================================================================
2025-11-22 03:35:59,748 - INFO - COGS CALCULATION SUMMARY BY CHANNEL
2025-11-22 03:35:59,748 - INFO - ================================================================================
2025-11-22 03:35:59,748 - INFO - 
Amazon:
2025-11-22 03:35:59,748 - INFO -   Orders: 1680
2025-11-22 03:35:59,748 - INFO -   Revenue: $221,804.92
2025-11-22 03:35:59,748 - INFO -   COGS Breakdown:
2025-11-22 03:35:59,748 - INFO -     Buy Price (incl. shipping): $86,570.74
2025-11-22 03:35:59,748 - INFO -     Commission+Fees: $39,645.86
2025-11-22 03:35:59,748 - INFO -     Payment Processor: $10.45
2025-11-22 03:35:59,748 - INFO -     Credits: -$290.01
2025-11-22 03:35:59,748 - INFO -     Loss: $9,797.17
2025-11-22 03:35:59,748 - INFO -   Total COGS: $135,734.21
2025-11-22 03:35:59,748 - INFO -   Gross Margin: $86,070.71 (38.80%)
2025-11-22 03:35:59,748 - INFO - 
B2B:
2025-11-22 03:35:59,748 - INFO -   Orders: 6695
2025-11-22 03:35:59,748 - INFO -   Revenue: $637,245.88
2025-11-22 03:35:59,748 - INFO -   COGS Breakdown:
2025-11-22 03:35:59,748 - INFO -     Buy Price (incl. shipping): $374,001.20
2025-11-22 03:35:59,748 - INFO -     Commission+Fees: $15,593.64
2025-11-22 03:35:59,749 - INFO -     Payment Processor: $0.47
2025-11-22 03:35:59,749 - INFO -     Credits: -$1,575.00
2025-11-22 03:35:59,749 - INFO -     Loss: $8,827.74
2025-11-22 03:35:59,749 - INFO -   Total COGS: $396,848.05
2025-11-22 03:35:59,749 - INFO -   Gross Margin: $240,397.83 (37.72%)
2025-11-22 03:35:59,749 - INFO - 
Web:
2025-11-22 03:35:59,749 - INFO -   Orders: 507
2025-11-22 03:35:59,749 - INFO -   Revenue: $64,796.50
2025-11-22 03:35:59,749 - INFO -   COGS Breakdown:
2025-11-22 03:35:59,749 - INFO -     Buy Price (incl. shipping): $27,579.40
2025-11-22 03:35:59,749 - INFO -     Commission+Fees: $5,711.73
2025-11-22 03:35:59,749 - INFO -     Payment Processor: $1,742.95
2025-11-22 03:35:59,749 - INFO -     Credits: -$159.74
2025-11-22 03:35:59,749 - INFO -     Loss: $3,786.28
2025-11-22 03:35:59,749 - INFO -   Total COGS: $38,660.62
2025-11-22 03:35:59,749 - INFO -   Gross Margin: $26,135.88 (40.34%)
2025-11-22 03:35:59,749 - INFO - 
eBay:
2025-11-22 03:35:59,749 - INFO -   Orders: 52
2025-11-22 03:35:59,749 - INFO -   Revenue: $8,538.40
2025-11-22 03:35:59,749 - INFO -   COGS Breakdown:
2025-11-22 03:35:59,749 - INFO -     Buy Price (incl. shipping): $2,478.89
2025-11-22 03:35:59,749 - INFO -     Commission+Fees: $1,755.70
2025-11-22 03:35:59,749 - INFO -     Payment Processor: $263.17
2025-11-22 03:35:59,749 - INFO -     Credits: -$0.00
2025-11-22 03:35:59,749 - INFO -     Loss: $212.87
2025-11-22 03:35:59,749 - INFO -   Total COGS: $4,710.63
2025-11-22 03:35:59,749 - INFO -   Gross Margin: $3,827.77 (44.83%)
2025-11-22 03:35:59,749 - INFO - 
================================================================================
2025-11-22 03:35:59,749 - INFO - OVERALL TOTALS
2025-11-22 03:35:59,749 - INFO - ================================================================================
2025-11-22 03:35:59,749 - INFO - Total Orders: 8934
2025-11-22 03:35:59,749 - INFO - Updated: 0
2025-11-22 03:35:59,749 - INFO - Unchanged: 8934
2025-11-22 03:35:59,749 - INFO - Missing buy price: 1074
2025-11-22 03:35:59,749 - INFO - 
Total Revenue: $932,385.70
2025-11-22 03:35:59,749 - INFO - Total COGS: $575,953.52
2025-11-22 03:35:59,749 - INFO - Total Gross Margin: $356,432.18 (38.23%)
2025-11-22 03:35:59,749 - INFO - ================================================================================

2025-11-22 03:35:59,749 - WARNING - ⚠️  1074 orders have NULL/zero buy price - COGS may be understated
2025-11-22 03:35:59,753 - INFO - 
================================================================================
2025-11-22 03:35:59,754 - INFO - Script completed successfully
2025-11-22 03:35:59,754 - INFO - ================================================================================