2025-11-22 21:55:20,243 - INFO - Log file: /home/centralgoparts/public_html/profitability/logs/final_cogs_20251122_215520.log
2025-11-22 21:55:20,243 - INFO - ================================================================================
2025-11-22 21:55:20,243 - INFO - FINAL COGS CALCULATION - 2025-11-22 21:55:20
2025-11-22 21:55:20,243 - INFO - LIVE MODE
2025-11-22 21:55:20,243 - INFO - ================================================================================
2025-11-22 21:55:20,243 - INFO - Date Range: 2025-07-25 to 2025-11-22 (120 days)
2025-11-22 21:55:20,251 - INFO - ================================================================================
2025-11-22 21:55:20,252 - INFO - Processing: FINAL COGS CALCULATION
2025-11-22 21:55:20,252 - INFO -   Formula: our_buy_price + commission_and_fee + payment_processor_fee
2025-11-22 21:55:20,252 - INFO -            - supplier_credits + loss_amount
2025-11-22 21:55:20,252 - INFO -   Note: our_buy_price already includes shipping & handling
2025-11-22 21:55:20,252 - INFO - ================================================================================
2025-11-22 21:55:20,344 - INFO - Found 8934 orders to calculate COGS
2025-11-22 21:55:20,344 - INFO -   Amazon - Order 111-3993246-7369036:
2025-11-22 21:55:20,345 - INFO -     Sales: $277.95
2025-11-22 21:55:20,345 - INFO -     Buy Price (incl. shipping): $165.65
2025-11-22 21:55:20,345 - INFO -     Commission+Fees: $54.13
2025-11-22 21:55:20,345 - INFO -     Payment Processor: $0.00
2025-11-22 21:55:20,345 - INFO -     Credits: -$0.00
2025-11-22 21:55:20,345 - INFO -     Loss: $0.00 (0.00% of sales)
2025-11-22 21:55:20,345 - INFO -     → COGS: $219.78 (was $54.13)
2025-11-22 21:55:20,345 - INFO -     → Gross Profit: $58.17 (20.93%)
2025-11-22 21:55:20,345 - INFO -   Amazon - Order 114-8826455-8369017:
2025-11-22 21:55:20,345 - INFO -     Sales: $118.95
2025-11-22 21:55:20,345 - INFO -     Buy Price (incl. shipping): $64.93
2025-11-22 21:55:20,345 - INFO -     Commission+Fees: $23.17
2025-11-22 21:55:20,345 - INFO -     Payment Processor: $0.00
2025-11-22 21:55:20,345 - INFO -     Credits: -$0.00
2025-11-22 21:55:20,345 - INFO -     Loss: $0.00 (0.00% of sales)
2025-11-22 21:55:20,345 - INFO -     → COGS: $88.10 (was $52.52)
2025-11-22 21:55:20,345 - INFO -     → Gross Profit: $30.85 (25.94%)
2025-11-22 21:55:20,345 - INFO -   Amazon - Order 111-8578134-0080232:
2025-11-22 21:55:20,345 - INFO -     Sales: $370.95
2025-11-22 21:55:20,345 - INFO -     Buy Price (incl. shipping): $221.16
2025-11-22 21:55:20,345 - INFO -     Commission+Fees: $72.24
2025-11-22 21:55:20,345 - INFO -     Payment Processor: $0.00
2025-11-22 21:55:20,345 - INFO -     Credits: -$0.00
2025-11-22 21:55:20,345 - INFO -     Loss: $20.40 (5.50% of sales)
2025-11-22 21:55:20,345 - INFO -     → COGS: $313.80 (was $92.64)
2025-11-22 21:55:20,345 - INFO -     → Gross Profit: $57.15 (15.41%)
2025-11-22 21:55:20,346 - INFO -   Amazon - Order 112-6398345-0909022:
2025-11-22 21:55:20,346 - INFO -     Sales: $95.95
2025-11-22 21:55:20,346 - INFO -     Buy Price (incl. shipping): $52.10
2025-11-22 21:55:20,346 - INFO -     Commission+Fees: $18.69
2025-11-22 21:55:20,346 - INFO -     Payment Processor: $0.00
2025-11-22 21:55:20,346 - INFO -     Credits: -$0.00
2025-11-22 21:55:20,346 - INFO -     Loss: $0.00 (0.00% of sales)
2025-11-22 21:55:20,346 - INFO -     → COGS: $70.79 (was $48.87)
2025-11-22 21:55:20,346 - INFO -     → Gross Profit: $25.16 (26.22%)
2025-11-22 21:55:20,389 - INFO -   B2B - Order 39038-0050:
2025-11-22 21:55:20,389 - INFO -     Sales: $43.35
2025-11-22 21:55:20,389 - INFO -     Buy Price (incl. shipping): $32.02
2025-11-22 21:55:20,390 - INFO -     Commission+Fees: $1.16
2025-11-22 21:55:20,390 - INFO -     Payment Processor: $0.00
2025-11-22 21:55:20,390 - INFO -     Credits: -$0.00
2025-11-22 21:55:20,390 - INFO -     Loss: $0.55 (1.26% of sales)
2025-11-22 21:55:20,390 - INFO -     → COGS: $33.73 (was $1.71)
2025-11-22 21:55:20,390 - INFO -     → Gross Profit: $9.62 (22.20%)
2025-11-22 21:55:20,390 - INFO -   B2B - Order 39038-0050:
2025-11-22 21:55:20,390 - INFO -     Sales: $70.22
2025-11-22 21:55:20,390 - INFO -     Buy Price (incl. shipping): $50.62
2025-11-22 21:55:20,390 - INFO -     Commission+Fees: $1.88
2025-11-22 21:55:20,390 - INFO -     Payment Processor: $0.00
2025-11-22 21:55:20,390 - INFO -     Credits: -$0.00
2025-11-22 21:55:20,390 - INFO -     Loss: $1.40 (2.00% of sales)
2025-11-22 21:55:20,390 - INFO -     → COGS: $53.90 (was $3.28)
2025-11-22 21:55:20,390 - INFO -     → Gross Profit: $16.32 (23.23%)
2025-11-22 21:55:20,390 - INFO -   B2B - Order 39038-0050:
2025-11-22 21:55:20,390 - INFO -     Sales: $63.60
2025-11-22 21:55:20,390 - INFO -     Buy Price (incl. shipping): $53.62
2025-11-22 21:55:20,390 - INFO -     Commission+Fees: $1.70
2025-11-22 21:55:20,390 - INFO -     Payment Processor: $0.00
2025-11-22 21:55:20,390 - INFO -     Credits: -$0.00
2025-11-22 21:55:20,390 - INFO -     Loss: $1.73 (2.72% of sales)
2025-11-22 21:55:20,390 - INFO -     → COGS: $57.05 (was $3.43)
2025-11-22 21:55:20,390 - INFO -     → Gross Profit: $6.55 (10.30%)
2025-11-22 21:55:20,390 - INFO -   B2B - Order 57170-0014:
2025-11-22 21:55:20,390 - INFO -     Sales: $64.40
2025-11-22 21:55:20,390 - INFO -     Buy Price (incl. shipping): $40.67
2025-11-22 21:55:20,390 - INFO -     Commission+Fees: $1.72
2025-11-22 21:55:20,390 - INFO -     Payment Processor: $0.00
2025-11-22 21:55:20,391 - INFO -     Credits: -$0.00
2025-11-22 21:55:20,391 - INFO -     Loss: $0.81 (1.26% of sales)
2025-11-22 21:55:20,391 - INFO -     → COGS: $43.20 (was $2.53)
2025-11-22 21:55:20,391 - INFO -     → Gross Profit: $21.20 (32.92%)
2025-11-22 21:55:20,391 - INFO -   B2B - Order 40151-0139:
2025-11-22 21:55:20,391 - INFO -     Sales: $82.63
2025-11-22 21:55:20,391 - INFO -     Buy Price (incl. shipping): $52.17
2025-11-22 21:55:20,391 - INFO -     Commission+Fees: $2.21
2025-11-22 21:55:20,391 - INFO -     Payment Processor: $0.00
2025-11-22 21:55:20,391 - INFO -     Credits: -$0.00
2025-11-22 21:55:20,391 - INFO -     Loss: $1.04 (1.26% of sales)
2025-11-22 21:55:20,391 - INFO -     → COGS: $55.42 (was $57.13)
2025-11-22 21:55:20,391 - INFO -     → Gross Profit: $27.21 (32.93%)
2025-11-22 21:55:20,445 - INFO -   eBay - Order 16-13826-63476:
2025-11-22 21:55:20,445 - INFO -     Sales: $338.95
2025-11-22 21:55:20,445 - INFO -     Buy Price (incl. shipping): $152.57
2025-11-22 21:55:20,445 - INFO -     Commission+Fees: $75.23
2025-11-22 21:55:20,445 - INFO -     Payment Processor: $10.13
2025-11-22 21:55:20,445 - INFO -     Credits: -$0.00
2025-11-22 21:55:20,445 - INFO -     Loss: $0.00 (0.00% of sales)
2025-11-22 21:55:20,445 - INFO -     → COGS: $237.93 (was $161.83)
2025-11-22 21:55:20,445 - INFO -     → Gross Profit: $101.02 (29.80%)
2025-11-22 21:55:20,445 - INFO -   eBay - Order 17-13816-44560:
2025-11-22 21:55:20,445 - INFO -     Sales: $338.95
2025-11-22 21:55:20,445 - INFO -     Buy Price (incl. shipping): $152.58
2025-11-22 21:55:20,445 - INFO -     Commission+Fees: $75.23
2025-11-22 21:55:20,445 - INFO -     Payment Processor: $10.13
2025-11-22 21:55:20,445 - INFO -     Credits: -$0.00
2025-11-22 21:55:20,445 - INFO -     Loss: $0.00 (0.00% of sales)
2025-11-22 21:55:20,445 - INFO -     → COGS: $237.94 (was $161.65)
2025-11-22 21:55:20,445 - INFO -     → Gross Profit: $101.01 (29.80%)
2025-11-22 21:55:20,446 - INFO -   Web - Order 229634668:
2025-11-22 21:55:20,446 - INFO -     Sales: $20.94
2025-11-22 21:55:20,446 - INFO -     Buy Price (incl. shipping): $8.67
2025-11-22 21:55:20,446 - INFO -     Commission+Fees: $2.42
2025-11-22 21:55:20,446 - INFO -     Payment Processor: $0.56
2025-11-22 21:55:20,446 - INFO -     Credits: -$0.00
2025-11-22 21:55:20,446 - INFO -     Loss: $1.95 (9.30% of sales)
2025-11-22 21:55:20,446 - INFO -     → COGS: $13.60 (was $4.93)
2025-11-22 21:55:20,446 - INFO -     → Gross Profit: $7.34 (35.06%)
2025-11-22 21:55:20,446 - INFO -   Web - Order 229634666:
2025-11-22 21:55:20,446 - INFO -     Sales: $76.94
2025-11-22 21:55:20,446 - INFO -     Buy Price (incl. shipping): $42.31
2025-11-22 21:55:20,446 - INFO -     Commission+Fees: $8.91
2025-11-22 21:55:20,446 - INFO -     Payment Processor: $2.07
2025-11-22 21:55:20,446 - INFO -     Credits: -$0.00
2025-11-22 21:55:20,446 - INFO -     Loss: $4.92 (6.40% of sales)
2025-11-22 21:55:20,446 - INFO -     → COGS: $58.21 (was $15.90)
2025-11-22 21:55:20,446 - INFO -     → Gross Profit: $18.73 (24.34%)
2025-11-22 21:55:20,447 - INFO -   Web - Order 229634657:
2025-11-22 21:55:20,447 - INFO -     Sales: $20.94
2025-11-22 21:55:20,447 - INFO -     Buy Price (incl. shipping): $8.67
2025-11-22 21:55:20,447 - INFO -     Commission+Fees: $2.42
2025-11-22 21:55:20,447 - INFO -     Payment Processor: $0.56
2025-11-22 21:55:20,447 - INFO -     Credits: -$0.00
2025-11-22 21:55:20,447 - INFO -     Loss: $1.95 (9.30% of sales)
2025-11-22 21:55:20,447 - INFO -     → COGS: $13.60 (was $4.93)
2025-11-22 21:55:20,447 - INFO -     → Gross Profit: $7.34 (35.06%)
2025-11-22 21:55:20,460 - INFO - 
================================================================================
2025-11-22 21:55:20,460 - INFO - COGS CALCULATION SUMMARY BY CHANNEL
2025-11-22 21:55:20,460 - INFO - ================================================================================
2025-11-22 21:55:20,460 - INFO - 
Amazon:
2025-11-22 21:55:20,460 - INFO -   Orders: 1680
2025-11-22 21:55:20,460 - INFO -   Revenue: $221,804.92
2025-11-22 21:55:20,460 - INFO -   COGS Breakdown:
2025-11-22 21:55:20,460 - INFO -     Buy Price (incl. shipping): $99,399.54
2025-11-22 21:55:20,460 - INFO -     Commission+Fees: $39,645.86
2025-11-22 21:55:20,460 - INFO -     Payment Processor: $10.45
2025-11-22 21:55:20,460 - INFO -     Credits: -$290.01
2025-11-22 21:55:20,460 - INFO -     Loss: $9,797.17
2025-11-22 21:55:20,460 - INFO -   Total COGS: $148,563.01
2025-11-22 21:55:20,460 - INFO -   Gross Margin: $73,241.91 (33.02%)
2025-11-22 21:55:20,460 - INFO - 
B2B:
2025-11-22 21:55:20,460 - INFO -   Orders: 6695
2025-11-22 21:55:20,460 - INFO -   Revenue: $637,245.88
2025-11-22 21:55:20,460 - INFO -   COGS Breakdown:
2025-11-22 21:55:20,460 - INFO -     Buy Price (incl. shipping): $375,358.90
2025-11-22 21:55:20,461 - INFO -     Commission+Fees: $15,593.64
2025-11-22 21:55:20,461 - INFO -     Payment Processor: $0.47
2025-11-22 21:55:20,461 - INFO -     Credits: -$1,575.00
2025-11-22 21:55:20,461 - INFO -     Loss: $8,827.74
2025-11-22 21:55:20,461 - INFO -   Total COGS: $398,205.75
2025-11-22 21:55:20,461 - INFO -   Gross Margin: $239,040.13 (37.51%)
2025-11-22 21:55:20,461 - INFO - 
Web:
2025-11-22 21:55:20,461 - INFO -   Orders: 507
2025-11-22 21:55:20,461 - INFO -   Revenue: $64,796.50
2025-11-22 21:55:20,461 - INFO -   COGS Breakdown:
2025-11-22 21:55:20,461 - INFO -     Buy Price (incl. shipping): $30,277.90
2025-11-22 21:55:20,461 - INFO -     Commission+Fees: $5,711.73
2025-11-22 21:55:20,461 - INFO -     Payment Processor: $1,742.95
2025-11-22 21:55:20,461 - INFO -     Credits: -$159.74
2025-11-22 21:55:20,461 - INFO -     Loss: $3,786.28
2025-11-22 21:55:20,461 - INFO -   Total COGS: $41,359.12
2025-11-22 21:55:20,461 - INFO -   Gross Margin: $23,437.38 (36.17%)
2025-11-22 21:55:20,461 - INFO - 
eBay:
2025-11-22 21:55:20,461 - INFO -   Orders: 52
2025-11-22 21:55:20,461 - INFO -   Revenue: $8,538.40
2025-11-22 21:55:20,461 - INFO -   COGS Breakdown:
2025-11-22 21:55:20,461 - INFO -     Buy Price (incl. shipping): $2,931.75
2025-11-22 21:55:20,461 - INFO -     Commission+Fees: $1,755.70
2025-11-22 21:55:20,461 - INFO -     Payment Processor: $263.17
2025-11-22 21:55:20,461 - INFO -     Credits: -$0.00
2025-11-22 21:55:20,461 - INFO -     Loss: $212.87
2025-11-22 21:55:20,461 - INFO -   Total COGS: $5,163.49
2025-11-22 21:55:20,461 - INFO -   Gross Margin: $3,374.91 (39.53%)
2025-11-22 21:55:20,461 - INFO - 
================================================================================
2025-11-22 21:55:20,461 - INFO - OVERALL TOTALS
2025-11-22 21:55:20,461 - INFO - ================================================================================
2025-11-22 21:55:20,461 - INFO - Total Orders: 8934
2025-11-22 21:55:20,461 - INFO - Updated: 718
2025-11-22 21:55:20,461 - INFO - Unchanged: 8216
2025-11-22 21:55:20,461 - INFO - Missing buy price: 909
2025-11-22 21:55:20,461 - INFO - 
Total Revenue: $932,385.70
2025-11-22 21:55:20,461 - INFO - Total COGS: $593,291.38
2025-11-22 21:55:20,461 - INFO - Total Gross Margin: $339,094.32 (36.37%)
2025-11-22 21:55:20,461 - INFO - ================================================================================

2025-11-22 21:55:20,461 - WARNING - ⚠️  909 orders have NULL/zero buy price - COGS may be understated
2025-11-22 21:55:20,466 - INFO - 
================================================================================
2025-11-22 21:55:20,466 - INFO - Script completed successfully
2025-11-22 21:55:20,466 - INFO - ================================================================================