2025-11-25 05:58:18,039 - INFO - Log file: /home/centralgoparts/public_html/profitability/logs/final_cogs_20251125_055818.log
2025-11-25 05:58:18,039 - INFO - ================================================================================
2025-11-25 05:58:18,039 - INFO - FINAL COGS CALCULATION - 2025-11-25 05:58:18
2025-11-25 05:58:18,039 - INFO - LIVE MODE
2025-11-25 05:58:18,039 - INFO - ================================================================================
2025-11-25 05:58:18,039 - INFO - Date Range: 2025-07-28 to 2025-11-25 (120 days)
2025-11-25 05:58:18,047 - INFO - ================================================================================
2025-11-25 05:58:18,047 - INFO - Processing: FINAL COGS CALCULATION (matches frontend formula)
2025-11-25 05:58:18,047 - INFO -   Formula: our_buy_price + (sales_price * commission%)
2025-11-25 05:58:18,047 - INFO -            + ad_fees + payment_processor_fee + repayment_fees
2025-11-25 05:58:18,047 - INFO -            + additional_cost + amazon_additional + label_cost
2025-11-25 05:58:18,047 - INFO -            - supplier_credits - carrier_credits
2025-11-25 05:58:18,047 - INFO -   Note: our_buy_price already includes shipping & handling
2025-11-25 05:58:18,047 - INFO - ================================================================================
2025-11-25 05:58:18,376 - INFO - Found 22250 orders to calculate COGS
2025-11-25 05:58:18,377 - INFO -   Amazon - Order 112-7580077-9273032 [Normal]:
2025-11-25 05:58:18,377 - INFO -     Sales: $74.95
2025-11-25 05:58:18,377 - INFO -     Buy Price (incl. shipping): $0.00
2025-11-25 05:58:18,377 - INFO -     Commission (12.0%): $8.99
2025-11-25 05:58:18,377 - INFO -     Ad Fees: $3.14
2025-11-25 05:58:18,377 - INFO -     Payment Processor: $0.00
2025-11-25 05:58:18,377 - INFO -     Repayment Fees: $0.00
2025-11-25 05:58:18,377 - INFO -     Additional Costs: +$0.00
2025-11-25 05:58:18,377 - INFO -     Label Costs: +$0.00
2025-11-25 05:58:18,377 - INFO -     Supplier Credits: -$0.00
2025-11-25 05:58:18,377 - INFO -     Carrier Credits: -$0.00
2025-11-25 05:58:18,377 - INFO -     → COGS: $12.13 (was $12.14)
2025-11-25 05:58:18,377 - INFO -     → Gross Profit: $62.82 (83.81%)
2025-11-25 05:58:18,378 - INFO -   Amazon - Order 114-9572827-5138608 [Normal]:
2025-11-25 05:58:18,378 - INFO -     Sales: $38.95
2025-11-25 05:58:18,378 - INFO -     Buy Price (incl. shipping): $0.00
2025-11-25 05:58:18,378 - INFO -     Commission (12.0%): $4.67
2025-11-25 05:58:18,378 - INFO -     Ad Fees: $1.63
2025-11-25 05:58:18,378 - INFO -     Payment Processor: $0.00
2025-11-25 05:58:18,378 - INFO -     Repayment Fees: $0.00
2025-11-25 05:58:18,378 - INFO -     Additional Costs: +$0.00
2025-11-25 05:58:18,378 - INFO -     Label Costs: +$0.00
2025-11-25 05:58:18,378 - INFO -     Supplier Credits: -$0.00
2025-11-25 05:58:18,378 - INFO -     Carrier Credits: -$0.00
2025-11-25 05:58:18,378 - INFO -     → COGS: $6.30 (was $6.31)
2025-11-25 05:58:18,378 - INFO -     → Gross Profit: $32.65 (83.82%)
2025-11-25 05:58:19,112 - INFO -   eBay - Order 03-13856-58490 [Cancelled (Cancelled)]:
2025-11-25 05:58:19,112 - INFO -     Sales: $75.95
2025-11-25 05:58:19,112 - INFO -     Buy Price (incl. shipping): $0.00
2025-11-25 05:58:19,112 - INFO -     Commission (16.35%): $12.42
2025-11-25 05:58:19,112 - INFO -     Ad Fees: $3.51
2025-11-25 05:58:19,112 - INFO -     Payment Processor: $0.00
2025-11-25 05:58:19,112 - INFO -     Repayment Fees: $0.00
2025-11-25 05:58:19,112 - INFO -     Additional Costs: +$0.00
2025-11-25 05:58:19,112 - INFO -     Label Costs: +$0.00
2025-11-25 05:58:19,112 - INFO -     Supplier Credits: -$0.00
2025-11-25 05:58:19,112 - INFO -     Carrier Credits: -$0.00
2025-11-25 05:58:19,112 - INFO -     → COGS: $15.93 (was $15.93)
2025-11-25 05:58:19,112 - INFO -     → Gross Profit: $-15.93 (-20.97%)
2025-11-25 05:58:19,194 - INFO - 
================================================================================
2025-11-25 05:58:19,194 - INFO - COGS CALCULATION SUMMARY BY CHANNEL
2025-11-25 05:58:19,194 - INFO - ================================================================================
2025-11-25 05:58:19,194 - INFO - 
Amazon:
2025-11-25 05:58:19,194 - INFO -   Orders: 4371
2025-11-25 05:58:19,194 - INFO -   Revenue: $576,584.13
2025-11-25 05:58:19,194 - INFO -   COGS Breakdown:
2025-11-25 05:58:19,194 - INFO -     Buy Price (incl. shipping): $256,848.30
2025-11-25 05:58:19,194 - INFO -     Commission: $69,190.10
2025-11-25 05:58:19,194 - INFO -     Ad Fees: $23,058.52
2025-11-25 05:58:19,194 - INFO -     Payment Processor: $251.77
2025-11-25 05:58:19,194 - INFO -     Repayment Fees: $0.00
2025-11-25 05:58:19,194 - INFO -     Additional Costs: +$260.06
2025-11-25 05:58:19,194 - INFO -     Label Costs: +$-109.10
2025-11-25 05:58:19,194 - INFO -     Supplier Credits: -$2,816.48
2025-11-25 05:58:19,194 - INFO -     Carrier Credits: -$0.00
2025-11-25 05:58:19,194 - INFO -   Total COGS: $334,232.07
2025-11-25 05:58:19,194 - INFO -   Gross Margin: $242,352.06 (42.03%)
2025-11-25 05:58:19,194 - INFO - 
B2B:
2025-11-25 05:58:19,194 - INFO -   Orders: 16064
2025-11-25 05:58:19,194 - INFO -   Revenue: $1,613,922.71
2025-11-25 05:58:19,194 - INFO -   COGS Breakdown:
2025-11-25 05:58:19,194 - INFO -     Buy Price (incl. shipping): $920,190.99
2025-11-25 05:58:19,194 - INFO -     Commission: $30,461.10
2025-11-25 05:58:19,194 - INFO -     Ad Fees: $0.00
2025-11-25 05:58:19,194 - INFO -     Payment Processor: $0.47
2025-11-25 05:58:19,194 - INFO -     Repayment Fees: $0.00
2025-11-25 05:58:19,194 - INFO -     Additional Costs: +$4,321.08
2025-11-25 05:58:19,194 - INFO -     Label Costs: +$8,631.65
2025-11-25 05:58:19,194 - INFO -     Supplier Credits: -$28,580.25
2025-11-25 05:58:19,194 - INFO -     Carrier Credits: -$45.19
2025-11-25 05:58:19,195 - INFO -   Total COGS: $825,069.28
2025-11-25 05:58:19,195 - INFO -   Gross Margin: $788,853.43 (48.88%)
2025-11-25 05:58:19,195 - INFO - 
Web:
2025-11-25 05:58:19,195 - INFO -   Orders: 1699
2025-11-25 05:58:19,195 - INFO -   Revenue: $209,433.25
2025-11-25 05:58:19,195 - INFO -   COGS Breakdown:
2025-11-25 05:58:19,195 - INFO -     Buy Price (incl. shipping): $86,943.86
2025-11-25 05:58:19,195 - INFO -     Commission: $0.00
2025-11-25 05:58:19,195 - INFO -     Ad Fees: $11,134.49
2025-11-25 05:58:19,195 - INFO -     Payment Processor: $3,843.86
2025-11-25 05:58:19,195 - INFO -     Repayment Fees: $0.00
2025-11-25 05:58:19,195 - INFO -     Additional Costs: +$55.85
2025-11-25 05:58:19,195 - INFO -     Label Costs: +$54.81
2025-11-25 05:58:19,195 - INFO -     Supplier Credits: -$923.41
2025-11-25 05:58:19,195 - INFO -     Carrier Credits: -$0.00
2025-11-25 05:58:19,195 - INFO -   Total COGS: $96,178.26
2025-11-25 05:58:19,195 - INFO -   Gross Margin: $113,254.99 (54.08%)
2025-11-25 05:58:19,195 - INFO - 
eBay:
2025-11-25 05:58:19,195 - INFO -   Orders: 116
2025-11-25 05:58:19,195 - INFO -   Revenue: $16,994.20
2025-11-25 05:58:19,195 - INFO -   COGS Breakdown:
2025-11-25 05:58:19,195 - INFO -     Buy Price (incl. shipping): $6,374.83
2025-11-25 05:58:19,195 - INFO -     Commission: $2,778.55
2025-11-25 05:58:19,195 - INFO -     Ad Fees: $611.73
2025-11-25 05:58:19,195 - INFO -     Payment Processor: $428.08
2025-11-25 05:58:19,195 - INFO -     Repayment Fees: $0.00
2025-11-25 05:58:19,195 - INFO -     Additional Costs: +$0.00
2025-11-25 05:58:19,195 - INFO -     Label Costs: +$0.00
2025-11-25 05:58:19,195 - INFO -     Supplier Credits: -$248.90
2025-11-25 05:58:19,195 - INFO -     Carrier Credits: -$0.00
2025-11-25 05:58:19,195 - INFO -   Total COGS: $9,447.72
2025-11-25 05:58:19,195 - INFO -   Gross Margin: $7,546.48 (44.41%)
2025-11-25 05:58:19,195 - INFO - 
================================================================================
2025-11-25 05:58:19,195 - INFO - OVERALL TOTALS
2025-11-25 05:58:19,195 - INFO - ================================================================================
2025-11-25 05:58:19,195 - INFO - Total Orders: 22250
2025-11-25 05:58:19,195 - INFO - Updated: 5698
2025-11-25 05:58:19,195 - INFO - Unchanged: 16552
2025-11-25 05:58:19,195 - INFO - Missing buy price: 2765
2025-11-25 05:58:19,195 - INFO - 
Total Revenue: $2,416,934.29
2025-11-25 05:58:19,196 - INFO - Total COGS: $1,264,927.33
2025-11-25 05:58:19,196 - INFO - Total Gross Margin: $1,152,006.96 (47.66%)
2025-11-25 05:58:19,196 - INFO - ================================================================================

2025-11-25 05:58:19,196 - WARNING - ⚠️  2765 orders have NULL/zero buy price - COGS may be understated
2025-11-25 05:58:19,222 - INFO - 
================================================================================
2025-11-25 05:58:19,222 - INFO - Script completed successfully
2025-11-25 05:58:19,222 - INFO - ================================================================================