2025-11-22 23:35:14,216 - INFO - Log file: /home/centralgoparts/public_html/profitability/logs/final_cogs_20251122_233514.log
2025-11-22 23:35:14,216 - INFO - ================================================================================
2025-11-22 23:35:14,216 - INFO - FINAL COGS CALCULATION - 2025-11-22 23:35:14
2025-11-22 23:35:14,216 - INFO - LIVE MODE
2025-11-22 23:35:14,216 - INFO - ================================================================================
2025-11-22 23:35:14,216 - INFO - Date Range: 2025-07-25 to 2025-11-22 (120 days)
2025-11-22 23:35:14,227 - INFO - ================================================================================
2025-11-22 23:35:14,227 - INFO - Processing: FINAL COGS CALCULATION
2025-11-22 23:35:14,227 - INFO -   Formula: our_buy_price + commission_and_fee + payment_processor_fee
2025-11-22 23:35:14,227 - INFO -            - supplier_credits + loss_amount
2025-11-22 23:35:14,227 - INFO -   Note: our_buy_price already includes shipping & handling
2025-11-22 23:35:14,227 - INFO - ================================================================================
2025-11-22 23:35:14,371 - INFO - Found 9365 orders to calculate COGS
2025-11-22 23:35:14,371 - INFO -   Amazon - Order 111-4107474-7502668:
2025-11-22 23:35:14,371 - INFO -     Sales: $44.95
2025-11-22 23:35:14,371 - INFO -     Buy Price (incl. shipping): $0.00
2025-11-22 23:35:14,371 - INFO -     Commission+Fees: $7.73
2025-11-22 23:35:14,371 - INFO -     Payment Processor: $0.00
2025-11-22 23:35:14,371 - INFO -     Credits: -$0.00
2025-11-22 23:35:14,371 - INFO -     Loss: $0.00 (0.00% of sales)
2025-11-22 23:35:14,371 - INFO -     → COGS: $7.73 (was $0.00)
2025-11-22 23:35:14,371 - INFO -     → Gross Profit: $37.22 (82.80%)
2025-11-22 23:35:14,372 - INFO -   Amazon - Order 111-5397988-8601016:
2025-11-22 23:35:14,372 - INFO -     Sales: $229.95
2025-11-22 23:35:14,372 - INFO -     Buy Price (incl. shipping): $127.20
2025-11-22 23:35:14,372 - INFO -     Commission+Fees: $39.55
2025-11-22 23:35:14,372 - INFO -     Payment Processor: $0.00
2025-11-22 23:35:14,372 - INFO -     Credits: -$0.00
2025-11-22 23:35:14,372 - INFO -     Loss: $0.00 (0.00% of sales)
2025-11-22 23:35:14,372 - INFO -     → COGS: $166.75 (was $0.00)
2025-11-22 23:35:14,372 - INFO -     → Gross Profit: $63.20 (27.48%)
2025-11-22 23:35:14,372 - INFO -   Amazon - Order 112-7902460-0541864:
2025-11-22 23:35:14,372 - INFO -     Sales: $83.95
2025-11-22 23:35:14,372 - INFO -     Buy Price (incl. shipping): $21.26
2025-11-22 23:35:14,372 - INFO -     Commission+Fees: $14.44
2025-11-22 23:35:14,372 - INFO -     Payment Processor: $0.00
2025-11-22 23:35:14,372 - INFO -     Credits: -$0.00
2025-11-22 23:35:14,372 - INFO -     Loss: $4.03 (4.80% of sales)
2025-11-22 23:35:14,373 - INFO -     → COGS: $39.73 (was $0.00)
2025-11-22 23:35:14,373 - INFO -     → Gross Profit: $44.22 (52.67%)
2025-11-22 23:35:14,373 - INFO -   Amazon - Order 111-1979214-1618652:
2025-11-22 23:35:14,373 - INFO -     Sales: $263.95
2025-11-22 23:35:14,373 - INFO -     Buy Price (incl. shipping): $142.56
2025-11-22 23:35:14,373 - INFO -     Commission+Fees: $45.39
2025-11-22 23:35:14,373 - INFO -     Payment Processor: $0.00
2025-11-22 23:35:14,373 - INFO -     Credits: -$0.00
2025-11-22 23:35:14,373 - INFO -     Loss: $14.52 (5.50% of sales)
2025-11-22 23:35:14,373 - INFO -     → COGS: $202.47 (was $0.00)
2025-11-22 23:35:14,373 - INFO -     → Gross Profit: $61.48 (23.29%)
2025-11-22 23:35:14,373 - INFO -   Amazon - Order 114-7444654-7220212:
2025-11-22 23:35:14,373 - INFO -     Sales: $248.95
2025-11-22 23:35:14,373 - INFO -     Buy Price (incl. shipping): $142.71
2025-11-22 23:35:14,373 - INFO -     Commission+Fees: $42.81
2025-11-22 23:35:14,373 - INFO -     Payment Processor: $0.00
2025-11-22 23:35:14,373 - INFO -     Credits: -$0.00
2025-11-22 23:35:14,374 - INFO -     Loss: $0.00 (0.00% of sales)
2025-11-22 23:35:14,374 - INFO -     → COGS: $185.52 (was $0.00)
2025-11-22 23:35:14,374 - INFO -     → Gross Profit: $63.43 (25.48%)
2025-11-22 23:35:14,374 - INFO -   Amazon - Order 112-4455379-5729858:
2025-11-22 23:35:14,374 - INFO -     Sales: $151.50
2025-11-22 23:35:14,374 - INFO -     Buy Price (incl. shipping): $64.45
2025-11-22 23:35:14,374 - INFO -     Commission+Fees: $26.05
2025-11-22 23:35:14,374 - INFO -     Payment Processor: $0.00
2025-11-22 23:35:14,374 - INFO -     Credits: -$0.00
2025-11-22 23:35:14,374 - INFO -     Loss: $0.00 (0.00% of sales)
2025-11-22 23:35:14,374 - INFO -     → COGS: $90.50 (was $0.00)
2025-11-22 23:35:14,374 - INFO -     → Gross Profit: $61.00 (40.26%)
2025-11-22 23:35:14,374 - INFO -   Amazon - Order 112-4455379-5729858:
2025-11-22 23:35:14,374 - INFO -     Sales: $151.50
2025-11-22 23:35:14,374 - INFO -     Buy Price (incl. shipping): $49.30
2025-11-22 23:35:14,374 - INFO -     Commission+Fees: $26.05
2025-11-22 23:35:14,374 - INFO -     Payment Processor: $0.00
2025-11-22 23:35:14,374 - INFO -     Credits: -$49.30
2025-11-22 23:35:14,375 - INFO -     Loss: $0.00 (0.00% of sales)
2025-11-22 23:35:14,375 - INFO -     → COGS: $26.05 (was $0.00)
2025-11-22 23:35:14,375 - INFO -     → Gross Profit: $125.45 (82.81%)
2025-11-22 23:35:14,375 - INFO -   Amazon - Order 111-9318861-2465819:
2025-11-22 23:35:14,375 - INFO -     Sales: $82.95
2025-11-22 23:35:14,375 - INFO -     Buy Price (incl. shipping): $49.02
2025-11-22 23:35:14,375 - INFO -     Commission+Fees: $14.27
2025-11-22 23:35:14,375 - INFO -     Payment Processor: $0.00
2025-11-22 23:35:14,375 - INFO -     Credits: -$0.00
2025-11-22 23:35:14,375 - INFO -     Loss: $2.65 (3.20% of sales)
2025-11-22 23:35:14,375 - INFO -     → COGS: $65.94 (was $0.00)
2025-11-22 23:35:14,375 - INFO -     → Gross Profit: $17.01 (20.50%)
2025-11-22 23:35:14,375 - INFO -   Amazon - Order 113-6758396-8100246:
2025-11-22 23:35:14,375 - INFO -     Sales: $147.94
2025-11-22 23:35:14,375 - INFO -     Buy Price (incl. shipping): $96.08
2025-11-22 23:35:14,375 - INFO -     Commission+Fees: $25.44
2025-11-22 23:35:14,376 - INFO -     Payment Processor: $0.00
2025-11-22 23:35:14,376 - INFO -     Credits: -$0.00
2025-11-22 23:35:14,376 - INFO -     Loss: $7.34 (4.96% of sales)
2025-11-22 23:35:14,376 - INFO -     → COGS: $128.86 (was $0.00)
2025-11-22 23:35:14,376 - INFO -     → Gross Profit: $19.08 (12.90%)
2025-11-22 23:35:14,376 - INFO -   Amazon - Order 114-7141284-1911432:
2025-11-22 23:35:14,376 - INFO -     Sales: $316.95
2025-11-22 23:35:14,376 - INFO -     Buy Price (incl. shipping): $179.01
2025-11-22 23:35:14,376 - INFO -     Commission+Fees: $54.51
2025-11-22 23:35:14,376 - INFO -     Payment Processor: $0.00
2025-11-22 23:35:14,376 - INFO -     Credits: -$0.00
2025-11-22 23:35:14,376 - INFO -     Loss: $21.55 (6.80% of sales)
2025-11-22 23:35:14,376 - INFO -     → COGS: $255.07 (was $0.00)
2025-11-22 23:35:14,376 - INFO -     → Gross Profit: $61.88 (19.52%)
2025-11-22 23:35:14,754 - INFO -   B2B - Order 45129-0045:
2025-11-22 23:35:14,754 - INFO -     Sales: $25.18
2025-11-22 23:35:14,754 - INFO -     Buy Price (incl. shipping): $18.81
2025-11-22 23:35:14,754 - INFO -     Commission+Fees: $0.58
2025-11-22 23:35:14,754 - INFO -     Payment Processor: $0.00
2025-11-22 23:35:14,754 - INFO -     Credits: -$0.00
2025-11-22 23:35:14,754 - INFO -     Loss: $0.00 (0.00% of sales)
2025-11-22 23:35:14,754 - INFO -     → COGS: $19.39 (was $0.00)
2025-11-22 23:35:14,755 - INFO -     → Gross Profit: $5.79 (22.99%)
2025-11-22 23:35:14,755 - INFO -   B2B - Order 45129-0045:
2025-11-22 23:35:14,755 - INFO -     Sales: $27.46
2025-11-22 23:35:14,755 - INFO -     Buy Price (incl. shipping): $20.22
2025-11-22 23:35:14,755 - INFO -     Commission+Fees: $0.63
2025-11-22 23:35:14,755 - INFO -     Payment Processor: $0.00
2025-11-22 23:35:14,755 - INFO -     Credits: -$0.00
2025-11-22 23:35:14,755 - INFO -     Loss: $0.00 (0.00% of sales)
2025-11-22 23:35:14,755 - INFO -     → COGS: $20.85 (was $0.00)
2025-11-22 23:35:14,755 - INFO -     → Gross Profit: $6.61 (24.07%)
2025-11-22 23:35:14,755 - INFO -   B2B - Order 43826-0004:
2025-11-22 23:35:14,755 - INFO -     Sales: $31.34
2025-11-22 23:35:14,755 - INFO -     Buy Price (incl. shipping): $18.80
2025-11-22 23:35:14,755 - INFO -     Commission+Fees: $0.72
2025-11-22 23:35:14,755 - INFO -     Payment Processor: $0.00
2025-11-22 23:35:14,755 - INFO -     Credits: -$0.00
2025-11-22 23:35:14,755 - INFO -     Loss: $0.00 (0.00% of sales)
2025-11-22 23:35:14,756 - INFO -     → COGS: $19.52 (was $0.00)
2025-11-22 23:35:14,756 - INFO -     → Gross Profit: $11.82 (37.72%)
2025-11-22 23:35:14,756 - INFO -   B2B - Order 15527-0009:
2025-11-22 23:35:14,756 - INFO -     Sales: $311.39
2025-11-22 23:35:14,756 - INFO -     Buy Price (incl. shipping): $196.60
2025-11-22 23:35:14,756 - INFO -     Commission+Fees: $7.20
2025-11-22 23:35:14,756 - INFO -     Payment Processor: $0.00
2025-11-22 23:35:14,756 - INFO -     Credits: -$0.00
2025-11-22 23:35:14,756 - INFO -     Loss: $0.00 (0.00% of sales)
2025-11-22 23:35:14,756 - INFO -     → COGS: $203.80 (was $0.00)
2025-11-22 23:35:14,756 - INFO -     → Gross Profit: $107.59 (34.55%)
2025-11-22 23:35:14,756 - INFO -   B2B - Order 07952-0077:
2025-11-22 23:35:14,756 - INFO -     Sales: $58.57
2025-11-22 23:35:14,756 - INFO -     Buy Price (incl. shipping): $21.15
2025-11-22 23:35:14,756 - INFO -     Commission+Fees: $1.35
2025-11-22 23:35:14,756 - INFO -     Payment Processor: $0.00
2025-11-22 23:35:14,756 - INFO -     Credits: -$0.00
2025-11-22 23:35:14,756 - INFO -     Loss: $2.69 (4.60% of sales)
2025-11-22 23:35:14,757 - INFO -     → COGS: $25.19 (was $0.00)
2025-11-22 23:35:14,757 - INFO -     → Gross Profit: $33.38 (56.98%)
2025-11-22 23:35:14,757 - INFO -   B2B - Order 20189-0006:
2025-11-22 23:35:14,757 - INFO -     Sales: $140.00
2025-11-22 23:35:14,757 - INFO -     Buy Price (incl. shipping): $97.25
2025-11-22 23:35:14,757 - INFO -     Commission+Fees: $3.24
2025-11-22 23:35:14,757 - INFO -     Payment Processor: $0.00
2025-11-22 23:35:14,757 - INFO -     Credits: -$0.00
2025-11-22 23:35:14,757 - INFO -     Loss: $0.00 (0.00% of sales)
2025-11-22 23:35:14,757 - INFO -     → COGS: $100.49 (was $0.00)
2025-11-22 23:35:14,757 - INFO -     → Gross Profit: $39.51 (28.22%)
2025-11-22 23:35:14,757 - INFO -   B2B - Order 54509-0006:
2025-11-22 23:35:14,757 - INFO -     Sales: $36.63
2025-11-22 23:35:14,757 - INFO -     Buy Price (incl. shipping): $22.43
2025-11-22 23:35:14,757 - INFO -     Commission+Fees: $0.85
2025-11-22 23:35:14,757 - INFO -     Payment Processor: $0.00
2025-11-22 23:35:14,757 - INFO -     Credits: -$0.00
2025-11-22 23:35:14,757 - INFO -     Loss: $1.21 (3.30% of sales)
2025-11-22 23:35:14,757 - INFO -     → COGS: $24.49 (was $0.00)
2025-11-22 23:35:14,757 - INFO -     → Gross Profit: $12.14 (33.15%)
2025-11-22 23:35:14,758 - INFO -   B2B - Order 36956-0013:
2025-11-22 23:35:14,758 - INFO -     Sales: $215.92
2025-11-22 23:35:14,758 - INFO -     Buy Price (incl. shipping): $129.79
2025-11-22 23:35:14,758 - INFO -     Commission+Fees: $4.99
2025-11-22 23:35:14,758 - INFO -     Payment Processor: $0.00
2025-11-22 23:35:14,758 - INFO -     Credits: -$0.00
2025-11-22 23:35:14,758 - INFO -     Loss: $4.10 (1.90% of sales)
2025-11-22 23:35:14,758 - INFO -     → COGS: $138.88 (was $0.00)
2025-11-22 23:35:14,758 - INFO -     → Gross Profit: $77.04 (35.68%)
2025-11-22 23:35:14,758 - INFO -   B2B - Order 49047-0025:
2025-11-22 23:35:14,758 - INFO -     Sales: $499.16
2025-11-22 23:35:14,758 - INFO -     Buy Price (incl. shipping): $263.27
2025-11-22 23:35:14,758 - INFO -     Commission+Fees: $11.54
2025-11-22 23:35:14,758 - INFO -     Payment Processor: $0.00
2025-11-22 23:35:14,758 - INFO -     Credits: -$0.00
2025-11-22 23:35:14,758 - INFO -     Loss: $5.49 (1.10% of sales)
2025-11-22 23:35:14,758 - INFO -     → COGS: $280.30 (was $0.00)
2025-11-22 23:35:14,758 - INFO -     → Gross Profit: $218.86 (43.85%)
2025-11-22 23:35:14,759 - INFO -   B2B - Order 45290-0064:
2025-11-22 23:35:14,759 - INFO -     Sales: $44.20
2025-11-22 23:35:14,759 - INFO -     Buy Price (incl. shipping): $31.71
2025-11-22 23:35:14,759 - INFO -     Commission+Fees: $1.02
2025-11-22 23:35:14,759 - INFO -     Payment Processor: $0.00
2025-11-22 23:35:14,759 - INFO -     Credits: -$0.00
2025-11-22 23:35:14,759 - INFO -     Loss: $0.00 (0.00% of sales)
2025-11-22 23:35:14,759 - INFO -     → COGS: $32.73 (was $0.00)
2025-11-22 23:35:14,759 - INFO -     → Gross Profit: $11.47 (25.95%)
2025-11-22 23:35:15,976 - INFO -   eBay - Order 04-13652-35215:
2025-11-22 23:35:15,976 - INFO -     Sales: $58.95
2025-11-22 23:35:15,976 - INFO -     Buy Price (incl. shipping): $19.13
2025-11-22 23:35:15,976 - INFO -     Commission+Fees: $13.09
2025-11-22 23:35:15,976 - INFO -     Payment Processor: $2.01
2025-11-22 23:35:15,976 - INFO -     Credits: -$0.00
2025-11-22 23:35:15,976 - INFO -     Loss: $0.00 (0.00% of sales)
2025-11-22 23:35:15,976 - INFO -     → COGS: $34.23 (was $0.00)
2025-11-22 23:35:15,976 - INFO -     → Gross Profit: $24.72 (41.93%)
2025-11-22 23:35:15,976 - INFO -   eBay - Order 09-13645-02998:
2025-11-22 23:35:15,976 - INFO -     Sales: $175.95
2025-11-22 23:35:15,976 - INFO -     Buy Price (incl. shipping): $0.00
2025-11-22 23:35:15,976 - INFO -     Commission+Fees: $39.06
2025-11-22 23:35:15,976 - INFO -     Payment Processor: $5.40
2025-11-22 23:35:15,976 - INFO -     Credits: -$0.00
2025-11-22 23:35:15,976 - INFO -     Loss: $19.53 (11.10% of sales)
2025-11-22 23:35:15,976 - INFO -     → COGS: $63.99 (was $0.00)
2025-11-22 23:35:15,977 - INFO -     → Gross Profit: $111.96 (63.63%)
2025-11-22 23:35:15,977 - INFO -   eBay - Order 18-13620-15037:
2025-11-22 23:35:15,977 - INFO -     Sales: $123.95
2025-11-22 23:35:15,977 - INFO -     Buy Price (incl. shipping): $52.52
2025-11-22 23:35:15,977 - INFO -     Commission+Fees: $27.52
2025-11-22 23:35:15,977 - INFO -     Payment Processor: $3.89
2025-11-22 23:35:15,977 - INFO -     Credits: -$0.00
2025-11-22 23:35:15,977 - INFO -     Loss: $7.34 (5.92% of sales)
2025-11-22 23:35:15,977 - INFO -     → COGS: $91.27 (was $0.00)
2025-11-22 23:35:15,977 - INFO -     → Gross Profit: $32.68 (26.37%)
2025-11-22 23:35:15,977 - INFO -   eBay - Order 03-13637-49182:
2025-11-22 23:35:15,977 - INFO -     Sales: $198.95
2025-11-22 23:35:15,977 - INFO -     Buy Price (incl. shipping): $0.00
2025-11-22 23:35:15,977 - INFO -     Commission+Fees: $44.17
2025-11-22 23:35:15,977 - INFO -     Payment Processor: $6.07
2025-11-22 23:35:15,977 - INFO -     Credits: -$0.00
2025-11-22 23:35:15,977 - INFO -     Loss: $5.77 (2.90% of sales)
2025-11-22 23:35:15,977 - INFO -     → COGS: $56.01 (was $0.00)
2025-11-22 23:35:15,978 - INFO -     → Gross Profit: $142.94 (71.85%)
2025-11-22 23:35:15,978 - INFO -   eBay - Order 03-13637-02125:
2025-11-22 23:35:15,978 - INFO -     Sales: $78.95
2025-11-22 23:35:15,978 - INFO -     Buy Price (incl. shipping): $28.70
2025-11-22 23:35:15,978 - INFO -     Commission+Fees: $17.53
2025-11-22 23:35:15,978 - INFO -     Payment Processor: $2.59
2025-11-22 23:35:15,978 - INFO -     Credits: -$0.00
2025-11-22 23:35:15,978 - INFO -     Loss: $0.00 (0.00% of sales)
2025-11-22 23:35:15,978 - INFO -     → COGS: $48.82 (was $0.00)
2025-11-22 23:35:15,978 - INFO -     → Gross Profit: $30.13 (38.16%)
2025-11-22 23:35:15,978 - INFO -   eBay - Order 04-13630-60972:
2025-11-22 23:35:15,978 - INFO -     Sales: $285.95
2025-11-22 23:35:15,978 - INFO -     Buy Price (incl. shipping): $137.81
2025-11-22 23:35:15,978 - INFO -     Commission+Fees: $63.48
2025-11-22 23:35:15,978 - INFO -     Payment Processor: $8.59
2025-11-22 23:35:15,978 - INFO -     Credits: -$0.00
2025-11-22 23:35:15,979 - INFO -     Loss: $0.00 (0.00% of sales)
2025-11-22 23:35:15,979 - INFO -     → COGS: $209.88 (was $0.00)
2025-11-22 23:35:15,979 - INFO -     → Gross Profit: $76.07 (26.60%)
2025-11-22 23:35:15,979 - INFO -   eBay - Order 09-13620-96209:
2025-11-22 23:35:15,979 - INFO -     Sales: $45.95
2025-11-22 23:35:15,979 - INFO -     Buy Price (incl. shipping): $18.37
2025-11-22 23:35:15,979 - INFO -     Commission+Fees: $10.20
2025-11-22 23:35:15,979 - INFO -     Payment Processor: $1.63
2025-11-22 23:35:15,979 - INFO -     Credits: -$0.00
2025-11-22 23:35:15,979 - INFO -     Loss: $0.00 (0.00% of sales)
2025-11-22 23:35:15,979 - INFO -     → COGS: $30.20 (was $0.00)
2025-11-22 23:35:15,979 - INFO -     → Gross Profit: $15.75 (34.28%)
2025-11-22 23:35:15,979 - INFO -   eBay - Order 03-13629-10493:
2025-11-22 23:35:15,979 - INFO -     Sales: $82.95
2025-11-22 23:35:15,979 - INFO -     Buy Price (incl. shipping): $38.86
2025-11-22 23:35:15,979 - INFO -     Commission+Fees: $18.42
2025-11-22 23:35:15,979 - INFO -     Payment Processor: $2.71
2025-11-22 23:35:15,979 - INFO -     Credits: -$0.00
2025-11-22 23:35:15,980 - INFO -     Loss: $0.00 (0.00% of sales)
2025-11-22 23:35:15,980 - INFO -     → COGS: $59.99 (was $0.00)
2025-11-22 23:35:15,980 - INFO -     → Gross Profit: $22.96 (27.68%)
2025-11-22 23:35:15,980 - INFO -   eBay - Order 17-13610-08657:
2025-11-22 23:35:15,980 - INFO -     Sales: $98.95
2025-11-22 23:35:15,980 - INFO -     Buy Price (incl. shipping): $32.73
2025-11-22 23:35:15,980 - INFO -     Commission+Fees: $21.97
2025-11-22 23:35:15,980 - INFO -     Payment Processor: $3.17
2025-11-22 23:35:15,980 - INFO -     Credits: -$0.00
2025-11-22 23:35:15,980 - INFO -     Loss: $0.00 (0.00% of sales)
2025-11-22 23:35:15,980 - INFO -     → COGS: $57.87 (was $0.00)
2025-11-22 23:35:15,980 - INFO -     → Gross Profit: $41.08 (41.52%)
2025-11-22 23:35:15,980 - INFO -   eBay - Order 27-13596-01952:
2025-11-22 23:35:15,980 - INFO -     Sales: $121.95
2025-11-22 23:35:15,980 - INFO -     Buy Price (incl. shipping): $43.07
2025-11-22 23:35:15,980 - INFO -     Commission+Fees: $27.07
2025-11-22 23:35:15,980 - INFO -     Payment Processor: $3.84
2025-11-22 23:35:15,980 - INFO -     Credits: -$0.00
2025-11-22 23:35:15,980 - INFO -     Loss: $0.00 (0.00% of sales)
2025-11-22 23:35:15,980 - INFO -     → COGS: $73.98 (was $0.00)
2025-11-22 23:35:15,980 - INFO -     → Gross Profit: $47.97 (39.34%)
2025-11-22 23:35:15,987 - INFO -   Web - Order 229629915:
2025-11-22 23:35:15,987 - INFO -     Sales: $73.94
2025-11-22 23:35:15,987 - INFO -     Buy Price (incl. shipping): $47.76
2025-11-22 23:35:15,987 - INFO -     Commission+Fees: $6.29
2025-11-22 23:35:15,987 - INFO -     Payment Processor: $1.99
2025-11-22 23:35:15,987 - INFO -     Credits: -$0.00
2025-11-22 23:35:15,987 - INFO -     Loss: $3.67 (4.96% of sales)
2025-11-22 23:35:15,987 - INFO -     → COGS: $59.71 (was $0.00)
2025-11-22 23:35:15,987 - INFO -     → Gross Profit: $14.23 (19.25%)
2025-11-22 23:35:15,987 - INFO -   Web - Order 229629897:
2025-11-22 23:35:15,987 - INFO -     Sales: $133.19
2025-11-22 23:35:15,987 - INFO -     Buy Price (incl. shipping): $75.17
2025-11-22 23:35:15,987 - INFO -     Commission+Fees: $11.33
2025-11-22 23:35:15,987 - INFO -     Payment Processor: $3.58
2025-11-22 23:35:15,987 - INFO -     Credits: -$0.00
2025-11-22 23:35:15,987 - INFO -     Loss: $0.00 (0.00% of sales)
2025-11-22 23:35:15,987 - INFO -     → COGS: $90.08 (was $0.00)
2025-11-22 23:35:15,987 - INFO -     → Gross Profit: $43.11 (32.37%)
2025-11-22 23:35:15,988 - INFO -   Web - Order 229629897:
2025-11-22 23:35:15,988 - INFO -     Sales: $115.19
2025-11-22 23:35:15,988 - INFO -     Buy Price (incl. shipping): $63.54
2025-11-22 23:35:15,988 - INFO -     Commission+Fees: $9.80
2025-11-22 23:35:15,988 - INFO -     Payment Processor: $3.10
2025-11-22 23:35:15,988 - INFO -     Credits: -$0.00
2025-11-22 23:35:15,988 - INFO -     Loss: $0.00 (0.00% of sales)
2025-11-22 23:35:15,988 - INFO -     → COGS: $76.44 (was $0.00)
2025-11-22 23:35:15,988 - INFO -     → Gross Profit: $38.75 (33.64%)
2025-11-22 23:35:15,988 - INFO -   Web - Order 229629897:
2025-11-22 23:35:15,988 - INFO -     Sales: $135.19
2025-11-22 23:35:15,988 - INFO -     Buy Price (incl. shipping): $76.70
2025-11-22 23:35:15,988 - INFO -     Commission+Fees: $11.50
2025-11-22 23:35:15,988 - INFO -     Payment Processor: $3.64
2025-11-22 23:35:15,988 - INFO -     Credits: -$0.00
2025-11-22 23:35:15,988 - INFO -     Loss: $0.00 (0.00% of sales)
2025-11-22 23:35:15,988 - INFO -     → COGS: $91.84 (was $0.00)
2025-11-22 23:35:15,988 - INFO -     → Gross Profit: $43.35 (32.07%)
2025-11-22 23:35:15,988 - INFO -   Web - Order 229629897:
2025-11-22 23:35:15,988 - INFO -     Sales: $99.19
2025-11-22 23:35:15,988 - INFO -     Buy Price (incl. shipping): $52.14
2025-11-22 23:35:15,988 - INFO -     Commission+Fees: $8.44
2025-11-22 23:35:15,988 - INFO -     Payment Processor: $2.67
2025-11-22 23:35:15,988 - INFO -     Credits: -$0.00
2025-11-22 23:35:15,989 - INFO -     Loss: $5.46 (5.50% of sales)
2025-11-22 23:35:15,989 - INFO -     → COGS: $68.71 (was $0.00)
2025-11-22 23:35:15,989 - INFO -     → Gross Profit: $30.48 (30.73%)
2025-11-22 23:35:15,989 - INFO -   Web - Order 229629902:
2025-11-22 23:35:15,989 - INFO -     Sales: $82.94
2025-11-22 23:35:15,989 - INFO -     Buy Price (incl. shipping): $59.88
2025-11-22 23:35:15,989 - INFO -     Commission+Fees: $7.06
2025-11-22 23:35:15,989 - INFO -     Payment Processor: $2.23
2025-11-22 23:35:15,989 - INFO -     Credits: -$0.00
2025-11-22 23:35:15,989 - INFO -     Loss: $5.64 (6.80% of sales)
2025-11-22 23:35:15,989 - INFO -     → COGS: $74.81 (was $0.00)
2025-11-22 23:35:15,989 - INFO -     → Gross Profit: $8.13 (9.80%)
2025-11-22 23:35:15,989 - INFO -   Web - Order 229629900:
2025-11-22 23:35:15,989 - INFO -     Sales: $26.94
2025-11-22 23:35:15,989 - INFO -     Buy Price (incl. shipping): $12.33
2025-11-22 23:35:15,989 - INFO -     Commission+Fees: $2.29
2025-11-22 23:35:15,989 - INFO -     Payment Processor: $0.72
2025-11-22 23:35:15,989 - INFO -     Credits: -$0.00
2025-11-22 23:35:15,989 - INFO -     Loss: $0.00 (0.00% of sales)
2025-11-22 23:35:15,989 - INFO -     → COGS: $15.34 (was $0.00)
2025-11-22 23:35:15,989 - INFO -     → Gross Profit: $11.60 (43.06%)
2025-11-22 23:35:15,990 - INFO -   Web - Order 229628997:
2025-11-22 23:35:15,990 - INFO -     Sales: $226.94
2025-11-22 23:35:15,990 - INFO -     Buy Price (incl. shipping): $79.90
2025-11-22 23:35:15,990 - INFO -     Commission+Fees: $19.31
2025-11-22 23:35:15,990 - INFO -     Payment Processor: $6.10
2025-11-22 23:35:15,990 - INFO -     Credits: -$0.00
2025-11-22 23:35:15,990 - INFO -     Loss: $24.06 (10.60% of sales)
2025-11-22 23:35:15,990 - INFO -     → COGS: $129.37 (was $0.00)
2025-11-22 23:35:15,990 - INFO -     → Gross Profit: $97.57 (43.00%)
2025-11-22 23:35:15,990 - INFO -   Web - Order 229629880:
2025-11-22 23:35:15,990 - INFO -     Sales: $44.94
2025-11-22 23:35:15,990 - INFO -     Buy Price (incl. shipping): $13.89
2025-11-22 23:35:15,990 - INFO -     Commission+Fees: $3.82
2025-11-22 23:35:15,990 - INFO -     Payment Processor: $1.21
2025-11-22 23:35:15,990 - INFO -     Credits: -$0.00
2025-11-22 23:35:15,990 - INFO -     Loss: $1.03 (2.30% of sales)
2025-11-22 23:35:15,990 - INFO -     → COGS: $19.95 (was $0.00)
2025-11-22 23:35:15,990 - INFO -     → Gross Profit: $24.99 (55.60%)
2025-11-22 23:35:15,990 - INFO -   Web - Order 229629877:
2025-11-22 23:35:15,990 - INFO -     Sales: $98.20
2025-11-22 23:35:15,990 - INFO -     Buy Price (incl. shipping): $56.14
2025-11-22 23:35:15,990 - INFO -     Commission+Fees: $8.36
2025-11-22 23:35:15,991 - INFO -     Payment Processor: $2.64
2025-11-22 23:35:15,991 - INFO -     Credits: -$0.00
2025-11-22 23:35:15,991 - INFO -     Loss: $12.77 (13.00% of sales)
2025-11-22 23:35:15,991 - INFO -     → COGS: $79.91 (was $0.00)
2025-11-22 23:35:15,991 - INFO -     → Gross Profit: $18.29 (18.63%)
2025-11-22 23:35:16,186 - INFO - 
================================================================================
2025-11-22 23:35:16,186 - INFO - COGS CALCULATION SUMMARY BY CHANNEL
2025-11-22 23:35:16,186 - INFO - ================================================================================
2025-11-22 23:35:16,186 - INFO - 
Amazon:
2025-11-22 23:35:16,186 - INFO -   Orders: 1900
2025-11-22 23:35:16,186 - INFO -   Revenue: $253,527.50
2025-11-22 23:35:16,186 - INFO -   COGS Breakdown:
2025-11-22 23:35:16,186 - INFO -     Buy Price (incl. shipping): $110,216.64
2025-11-22 23:35:16,186 - INFO -     Commission+Fees: $42,092.83
2025-11-22 23:35:16,186 - INFO -     Payment Processor: $241.32
2025-11-22 23:35:16,186 - INFO -     Credits: -$227.41
2025-11-22 23:35:16,186 - INFO -     Loss: $10,225.67
2025-11-22 23:35:16,186 - INFO -   Total COGS: $162,549.05
2025-11-22 23:35:16,186 - INFO -   Gross Margin: $90,978.45 (35.89%)
2025-11-22 23:35:16,186 - INFO - 
B2B:
2025-11-22 23:35:16,186 - INFO -   Orders: 6745
2025-11-22 23:35:16,186 - INFO -   Revenue: $674,083.66
2025-11-22 23:35:16,186 - INFO -   COGS Breakdown:
2025-11-22 23:35:16,186 - INFO -     Buy Price (incl. shipping): $396,827.22
2025-11-22 23:35:16,186 - INFO -     Commission+Fees: $16,381.27
2025-11-22 23:35:16,186 - INFO -     Payment Processor: $0.00
2025-11-22 23:35:16,186 - INFO -     Credits: -$2,413.86
2025-11-22 23:35:16,186 - INFO -     Loss: $8,899.87
2025-11-22 23:35:16,186 - INFO -   Total COGS: $419,694.50
2025-11-22 23:35:16,186 - INFO -   Gross Margin: $254,389.16 (37.74%)
2025-11-22 23:35:16,186 - INFO - 
Web:
2025-11-22 23:35:16,186 - INFO -   Orders: 679
2025-11-22 23:35:16,186 - INFO -   Revenue: $77,357.59
2025-11-22 23:35:16,186 - INFO -   COGS Breakdown:
2025-11-22 23:35:16,186 - INFO -     Buy Price (incl. shipping): $38,032.89
2025-11-22 23:35:16,186 - INFO -     Commission+Fees: $5,425.33
2025-11-22 23:35:16,186 - INFO -     Payment Processor: $2,080.84
2025-11-22 23:35:16,186 - INFO -     Credits: -$191.24
2025-11-22 23:35:16,186 - INFO -     Loss: $4,583.55
2025-11-22 23:35:16,186 - INFO -   Total COGS: $49,931.37
2025-11-22 23:35:16,186 - INFO -   Gross Margin: $27,426.22 (35.45%)
2025-11-22 23:35:16,186 - INFO - 
eBay:
2025-11-22 23:35:16,186 - INFO -   Orders: 41
2025-11-22 23:35:16,187 - INFO -   Revenue: $5,119.95
2025-11-22 23:35:16,187 - INFO -   COGS Breakdown:
2025-11-22 23:35:16,187 - INFO -     Buy Price (incl. shipping): $1,928.67
2025-11-22 23:35:16,187 - INFO -     Commission+Fees: $1,016.95
2025-11-22 23:35:16,187 - INFO -     Payment Processor: $160.78
2025-11-22 23:35:16,187 - INFO -     Credits: -$0.00
2025-11-22 23:35:16,187 - INFO -     Loss: $156.02
2025-11-22 23:35:16,187 - INFO -   Total COGS: $3,262.42
2025-11-22 23:35:16,187 - INFO -   Gross Margin: $1,857.53 (36.28%)
2025-11-22 23:35:16,187 - INFO - 
================================================================================
2025-11-22 23:35:16,187 - INFO - OVERALL TOTALS
2025-11-22 23:35:16,187 - INFO - ================================================================================
2025-11-22 23:35:16,187 - INFO - Total Orders: 9365
2025-11-22 23:35:16,187 - INFO - Updated: 9365
2025-11-22 23:35:16,187 - INFO - Unchanged: 0
2025-11-22 23:35:16,187 - INFO - Missing buy price: 797
2025-11-22 23:35:16,187 - INFO - 
Total Revenue: $1,010,088.70
2025-11-22 23:35:16,187 - INFO - Total COGS: $635,437.34
2025-11-22 23:35:16,187 - INFO - Total Gross Margin: $374,651.36 (37.09%)
2025-11-22 23:35:16,187 - INFO - ================================================================================

2025-11-22 23:35:16,187 - WARNING - ⚠️  797 orders have NULL/zero buy price - COGS may be understated
2025-11-22 23:35:16,193 - INFO - 
================================================================================
2025-11-22 23:35:16,193 - INFO - Script completed successfully
2025-11-22 23:35:16,193 - INFO - ================================================================================