2025-11-24 06:35:18,927 - INFO - Log file: /home/centralgoparts/public_html/profitability/logs/final_cogs_20251124_063518.log
2025-11-24 06:35:18,927 - INFO - ================================================================================
2025-11-24 06:35:18,927 - INFO - FINAL COGS CALCULATION - 2025-11-24 06:35:18
2025-11-24 06:35:18,927 - INFO - LIVE MODE
2025-11-24 06:35:18,927 - INFO - ================================================================================
2025-11-24 06:35:18,927 - INFO - Date Range: 2025-07-27 to 2025-11-24 (120 days)
2025-11-24 06:35:18,935 - INFO - ================================================================================
2025-11-24 06:35:18,935 - INFO - Processing: FINAL COGS CALCULATION
2025-11-24 06:35:18,935 - INFO -   Formula: our_buy_price + commission_and_fee + payment_processor_fee
2025-11-24 06:35:18,935 - INFO -            - supplier_credits + loss_amount
2025-11-24 06:35:18,935 - INFO -   Note: our_buy_price already includes shipping & handling
2025-11-24 06:35:18,935 - INFO - ================================================================================
2025-11-24 06:35:19,174 - INFO - Found 22250 orders to calculate COGS
2025-11-24 06:35:19,175 - INFO -   Amazon - Order 112-2384609-9637809 [Normal]:
2025-11-24 06:35:19,175 - INFO -     Sales: $34.50
2025-11-24 06:35:19,175 - INFO -     Buy Price (incl. shipping): $0.00
2025-11-24 06:35:19,175 - INFO -     Commission+Fees: $5.93
2025-11-24 06:35:19,175 - INFO -     Payment Processor: $0.00
2025-11-24 06:35:19,175 - INFO -     Credits: -$0.00
2025-11-24 06:35:19,175 - INFO -     Loss: $0.00 (0.00% of sales)
2025-11-24 06:35:19,175 - INFO -     → COGS: $5.93 (was $0.00)
2025-11-24 06:35:19,175 - INFO -     → Gross Profit: $28.57 (82.81%)
2025-11-24 06:35:19,175 - INFO -   Amazon - Order 112-2384609-9637809 [Normal]:
2025-11-24 06:35:19,176 - INFO -     Sales: $34.50
2025-11-24 06:35:19,176 - INFO -     Buy Price (incl. shipping): $0.00
2025-11-24 06:35:19,176 - INFO -     Commission+Fees: $5.93
2025-11-24 06:35:19,176 - INFO -     Payment Processor: $0.00
2025-11-24 06:35:19,176 - INFO -     Credits: -$0.00
2025-11-24 06:35:19,176 - INFO -     Loss: $0.00 (0.00% of sales)
2025-11-24 06:35:19,176 - INFO -     → COGS: $5.93 (was $0.00)
2025-11-24 06:35:19,176 - INFO -     → Gross Profit: $28.57 (82.81%)
2025-11-24 06:35:19,176 - INFO -   Amazon - Order 111-8832899-8069043 [Normal]:
2025-11-24 06:35:19,176 - INFO -     Sales: $120.95
2025-11-24 06:35:19,176 - INFO -     Buy Price (incl. shipping): $0.00
2025-11-24 06:35:19,176 - INFO -     Commission+Fees: $20.80
2025-11-24 06:35:19,176 - INFO -     Payment Processor: $0.00
2025-11-24 06:35:19,176 - INFO -     Credits: -$0.00
2025-11-24 06:35:19,176 - INFO -     Loss: $0.00 (0.00% of sales)
2025-11-24 06:35:19,176 - INFO -     → COGS: $20.80 (was $0.00)
2025-11-24 06:35:19,176 - INFO -     → Gross Profit: $100.15 (82.80%)
2025-11-24 06:35:19,176 - INFO -   Amazon - Order 112-7580077-9273032 [Normal]:
2025-11-24 06:35:19,176 - INFO -     Sales: $74.95
2025-11-24 06:35:19,176 - INFO -     Buy Price (incl. shipping): $0.00
2025-11-24 06:35:19,176 - INFO -     Commission+Fees: $12.89
2025-11-24 06:35:19,176 - INFO -     Payment Processor: $0.00
2025-11-24 06:35:19,176 - INFO -     Credits: -$0.00
2025-11-24 06:35:19,176 - INFO -     Loss: $0.00 (0.00% of sales)
2025-11-24 06:35:19,176 - INFO -     → COGS: $12.89 (was $0.00)
2025-11-24 06:35:19,176 - INFO -     → Gross Profit: $62.06 (82.80%)
2025-11-24 06:35:19,177 - INFO -   Amazon - Order 111-6444989-3525038 [Normal]:
2025-11-24 06:35:19,177 - INFO -     Sales: $206.95
2025-11-24 06:35:19,177 - INFO -     Buy Price (incl. shipping): $0.00
2025-11-24 06:35:19,177 - INFO -     Commission+Fees: $35.59
2025-11-24 06:35:19,177 - INFO -     Payment Processor: $0.00
2025-11-24 06:35:19,177 - INFO -     Credits: -$0.00
2025-11-24 06:35:19,177 - INFO -     Loss: $0.00 (0.00% of sales)
2025-11-24 06:35:19,177 - INFO -     → COGS: $35.59 (was $0.00)
2025-11-24 06:35:19,177 - INFO -     → Gross Profit: $171.36 (82.80%)
2025-11-24 06:35:19,177 - INFO -   Amazon - Order 112-0338287-2430662 [Normal]:
2025-11-24 06:35:19,177 - INFO -     Sales: $145.95
2025-11-24 06:35:19,177 - INFO -     Buy Price (incl. shipping): $0.00
2025-11-24 06:35:19,177 - INFO -     Commission+Fees: $25.10
2025-11-24 06:35:19,177 - INFO -     Payment Processor: $0.00
2025-11-24 06:35:19,177 - INFO -     Credits: -$0.00
2025-11-24 06:35:19,177 - INFO -     Loss: $0.00 (0.00% of sales)
2025-11-24 06:35:19,177 - INFO -     → COGS: $25.10 (was $0.00)
2025-11-24 06:35:19,177 - INFO -     → Gross Profit: $120.85 (82.80%)
2025-11-24 06:35:19,177 - INFO -   Amazon - Order 114-9572827-5138608 [Normal]:
2025-11-24 06:35:19,177 - INFO -     Sales: $38.95
2025-11-24 06:35:19,177 - INFO -     Buy Price (incl. shipping): $0.00
2025-11-24 06:35:19,177 - INFO -     Commission+Fees: $6.70
2025-11-24 06:35:19,177 - INFO -     Payment Processor: $0.00
2025-11-24 06:35:19,177 - INFO -     Credits: -$0.00
2025-11-24 06:35:19,177 - INFO -     Loss: $0.00 (0.00% of sales)
2025-11-24 06:35:19,177 - INFO -     → COGS: $6.70 (was $0.00)
2025-11-24 06:35:19,177 - INFO -     → Gross Profit: $32.25 (82.80%)
2025-11-24 06:35:19,177 - INFO -   Amazon - Order 114-8571312-0163441 [Normal]:
2025-11-24 06:35:19,177 - INFO -     Sales: $232.95
2025-11-24 06:35:19,178 - INFO -     Buy Price (incl. shipping): $0.00
2025-11-24 06:35:19,178 - INFO -     Commission+Fees: $40.06
2025-11-24 06:35:19,178 - INFO -     Payment Processor: $0.00
2025-11-24 06:35:19,178 - INFO -     Credits: -$0.00
2025-11-24 06:35:19,178 - INFO -     Loss: $0.00 (0.00% of sales)
2025-11-24 06:35:19,178 - INFO -     → COGS: $40.06 (was $0.00)
2025-11-24 06:35:19,178 - INFO -     → Gross Profit: $192.89 (82.80%)
2025-11-24 06:35:19,178 - INFO -   Amazon - Order 114-8571312-0163441 [Normal]:
2025-11-24 06:35:19,178 - INFO -     Sales: $123.95
2025-11-24 06:35:19,178 - INFO -     Buy Price (incl. shipping): $0.00
2025-11-24 06:35:19,178 - INFO -     Commission+Fees: $21.32
2025-11-24 06:35:19,178 - INFO -     Payment Processor: $0.00
2025-11-24 06:35:19,178 - INFO -     Credits: -$0.00
2025-11-24 06:35:19,178 - INFO -     Loss: $0.00 (0.00% of sales)
2025-11-24 06:35:19,178 - INFO -     → COGS: $21.32 (was $0.00)
2025-11-24 06:35:19,178 - INFO -     → Gross Profit: $102.63 (82.80%)
2025-11-24 06:35:19,178 - INFO -   Amazon - Order 113-2934462-8587416 [Normal]:
2025-11-24 06:35:19,178 - INFO -     Sales: $41.95
2025-11-24 06:35:19,178 - INFO -     Buy Price (incl. shipping): $0.00
2025-11-24 06:35:19,178 - INFO -     Commission+Fees: $7.21
2025-11-24 06:35:19,178 - INFO -     Payment Processor: $0.00
2025-11-24 06:35:19,178 - INFO -     Credits: -$0.00
2025-11-24 06:35:19,178 - INFO -     Loss: $0.00 (0.00% of sales)
2025-11-24 06:35:19,178 - INFO -     → COGS: $7.21 (was $0.00)
2025-11-24 06:35:19,178 - INFO -     → Gross Profit: $34.74 (82.81%)
2025-11-24 06:35:20,209 - INFO -   eBay - Order 03-13878-25869 [Normal]:
2025-11-24 06:35:20,209 - INFO -     Sales: $131.95
2025-11-24 06:35:20,209 - INFO -     Buy Price (incl. shipping): $0.00
2025-11-24 06:35:20,209 - INFO -     Commission+Fees: $29.29
2025-11-24 06:35:20,209 - INFO -     Payment Processor: $4.13
2025-11-24 06:35:20,209 - INFO -     Credits: -$0.00
2025-11-24 06:35:20,209 - INFO -     Loss: $0.00 (0.00% of sales)
2025-11-24 06:35:20,209 - INFO -     → COGS: $33.42 (was $0.00)
2025-11-24 06:35:20,209 - INFO -     → Gross Profit: $98.53 (74.67%)
2025-11-24 06:35:20,210 - INFO -   eBay - Order 03-13856-58490 [Cancelled (Cancelled)]:
2025-11-24 06:35:20,210 - INFO -     Sales: $75.95
2025-11-24 06:35:20,210 - INFO -     Buy Price (incl. shipping): $0.00
2025-11-24 06:35:20,210 - INFO -     Commission+Fees: $0.00
2025-11-24 06:35:20,210 - INFO -     Payment Processor: $0.00
2025-11-24 06:35:20,210 - INFO -     Credits: -$0.00
2025-11-24 06:35:20,210 - INFO -     Loss: $0.00 (0.00% of sales)
2025-11-24 06:35:20,210 - INFO -     → COGS: $0.00 (was $0.00)
2025-11-24 06:35:20,210 - INFO -     → Gross Profit: $0.00 (0.00%)
2025-11-24 06:35:20,215 - INFO -   Web - Order 229634862 [Normal]:
2025-11-24 06:35:20,215 - INFO -     Sales: $186.95
2025-11-24 06:35:20,215 - INFO -     Buy Price (incl. shipping): $0.00
2025-11-24 06:35:20,215 - INFO -     Commission+Fees: $15.91
2025-11-24 06:35:20,215 - INFO -     Payment Processor: $5.03
2025-11-24 06:35:20,215 - INFO -     Credits: -$0.00
2025-11-24 06:35:20,215 - INFO -     Loss: $0.00 (0.00% of sales)
2025-11-24 06:35:20,215 - INFO -     → COGS: $20.94 (was $0.00)
2025-11-24 06:35:20,215 - INFO -     → Gross Profit: $166.01 (88.80%)
2025-11-24 06:35:20,215 - INFO -   Web - Order 229634851 [Normal]:
2025-11-24 06:35:20,215 - INFO -     Sales: $97.95
2025-11-24 06:35:20,215 - INFO -     Buy Price (incl. shipping): $0.00
2025-11-24 06:35:20,215 - INFO -     Commission+Fees: $8.33
2025-11-24 06:35:20,215 - INFO -     Payment Processor: $2.63
2025-11-24 06:35:20,215 - INFO -     Credits: -$0.00
2025-11-24 06:35:20,215 - INFO -     Loss: $0.00 (0.00% of sales)
2025-11-24 06:35:20,215 - INFO -     → COGS: $10.96 (was $0.00)
2025-11-24 06:35:20,215 - INFO -     → Gross Profit: $86.99 (88.81%)
2025-11-24 06:35:20,215 - INFO -   Web - Order 229634838 [Normal]:
2025-11-24 06:35:20,215 - INFO -     Sales: $168.95
2025-11-24 06:35:20,215 - INFO -     Buy Price (incl. shipping): $0.00
2025-11-24 06:35:20,216 - INFO -     Commission+Fees: $14.38
2025-11-24 06:35:20,216 - INFO -     Payment Processor: $4.54
2025-11-24 06:35:20,216 - INFO -     Credits: -$0.00
2025-11-24 06:35:20,216 - INFO -     Loss: $0.00 (0.00% of sales)
2025-11-24 06:35:20,216 - INFO -     → COGS: $18.92 (was $0.00)
2025-11-24 06:35:20,216 - INFO -     → Gross Profit: $150.03 (88.80%)
2025-11-24 06:35:20,216 - INFO -   Web - Order 229634827 [Normal]:
2025-11-24 06:35:20,216 - INFO -     Sales: $26.95
2025-11-24 06:35:20,216 - INFO -     Buy Price (incl. shipping): $0.00
2025-11-24 06:35:20,216 - INFO -     Commission+Fees: $2.29
2025-11-24 06:35:20,216 - INFO -     Payment Processor: $0.72
2025-11-24 06:35:20,216 - INFO -     Credits: -$0.00
2025-11-24 06:35:20,216 - INFO -     Loss: $0.00 (0.00% of sales)
2025-11-24 06:35:20,216 - INFO -     → COGS: $3.01 (was $0.00)
2025-11-24 06:35:20,216 - INFO -     → Gross Profit: $23.94 (88.83%)
2025-11-24 06:35:20,216 - INFO -   Web - Order 229634769 [Normal]:
2025-11-24 06:35:20,216 - INFO -     Sales: $10.95
2025-11-24 06:35:20,216 - INFO -     Buy Price (incl. shipping): $0.00
2025-11-24 06:35:20,216 - INFO -     Commission+Fees: $0.93
2025-11-24 06:35:20,216 - INFO -     Payment Processor: $0.29
2025-11-24 06:35:20,216 - INFO -     Credits: -$0.00
2025-11-24 06:35:20,216 - INFO -     Loss: $0.00 (0.00% of sales)
2025-11-24 06:35:20,216 - INFO -     → COGS: $1.22 (was $0.00)
2025-11-24 06:35:20,216 - INFO -     → Gross Profit: $9.73 (88.86%)
2025-11-24 06:35:20,368 - INFO - 
================================================================================
2025-11-24 06:35:20,368 - INFO - COGS CALCULATION SUMMARY BY CHANNEL
2025-11-24 06:35:20,368 - INFO - ================================================================================
2025-11-24 06:35:20,368 - INFO - 
Amazon:
2025-11-24 06:35:20,368 - INFO -   Orders: 4371
2025-11-24 06:35:20,368 - INFO -   Revenue: $576,584.13
2025-11-24 06:35:20,368 - INFO -   COGS Breakdown:
2025-11-24 06:35:20,368 - INFO -     Buy Price (incl. shipping): $235,699.80
2025-11-24 06:35:20,368 - INFO -     Commission+Fees: $81,751.72
2025-11-24 06:35:20,368 - INFO -     Payment Processor: $251.77
2025-11-24 06:35:20,368 - INFO -     Credits: -$2,856.07
2025-11-24 06:35:20,368 - INFO -     Loss: $23,156.33
2025-11-24 06:35:20,368 - INFO -   Total COGS: $326,237.39
2025-11-24 06:35:20,368 - INFO -   Gross Margin: $250,346.74 (43.42%)
2025-11-24 06:35:20,368 - INFO - 
B2B:
2025-11-24 06:35:20,368 - INFO -   Orders: 16064
2025-11-24 06:35:20,368 - INFO -   Revenue: $1,613,922.71
2025-11-24 06:35:20,368 - INFO -   COGS Breakdown:
2025-11-24 06:35:20,368 - INFO -     Buy Price (incl. shipping): $905,908.20
2025-11-24 06:35:20,368 - INFO -     Commission+Fees: $31,107.70
2025-11-24 06:35:20,368 - INFO -     Payment Processor: $0.47
2025-11-24 06:35:20,368 - INFO -     Credits: -$30,040.61
2025-11-24 06:35:20,368 - INFO -     Loss: $20,954.83
2025-11-24 06:35:20,368 - INFO -   Total COGS: $817,955.24
2025-11-24 06:35:20,368 - INFO -   Gross Margin: $795,967.47 (49.32%)
2025-11-24 06:35:20,368 - INFO - 
Web:
2025-11-24 06:35:20,368 - INFO -   Orders: 1699
2025-11-24 06:35:20,368 - INFO -   Revenue: $209,433.25
2025-11-24 06:35:20,368 - INFO -   COGS Breakdown:
2025-11-24 06:35:20,368 - INFO -     Buy Price (incl. shipping): $75,455.37
2025-11-24 06:35:20,368 - INFO -     Commission+Fees: $11,002.14
2025-11-24 06:35:20,368 - INFO -     Payment Processor: $3,843.86
2025-11-24 06:35:20,368 - INFO -     Credits: -$1,076.95
2025-11-24 06:35:20,369 - INFO -     Loss: $9,122.67
2025-11-24 06:35:20,369 - INFO -   Total COGS: $93,433.42
2025-11-24 06:35:20,369 - INFO -   Gross Margin: $115,999.83 (55.39%)
2025-11-24 06:35:20,369 - INFO - 
eBay:
2025-11-24 06:35:20,369 - INFO -   Orders: 116
2025-11-24 06:35:20,369 - INFO -   Revenue: $16,994.20
2025-11-24 06:35:20,369 - INFO -   COGS Breakdown:
2025-11-24 06:35:20,369 - INFO -     Buy Price (incl. shipping): $5,707.97
2025-11-24 06:35:20,369 - INFO -     Commission+Fees: $2,941.81
2025-11-24 06:35:20,369 - INFO -     Payment Processor: $428.08
2025-11-24 06:35:20,369 - INFO -     Credits: -$248.90
2025-11-24 06:35:20,369 - INFO -     Loss: $409.83
2025-11-24 06:35:20,369 - INFO -   Total COGS: $8,742.22
2025-11-24 06:35:20,369 - INFO -   Gross Margin: $8,251.98 (48.56%)
2025-11-24 06:35:20,369 - INFO - 
================================================================================
2025-11-24 06:35:20,369 - INFO - OVERALL TOTALS
2025-11-24 06:35:20,369 - INFO - ================================================================================
2025-11-24 06:35:20,369 - INFO - Total Orders: 22250
2025-11-24 06:35:20,369 - INFO - Updated: 9238
2025-11-24 06:35:20,369 - INFO - Unchanged: 13012
2025-11-24 06:35:20,369 - INFO - Missing buy price: 3266
2025-11-24 06:35:20,369 - INFO - 
Total Revenue: $2,416,934.29
2025-11-24 06:35:20,369 - INFO - Total COGS: $1,246,368.27
2025-11-24 06:35:20,369 - INFO - Total Gross Margin: $1,170,566.02 (48.43%)
2025-11-24 06:35:20,369 - INFO - ================================================================================

2025-11-24 06:35:20,369 - WARNING - ⚠️  3266 orders have NULL/zero buy price - COGS may be understated
2025-11-24 06:35:20,382 - INFO - 
================================================================================
2025-11-24 06:35:20,382 - INFO - Script completed successfully
2025-11-24 06:35:20,382 - INFO - ================================================================================