2025-11-24 08:38:35,113 - INFO - Log file: /home/centralgoparts/public_html/profitability/logs/final_cogs_20251124_083835.log
2025-11-24 08:38:35,113 - INFO - ================================================================================
2025-11-24 08:38:35,113 - INFO - FINAL COGS CALCULATION - 2025-11-24 08:38:35
2025-11-24 08:38:35,113 - INFO - LIVE MODE
2025-11-24 08:38:35,113 - INFO - ================================================================================
2025-11-24 08:38:35,113 - INFO - Date Range: 2025-07-27 to 2025-11-24 (120 days)
2025-11-24 08:38:35,122 - INFO - ================================================================================
2025-11-24 08:38:35,122 - INFO - Processing: FINAL COGS CALCULATION
2025-11-24 08:38:35,122 - INFO -   Formula: our_buy_price + commission_and_fee + payment_processor_fee
2025-11-24 08:38:35,122 - INFO -            - supplier_credits
2025-11-24 08:38:35,122 - INFO -   Note: our_buy_price already includes shipping & handling
2025-11-24 08:38:35,122 - INFO - ================================================================================
2025-11-24 08:38:35,373 - INFO - Found 22250 orders to calculate COGS
2025-11-24 08:38:35,796 - INFO -   eBay - Order 03-13856-58490 [Cancelled (Cancelled)]:
2025-11-24 08:38:35,796 - INFO -     Sales: $75.95
2025-11-24 08:38:35,796 - INFO -     Buy Price (incl. shipping): $0.00
2025-11-24 08:38:35,796 - INFO -     Commission+Fees: $15.93
2025-11-24 08:38:35,796 - INFO -     Payment Processor: $0.00
2025-11-24 08:38:35,796 - INFO -     Credits: -$0.00
2025-11-24 08:38:35,796 - INFO -     → COGS: $15.93 (was $15.93)
2025-11-24 08:38:35,796 - INFO -     → Gross Profit: $-15.93 (-20.97%)
2025-11-24 08:38:35,874 - INFO - 
================================================================================
2025-11-24 08:38:35,874 - INFO - COGS CALCULATION SUMMARY BY CHANNEL
2025-11-24 08:38:35,874 - INFO - ================================================================================
2025-11-24 08:38:35,874 - INFO - 
Amazon:
2025-11-24 08:38:35,874 - INFO -   Orders: 4371
2025-11-24 08:38:35,874 - INFO -   Revenue: $576,584.13
2025-11-24 08:38:35,874 - INFO -   COGS Breakdown:
2025-11-24 08:38:35,874 - INFO -     Buy Price (incl. shipping): $256,796.98
2025-11-24 08:38:35,874 - INFO -     Commission+Fees: $92,146.13
2025-11-24 08:38:35,874 - INFO -     Payment Processor: $251.77
2025-11-24 08:38:35,874 - INFO -     Credits: -$2,856.07
2025-11-24 08:38:35,874 - INFO -   Total COGS: $333,887.71
2025-11-24 08:38:35,874 - INFO -   Gross Margin: $242,696.42 (42.09%)
2025-11-24 08:38:35,874 - INFO - 
B2B:
2025-11-24 08:38:35,874 - INFO -   Orders: 16064
2025-11-24 08:38:35,874 - INFO -   Revenue: $1,613,922.71
2025-11-24 08:38:35,874 - INFO -   COGS Breakdown:
2025-11-24 08:38:35,874 - INFO -     Buy Price (incl. shipping): $920,185.38
2025-11-24 08:38:35,874 - INFO -     Commission+Fees: $30,467.57
2025-11-24 08:38:35,874 - INFO -     Payment Processor: $0.47
2025-11-24 08:38:35,874 - INFO -     Credits: -$30,040.61
2025-11-24 08:38:35,874 - INFO -   Total COGS: $810,520.44
2025-11-24 08:38:35,874 - INFO -   Gross Margin: $803,402.27 (49.78%)
2025-11-24 08:38:35,874 - INFO - 
Web:
2025-11-24 08:38:35,874 - INFO -   Orders: 1699
2025-11-24 08:38:35,874 - INFO -   Revenue: $209,433.25
2025-11-24 08:38:35,874 - INFO -   COGS Breakdown:
2025-11-24 08:38:35,874 - INFO -     Buy Price (incl. shipping): $86,883.46
2025-11-24 08:38:35,874 - INFO -     Commission+Fees: $11,134.49
2025-11-24 08:38:35,874 - INFO -     Payment Processor: $3,843.86
2025-11-24 08:38:35,875 - INFO -     Credits: -$1,076.95
2025-11-24 08:38:35,875 - INFO -   Total COGS: $95,853.66
2025-11-24 08:38:35,875 - INFO -   Gross Margin: $113,579.59 (54.23%)
2025-11-24 08:38:35,875 - INFO - 
eBay:
2025-11-24 08:38:35,875 - INFO -   Orders: 116
2025-11-24 08:38:35,875 - INFO -   Revenue: $16,994.20
2025-11-24 08:38:35,875 - INFO -   COGS Breakdown:
2025-11-24 08:38:35,875 - INFO -     Buy Price (incl. shipping): $6,370.62
2025-11-24 08:38:35,875 - INFO -     Commission+Fees: $3,390.26
2025-11-24 08:38:35,875 - INFO -     Payment Processor: $428.08
2025-11-24 08:38:35,875 - INFO -     Credits: -$248.90
2025-11-24 08:38:35,875 - INFO -   Total COGS: $9,443.49
2025-11-24 08:38:35,875 - INFO -   Gross Margin: $7,550.71 (44.43%)
2025-11-24 08:38:35,875 - INFO - 
================================================================================
2025-11-24 08:38:35,875 - INFO - OVERALL TOTALS
2025-11-24 08:38:35,875 - INFO - ================================================================================
2025-11-24 08:38:35,875 - INFO - Total Orders: 22250
2025-11-24 08:38:35,875 - INFO - Updated: 3863
2025-11-24 08:38:35,875 - INFO - Unchanged: 18387
2025-11-24 08:38:35,875 - INFO - Missing buy price: 2775
2025-11-24 08:38:35,875 - INFO - 
Total Revenue: $2,416,934.29
2025-11-24 08:38:35,875 - INFO - Total COGS: $1,249,705.30
2025-11-24 08:38:35,875 - INFO - Total Gross Margin: $1,167,228.99 (48.29%)
2025-11-24 08:38:35,875 - INFO - ================================================================================

2025-11-24 08:38:35,875 - WARNING - ⚠️  2775 orders have NULL/zero buy price - COGS may be understated
2025-11-24 08:38:35,889 - INFO - 
================================================================================
2025-11-24 08:38:35,889 - INFO - Script completed successfully
2025-11-24 08:38:35,889 - INFO - ================================================================================