2025-11-22 23:53:30,930 - INFO - Log file: /home/centralgoparts/public_html/profitability/logs/final_cogs_20251122_235330.log
2025-11-22 23:53:30,930 - INFO - ================================================================================
2025-11-22 23:53:30,930 - INFO - FINAL COGS CALCULATION - 2025-11-22 23:53:30
2025-11-22 23:53:30,930 - INFO - LIVE MODE
2025-11-22 23:53:30,930 - INFO - ================================================================================
2025-11-22 23:53:30,930 - INFO - Date Range: 2025-07-25 to 2025-11-22 (120 days)
2025-11-22 23:53:30,939 - INFO - ================================================================================
2025-11-22 23:53:30,939 - INFO - Processing: FINAL COGS CALCULATION
2025-11-22 23:53:30,939 - INFO -   Formula: our_buy_price + commission_and_fee + payment_processor_fee
2025-11-22 23:53:30,939 - INFO -            - supplier_credits + loss_amount
2025-11-22 23:53:30,939 - INFO -   Note: our_buy_price already includes shipping & handling
2025-11-22 23:53:30,939 - INFO - ================================================================================
2025-11-22 23:53:31,116 - INFO - Found 17156 orders to calculate COGS
2025-11-22 23:53:31,117 - INFO -   Amazon - Order 111-5300034-2931411:
2025-11-22 23:53:31,117 - INFO -     Sales: $246.95
2025-11-22 23:53:31,117 - INFO -     Buy Price (incl. shipping): $0.00
2025-11-22 23:53:31,117 - INFO -     Commission+Fees: $42.47
2025-11-22 23:53:31,117 - INFO -     Payment Processor: $0.00
2025-11-22 23:53:31,117 - INFO -     Credits: -$0.00
2025-11-22 23:53:31,117 - INFO -     Loss: $0.00 (0.00% of sales)
2025-11-22 23:53:31,117 - INFO -     → COGS: $42.47 (was $0.00)
2025-11-22 23:53:31,117 - INFO -     → Gross Profit: $204.48 (82.80%)
2025-11-22 23:53:31,117 - INFO -   Amazon - Order 114-3940154-1853820:
2025-11-22 23:53:31,117 - INFO -     Sales: $75.95
2025-11-22 23:53:31,117 - INFO -     Buy Price (incl. shipping): $0.00
2025-11-22 23:53:31,117 - INFO -     Commission+Fees: $13.06
2025-11-22 23:53:31,117 - INFO -     Payment Processor: $0.00
2025-11-22 23:53:31,117 - INFO -     Credits: -$0.00
2025-11-22 23:53:31,117 - INFO -     Loss: $0.00 (0.00% of sales)
2025-11-22 23:53:31,117 - INFO -     → COGS: $13.06 (was $0.00)
2025-11-22 23:53:31,117 - INFO -     → Gross Profit: $62.89 (82.80%)
2025-11-22 23:53:31,118 - INFO -   Amazon - Order 113-3970158-0817035:
2025-11-22 23:53:31,118 - INFO -     Sales: $242.95
2025-11-22 23:53:31,118 - INFO -     Buy Price (incl. shipping): $0.00
2025-11-22 23:53:31,118 - INFO -     Commission+Fees: $41.78
2025-11-22 23:53:31,118 - INFO -     Payment Processor: $0.00
2025-11-22 23:53:31,118 - INFO -     Credits: -$0.00
2025-11-22 23:53:31,118 - INFO -     Loss: $0.00 (0.00% of sales)
2025-11-22 23:53:31,118 - INFO -     → COGS: $41.78 (was $0.00)
2025-11-22 23:53:31,118 - INFO -     → Gross Profit: $201.17 (82.80%)
2025-11-22 23:53:31,118 - INFO -   Amazon - Order 112-6521375-0985843:
2025-11-22 23:53:31,118 - INFO -     Sales: $67.95
2025-11-22 23:53:31,118 - INFO -     Buy Price (incl. shipping): $0.00
2025-11-22 23:53:31,118 - INFO -     Commission+Fees: $11.69
2025-11-22 23:53:31,118 - INFO -     Payment Processor: $0.00
2025-11-22 23:53:31,118 - INFO -     Credits: -$0.00
2025-11-22 23:53:31,118 - INFO -     Loss: $0.00 (0.00% of sales)
2025-11-22 23:53:31,118 - INFO -     → COGS: $11.69 (was $0.00)
2025-11-22 23:53:31,118 - INFO -     → Gross Profit: $56.26 (82.80%)
2025-11-22 23:53:31,118 - INFO -   Amazon - Order 112-9385906-4383456:
2025-11-22 23:53:31,118 - INFO -     Sales: $134.95
2025-11-22 23:53:31,118 - INFO -     Buy Price (incl. shipping): $0.00
2025-11-22 23:53:31,118 - INFO -     Commission+Fees: $23.21
2025-11-22 23:53:31,118 - INFO -     Payment Processor: $0.00
2025-11-22 23:53:31,118 - INFO -     Credits: -$0.00
2025-11-22 23:53:31,118 - INFO -     Loss: $0.00 (0.00% of sales)
2025-11-22 23:53:31,118 - INFO -     → COGS: $23.21 (was $0.00)
2025-11-22 23:53:31,118 - INFO -     → Gross Profit: $111.74 (82.80%)
2025-11-22 23:53:31,119 - INFO -   Amazon - Order 112-9651157-2935433:
2025-11-22 23:53:31,119 - INFO -     Sales: $80.95
2025-11-22 23:53:31,119 - INFO -     Buy Price (incl. shipping): $0.00
2025-11-22 23:53:31,119 - INFO -     Commission+Fees: $13.92
2025-11-22 23:53:31,119 - INFO -     Payment Processor: $0.00
2025-11-22 23:53:31,119 - INFO -     Credits: -$0.00
2025-11-22 23:53:31,119 - INFO -     Loss: $0.00 (0.00% of sales)
2025-11-22 23:53:31,119 - INFO -     → COGS: $13.92 (was $0.00)
2025-11-22 23:53:31,119 - INFO -     → Gross Profit: $67.03 (82.80%)
2025-11-22 23:53:31,119 - INFO -   Amazon - Order 111-1983015-0997048:
2025-11-22 23:53:31,119 - INFO -     Sales: $160.95
2025-11-22 23:53:31,119 - INFO -     Buy Price (incl. shipping): $0.00
2025-11-22 23:53:31,119 - INFO -     Commission+Fees: $27.68
2025-11-22 23:53:31,119 - INFO -     Payment Processor: $0.00
2025-11-22 23:53:31,119 - INFO -     Credits: -$0.00
2025-11-22 23:53:31,119 - INFO -     Loss: $0.00 (0.00% of sales)
2025-11-22 23:53:31,119 - INFO -     → COGS: $27.68 (was $0.00)
2025-11-22 23:53:31,119 - INFO -     → Gross Profit: $133.27 (82.80%)
2025-11-22 23:53:31,119 - INFO -   Amazon - Order 114-6586112-3029027:
2025-11-22 23:53:31,119 - INFO -     Sales: $80.95
2025-11-22 23:53:31,119 - INFO -     Buy Price (incl. shipping): $0.00
2025-11-22 23:53:31,119 - INFO -     Commission+Fees: $13.92
2025-11-22 23:53:31,119 - INFO -     Payment Processor: $0.00
2025-11-22 23:53:31,119 - INFO -     Credits: -$0.00
2025-11-22 23:53:31,119 - INFO -     Loss: $0.00 (0.00% of sales)
2025-11-22 23:53:31,119 - INFO -     → COGS: $13.92 (was $0.00)
2025-11-22 23:53:31,120 - INFO -     → Gross Profit: $67.03 (82.80%)
2025-11-22 23:53:31,120 - INFO -   Amazon - Order 113-2815405-0592220:
2025-11-22 23:53:31,120 - INFO -     Sales: $43.95
2025-11-22 23:53:31,120 - INFO -     Buy Price (incl. shipping): $0.00
2025-11-22 23:53:31,120 - INFO -     Commission+Fees: $7.56
2025-11-22 23:53:31,120 - INFO -     Payment Processor: $0.00
2025-11-22 23:53:31,120 - INFO -     Credits: -$0.00
2025-11-22 23:53:31,120 - INFO -     Loss: $0.00 (0.00% of sales)
2025-11-22 23:53:31,120 - INFO -     → COGS: $7.56 (was $0.00)
2025-11-22 23:53:31,120 - INFO -     → Gross Profit: $36.39 (82.80%)
2025-11-22 23:53:31,120 - INFO -   Amazon - Order 114-1877043-3527402:
2025-11-22 23:53:31,120 - INFO -     Sales: $42.95
2025-11-22 23:53:31,120 - INFO -     Buy Price (incl. shipping): $0.00
2025-11-22 23:53:31,120 - INFO -     Commission+Fees: $7.39
2025-11-22 23:53:31,120 - INFO -     Payment Processor: $0.00
2025-11-22 23:53:31,120 - INFO -     Credits: -$0.00
2025-11-22 23:53:31,120 - INFO -     Loss: $0.00 (0.00% of sales)
2025-11-22 23:53:31,120 - INFO -     → COGS: $7.39 (was $0.00)
2025-11-22 23:53:31,120 - INFO -     → Gross Profit: $35.56 (82.79%)
2025-11-22 23:53:31,597 - INFO -   B2B - Order 35671-0057:
2025-11-22 23:53:31,597 - INFO -     Sales: $82.22
2025-11-22 23:53:31,597 - INFO -     Buy Price (incl. shipping): $0.00
2025-11-22 23:53:31,597 - INFO -     Commission+Fees: $1.90
2025-11-22 23:53:31,597 - INFO -     Payment Processor: $0.00
2025-11-22 23:53:31,597 - INFO -     Credits: -$0.00
2025-11-22 23:53:31,597 - INFO -     Loss: $0.00 (0.00% of sales)
2025-11-22 23:53:31,597 - INFO -     → COGS: $1.90 (was $0.00)
2025-11-22 23:53:31,597 - INFO -     → Gross Profit: $80.32 (97.69%)
2025-11-22 23:53:31,597 - INFO -   B2B - Order 35362-0032:
2025-11-22 23:53:31,597 - INFO -     Sales: $74.34
2025-11-22 23:53:31,597 - INFO -     Buy Price (incl. shipping): $0.00
2025-11-22 23:53:31,597 - INFO -     Commission+Fees: $1.72
2025-11-22 23:53:31,597 - INFO -     Payment Processor: $0.00
2025-11-22 23:53:31,597 - INFO -     Credits: -$0.00
2025-11-22 23:53:31,598 - INFO -     Loss: $0.00 (0.00% of sales)
2025-11-22 23:53:31,598 - INFO -     → COGS: $1.72 (was $0.00)
2025-11-22 23:53:31,598 - INFO -     → Gross Profit: $72.62 (97.69%)
2025-11-22 23:53:31,598 - INFO -   B2B - Order 42906-0064:
2025-11-22 23:53:31,598 - INFO -     Sales: $127.70
2025-11-22 23:53:31,598 - INFO -     Buy Price (incl. shipping): $0.00
2025-11-22 23:53:31,598 - INFO -     Commission+Fees: $2.95
2025-11-22 23:53:31,598 - INFO -     Payment Processor: $0.00
2025-11-22 23:53:31,598 - INFO -     Credits: -$0.00
2025-11-22 23:53:31,598 - INFO -     Loss: $0.00 (0.00% of sales)
2025-11-22 23:53:31,598 - INFO -     → COGS: $2.95 (was $0.00)
2025-11-22 23:53:31,598 - INFO -     → Gross Profit: $124.75 (97.69%)
2025-11-22 23:53:31,598 - INFO -   B2B - Order 37162-0065:
2025-11-22 23:53:31,598 - INFO -     Sales: $112.52
2025-11-22 23:53:31,598 - INFO -     Buy Price (incl. shipping): $0.00
2025-11-22 23:53:31,598 - INFO -     Commission+Fees: $2.60
2025-11-22 23:53:31,598 - INFO -     Payment Processor: $0.00
2025-11-22 23:53:31,598 - INFO -     Credits: -$0.00
2025-11-22 23:53:31,598 - INFO -     Loss: $0.00 (0.00% of sales)
2025-11-22 23:53:31,598 - INFO -     → COGS: $2.60 (was $0.00)
2025-11-22 23:53:31,598 - INFO -     → Gross Profit: $109.92 (97.69%)
2025-11-22 23:53:31,599 - INFO -   B2B - Order 39038-0050:
2025-11-22 23:53:31,599 - INFO -     Sales: $43.35
2025-11-22 23:53:31,599 - INFO -     Buy Price (incl. shipping): $32.02
2025-11-22 23:53:31,599 - INFO -     Commission+Fees: $1.00
2025-11-22 23:53:31,599 - INFO -     Payment Processor: $0.00
2025-11-22 23:53:31,599 - INFO -     Credits: -$0.00
2025-11-22 23:53:31,599 - INFO -     Loss: $0.00 (0.00% of sales)
2025-11-22 23:53:31,599 - INFO -     → COGS: $33.02 (was $0.00)
2025-11-22 23:53:31,599 - INFO -     → Gross Profit: $10.33 (23.83%)
2025-11-22 23:53:31,599 - INFO -   B2B - Order 39038-0050:
2025-11-22 23:53:31,599 - INFO -     Sales: $70.22
2025-11-22 23:53:31,599 - INFO -     Buy Price (incl. shipping): $50.62
2025-11-22 23:53:31,599 - INFO -     Commission+Fees: $1.62
2025-11-22 23:53:31,599 - INFO -     Payment Processor: $0.00
2025-11-22 23:53:31,599 - INFO -     Credits: -$0.00
2025-11-22 23:53:31,599 - INFO -     Loss: $0.00 (0.00% of sales)
2025-11-22 23:53:31,599 - INFO -     → COGS: $52.24 (was $0.00)
2025-11-22 23:53:31,599 - INFO -     → Gross Profit: $17.98 (25.61%)
2025-11-22 23:53:31,599 - INFO -   B2B - Order 39038-0050:
2025-11-22 23:53:31,599 - INFO -     Sales: $63.60
2025-11-22 23:53:31,599 - INFO -     Buy Price (incl. shipping): $53.62
2025-11-22 23:53:31,599 - INFO -     Commission+Fees: $1.47
2025-11-22 23:53:31,599 - INFO -     Payment Processor: $0.00
2025-11-22 23:53:31,599 - INFO -     Credits: -$0.00
2025-11-22 23:53:31,599 - INFO -     Loss: $0.00 (0.00% of sales)
2025-11-22 23:53:31,599 - INFO -     → COGS: $55.09 (was $0.00)
2025-11-22 23:53:31,599 - INFO -     → Gross Profit: $8.51 (13.38%)
2025-11-22 23:53:31,600 - INFO -   B2B - Order 35916-0073:
2025-11-22 23:53:31,600 - INFO -     Sales: $30.23
2025-11-22 23:53:31,600 - INFO -     Buy Price (incl. shipping): $0.00
2025-11-22 23:53:31,600 - INFO -     Commission+Fees: $0.70
2025-11-22 23:53:31,600 - INFO -     Payment Processor: $0.00
2025-11-22 23:53:31,600 - INFO -     Credits: -$0.00
2025-11-22 23:53:31,600 - INFO -     Loss: $0.36 (1.20% of sales)
2025-11-22 23:53:31,600 - INFO -     → COGS: $1.06 (was $0.00)
2025-11-22 23:53:31,600 - INFO -     → Gross Profit: $29.17 (96.48%)
2025-11-22 23:53:31,600 - INFO -   B2B - Order 57170-0014:
2025-11-22 23:53:31,600 - INFO -     Sales: $64.40
2025-11-22 23:53:31,600 - INFO -     Buy Price (incl. shipping): $40.67
2025-11-22 23:53:31,600 - INFO -     Commission+Fees: $1.49
2025-11-22 23:53:31,600 - INFO -     Payment Processor: $0.00
2025-11-22 23:53:31,600 - INFO -     Credits: -$0.00
2025-11-22 23:53:31,600 - INFO -     Loss: $0.00 (0.00% of sales)
2025-11-22 23:53:31,600 - INFO -     → COGS: $42.16 (was $0.00)
2025-11-22 23:53:31,600 - INFO -     → Gross Profit: $22.24 (34.53%)
2025-11-22 23:53:31,600 - INFO -   B2B - Order 40151-0139:
2025-11-22 23:53:31,600 - INFO -     Sales: $82.63
2025-11-22 23:53:31,600 - INFO -     Buy Price (incl. shipping): $52.17
2025-11-22 23:53:31,600 - INFO -     Commission+Fees: $1.91
2025-11-22 23:53:31,600 - INFO -     Payment Processor: $0.00
2025-11-22 23:53:31,600 - INFO -     Credits: -$0.00
2025-11-22 23:53:31,600 - INFO -     Loss: $0.00 (0.00% of sales)
2025-11-22 23:53:31,600 - INFO -     → COGS: $54.08 (was $0.00)
2025-11-22 23:53:31,600 - INFO -     → Gross Profit: $28.55 (34.55%)
2025-11-22 23:53:33,434 - INFO -   eBay - Order 26-13838-14637:
2025-11-22 23:53:33,434 - INFO -     Sales: $515.95
2025-11-22 23:53:33,434 - INFO -     Buy Price (incl. shipping): $30.51
2025-11-22 23:53:33,434 - INFO -     Commission+Fees: $114.54
2025-11-22 23:53:33,434 - INFO -     Payment Processor: $15.26
2025-11-22 23:53:33,434 - INFO -     Credits: -$0.00
2025-11-22 23:53:33,434 - INFO -     Loss: $22.70 (4.40% of sales)
2025-11-22 23:53:33,434 - INFO -     → COGS: $183.01 (was $0.00)
2025-11-22 23:53:33,434 - INFO -     → Gross Profit: $332.94 (64.53%)
2025-11-22 23:53:33,434 - INFO -   eBay - Order 24-13843-98252:
2025-11-22 23:53:33,434 - INFO -     Sales: $101.95
2025-11-22 23:53:33,434 - INFO -     Buy Price (incl. shipping): $38.59
2025-11-22 23:53:33,434 - INFO -     Commission+Fees: $22.63
2025-11-22 23:53:33,434 - INFO -     Payment Processor: $3.26
2025-11-22 23:53:33,434 - INFO -     Credits: -$0.00
2025-11-22 23:53:33,434 - INFO -     Loss: $0.00 (0.00% of sales)
2025-11-22 23:53:33,434 - INFO -     → COGS: $64.48 (was $0.00)
2025-11-22 23:53:33,435 - INFO -     → Gross Profit: $37.47 (36.75%)
2025-11-22 23:53:33,435 - INFO -   eBay - Order 13-13838-38665:
2025-11-22 23:53:33,435 - INFO -     Sales: $336.95
2025-11-22 23:53:33,435 - INFO -     Buy Price (incl. shipping): $100.08
2025-11-22 23:53:33,435 - INFO -     Commission+Fees: $74.80
2025-11-22 23:53:33,435 - INFO -     Payment Processor: $10.07
2025-11-22 23:53:33,435 - INFO -     Credits: -$0.00
2025-11-22 23:53:33,435 - INFO -     Loss: $0.00 (0.00% of sales)
2025-11-22 23:53:33,435 - INFO -     → COGS: $184.95 (was $0.00)
2025-11-22 23:53:33,435 - INFO -     → Gross Profit: $152.00 (45.11%)
2025-11-22 23:53:33,435 - INFO -   eBay - Order 20-13827-27148:
2025-11-22 23:53:33,435 - INFO -     Sales: $128.95
2025-11-22 23:53:33,435 - INFO -     Buy Price (incl. shipping): $48.02
2025-11-22 23:53:33,435 - INFO -     Commission+Fees: $28.63
2025-11-22 23:53:33,435 - INFO -     Payment Processor: $4.04
2025-11-22 23:53:33,435 - INFO -     Credits: -$0.00
2025-11-22 23:53:33,435 - INFO -     Loss: $0.00 (0.00% of sales)
2025-11-22 23:53:33,435 - INFO -     → COGS: $80.69 (was $0.00)
2025-11-22 23:53:33,435 - INFO -     → Gross Profit: $48.26 (37.43%)
2025-11-22 23:53:33,435 - INFO -   eBay - Order 16-13826-63476:
2025-11-22 23:53:33,435 - INFO -     Sales: $338.95
2025-11-22 23:53:33,435 - INFO -     Buy Price (incl. shipping): $152.57
2025-11-22 23:53:33,435 - INFO -     Commission+Fees: $75.25
2025-11-22 23:53:33,435 - INFO -     Payment Processor: $10.13
2025-11-22 23:53:33,435 - INFO -     Credits: -$0.00
2025-11-22 23:53:33,435 - INFO -     Loss: $0.00 (0.00% of sales)
2025-11-22 23:53:33,436 - INFO -     → COGS: $237.95 (was $0.00)
2025-11-22 23:53:33,436 - INFO -     → Gross Profit: $101.00 (29.80%)
2025-11-22 23:53:33,436 - INFO -   eBay - Order 26-13811-24326:
2025-11-22 23:53:33,436 - INFO -     Sales: $225.95
2025-11-22 23:53:33,436 - INFO -     Buy Price (incl. shipping): $108.99
2025-11-22 23:53:33,436 - INFO -     Commission+Fees: $50.16
2025-11-22 23:53:33,436 - INFO -     Payment Processor: $6.85
2025-11-22 23:53:33,436 - INFO -     Credits: -$0.00
2025-11-22 23:53:33,436 - INFO -     Loss: $21.47 (9.50% of sales)
2025-11-22 23:53:33,436 - INFO -     → COGS: $187.47 (was $0.00)
2025-11-22 23:53:33,436 - INFO -     → Gross Profit: $38.48 (17.03%)
2025-11-22 23:53:33,436 - INFO -   eBay - Order 17-13816-44560:
2025-11-22 23:53:33,436 - INFO -     Sales: $338.95
2025-11-22 23:53:33,436 - INFO -     Buy Price (incl. shipping): $152.58
2025-11-22 23:53:33,436 - INFO -     Commission+Fees: $75.25
2025-11-22 23:53:33,436 - INFO -     Payment Processor: $10.13
2025-11-22 23:53:33,436 - INFO -     Credits: -$0.00
2025-11-22 23:53:33,436 - INFO -     Loss: $0.00 (0.00% of sales)
2025-11-22 23:53:33,436 - INFO -     → COGS: $237.96 (was $0.00)
2025-11-22 23:53:33,436 - INFO -     → Gross Profit: $100.99 (29.79%)
2025-11-22 23:53:33,436 - INFO -   eBay - Order 23-13798-85919:
2025-11-22 23:53:33,436 - INFO -     Sales: $100.95
2025-11-22 23:53:33,436 - INFO -     Buy Price (incl. shipping): $37.79
2025-11-22 23:53:33,436 - INFO -     Commission+Fees: $22.41
2025-11-22 23:53:33,436 - INFO -     Payment Processor: $3.23
2025-11-22 23:53:33,437 - INFO -     Credits: -$0.00
2025-11-22 23:53:33,437 - INFO -     Loss: $0.00 (0.00% of sales)
2025-11-22 23:53:33,437 - INFO -     → COGS: $63.43 (was $0.00)
2025-11-22 23:53:33,437 - INFO -     → Gross Profit: $37.52 (37.17%)
2025-11-22 23:53:33,437 - INFO -   eBay - Order 06-13819-12896:
2025-11-22 23:53:33,437 - INFO -     Sales: $150.95
2025-11-22 23:53:33,437 - INFO -     Buy Price (incl. shipping): $60.36
2025-11-22 23:53:33,437 - INFO -     Commission+Fees: $33.51
2025-11-22 23:53:33,437 - INFO -     Payment Processor: $4.68
2025-11-22 23:53:33,437 - INFO -     Credits: -$0.00
2025-11-22 23:53:33,437 - INFO -     Loss: $0.00 (0.00% of sales)
2025-11-22 23:53:33,437 - INFO -     → COGS: $98.55 (was $0.00)
2025-11-22 23:53:33,437 - INFO -     → Gross Profit: $52.40 (34.71%)
2025-11-22 23:53:33,437 - INFO -   eBay - Order 15-13801-10931:
2025-11-22 23:53:33,437 - INFO -     Sales: $77.95
2025-11-22 23:53:33,437 - INFO -     Buy Price (incl. shipping): $33.67
2025-11-22 23:53:33,437 - INFO -     Commission+Fees: $17.31
2025-11-22 23:53:33,437 - INFO -     Payment Processor: $2.56
2025-11-22 23:53:33,437 - INFO -     Credits: -$0.00
2025-11-22 23:53:33,437 - INFO -     Loss: $6.00 (7.70% of sales)
2025-11-22 23:53:33,437 - INFO -     → COGS: $59.54 (was $0.00)
2025-11-22 23:53:33,437 - INFO -     → Gross Profit: $18.41 (23.61%)
2025-11-22 23:53:33,449 - INFO -   Web - Order 229634726:
2025-11-22 23:53:33,449 - INFO -     Sales: $61.95
2025-11-22 23:53:33,449 - INFO -     Buy Price (incl. shipping): $0.00
2025-11-22 23:53:33,449 - INFO -     Commission+Fees: $5.27
2025-11-22 23:53:33,449 - INFO -     Payment Processor: $1.67
2025-11-22 23:53:33,449 - INFO -     Credits: -$0.00
2025-11-22 23:53:33,449 - INFO -     Loss: $0.00 (0.00% of sales)
2025-11-22 23:53:33,449 - INFO -     → COGS: $6.94 (was $0.00)
2025-11-22 23:53:33,449 - INFO -     → Gross Profit: $55.01 (88.80%)
2025-11-22 23:53:33,449 - INFO -   Web - Order 229634723:
2025-11-22 23:53:33,449 - INFO -     Sales: $66.95
2025-11-22 23:53:33,449 - INFO -     Buy Price (incl. shipping): $0.00
2025-11-22 23:53:33,449 - INFO -     Commission+Fees: $5.70
2025-11-22 23:53:33,449 - INFO -     Payment Processor: $1.80
2025-11-22 23:53:33,449 - INFO -     Credits: -$0.00
2025-11-22 23:53:33,449 - INFO -     Loss: $0.00 (0.00% of sales)
2025-11-22 23:53:33,449 - INFO -     → COGS: $7.50 (was $0.00)
2025-11-22 23:53:33,449 - INFO -     → Gross Profit: $59.45 (88.80%)
2025-11-22 23:53:33,450 - INFO -   Web - Order 229634721:
2025-11-22 23:53:33,450 - INFO -     Sales: $125.95
2025-11-22 23:53:33,450 - INFO -     Buy Price (incl. shipping): $0.00
2025-11-22 23:53:33,450 - INFO -     Commission+Fees: $10.72
2025-11-22 23:53:33,450 - INFO -     Payment Processor: $3.39
2025-11-22 23:53:33,450 - INFO -     Credits: -$0.00
2025-11-22 23:53:33,450 - INFO -     Loss: $0.00 (0.00% of sales)
2025-11-22 23:53:33,450 - INFO -     → COGS: $14.11 (was $0.00)
2025-11-22 23:53:33,450 - INFO -     → Gross Profit: $111.84 (88.80%)
2025-11-22 23:53:33,450 - INFO -   Web - Order 229634711:
2025-11-22 23:53:33,450 - INFO -     Sales: $102.95
2025-11-22 23:53:33,450 - INFO -     Buy Price (incl. shipping): $0.00
2025-11-22 23:53:33,450 - INFO -     Commission+Fees: $8.76
2025-11-22 23:53:33,450 - INFO -     Payment Processor: $2.77
2025-11-22 23:53:33,450 - INFO -     Credits: -$0.00
2025-11-22 23:53:33,450 - INFO -     Loss: $0.00 (0.00% of sales)
2025-11-22 23:53:33,450 - INFO -     → COGS: $11.53 (was $0.00)
2025-11-22 23:53:33,450 - INFO -     → Gross Profit: $91.42 (88.80%)
2025-11-22 23:53:33,450 - INFO -   Web - Order 229634709:
2025-11-22 23:53:33,450 - INFO -     Sales: $129.95
2025-11-22 23:53:33,450 - INFO -     Buy Price (incl. shipping): $0.00
2025-11-22 23:53:33,450 - INFO -     Commission+Fees: $11.06
2025-11-22 23:53:33,450 - INFO -     Payment Processor: $3.50
2025-11-22 23:53:33,450 - INFO -     Credits: -$0.00
2025-11-22 23:53:33,450 - INFO -     Loss: $0.00 (0.00% of sales)
2025-11-22 23:53:33,450 - INFO -     → COGS: $14.56 (was $0.00)
2025-11-22 23:53:33,450 - INFO -     → Gross Profit: $115.39 (88.80%)
2025-11-22 23:53:33,451 - INFO -   Web - Order 229634700:
2025-11-22 23:53:33,451 - INFO -     Sales: $99.95
2025-11-22 23:53:33,451 - INFO -     Buy Price (incl. shipping): $0.00
2025-11-22 23:53:33,451 - INFO -     Commission+Fees: $8.50
2025-11-22 23:53:33,451 - INFO -     Payment Processor: $2.69
2025-11-22 23:53:33,451 - INFO -     Credits: -$0.00
2025-11-22 23:53:33,451 - INFO -     Loss: $0.00 (0.00% of sales)
2025-11-22 23:53:33,451 - INFO -     → COGS: $11.19 (was $0.00)
2025-11-22 23:53:33,451 - INFO -     → Gross Profit: $88.76 (88.80%)
2025-11-22 23:53:33,451 - INFO -   Web - Order 229634700:
2025-11-22 23:53:33,451 - INFO -     Sales: $24.95
2025-11-22 23:53:33,451 - INFO -     Buy Price (incl. shipping): $0.00
2025-11-22 23:53:33,451 - INFO -     Commission+Fees: $2.12
2025-11-22 23:53:33,451 - INFO -     Payment Processor: $0.67
2025-11-22 23:53:33,451 - INFO -     Credits: -$0.00
2025-11-22 23:53:33,451 - INFO -     Loss: $0.00 (0.00% of sales)
2025-11-22 23:53:33,451 - INFO -     → COGS: $2.79 (was $0.00)
2025-11-22 23:53:33,451 - INFO -     → Gross Profit: $22.16 (88.82%)
2025-11-22 23:53:33,451 - INFO -   Web - Order 229634690:
2025-11-22 23:53:33,451 - INFO -     Sales: $144.56
2025-11-22 23:53:33,451 - INFO -     Buy Price (incl. shipping): $0.00
2025-11-22 23:53:33,451 - INFO -     Commission+Fees: $12.30
2025-11-22 23:53:33,451 - INFO -     Payment Processor: $3.89
2025-11-22 23:53:33,451 - INFO -     Credits: -$0.00
2025-11-22 23:53:33,451 - INFO -     Loss: $18.79 (13.00% of sales)
2025-11-22 23:53:33,451 - INFO -     → COGS: $34.98 (was $0.00)
2025-11-22 23:53:33,451 - INFO -     → Gross Profit: $109.58 (75.80%)
2025-11-22 23:53:33,452 - INFO -   Web - Order 229634690:
2025-11-22 23:53:33,452 - INFO -     Sales: $139.39
2025-11-22 23:53:33,452 - INFO -     Buy Price (incl. shipping): $0.00
2025-11-22 23:53:33,452 - INFO -     Commission+Fees: $11.86
2025-11-22 23:53:33,452 - INFO -     Payment Processor: $3.75
2025-11-22 23:53:33,452 - INFO -     Credits: -$0.00
2025-11-22 23:53:33,452 - INFO -     Loss: $18.12 (13.00% of sales)
2025-11-22 23:53:33,452 - INFO -     → COGS: $33.73 (was $0.00)
2025-11-22 23:53:33,452 - INFO -     → Gross Profit: $105.66 (75.80%)
2025-11-22 23:53:33,452 - INFO -   Web - Order 229634674:
2025-11-22 23:53:33,543 - INFO -     Sales: $10.95
2025-11-22 23:53:33,543 - INFO -     Buy Price (incl. shipping): $0.00
2025-11-22 23:53:33,543 - INFO -     Commission+Fees: $0.93
2025-11-22 23:53:33,543 - INFO -     Payment Processor: $0.29
2025-11-22 23:53:33,543 - INFO -     Credits: -$0.00
2025-11-22 23:53:33,543 - INFO -     Loss: $0.00 (0.00% of sales)
2025-11-22 23:53:33,543 - INFO -     → COGS: $1.22 (was $0.00)
2025-11-22 23:53:33,543 - INFO -     → Gross Profit: $9.73 (88.86%)
2025-11-22 23:53:33,800 - INFO - 
================================================================================
2025-11-22 23:53:33,800 - INFO - COGS CALCULATION SUMMARY BY CHANNEL
2025-11-22 23:53:33,800 - INFO - ================================================================================
2025-11-22 23:53:33,800 - INFO - 
Amazon:
2025-11-22 23:53:33,800 - INFO -   Orders: 3382
2025-11-22 23:53:33,800 - INFO -   Revenue: $450,159.49
2025-11-22 23:53:33,800 - INFO -   COGS Breakdown:
2025-11-22 23:53:33,800 - INFO -     Buy Price (incl. shipping): $191,385.61
2025-11-22 23:53:33,800 - INFO -     Commission+Fees: $76,804.53
2025-11-22 23:53:33,800 - INFO -     Payment Processor: $15.18
2025-11-22 23:53:33,800 - INFO -     Credits: -$517.42
2025-11-22 23:53:33,800 - INFO -     Loss: $18,776.56
2025-11-22 23:53:33,800 - INFO -   Total COGS: $286,464.46
2025-11-22 23:53:33,800 - INFO -   Gross Margin: $163,695.03 (36.36%)
2025-11-22 23:53:33,800 - INFO - 
B2B:
2025-11-22 23:53:33,800 - INFO -   Orders: 12578
2025-11-22 23:53:33,800 - INFO -   Revenue: $1,226,887.57
2025-11-22 23:53:33,800 - INFO -   COGS Breakdown:
2025-11-22 23:53:33,800 - INFO -     Buy Price (incl. shipping): $689,013.52
2025-11-22 23:53:33,800 - INFO -     Commission+Fees: $31,107.32
2025-11-22 23:53:33,800 - INFO -     Payment Processor: $0.47
2025-11-22 23:53:33,800 - INFO -     Credits: -$3,765.33
2025-11-22 23:53:33,800 - INFO -     Loss: $16,372.85
2025-11-22 23:53:33,800 - INFO -   Total COGS: $732,728.83
2025-11-22 23:53:33,800 - INFO -   Gross Margin: $494,158.74 (40.28%)
2025-11-22 23:53:33,800 - INFO - 
Web:
2025-11-22 23:53:33,800 - INFO -   Orders: 1105
2025-11-22 23:53:33,800 - INFO -   Revenue: $133,416.88
2025-11-22 23:53:33,800 - INFO -   COGS Breakdown:
2025-11-22 23:53:33,800 - INFO -     Buy Price (incl. shipping): $63,168.58
2025-11-22 23:53:33,800 - INFO -     Commission+Fees: $10,960.40
2025-11-22 23:53:33,800 - INFO -     Payment Processor: $3,372.11
2025-11-22 23:53:33,800 - INFO -     Credits: -$350.98
2025-11-22 23:53:33,800 - INFO -     Loss: $7,782.68
2025-11-22 23:53:33,800 - INFO -   Total COGS: $84,932.79
2025-11-22 23:53:33,800 - INFO -   Gross Margin: $48,484.09 (36.34%)
2025-11-22 23:53:33,800 - INFO - 
eBay:
2025-11-22 23:53:33,800 - INFO -   Orders: 91
2025-11-22 23:53:33,800 - INFO -   Revenue: $13,145.45
2025-11-22 23:53:33,800 - INFO -   COGS Breakdown:
2025-11-22 23:53:33,800 - INFO -     Buy Price (incl. shipping): $4,624.61
2025-11-22 23:53:33,800 - INFO -     Commission+Fees: $2,828.66
2025-11-22 23:53:33,801 - INFO -     Payment Processor: $400.38
2025-11-22 23:53:33,801 - INFO -     Credits: -$0.00
2025-11-22 23:53:33,801 - INFO -     Loss: $327.56
2025-11-22 23:53:33,801 - INFO -   Total COGS: $8,181.21
2025-11-22 23:53:33,801 - INFO -   Gross Margin: $4,964.24 (37.76%)
2025-11-22 23:53:33,801 - INFO - 
================================================================================
2025-11-22 23:53:33,801 - INFO - OVERALL TOTALS
2025-11-22 23:53:33,801 - INFO - ================================================================================
2025-11-22 23:53:33,801 - INFO - Total Orders: 17156
2025-11-22 23:53:33,801 - INFO - Updated: 17156
2025-11-22 23:53:33,801 - INFO - Unchanged: 0
2025-11-22 23:53:33,801 - INFO - Missing buy price: 2241
2025-11-22 23:53:33,801 - INFO - 
Total Revenue: $1,823,609.39
2025-11-22 23:53:33,801 - INFO - Total COGS: $1,112,307.29
2025-11-22 23:53:33,801 - INFO - Total Gross Margin: $711,302.10 (39.01%)
2025-11-22 23:53:33,801 - INFO - ================================================================================

2025-11-22 23:53:33,801 - WARNING - ⚠️  2241 orders have NULL/zero buy price - COGS may be understated
2025-11-22 23:53:33,810 - INFO - 
================================================================================
2025-11-22 23:53:33,810 - INFO - Script completed successfully
2025-11-22 23:53:33,810 - INFO - ================================================================================