2025-11-25 06:48:28,588 - INFO - Log file: /home/centralgoparts/public_html/profitability/logs/final_cogs_20251125_064828.log 2025-11-25 06:48:28,588 - INFO - ================================================================================ 2025-11-25 06:48:28,588 - INFO - FINAL COGS CALCULATION - 2025-11-25 06:48:28 2025-11-25 06:48:28,588 - INFO - LIVE MODE 2025-11-25 06:48:28,588 - INFO - ================================================================================ 2025-11-25 06:48:28,588 - INFO - Date Range: 2025-07-28 to 2025-11-25 (120 days) 2025-11-25 06:48:28,597 - INFO - ================================================================================ 2025-11-25 06:48:28,597 - INFO - Processing: FINAL COGS CALCULATION (matches frontend formula) 2025-11-25 06:48:28,597 - INFO - Formula: our_buy_price + (sales_price * commission%) 2025-11-25 06:48:28,597 - INFO - + ad_fees + payment_processor_fee + repayment_fees 2025-11-25 06:48:28,597 - INFO - + additional_cost + amazon_additional + label_cost 2025-11-25 06:48:28,597 - INFO - - supplier_credits - carrier_credits 2025-11-25 06:48:28,597 - INFO - Note: our_buy_price already includes shipping & handling 2025-11-25 06:48:28,597 - INFO - ================================================================================ 2025-11-25 06:48:28,938 - INFO - Found 22250 orders to calculate COGS 2025-11-25 06:48:28,939 - INFO - Amazon - Order 112-7580077-9273032 [Normal]: 2025-11-25 06:48:28,939 - INFO - Sales: $74.95 2025-11-25 06:48:28,939 - INFO - Buy Price (incl. shipping): $20.32 2025-11-25 06:48:28,939 - INFO - Commission (12.0%): $8.99 2025-11-25 06:48:28,939 - INFO - Ad Fees: $3.14 2025-11-25 06:48:28,939 - INFO - Payment Processor: $0.00 2025-11-25 06:48:28,939 - INFO - Repayment Fees: $0.00 2025-11-25 06:48:28,939 - INFO - Additional Costs: +$0.00 2025-11-25 06:48:28,939 - INFO - Label Costs: +$0.00 2025-11-25 06:48:28,939 - INFO - Supplier Credits: -$0.00 2025-11-25 06:48:28,939 - INFO - Carrier Credits: -$0.00 2025-11-25 06:48:28,939 - INFO - → COGS: $32.45 (was $12.13) 2025-11-25 06:48:28,939 - INFO - → Gross Profit: $42.50 (56.70%) 2025-11-25 06:48:29,038 - INFO - B2B - Order 35916-0073 [Normal]: 2025-11-25 06:48:29,038 - INFO - Sales: $30.23 2025-11-25 06:48:29,038 - INFO - Buy Price (incl. shipping): $19.59 2025-11-25 06:48:29,038 - INFO - Commission (1.84%): $0.56 2025-11-25 06:48:29,038 - INFO - Ad Fees: $0.00 2025-11-25 06:48:29,038 - INFO - Payment Processor: $0.00 2025-11-25 06:48:29,039 - INFO - Repayment Fees: $0.00 2025-11-25 06:48:29,039 - INFO - Additional Costs: +$0.00 2025-11-25 06:48:29,039 - INFO - Label Costs: +$0.00 2025-11-25 06:48:29,039 - INFO - Supplier Credits: -$0.00 2025-11-25 06:48:29,039 - INFO - Carrier Credits: -$0.00 2025-11-25 06:48:29,039 - INFO - → COGS: $20.15 (was $0.56) 2025-11-25 06:48:29,039 - INFO - → Gross Profit: $10.08 (33.36%) 2025-11-25 06:48:29,429 - INFO - eBay - Order 03-13878-25869 [Normal]: 2025-11-25 06:48:29,430 - INFO - Sales: $131.95 2025-11-25 06:48:29,430 - INFO - Buy Price (incl. shipping): $49.63 2025-11-25 06:48:29,430 - INFO - Commission (16.35%): $21.57 2025-11-25 06:48:29,430 - INFO - Ad Fees: $6.11 2025-11-25 06:48:29,430 - INFO - Payment Processor: $4.13 2025-11-25 06:48:29,430 - INFO - Repayment Fees: $0.00 2025-11-25 06:48:29,430 - INFO - Additional Costs: +$0.00 2025-11-25 06:48:29,430 - INFO - Label Costs: +$0.00 2025-11-25 06:48:29,430 - INFO - Supplier Credits: -$0.00 2025-11-25 06:48:29,430 - INFO - Carrier Credits: -$0.00 2025-11-25 06:48:29,430 - INFO - → COGS: $81.44 (was $31.81) 2025-11-25 06:48:29,430 - INFO - → Gross Profit: $50.51 (38.28%) 2025-11-25 06:48:29,430 - INFO - eBay - Order 03-13856-58490 [Cancelled (Cancelled)]: 2025-11-25 06:48:29,430 - INFO - Sales: $75.95 2025-11-25 06:48:29,430 - INFO - Buy Price (incl. shipping): $0.00 2025-11-25 06:48:29,430 - INFO - Commission (16.35%): $12.42 2025-11-25 06:48:29,430 - INFO - Ad Fees: $3.51 2025-11-25 06:48:29,430 - INFO - Payment Processor: $0.00 2025-11-25 06:48:29,430 - INFO - Repayment Fees: $0.00 2025-11-25 06:48:29,430 - INFO - Additional Costs: +$0.00 2025-11-25 06:48:29,430 - INFO - Label Costs: +$0.00 2025-11-25 06:48:29,430 - INFO - Supplier Credits: -$0.00 2025-11-25 06:48:29,430 - INFO - Carrier Credits: -$0.00 2025-11-25 06:48:29,430 - INFO - → COGS: $15.93 (was $15.93) 2025-11-25 06:48:29,430 - INFO - → Gross Profit: $-15.93 (-20.97%) 2025-11-25 06:48:29,433 - INFO - Web - Order 229634769 [Normal]: 2025-11-25 06:48:29,433 - INFO - Sales: $10.95 2025-11-25 06:48:29,433 - INFO - Buy Price (incl. shipping): $8.67 2025-11-25 06:48:29,433 - INFO - Commission (0.0%): $0.00 2025-11-25 06:48:29,433 - INFO - Ad Fees: $0.63 2025-11-25 06:48:29,433 - INFO - Payment Processor: $0.29 2025-11-25 06:48:29,433 - INFO - Repayment Fees: $0.00 2025-11-25 06:48:29,433 - INFO - Additional Costs: +$0.00 2025-11-25 06:48:29,433 - INFO - Label Costs: +$0.00 2025-11-25 06:48:29,433 - INFO - Supplier Credits: -$0.00 2025-11-25 06:48:29,433 - INFO - Carrier Credits: -$0.00 2025-11-25 06:48:29,433 - INFO - → COGS: $9.59 (was $0.92) 2025-11-25 06:48:29,433 - INFO - → Gross Profit: $1.36 (12.42%) 2025-11-25 06:48:29,433 - INFO - Web - Order 229634723 [Normal]: 2025-11-25 06:48:29,433 - INFO - Sales: $66.95 2025-11-25 06:48:29,433 - INFO - Buy Price (incl. shipping): $54.95 2025-11-25 06:48:29,433 - INFO - Commission (0.0%): $0.00 2025-11-25 06:48:29,433 - INFO - Ad Fees: $3.84 2025-11-25 06:48:29,433 - INFO - Payment Processor: $1.80 2025-11-25 06:48:29,433 - INFO - Repayment Fees: $0.00 2025-11-25 06:48:29,433 - INFO - Additional Costs: +$0.00 2025-11-25 06:48:29,433 - INFO - Label Costs: +$0.00 2025-11-25 06:48:29,433 - INFO - Supplier Credits: -$0.00 2025-11-25 06:48:29,433 - INFO - Carrier Credits: -$0.00 2025-11-25 06:48:29,433 - INFO - → COGS: $60.59 (was $5.64) 2025-11-25 06:48:29,433 - INFO - → Gross Profit: $6.36 (9.50%) 2025-11-25 06:48:29,496 - INFO - ================================================================================ 2025-11-25 06:48:29,496 - INFO - COGS CALCULATION SUMMARY BY CHANNEL 2025-11-25 06:48:29,496 - INFO - ================================================================================ 2025-11-25 06:48:29,496 - INFO - Amazon: 2025-11-25 06:48:29,496 - INFO - Orders: 4371 2025-11-25 06:48:29,496 - INFO - Revenue: $576,584.13 2025-11-25 06:48:29,496 - INFO - COGS Breakdown: 2025-11-25 06:48:29,496 - INFO - Buy Price (incl. shipping): $277,712.22 2025-11-25 06:48:29,496 - INFO - Commission: $69,190.10 2025-11-25 06:48:29,496 - INFO - Ad Fees: $23,058.52 2025-11-25 06:48:29,496 - INFO - Payment Processor: $251.77 2025-11-25 06:48:29,496 - INFO - Repayment Fees: $0.00 2025-11-25 06:48:29,496 - INFO - Additional Costs: +$260.06 2025-11-25 06:48:29,497 - INFO - Label Costs: +$-109.10 2025-11-25 06:48:29,497 - INFO - Supplier Credits: -$2,816.48 2025-11-25 06:48:29,497 - INFO - Carrier Credits: -$0.00 2025-11-25 06:48:29,497 - INFO - Total COGS: $347,937.09 2025-11-25 06:48:29,497 - INFO - Gross Margin: $228,647.04 (39.66%) 2025-11-25 06:48:29,497 - INFO - B2B: 2025-11-25 06:48:29,497 - INFO - Orders: 16064 2025-11-25 06:48:29,497 - INFO - Revenue: $1,613,922.71 2025-11-25 06:48:29,497 - INFO - COGS Breakdown: 2025-11-25 06:48:29,497 - INFO - Buy Price (incl. shipping): $964,584.73 2025-11-25 06:48:29,497 - INFO - Commission: $30,461.10 2025-11-25 06:48:29,497 - INFO - Ad Fees: $0.00 2025-11-25 06:48:29,497 - INFO - Payment Processor: $0.47 2025-11-25 06:48:29,497 - INFO - Repayment Fees: $0.00 2025-11-25 06:48:29,497 - INFO - Additional Costs: +$4,321.08 2025-11-25 06:48:29,497 - INFO - Label Costs: +$8,631.65 2025-11-25 06:48:29,497 - INFO - Supplier Credits: -$28,580.25 2025-11-25 06:48:29,497 - INFO - Carrier Credits: -$45.19 2025-11-25 06:48:29,497 - INFO - Total COGS: $859,544.41 2025-11-25 06:48:29,497 - INFO - Gross Margin: $754,378.30 (46.74%) 2025-11-25 06:48:29,497 - INFO - Web: 2025-11-25 06:48:29,497 - INFO - Orders: 1699 2025-11-25 06:48:29,497 - INFO - Revenue: $209,433.25 2025-11-25 06:48:29,497 - INFO - COGS Breakdown: 2025-11-25 06:48:29,497 - INFO - Buy Price (incl. shipping): $99,068.96 2025-11-25 06:48:29,497 - INFO - Commission: $0.00 2025-11-25 06:48:29,497 - INFO - Ad Fees: $11,134.49 2025-11-25 06:48:29,497 - INFO - Payment Processor: $3,843.86 2025-11-25 06:48:29,497 - INFO - Repayment Fees: $0.00 2025-11-25 06:48:29,497 - INFO - Additional Costs: +$55.85 2025-11-25 06:48:29,497 - INFO - Label Costs: +$54.81 2025-11-25 06:48:29,497 - INFO - Supplier Credits: -$923.41 2025-11-25 06:48:29,497 - INFO - Carrier Credits: -$0.00 2025-11-25 06:48:29,497 - INFO - Total COGS: $102,809.52 2025-11-25 06:48:29,497 - INFO - Gross Margin: $106,623.73 (50.91%) 2025-11-25 06:48:29,497 - INFO - eBay: 2025-11-25 06:48:29,497 - INFO - Orders: 116 2025-11-25 06:48:29,497 - INFO - Revenue: $16,994.20 2025-11-25 06:48:29,497 - INFO - COGS Breakdown: 2025-11-25 06:48:29,497 - INFO - Buy Price (incl. shipping): $6,546.79 2025-11-25 06:48:29,497 - INFO - Commission: $2,778.55 2025-11-25 06:48:29,497 - INFO - Ad Fees: $611.73 2025-11-25 06:48:29,497 - INFO - Payment Processor: $428.08 2025-11-25 06:48:29,497 - INFO - Repayment Fees: $0.00 2025-11-25 06:48:29,497 - INFO - Additional Costs: +$0.00 2025-11-25 06:48:29,497 - INFO - Label Costs: +$0.00 2025-11-25 06:48:29,497 - INFO - Supplier Credits: -$248.90 2025-11-25 06:48:29,497 - INFO - Carrier Credits: -$0.00 2025-11-25 06:48:29,497 - INFO - Total COGS: $9,497.35 2025-11-25 06:48:29,497 - INFO - Gross Margin: $7,496.85 (44.11%) 2025-11-25 06:48:29,497 - INFO - ================================================================================ 2025-11-25 06:48:29,497 - INFO - OVERALL TOTALS 2025-11-25 06:48:29,497 - INFO - ================================================================================ 2025-11-25 06:48:29,497 - INFO - Total Orders: 22250 2025-11-25 06:48:29,497 - INFO - Updated: 4096 2025-11-25 06:48:29,497 - INFO - Unchanged: 18154 2025-11-25 06:48:29,498 - INFO - Missing buy price: 1736 2025-11-25 06:48:29,498 - INFO - Total Revenue: $2,416,934.29 2025-11-25 06:48:29,498 - INFO - Total COGS: $1,319,788.37 2025-11-25 06:48:29,498 - INFO - Total Gross Margin: $1,097,145.92 (45.39%) 2025-11-25 06:48:29,498 - INFO - ================================================================================ 2025-11-25 06:48:29,498 - WARNING - ⚠️ 1736 orders have NULL/zero buy price - COGS may be understated 2025-11-25 06:48:29,517 - INFO - ================================================================================ 2025-11-25 06:48:29,518 - INFO - Script completed successfully 2025-11-25 06:48:29,518 - INFO - ================================================================================