2025-11-23 04:23:57,086 - INFO - Log file: /home/centralgoparts/public_html/profitability/logs/final_cogs_20251123_042357.log
2025-11-23 04:23:57,086 - INFO - ================================================================================
2025-11-23 04:23:57,086 - INFO - FINAL COGS CALCULATION - 2025-11-23 04:23:57
2025-11-23 04:23:57,087 - INFO - LIVE MODE
2025-11-23 04:23:57,087 - INFO - ================================================================================
2025-11-23 04:23:57,087 - INFO - Date Range: 2025-07-26 to 2025-11-23 (120 days)
2025-11-23 04:23:57,095 - INFO - ================================================================================
2025-11-23 04:23:57,095 - INFO - Processing: FINAL COGS CALCULATION
2025-11-23 04:23:57,095 - INFO -   Formula: our_buy_price + commission_and_fee + payment_processor_fee
2025-11-23 04:23:57,095 - INFO -            - supplier_credits + loss_amount
2025-11-23 04:23:57,095 - INFO -   Note: our_buy_price already includes shipping & handling
2025-11-23 04:23:57,096 - INFO - ================================================================================
2025-11-23 04:23:57,304 - INFO - Found 18308 orders to calculate COGS
2025-11-23 04:23:57,492 - INFO - 
================================================================================
2025-11-23 04:23:57,493 - INFO - COGS CALCULATION SUMMARY BY CHANNEL
2025-11-23 04:23:57,493 - INFO - ================================================================================
2025-11-23 04:23:57,493 - INFO - 
Amazon:
2025-11-23 04:23:57,493 - INFO -   Orders: 3622
2025-11-23 04:23:57,493 - INFO -   Revenue: $480,406.48
2025-11-23 04:23:57,493 - INFO -   COGS Breakdown:
2025-11-23 04:23:57,493 - INFO -     Buy Price (incl. shipping): $206,671.43
2025-11-23 04:23:57,493 - INFO -     Commission+Fees: $76,804.53
2025-11-23 04:23:57,493 - INFO -     Payment Processor: $15.18
2025-11-23 04:23:57,493 - INFO -     Credits: -$517.42
2025-11-23 04:23:57,493 - INFO -     Loss: $19,973.12
2025-11-23 04:23:57,493 - INFO -   Total COGS: $302,946.84
2025-11-23 04:23:57,493 - INFO -   Gross Margin: $177,459.64 (36.94%)
2025-11-23 04:23:57,493 - INFO - 
B2B:
2025-11-23 04:23:57,493 - INFO -   Orders: 13404
2025-11-23 04:23:57,493 - INFO -   Revenue: $1,307,764.90
2025-11-23 04:23:57,493 - INFO -   COGS Breakdown:
2025-11-23 04:23:57,493 - INFO -     Buy Price (incl. shipping): $718,759.84
2025-11-23 04:23:57,493 - INFO -     Commission+Fees: $31,107.32
2025-11-23 04:23:57,493 - INFO -     Payment Processor: $0.47
2025-11-23 04:23:57,493 - INFO -     Credits: -$3,988.86
2025-11-23 04:23:57,493 - INFO -     Loss: $17,555.55
2025-11-23 04:23:57,493 - INFO -   Total COGS: $763,434.32
2025-11-23 04:23:57,493 - INFO -   Gross Margin: $544,330.58 (41.62%)
2025-11-23 04:23:57,493 - INFO - 
Web:
2025-11-23 04:23:57,493 - INFO -   Orders: 1189
2025-11-23 04:23:57,493 - INFO -   Revenue: $142,408.94
2025-11-23 04:23:57,493 - INFO -   COGS Breakdown:
2025-11-23 04:23:57,493 - INFO -     Buy Price (incl. shipping): $68,795.04
2025-11-23 04:23:57,493 - INFO -     Commission+Fees: $10,960.40
2025-11-23 04:23:57,493 - INFO -     Payment Processor: $3,372.11
2025-11-23 04:23:57,493 - INFO -     Credits: -$350.98
2025-11-23 04:23:57,493 - INFO -     Loss: $8,302.07
2025-11-23 04:23:57,493 - INFO -   Total COGS: $91,078.64
2025-11-23 04:23:57,493 - INFO -   Gross Margin: $51,330.30 (36.04%)
2025-11-23 04:23:57,493 - INFO - 
eBay:
2025-11-23 04:23:57,493 - INFO -   Orders: 93
2025-11-23 04:23:57,493 - INFO -   Revenue: $13,658.35
2025-11-23 04:23:57,493 - INFO -   COGS Breakdown:
2025-11-23 04:23:57,493 - INFO -     Buy Price (incl. shipping): $4,852.74
2025-11-23 04:23:57,493 - INFO -     Commission+Fees: $2,828.66
2025-11-23 04:23:57,493 - INFO -     Payment Processor: $400.38
2025-11-23 04:23:57,493 - INFO -     Credits: -$0.00
2025-11-23 04:23:57,493 - INFO -     Loss: $368.90
2025-11-23 04:23:57,493 - INFO -   Total COGS: $8,450.68
2025-11-23 04:23:57,493 - INFO -   Gross Margin: $5,207.67 (38.13%)
2025-11-23 04:23:57,493 - INFO - 
================================================================================
2025-11-23 04:23:57,493 - INFO - OVERALL TOTALS
2025-11-23 04:23:57,493 - INFO - ================================================================================
2025-11-23 04:23:57,493 - INFO - Total Orders: 18308
2025-11-23 04:23:57,493 - INFO - Updated: 884
2025-11-23 04:23:57,493 - INFO - Unchanged: 17424
2025-11-23 04:23:57,494 - INFO - Missing buy price: 2829
2025-11-23 04:23:57,494 - INFO - 
Total Revenue: $1,944,238.67
2025-11-23 04:23:57,494 - INFO - Total COGS: $1,165,910.48
2025-11-23 04:23:57,494 - INFO - Total Gross Margin: $778,328.19 (40.03%)
2025-11-23 04:23:57,494 - INFO - ================================================================================

2025-11-23 04:23:57,494 - WARNING - ⚠️  2829 orders have NULL/zero buy price - COGS may be understated
2025-11-23 04:23:57,504 - INFO - 
================================================================================
2025-11-23 04:23:57,504 - INFO - Script completed successfully
2025-11-23 04:23:57,504 - INFO - ================================================================================