2025-11-25 07:01:37,903 - INFO - Log file: /home/centralgoparts/public_html/profitability/logs/final_cogs_20251125_070137.log
2025-11-25 07:01:37,903 - INFO - ================================================================================
2025-11-25 07:01:37,903 - INFO - FINAL COGS CALCULATION - 2025-11-25 07:01:37
2025-11-25 07:01:37,903 - INFO - LIVE MODE
2025-11-25 07:01:37,903 - INFO - ================================================================================
2025-11-25 07:01:37,903 - INFO - Date Range: 2025-07-28 to 2025-11-25 (120 days)
2025-11-25 07:01:37,913 - INFO - ================================================================================
2025-11-25 07:01:37,913 - INFO - Processing: FINAL COGS CALCULATION (matches frontend formula)
2025-11-25 07:01:37,913 - INFO -   Formula: our_buy_price + (sales_price * commission%)
2025-11-25 07:01:37,913 - INFO -            + ad_fees + payment_processor_fee + repayment_fees
2025-11-25 07:01:37,913 - INFO -            + additional_cost + amazon_additional + label_cost
2025-11-25 07:01:37,913 - INFO -            - supplier_credits - carrier_credits
2025-11-25 07:01:37,913 - INFO -   Note: our_buy_price already includes shipping & handling
2025-11-25 07:01:37,913 - INFO - ================================================================================
2025-11-25 07:01:38,297 - INFO - Found 22250 orders to calculate COGS
2025-11-25 07:01:38,689 - INFO -   eBay - Order 03-13856-58490 [Cancelled (Cancelled)]:
2025-11-25 07:01:38,690 - INFO -     Sales: $75.95
2025-11-25 07:01:38,690 - INFO -     Buy Price (incl. shipping): $0.00
2025-11-25 07:01:38,690 - INFO -     Commission (16.35%): $12.42
2025-11-25 07:01:38,690 - INFO -     Ad Fees: $3.51
2025-11-25 07:01:38,690 - INFO -     Payment Processor: $0.00
2025-11-25 07:01:38,690 - INFO -     Repayment Fees: $0.00
2025-11-25 07:01:38,690 - INFO -     Additional Costs: +$0.00
2025-11-25 07:01:38,690 - INFO -     Label Costs: +$0.00
2025-11-25 07:01:38,690 - INFO -     Supplier Credits: -$0.00
2025-11-25 07:01:38,690 - INFO -     Carrier Credits: -$0.00
2025-11-25 07:01:38,690 - INFO -     → COGS: $15.93 (was $15.93)
2025-11-25 07:01:38,690 - INFO -     → Gross Profit: $-15.93 (-20.97%)
2025-11-25 07:01:38,744 - INFO - 
================================================================================
2025-11-25 07:01:38,745 - INFO - COGS CALCULATION SUMMARY BY CHANNEL
2025-11-25 07:01:38,745 - INFO - ================================================================================
2025-11-25 07:01:38,745 - INFO - 
Amazon:
2025-11-25 07:01:38,745 - INFO -   Orders: 4371
2025-11-25 07:01:38,745 - INFO -   Revenue: $576,584.13
2025-11-25 07:01:38,745 - INFO -   COGS Breakdown:
2025-11-25 07:01:38,745 - INFO -     Buy Price (incl. shipping): $258,383.03
2025-11-25 07:01:38,745 - INFO -     Commission: $69,190.10
2025-11-25 07:01:38,745 - INFO -     Ad Fees: $23,058.52
2025-11-25 07:01:38,745 - INFO -     Payment Processor: $251.77
2025-11-25 07:01:38,745 - INFO -     Repayment Fees: $0.00
2025-11-25 07:01:38,745 - INFO -     Additional Costs: +$260.06
2025-11-25 07:01:38,745 - INFO -     Label Costs: +$-109.10
2025-11-25 07:01:38,745 - INFO -     Supplier Credits: -$2,816.48
2025-11-25 07:01:38,745 - INFO -     Carrier Credits: -$0.00
2025-11-25 07:01:38,745 - INFO -   Total COGS: $332,632.27
2025-11-25 07:01:38,745 - INFO -   Gross Margin: $243,951.86 (42.31%)
2025-11-25 07:01:38,745 - INFO - 
B2B:
2025-11-25 07:01:38,745 - INFO -   Orders: 16064
2025-11-25 07:01:38,745 - INFO -   Revenue: $1,613,922.71
2025-11-25 07:01:38,745 - INFO -   COGS Breakdown:
2025-11-25 07:01:38,745 - INFO -     Buy Price (incl. shipping): $930,265.54
2025-11-25 07:01:38,745 - INFO -     Commission: $30,461.10
2025-11-25 07:01:38,745 - INFO -     Ad Fees: $0.00
2025-11-25 07:01:38,745 - INFO -     Payment Processor: $0.47
2025-11-25 07:01:38,745 - INFO -     Repayment Fees: $0.00
2025-11-25 07:01:38,745 - INFO -     Additional Costs: +$4,321.08
2025-11-25 07:01:38,745 - INFO -     Label Costs: +$8,631.65
2025-11-25 07:01:38,745 - INFO -     Supplier Credits: -$28,580.25
2025-11-25 07:01:38,745 - INFO -     Carrier Credits: -$45.19
2025-11-25 07:01:38,745 - INFO -   Total COGS: $828,578.59
2025-11-25 07:01:38,745 - INFO -   Gross Margin: $785,344.12 (48.66%)
2025-11-25 07:01:38,745 - INFO - 
Web:
2025-11-25 07:01:38,745 - INFO -   Orders: 1699
2025-11-25 07:01:38,745 - INFO -   Revenue: $209,433.25
2025-11-25 07:01:38,745 - INFO -   COGS Breakdown:
2025-11-25 07:01:38,745 - INFO -     Buy Price (incl. shipping): $90,348.89
2025-11-25 07:01:38,745 - INFO -     Commission: $0.00
2025-11-25 07:01:38,745 - INFO -     Ad Fees: $11,134.49
2025-11-25 07:01:38,745 - INFO -     Payment Processor: $3,843.86
2025-11-25 07:01:38,745 - INFO -     Repayment Fees: $0.00
2025-11-25 07:01:38,745 - INFO -     Additional Costs: +$55.85
2025-11-25 07:01:38,745 - INFO -     Label Costs: +$54.81
2025-11-25 07:01:38,745 - INFO -     Supplier Credits: -$923.41
2025-11-25 07:01:38,745 - INFO -     Carrier Credits: -$0.00
2025-11-25 07:01:38,745 - INFO -   Total COGS: $95,984.16
2025-11-25 07:01:38,745 - INFO -   Gross Margin: $113,449.09 (54.17%)
2025-11-25 07:01:38,745 - INFO - 
eBay:
2025-11-25 07:01:38,746 - INFO -   Orders: 116
2025-11-25 07:01:38,746 - INFO -   Revenue: $16,994.20
2025-11-25 07:01:38,746 - INFO -   COGS Breakdown:
2025-11-25 07:01:38,746 - INFO -     Buy Price (incl. shipping): $6,426.73
2025-11-25 07:01:38,746 - INFO -     Commission: $2,778.55
2025-11-25 07:01:38,746 - INFO -     Ad Fees: $611.73
2025-11-25 07:01:38,746 - INFO -     Payment Processor: $428.08
2025-11-25 07:01:38,746 - INFO -     Repayment Fees: $0.00
2025-11-25 07:01:38,746 - INFO -     Additional Costs: +$0.00
2025-11-25 07:01:38,746 - INFO -     Label Costs: +$0.00
2025-11-25 07:01:38,746 - INFO -     Supplier Credits: -$248.90
2025-11-25 07:01:38,746 - INFO -     Carrier Credits: -$0.00
2025-11-25 07:01:38,746 - INFO -   Total COGS: $9,472.22
2025-11-25 07:01:38,746 - INFO -   Gross Margin: $7,521.98 (44.26%)
2025-11-25 07:01:38,746 - INFO - 
================================================================================
2025-11-25 07:01:38,746 - INFO - OVERALL TOTALS
2025-11-25 07:01:38,746 - INFO - ================================================================================
2025-11-25 07:01:38,746 - INFO - Total Orders: 22250
2025-11-25 07:01:38,746 - INFO - Updated: 3432
2025-11-25 07:01:38,746 - INFO - Unchanged: 18818
2025-11-25 07:01:38,746 - INFO - Missing buy price: 2430
2025-11-25 07:01:38,746 - INFO - 
Total Revenue: $2,416,934.29
2025-11-25 07:01:38,746 - INFO - Total COGS: $1,266,667.24
2025-11-25 07:01:38,746 - INFO - Total Gross Margin: $1,150,267.05 (47.59%)
2025-11-25 07:01:38,746 - INFO - ================================================================================

2025-11-25 07:01:38,746 - WARNING - ⚠️  2430 orders have NULL/zero buy price - COGS may be understated
2025-11-25 07:01:38,766 - INFO - 
================================================================================
2025-11-25 07:01:38,767 - INFO - Script completed successfully
2025-11-25 07:01:38,767 - INFO - ================================================================================