2025-11-23 04:25:26,249 - INFO - Log file: /home/centralgoparts/public_html/profitability/logs/final_cogs_20251123_042526.log 2025-11-23 04:25:26,249 - INFO - ================================================================================ 2025-11-23 04:25:26,249 - INFO - FINAL COGS CALCULATION - 2025-11-23 04:25:26 2025-11-23 04:25:26,249 - INFO - LIVE MODE 2025-11-23 04:25:26,249 - INFO - ================================================================================ 2025-11-23 04:25:26,249 - INFO - Date Range: 2025-07-26 to 2025-11-23 (120 days) 2025-11-23 04:25:26,258 - INFO - ================================================================================ 2025-11-23 04:25:26,258 - INFO - Processing: FINAL COGS CALCULATION 2025-11-23 04:25:26,258 - INFO - Formula: our_buy_price + commission_and_fee + payment_processor_fee 2025-11-23 04:25:26,258 - INFO - - supplier_credits + loss_amount 2025-11-23 04:25:26,258 - INFO - Note: our_buy_price already includes shipping & handling 2025-11-23 04:25:26,258 - INFO - ================================================================================ 2025-11-23 04:25:26,510 - INFO - Found 22250 orders to calculate COGS 2025-11-23 04:25:26,950 - INFO - eBay - Order 03-13856-58490 [Cancelled (Cancelled)]: 2025-11-23 04:25:26,950 - INFO - Sales: $75.95 2025-11-23 04:25:26,950 - INFO - Buy Price (incl. shipping): $0.00 2025-11-23 04:25:26,950 - INFO - Commission+Fees: $0.00 2025-11-23 04:25:26,950 - INFO - Payment Processor: $0.00 2025-11-23 04:25:26,950 - INFO - Credits: -$0.00 2025-11-23 04:25:26,950 - INFO - Loss: $0.00 (0.00% of sales) 2025-11-23 04:25:26,950 - INFO - → COGS: $0.00 (was $0.00) 2025-11-23 04:25:26,950 - INFO - → Gross Profit: $0.00 (0.00%) 2025-11-23 04:25:27,040 - INFO - ================================================================================ 2025-11-23 04:25:27,040 - INFO - COGS CALCULATION SUMMARY BY CHANNEL 2025-11-23 04:25:27,040 - INFO - ================================================================================ 2025-11-23 04:25:27,040 - INFO - Amazon: 2025-11-23 04:25:27,040 - INFO - Orders: 4371 2025-11-23 04:25:27,040 - INFO - Revenue: $576,584.13 2025-11-23 04:25:27,040 - INFO - COGS Breakdown: 2025-11-23 04:25:27,040 - INFO - Buy Price (incl. shipping): $230,477.83 2025-11-23 04:25:27,040 - INFO - Commission+Fees: $76,804.53 2025-11-23 04:25:27,040 - INFO - Payment Processor: $15.18 2025-11-23 04:25:27,040 - INFO - Credits: -$2,856.07 2025-11-23 04:25:27,040 - INFO - Loss: $23,156.33 2025-11-23 04:25:27,040 - INFO - Total COGS: $314,954.48 2025-11-23 04:25:27,041 - INFO - Gross Margin: $261,629.65 (45.38%) 2025-11-23 04:25:27,041 - INFO - B2B: 2025-11-23 04:25:27,041 - INFO - Orders: 16064 2025-11-23 04:25:27,041 - INFO - Revenue: $1,613,922.71 2025-11-23 04:25:27,041 - INFO - COGS Breakdown: 2025-11-23 04:25:27,041 - INFO - Buy Price (incl. shipping): $777,041.18 2025-11-23 04:25:27,041 - INFO - Commission+Fees: $31,107.32 2025-11-23 04:25:27,041 - INFO - Payment Processor: $0.47 2025-11-23 04:25:27,041 - INFO - Credits: -$30,040.61 2025-11-23 04:25:27,041 - INFO - Loss: $20,954.83 2025-11-23 04:25:27,041 - INFO - Total COGS: $754,405.65 2025-11-23 04:25:27,041 - INFO - Gross Margin: $859,517.06 (53.26%) 2025-11-23 04:25:27,041 - INFO - Web: 2025-11-23 04:25:27,041 - INFO - Orders: 1699 2025-11-23 04:25:27,041 - INFO - Revenue: $209,433.25 2025-11-23 04:25:27,041 - INFO - COGS Breakdown: 2025-11-23 04:25:27,041 - INFO - Buy Price (incl. shipping): $75,007.65 2025-11-23 04:25:27,041 - INFO - Commission+Fees: $10,960.40 2025-11-23 04:25:27,041 - INFO - Payment Processor: $3,372.11 2025-11-23 04:25:27,041 - INFO - Credits: -$1,076.95 2025-11-23 04:25:27,041 - INFO - Loss: $9,122.67 2025-11-23 04:25:27,041 - INFO - Total COGS: $93,634.04 2025-11-23 04:25:27,041 - INFO - Gross Margin: $115,799.21 (55.29%) 2025-11-23 04:25:27,041 - INFO - eBay: 2025-11-23 04:25:27,041 - INFO - Orders: 116 2025-11-23 04:25:27,041 - INFO - Revenue: $16,994.20 2025-11-23 04:25:27,041 - INFO - COGS Breakdown: 2025-11-23 04:25:27,041 - INFO - Buy Price (incl. shipping): $5,053.75 2025-11-23 04:25:27,041 - INFO - Commission+Fees: $2,828.66 2025-11-23 04:25:27,041 - INFO - Payment Processor: $400.38 2025-11-23 04:25:27,041 - INFO - Credits: -$248.90 2025-11-23 04:25:27,041 - INFO - Loss: $409.83 2025-11-23 04:25:27,041 - INFO - Total COGS: $8,347.52 2025-11-23 04:25:27,041 - INFO - Gross Margin: $8,646.68 (50.88%) 2025-11-23 04:25:27,041 - INFO - ================================================================================ 2025-11-23 04:25:27,041 - INFO - OVERALL TOTALS 2025-11-23 04:25:27,041 - INFO - ================================================================================ 2025-11-23 04:25:27,042 - INFO - Total Orders: 22250 2025-11-23 04:25:27,042 - INFO - Updated: 3465 2025-11-23 04:25:27,042 - INFO - Unchanged: 18785 2025-11-23 04:25:27,042 - INFO - Missing buy price: 5583 2025-11-23 04:25:27,042 - INFO - Total Revenue: $2,416,934.29 2025-11-23 04:25:27,042 - INFO - Total COGS: $1,171,341.69 2025-11-23 04:25:27,042 - INFO - Total Gross Margin: $1,245,592.60 (51.54%) 2025-11-23 04:25:27,042 - INFO - ================================================================================ 2025-11-23 04:25:27,042 - WARNING - ⚠️ 5583 orders have NULL/zero buy price - COGS may be understated 2025-11-23 04:25:27,061 - INFO - ================================================================================ 2025-11-23 04:25:27,061 - INFO - Script completed successfully 2025-11-23 04:25:27,061 - INFO - ================================================================================