2025-11-25 05:25:28,821 - INFO - Log file: /home/centralgoparts/public_html/profitability/logs/final_cogs_20251125_052528.log 2025-11-25 05:25:28,821 - INFO - ================================================================================ 2025-11-25 05:25:28,821 - INFO - FINAL COGS CALCULATION - 2025-11-25 05:25:28 2025-11-25 05:25:28,821 - INFO - LIVE MODE 2025-11-25 05:25:28,821 - INFO - ================================================================================ 2025-11-25 05:25:28,821 - INFO - Date Range: 2025-07-28 to 2025-11-25 (120 days) 2025-11-25 05:25:28,829 - INFO - ================================================================================ 2025-11-25 05:25:28,830 - INFO - Processing: FINAL COGS CALCULATION 2025-11-25 05:25:28,830 - INFO - Formula: our_buy_price + commission_and_fee + payment_processor_fee 2025-11-25 05:25:28,830 - INFO - + additional_cost + label_cost 2025-11-25 05:25:28,830 - INFO - - supplier_credits - carrier_credits 2025-11-25 05:25:28,830 - INFO - Note: our_buy_price already includes shipping & handling 2025-11-25 05:25:28,830 - INFO - ================================================================================ 2025-11-25 05:25:29,117 - INFO - Found 22250 orders to calculate COGS 2025-11-25 05:25:29,451 - INFO - eBay - Order 03-13856-58490 [Cancelled (Cancelled)]: 2025-11-25 05:25:29,451 - INFO - Sales: $75.95 2025-11-25 05:25:29,451 - INFO - Buy Price (incl. shipping): $0.00 2025-11-25 05:25:29,451 - INFO - Commission+Fees: $15.93 2025-11-25 05:25:29,451 - INFO - Payment Processor: $0.00 2025-11-25 05:25:29,451 - INFO - Additional Costs: +$0.00 2025-11-25 05:25:29,451 - INFO - Label Costs: +$0.00 2025-11-25 05:25:29,451 - INFO - Supplier Credits: -$0.00 2025-11-25 05:25:29,451 - INFO - Carrier Credits: -$0.00 2025-11-25 05:25:29,451 - INFO - → COGS: $15.93 (was $15.93) 2025-11-25 05:25:29,451 - INFO - → Gross Profit: $-15.93 (-20.97%) 2025-11-25 05:25:29,503 - INFO - ================================================================================ 2025-11-25 05:25:29,503 - INFO - COGS CALCULATION SUMMARY BY CHANNEL 2025-11-25 05:25:29,503 - INFO - ================================================================================ 2025-11-25 05:25:29,504 - INFO - Amazon: 2025-11-25 05:25:29,504 - INFO - Orders: 4371 2025-11-25 05:25:29,504 - INFO - Revenue: $576,584.13 2025-11-25 05:25:29,504 - INFO - COGS Breakdown: 2025-11-25 05:25:29,504 - INFO - Buy Price (incl. shipping): $256,848.30 2025-11-25 05:25:29,504 - INFO - Commission+Fees: $92,146.13 2025-11-25 05:25:29,504 - INFO - Payment Processor: $251.77 2025-11-25 05:25:29,504 - INFO - Additional Costs: +$260.06 2025-11-25 05:25:29,504 - INFO - Label Costs: +$-109.10 2025-11-25 05:25:29,504 - INFO - Supplier Credits: -$2,816.48 2025-11-25 05:25:29,504 - INFO - Carrier Credits: -$0.00 2025-11-25 05:25:29,504 - INFO - Total COGS: $334,129.58 2025-11-25 05:25:29,504 - INFO - Gross Margin: $242,454.55 (42.05%) 2025-11-25 05:25:29,504 - INFO - B2B: 2025-11-25 05:25:29,504 - INFO - Orders: 16064 2025-11-25 05:25:29,504 - INFO - Revenue: $1,613,922.71 2025-11-25 05:25:29,504 - INFO - COGS Breakdown: 2025-11-25 05:25:29,504 - INFO - Buy Price (incl. shipping): $920,190.99 2025-11-25 05:25:29,504 - INFO - Commission+Fees: $30,467.57 2025-11-25 05:25:29,504 - INFO - Payment Processor: $0.47 2025-11-25 05:25:29,504 - INFO - Additional Costs: +$4,321.08 2025-11-25 05:25:29,504 - INFO - Label Costs: +$8,631.65 2025-11-25 05:25:29,504 - INFO - Supplier Credits: -$28,580.25 2025-11-25 05:25:29,504 - INFO - Carrier Credits: -$45.19 2025-11-25 05:25:29,504 - INFO - Total COGS: $825,075.75 2025-11-25 05:25:29,504 - INFO - Gross Margin: $788,846.96 (48.88%) 2025-11-25 05:25:29,504 - INFO - Web: 2025-11-25 05:25:29,504 - INFO - Orders: 1699 2025-11-25 05:25:29,504 - INFO - Revenue: $209,433.25 2025-11-25 05:25:29,504 - INFO - COGS Breakdown: 2025-11-25 05:25:29,504 - INFO - Buy Price (incl. shipping): $86,943.86 2025-11-25 05:25:29,504 - INFO - Commission+Fees: $11,134.49 2025-11-25 05:25:29,504 - INFO - Payment Processor: $3,843.86 2025-11-25 05:25:29,504 - INFO - Additional Costs: +$55.85 2025-11-25 05:25:29,504 - INFO - Label Costs: +$54.81 2025-11-25 05:25:29,504 - INFO - Supplier Credits: -$923.41 2025-11-25 05:25:29,504 - INFO - Carrier Credits: -$0.00 2025-11-25 05:25:29,504 - INFO - Total COGS: $96,178.26 2025-11-25 05:25:29,504 - INFO - Gross Margin: $113,254.99 (54.08%) 2025-11-25 05:25:29,504 - INFO - eBay: 2025-11-25 05:25:29,504 - INFO - Orders: 116 2025-11-25 05:25:29,504 - INFO - Revenue: $16,994.20 2025-11-25 05:25:29,504 - INFO - COGS Breakdown: 2025-11-25 05:25:29,504 - INFO - Buy Price (incl. shipping): $6,374.83 2025-11-25 05:25:29,504 - INFO - Commission+Fees: $3,390.26 2025-11-25 05:25:29,504 - INFO - Payment Processor: $428.08 2025-11-25 05:25:29,504 - INFO - Additional Costs: +$0.00 2025-11-25 05:25:29,504 - INFO - Label Costs: +$0.00 2025-11-25 05:25:29,504 - INFO - Supplier Credits: -$248.90 2025-11-25 05:25:29,504 - INFO - Carrier Credits: -$0.00 2025-11-25 05:25:29,504 - INFO - Total COGS: $9,447.70 2025-11-25 05:25:29,504 - INFO - Gross Margin: $7,546.50 (44.41%) 2025-11-25 05:25:29,505 - INFO - ================================================================================ 2025-11-25 05:25:29,505 - INFO - OVERALL TOTALS 2025-11-25 05:25:29,505 - INFO - ================================================================================ 2025-11-25 05:25:29,505 - INFO - Total Orders: 22250 2025-11-25 05:25:29,505 - INFO - Updated: 3394 2025-11-25 05:25:29,505 - INFO - Unchanged: 18856 2025-11-25 05:25:29,505 - INFO - Missing buy price: 2765 2025-11-25 05:25:29,505 - INFO - Total Revenue: $2,416,934.29 2025-11-25 05:25:29,505 - INFO - Total COGS: $1,264,831.29 2025-11-25 05:25:29,505 - INFO - Total Gross Margin: $1,152,103.00 (47.67%) 2025-11-25 05:25:29,505 - INFO - ================================================================================ 2025-11-25 05:25:29,505 - WARNING - ⚠️ 2765 orders have NULL/zero buy price - COGS may be understated 2025-11-25 05:25:29,519 - INFO - ================================================================================ 2025-11-25 05:25:29,519 - INFO - Script completed successfully 2025-11-25 05:25:29,519 - INFO - ================================================================================