2025-11-24 07:18:20,557 - INFO - Log file: /home/centralgoparts/public_html/profitability/logs/final_cogs_20251124_071820.log 2025-11-24 07:18:20,557 - INFO - ================================================================================ 2025-11-24 07:18:20,557 - INFO - FINAL COGS CALCULATION - 2025-11-24 07:18:20 2025-11-24 07:18:20,557 - INFO - LIVE MODE 2025-11-24 07:18:20,557 - INFO - ================================================================================ 2025-11-24 07:18:20,557 - INFO - Date Range: 2025-07-27 to 2025-11-24 (120 days) 2025-11-24 07:18:20,565 - INFO - ================================================================================ 2025-11-24 07:18:20,565 - INFO - Processing: FINAL COGS CALCULATION 2025-11-24 07:18:20,565 - INFO - Formula: our_buy_price + commission_and_fee + payment_processor_fee 2025-11-24 07:18:20,565 - INFO - - supplier_credits 2025-11-24 07:18:20,566 - INFO - Note: our_buy_price already includes shipping & handling 2025-11-24 07:18:20,566 - INFO - ================================================================================ 2025-11-24 07:18:20,807 - INFO - Found 22250 orders to calculate COGS 2025-11-24 07:18:21,150 - INFO - B2B - Order 35916-0073 [Normal]: 2025-11-24 07:18:21,150 - INFO - Sales: $30.23 2025-11-24 07:18:21,150 - INFO - Buy Price (incl. shipping): $0.00 2025-11-24 07:18:21,150 - INFO - Commission+Fees: $0.70 2025-11-24 07:18:21,150 - INFO - Payment Processor: $0.00 2025-11-24 07:18:21,151 - INFO - Credits: -$0.00 2025-11-24 07:18:21,151 - INFO - → COGS: $0.70 (was $1.06) 2025-11-24 07:18:21,151 - INFO - → Gross Profit: $29.53 (97.68%) 2025-11-24 07:18:22,009 - INFO - eBay - Order 26-13838-14637 [Normal]: 2025-11-24 07:18:22,009 - INFO - Sales: $515.95 2025-11-24 07:18:22,009 - INFO - Buy Price (incl. shipping): $30.51 2025-11-24 07:18:22,009 - INFO - Commission+Fees: $114.54 2025-11-24 07:18:22,009 - INFO - Payment Processor: $15.26 2025-11-24 07:18:22,009 - INFO - Credits: -$0.00 2025-11-24 07:18:22,009 - INFO - → COGS: $160.31 (was $183.01) 2025-11-24 07:18:22,009 - INFO - → Gross Profit: $355.64 (68.93%) 2025-11-24 07:18:22,009 - INFO - eBay - Order 03-13856-58490 [Cancelled (Cancelled)]: 2025-11-24 07:18:22,010 - INFO - Sales: $75.95 2025-11-24 07:18:22,010 - INFO - Buy Price (incl. shipping): $0.00 2025-11-24 07:18:22,010 - INFO - Commission+Fees: $0.00 2025-11-24 07:18:22,010 - INFO - Payment Processor: $0.00 2025-11-24 07:18:22,010 - INFO - Credits: -$0.00 2025-11-24 07:18:22,010 - INFO - → COGS: $0.00 (was $0.00) 2025-11-24 07:18:22,010 - INFO - → Gross Profit: $0.00 (0.00%) 2025-11-24 07:18:22,010 - INFO - eBay - Order 26-13811-24326 [Normal]: 2025-11-24 07:18:22,010 - INFO - Sales: $225.95 2025-11-24 07:18:22,010 - INFO - Buy Price (incl. shipping): $108.99 2025-11-24 07:18:22,010 - INFO - Commission+Fees: $50.16 2025-11-24 07:18:22,010 - INFO - Payment Processor: $6.85 2025-11-24 07:18:22,010 - INFO - Credits: -$0.00 2025-11-24 07:18:22,010 - INFO - → COGS: $166.00 (was $187.47) 2025-11-24 07:18:22,010 - INFO - → Gross Profit: $59.95 (26.53%) 2025-11-24 07:18:22,010 - INFO - eBay - Order 14-13822-84611 [Normal]: 2025-11-24 07:18:22,010 - INFO - Sales: $100.95 2025-11-24 07:18:22,010 - INFO - Buy Price (incl. shipping): $27.69 2025-11-24 07:18:22,010 - INFO - Commission+Fees: $0.00 2025-11-24 07:18:22,010 - INFO - Payment Processor: $0.00 2025-11-24 07:18:22,010 - INFO - Credits: -$0.00 2025-11-24 07:18:22,010 - INFO - → COGS: $27.69 (was $40.81) 2025-11-24 07:18:22,010 - INFO - → Gross Profit: $73.26 (72.57%) 2025-11-24 07:18:22,250 - INFO - ================================================================================ 2025-11-24 07:18:22,250 - INFO - COGS CALCULATION SUMMARY BY CHANNEL 2025-11-24 07:18:22,250 - INFO - ================================================================================ 2025-11-24 07:18:22,250 - INFO - Amazon: 2025-11-24 07:18:22,250 - INFO - Orders: 4371 2025-11-24 07:18:22,250 - INFO - Revenue: $576,584.13 2025-11-24 07:18:22,250 - INFO - COGS Breakdown: 2025-11-24 07:18:22,250 - INFO - Buy Price (incl. shipping): $239,307.85 2025-11-24 07:18:22,250 - INFO - Commission+Fees: $81,751.72 2025-11-24 07:18:22,250 - INFO - Payment Processor: $251.77 2025-11-24 07:18:22,250 - INFO - Credits: -$2,856.07 2025-11-24 07:18:22,250 - INFO - Total COGS: $306,743.55 2025-11-24 07:18:22,250 - INFO - Gross Margin: $269,840.58 (46.80%) 2025-11-24 07:18:22,250 - INFO - B2B: 2025-11-24 07:18:22,250 - INFO - Orders: 16064 2025-11-24 07:18:22,250 - INFO - Revenue: $1,613,922.71 2025-11-24 07:18:22,250 - INFO - COGS Breakdown: 2025-11-24 07:18:22,250 - INFO - Buy Price (incl. shipping): $911,556.42 2025-11-24 07:18:22,250 - INFO - Commission+Fees: $31,107.70 2025-11-24 07:18:22,250 - INFO - Payment Processor: $0.47 2025-11-24 07:18:22,250 - INFO - Credits: -$30,040.61 2025-11-24 07:18:22,250 - INFO - Total COGS: $802,663.54 2025-11-24 07:18:22,250 - INFO - Gross Margin: $811,259.17 (50.27%) 2025-11-24 07:18:22,250 - INFO - Web: 2025-11-24 07:18:22,250 - INFO - Orders: 1699 2025-11-24 07:18:22,250 - INFO - Revenue: $209,433.25 2025-11-24 07:18:22,250 - INFO - COGS Breakdown: 2025-11-24 07:18:22,251 - INFO - Buy Price (incl. shipping): $76,654.27 2025-11-24 07:18:22,251 - INFO - Commission+Fees: $11,002.14 2025-11-24 07:18:22,251 - INFO - Payment Processor: $3,843.86 2025-11-24 07:18:22,251 - INFO - Credits: -$1,076.95 2025-11-24 07:18:22,251 - INFO - Total COGS: $85,527.79 2025-11-24 07:18:22,251 - INFO - Gross Margin: $123,905.46 (59.16%) 2025-11-24 07:18:22,251 - INFO - eBay: 2025-11-24 07:18:22,251 - INFO - Orders: 116 2025-11-24 07:18:22,251 - INFO - Revenue: $16,994.20 2025-11-24 07:18:22,251 - INFO - COGS Breakdown: 2025-11-24 07:18:22,251 - INFO - Buy Price (incl. shipping): $5,733.10 2025-11-24 07:18:22,251 - INFO - Commission+Fees: $2,941.81 2025-11-24 07:18:22,251 - INFO - Payment Processor: $428.08 2025-11-24 07:18:22,251 - INFO - Credits: -$248.90 2025-11-24 07:18:22,251 - INFO - Total COGS: $8,357.52 2025-11-24 07:18:22,251 - INFO - Gross Margin: $8,636.68 (50.82%) 2025-11-24 07:18:22,251 - INFO - ================================================================================ 2025-11-24 07:18:22,251 - INFO - OVERALL TOTALS 2025-11-24 07:18:22,251 - INFO - ================================================================================ 2025-11-24 07:18:22,251 - INFO - Total Orders: 22250 2025-11-24 07:18:22,251 - INFO - Updated: 11461 2025-11-24 07:18:22,251 - INFO - Unchanged: 10789 2025-11-24 07:18:22,251 - INFO - Missing buy price: 3266 2025-11-24 07:18:22,251 - INFO - Total Revenue: $2,416,934.29 2025-11-24 07:18:22,251 - INFO - Total COGS: $1,203,292.40 2025-11-24 07:18:22,251 - INFO - Total Gross Margin: $1,213,641.89 (50.21%) 2025-11-24 07:18:22,251 - INFO - ================================================================================ 2025-11-24 07:18:22,251 - WARNING - ⚠️ 3266 orders have NULL/zero buy price - COGS may be understated 2025-11-24 07:18:22,264 - INFO - ================================================================================ 2025-11-24 07:18:22,264 - INFO - Script completed successfully 2025-11-24 07:18:22,264 - INFO - ================================================================================