2025-11-24 08:16:06,093 - INFO - Log file: /home/centralgoparts/public_html/profitability/logs/final_cogs_20251124_081606.log
2025-11-24 08:16:06,093 - INFO - ================================================================================
2025-11-24 08:16:06,093 - INFO - FINAL COGS CALCULATION - 2025-11-24 08:16:06
2025-11-24 08:16:06,093 - INFO - LIVE MODE
2025-11-24 08:16:06,093 - INFO - ================================================================================
2025-11-24 08:16:06,093 - INFO - Date Range: 2025-07-27 to 2025-11-24 (120 days)
2025-11-24 08:16:06,101 - INFO - ================================================================================
2025-11-24 08:16:06,101 - INFO - Processing: FINAL COGS CALCULATION
2025-11-24 08:16:06,101 - INFO -   Formula: our_buy_price + commission_and_fee + payment_processor_fee
2025-11-24 08:16:06,101 - INFO -            - supplier_credits
2025-11-24 08:16:06,101 - INFO -   Note: our_buy_price already includes shipping & handling
2025-11-24 08:16:06,101 - INFO - ================================================================================
2025-11-24 08:16:06,343 - INFO - Found 22250 orders to calculate COGS
2025-11-24 08:16:06,343 - INFO -   Amazon - Order 112-2384609-9637809 [Normal]:
2025-11-24 08:16:06,344 - INFO -     Sales: $34.50
2025-11-24 08:16:06,344 - INFO -     Buy Price (incl. shipping): $0.00
2025-11-24 08:16:06,344 - INFO -     Commission+Fees: $5.59
2025-11-24 08:16:06,344 - INFO -     Payment Processor: $0.00
2025-11-24 08:16:06,344 - INFO -     Credits: -$0.00
2025-11-24 08:16:06,344 - INFO -     → COGS: $5.59 (was $5.93)
2025-11-24 08:16:06,344 - INFO -     → Gross Profit: $28.91 (83.80%)
2025-11-24 08:16:06,344 - INFO -   Amazon - Order 112-2384609-9637809 [Normal]:
2025-11-24 08:16:06,344 - INFO -     Sales: $34.50
2025-11-24 08:16:06,344 - INFO -     Buy Price (incl. shipping): $0.00
2025-11-24 08:16:06,344 - INFO -     Commission+Fees: $5.59
2025-11-24 08:16:06,344 - INFO -     Payment Processor: $0.00
2025-11-24 08:16:06,344 - INFO -     Credits: -$0.00
2025-11-24 08:16:06,344 - INFO -     → COGS: $5.59 (was $5.93)
2025-11-24 08:16:06,344 - INFO -     → Gross Profit: $28.91 (83.80%)
2025-11-24 08:16:06,344 - INFO -   Amazon - Order 111-8832899-8069043 [Normal]:
2025-11-24 08:16:06,344 - INFO -     Sales: $120.95
2025-11-24 08:16:06,344 - INFO -     Buy Price (incl. shipping): $0.00
2025-11-24 08:16:06,344 - INFO -     Commission+Fees: $19.59
2025-11-24 08:16:06,344 - INFO -     Payment Processor: $0.00
2025-11-24 08:16:06,344 - INFO -     Credits: -$0.00
2025-11-24 08:16:06,344 - INFO -     → COGS: $19.59 (was $20.80)
2025-11-24 08:16:06,344 - INFO -     → Gross Profit: $101.36 (83.80%)
2025-11-24 08:16:06,345 - INFO -   Amazon - Order 112-7580077-9273032 [Normal]:
2025-11-24 08:16:06,345 - INFO -     Sales: $74.95
2025-11-24 08:16:06,345 - INFO -     Buy Price (incl. shipping): $0.00
2025-11-24 08:16:06,345 - INFO -     Commission+Fees: $12.14
2025-11-24 08:16:06,345 - INFO -     Payment Processor: $0.00
2025-11-24 08:16:06,345 - INFO -     Credits: -$0.00
2025-11-24 08:16:06,345 - INFO -     → COGS: $12.14 (was $12.89)
2025-11-24 08:16:06,345 - INFO -     → Gross Profit: $62.81 (83.80%)
2025-11-24 08:16:06,345 - INFO -   Amazon - Order 111-6444989-3525038 [Normal]:
2025-11-24 08:16:06,345 - INFO -     Sales: $206.95
2025-11-24 08:16:06,345 - INFO -     Buy Price (incl. shipping): $0.00
2025-11-24 08:16:06,345 - INFO -     Commission+Fees: $33.51
2025-11-24 08:16:06,345 - INFO -     Payment Processor: $0.00
2025-11-24 08:16:06,345 - INFO -     Credits: -$0.00
2025-11-24 08:16:06,345 - INFO -     → COGS: $33.51 (was $35.59)
2025-11-24 08:16:06,345 - INFO -     → Gross Profit: $173.44 (83.81%)
2025-11-24 08:16:06,345 - INFO -   Amazon - Order 112-0338287-2430662 [Normal]:
2025-11-24 08:16:06,345 - INFO -     Sales: $145.95
2025-11-24 08:16:06,345 - INFO -     Buy Price (incl. shipping): $0.00
2025-11-24 08:16:06,345 - INFO -     Commission+Fees: $23.64
2025-11-24 08:16:06,345 - INFO -     Payment Processor: $0.00
2025-11-24 08:16:06,345 - INFO -     Credits: -$0.00
2025-11-24 08:16:06,345 - INFO -     → COGS: $23.64 (was $25.10)
2025-11-24 08:16:06,345 - INFO -     → Gross Profit: $122.31 (83.80%)
2025-11-24 08:16:06,345 - INFO -   Amazon - Order 114-9572827-5138608 [Normal]:
2025-11-24 08:16:06,346 - INFO -     Sales: $38.95
2025-11-24 08:16:06,346 - INFO -     Buy Price (incl. shipping): $0.00
2025-11-24 08:16:06,346 - INFO -     Commission+Fees: $6.31
2025-11-24 08:16:06,346 - INFO -     Payment Processor: $0.00
2025-11-24 08:16:06,346 - INFO -     Credits: -$0.00
2025-11-24 08:16:06,346 - INFO -     → COGS: $6.31 (was $6.70)
2025-11-24 08:16:06,346 - INFO -     → Gross Profit: $32.64 (83.80%)
2025-11-24 08:16:06,346 - INFO -   Amazon - Order 114-8571312-0163441 [Normal]:
2025-11-24 08:16:06,346 - INFO -     Sales: $232.95
2025-11-24 08:16:06,346 - INFO -     Buy Price (incl. shipping): $0.00
2025-11-24 08:16:06,346 - INFO -     Commission+Fees: $37.72
2025-11-24 08:16:06,346 - INFO -     Payment Processor: $0.00
2025-11-24 08:16:06,346 - INFO -     Credits: -$0.00
2025-11-24 08:16:06,346 - INFO -     → COGS: $37.72 (was $40.06)
2025-11-24 08:16:06,346 - INFO -     → Gross Profit: $195.23 (83.81%)
2025-11-24 08:16:06,346 - INFO -   Amazon - Order 114-8571312-0163441 [Normal]:
2025-11-24 08:16:06,346 - INFO -     Sales: $123.95
2025-11-24 08:16:06,346 - INFO -     Buy Price (incl. shipping): $0.00
2025-11-24 08:16:06,346 - INFO -     Commission+Fees: $20.07
2025-11-24 08:16:06,346 - INFO -     Payment Processor: $0.00
2025-11-24 08:16:06,346 - INFO -     Credits: -$0.00
2025-11-24 08:16:06,346 - INFO -     → COGS: $20.07 (was $21.32)
2025-11-24 08:16:06,346 - INFO -     → Gross Profit: $103.88 (83.81%)
2025-11-24 08:16:06,346 - INFO -   Amazon - Order 113-2934462-8587416 [Normal]:
2025-11-24 08:16:06,346 - INFO -     Sales: $41.95
2025-11-24 08:16:06,346 - INFO -     Buy Price (incl. shipping): $0.00
2025-11-24 08:16:06,346 - INFO -     Commission+Fees: $6.79
2025-11-24 08:16:06,346 - INFO -     Payment Processor: $0.00
2025-11-24 08:16:06,346 - INFO -     Credits: -$0.00
2025-11-24 08:16:06,347 - INFO -     → COGS: $6.79 (was $7.21)
2025-11-24 08:16:06,347 - INFO -     → Gross Profit: $35.16 (83.81%)
2025-11-24 08:16:06,895 - INFO -   B2B - Order 35671-0057 [Normal]:
2025-11-24 08:16:06,895 - INFO -     Sales: $82.22
2025-11-24 08:16:06,895 - INFO -     Buy Price (incl. shipping): $0.00
2025-11-24 08:16:06,895 - INFO -     Commission+Fees: $1.51
2025-11-24 08:16:06,895 - INFO -     Payment Processor: $0.00
2025-11-24 08:16:06,895 - INFO -     Credits: -$0.00
2025-11-24 08:16:06,895 - INFO -     → COGS: $1.51 (was $1.90)
2025-11-24 08:16:06,895 - INFO -     → Gross Profit: $80.71 (98.16%)
2025-11-24 08:16:06,895 - INFO -   B2B - Order 35362-0032 [Normal]:
2025-11-24 08:16:06,895 - INFO -     Sales: $74.34
2025-11-24 08:16:06,895 - INFO -     Buy Price (incl. shipping): $0.00
2025-11-24 08:16:06,895 - INFO -     Commission+Fees: $1.37
2025-11-24 08:16:06,895 - INFO -     Payment Processor: $0.00
2025-11-24 08:16:06,895 - INFO -     Credits: -$0.00
2025-11-24 08:16:06,895 - INFO -     → COGS: $1.37 (was $1.72)
2025-11-24 08:16:06,895 - INFO -     → Gross Profit: $72.97 (98.16%)
2025-11-24 08:16:06,895 - INFO -   B2B - Order 42906-0064 [Normal]:
2025-11-24 08:16:06,895 - INFO -     Sales: $127.70
2025-11-24 08:16:06,896 - INFO -     Buy Price (incl. shipping): $0.00
2025-11-24 08:16:06,896 - INFO -     Commission+Fees: $2.35
2025-11-24 08:16:06,896 - INFO -     Payment Processor: $0.00
2025-11-24 08:16:06,896 - INFO -     Credits: -$0.00
2025-11-24 08:16:06,896 - INFO -     → COGS: $2.35 (was $2.95)
2025-11-24 08:16:06,896 - INFO -     → Gross Profit: $125.35 (98.16%)
2025-11-24 08:16:06,896 - INFO -   B2B - Order 37162-0065 [Normal]:
2025-11-24 08:16:06,896 - INFO -     Sales: $112.52
2025-11-24 08:16:06,896 - INFO -     Buy Price (incl. shipping): $0.00
2025-11-24 08:16:06,896 - INFO -     Commission+Fees: $2.07
2025-11-24 08:16:06,896 - INFO -     Payment Processor: $0.00
2025-11-24 08:16:06,896 - INFO -     Credits: -$0.00
2025-11-24 08:16:06,896 - INFO -     → COGS: $2.07 (was $2.60)
2025-11-24 08:16:06,896 - INFO -     → Gross Profit: $110.45 (98.16%)
2025-11-24 08:16:06,896 - INFO -   B2B - Order 39038-0050 [Normal]:
2025-11-24 08:16:06,896 - INFO -     Sales: $43.35
2025-11-24 08:16:06,896 - INFO -     Buy Price (incl. shipping): $32.02
2025-11-24 08:16:06,896 - INFO -     Commission+Fees: $0.80
2025-11-24 08:16:06,896 - INFO -     Payment Processor: $0.00
2025-11-24 08:16:06,896 - INFO -     Credits: -$0.00
2025-11-24 08:16:06,896 - INFO -     → COGS: $32.82 (was $33.02)
2025-11-24 08:16:06,896 - INFO -     → Gross Profit: $10.53 (24.29%)
2025-11-24 08:16:06,896 - INFO -   B2B - Order 39038-0050 [Normal]:
2025-11-24 08:16:06,896 - INFO -     Sales: $70.22
2025-11-24 08:16:06,896 - INFO -     Buy Price (incl. shipping): $50.62
2025-11-24 08:16:06,896 - INFO -     Commission+Fees: $1.29
2025-11-24 08:16:06,896 - INFO -     Payment Processor: $0.00
2025-11-24 08:16:06,896 - INFO -     Credits: -$0.00
2025-11-24 08:16:06,896 - INFO -     → COGS: $51.91 (was $52.24)
2025-11-24 08:16:06,896 - INFO -     → Gross Profit: $18.31 (26.08%)
2025-11-24 08:16:06,897 - INFO -   B2B - Order 39038-0050 [Normal]:
2025-11-24 08:16:06,897 - INFO -     Sales: $63.60
2025-11-24 08:16:06,897 - INFO -     Buy Price (incl. shipping): $53.62
2025-11-24 08:16:06,897 - INFO -     Commission+Fees: $1.17
2025-11-24 08:16:06,897 - INFO -     Payment Processor: $0.00
2025-11-24 08:16:06,897 - INFO -     Credits: -$0.00
2025-11-24 08:16:06,897 - INFO -     → COGS: $54.79 (was $55.09)
2025-11-24 08:16:06,897 - INFO -     → Gross Profit: $8.81 (13.85%)
2025-11-24 08:16:06,897 - INFO -   B2B - Order 35916-0073 [Normal]:
2025-11-24 08:16:06,897 - INFO -     Sales: $30.23
2025-11-24 08:16:06,897 - INFO -     Buy Price (incl. shipping): $0.00
2025-11-24 08:16:06,897 - INFO -     Commission+Fees: $0.56
2025-11-24 08:16:06,897 - INFO -     Payment Processor: $0.00
2025-11-24 08:16:06,897 - INFO -     Credits: -$0.00
2025-11-24 08:16:06,897 - INFO -     → COGS: $0.56 (was $0.70)
2025-11-24 08:16:06,897 - INFO -     → Gross Profit: $29.67 (98.15%)
2025-11-24 08:16:06,897 - INFO -   B2B - Order 57170-0014 [Normal]:
2025-11-24 08:16:06,897 - INFO -     Sales: $64.40
2025-11-24 08:16:06,897 - INFO -     Buy Price (incl. shipping): $40.67
2025-11-24 08:16:06,897 - INFO -     Commission+Fees: $1.19
2025-11-24 08:16:06,897 - INFO -     Payment Processor: $0.00
2025-11-24 08:16:06,897 - INFO -     Credits: -$0.00
2025-11-24 08:16:06,897 - INFO -     → COGS: $41.86 (was $42.16)
2025-11-24 08:16:06,897 - INFO -     → Gross Profit: $22.54 (35.00%)
2025-11-24 08:16:06,898 - INFO -   B2B - Order 40151-0139 [Normal]:
2025-11-24 08:16:06,898 - INFO -     Sales: $82.63
2025-11-24 08:16:06,898 - INFO -     Buy Price (incl. shipping): $52.17
2025-11-24 08:16:06,898 - INFO -     Commission+Fees: $1.52
2025-11-24 08:16:06,898 - INFO -     Payment Processor: $0.00
2025-11-24 08:16:06,898 - INFO -     Credits: -$0.00
2025-11-24 08:16:06,898 - INFO -     → COGS: $53.69 (was $54.08)
2025-11-24 08:16:06,898 - INFO -     → Gross Profit: $28.94 (35.02%)
2025-11-24 08:16:08,981 - INFO -   eBay - Order 03-13878-25869 [Normal]:
2025-11-24 08:16:08,982 - INFO -     Sales: $131.95
2025-11-24 08:16:08,982 - INFO -     Buy Price (incl. shipping): $0.00
2025-11-24 08:16:08,982 - INFO -     Commission+Fees: $27.68
2025-11-24 08:16:08,982 - INFO -     Payment Processor: $4.13
2025-11-24 08:16:08,982 - INFO -     Credits: -$0.00
2025-11-24 08:16:08,982 - INFO -     → COGS: $31.81 (was $33.42)
2025-11-24 08:16:08,982 - INFO -     → Gross Profit: $100.14 (75.89%)
2025-11-24 08:16:08,982 - INFO -   eBay - Order 26-13838-14637 [Normal]:
2025-11-24 08:16:08,982 - INFO -     Sales: $515.95
2025-11-24 08:16:08,982 - INFO -     Buy Price (incl. shipping): $30.51
2025-11-24 08:16:08,982 - INFO -     Commission+Fees: $108.23
2025-11-24 08:16:08,982 - INFO -     Payment Processor: $15.26
2025-11-24 08:16:08,982 - INFO -     Credits: -$0.00
2025-11-24 08:16:08,982 - INFO -     → COGS: $154.00 (was $160.31)
2025-11-24 08:16:08,982 - INFO -     → Gross Profit: $361.95 (70.15%)
2025-11-24 08:16:08,982 - INFO -   eBay - Order 24-13843-98252 [Normal]:
2025-11-24 08:16:08,982 - INFO -     Sales: $101.95
2025-11-24 08:16:08,982 - INFO -     Buy Price (incl. shipping): $38.59
2025-11-24 08:16:08,982 - INFO -     Commission+Fees: $21.39
2025-11-24 08:16:08,982 - INFO -     Payment Processor: $3.26
2025-11-24 08:16:08,982 - INFO -     Credits: -$0.00
2025-11-24 08:16:08,982 - INFO -     → COGS: $63.24 (was $64.48)
2025-11-24 08:16:08,982 - INFO -     → Gross Profit: $38.71 (37.97%)
2025-11-24 08:16:08,982 - INFO -   eBay - Order 03-13856-58490 [Cancelled (Cancelled)]:
2025-11-24 08:16:08,983 - INFO -     Sales: $75.95
2025-11-24 08:16:08,983 - INFO -     Buy Price (incl. shipping): $0.00
2025-11-24 08:16:08,983 - INFO -     Commission+Fees: $15.93
2025-11-24 08:16:08,983 - INFO -     Payment Processor: $0.00
2025-11-24 08:16:08,983 - INFO -     Credits: -$0.00
2025-11-24 08:16:08,983 - INFO -     → COGS: $15.93 (was $0.00)
2025-11-24 08:16:08,983 - INFO -     → Gross Profit: $-15.93 (-20.97%)
2025-11-24 08:16:08,983 - INFO -   eBay - Order 13-13838-38665 [Normal]:
2025-11-24 08:16:08,983 - INFO -     Sales: $336.95
2025-11-24 08:16:08,983 - INFO -     Buy Price (incl. shipping): $100.08
2025-11-24 08:16:08,983 - INFO -     Commission+Fees: $70.68
2025-11-24 08:16:08,983 - INFO -     Payment Processor: $10.07
2025-11-24 08:16:08,983 - INFO -     Credits: -$0.00
2025-11-24 08:16:08,983 - INFO -     → COGS: $180.83 (was $184.95)
2025-11-24 08:16:08,983 - INFO -     → Gross Profit: $156.12 (46.33%)
2025-11-24 08:16:08,983 - INFO -   eBay - Order 20-13827-27148 [Normal]:
2025-11-24 08:16:08,983 - INFO -     Sales: $128.95
2025-11-24 08:16:08,983 - INFO -     Buy Price (incl. shipping): $48.02
2025-11-24 08:16:08,983 - INFO -     Commission+Fees: $27.05
2025-11-24 08:16:08,983 - INFO -     Payment Processor: $4.04
2025-11-24 08:16:08,983 - INFO -     Credits: -$0.00
2025-11-24 08:16:08,983 - INFO -     → COGS: $79.11 (was $80.69)
2025-11-24 08:16:08,983 - INFO -     → Gross Profit: $49.84 (38.65%)
2025-11-24 08:16:08,983 - INFO -   eBay - Order 16-13826-63476 [Normal]:
2025-11-24 08:16:08,983 - INFO -     Sales: $338.95
2025-11-24 08:16:08,984 - INFO -     Buy Price (incl. shipping): $152.57
2025-11-24 08:16:08,984 - INFO -     Commission+Fees: $71.10
2025-11-24 08:16:08,984 - INFO -     Payment Processor: $10.13
2025-11-24 08:16:08,984 - INFO -     Credits: -$0.00
2025-11-24 08:16:08,984 - INFO -     → COGS: $233.80 (was $237.95)
2025-11-24 08:16:08,984 - INFO -     → Gross Profit: $105.15 (31.02%)
2025-11-24 08:16:08,984 - INFO -   eBay - Order 26-13811-24326 [Normal]:
2025-11-24 08:16:08,984 - INFO -     Sales: $225.95
2025-11-24 08:16:08,984 - INFO -     Buy Price (incl. shipping): $108.99
2025-11-24 08:16:08,984 - INFO -     Commission+Fees: $47.40
2025-11-24 08:16:08,984 - INFO -     Payment Processor: $6.85
2025-11-24 08:16:08,984 - INFO -     Credits: -$0.00
2025-11-24 08:16:08,984 - INFO -     → COGS: $163.24 (was $166.00)
2025-11-24 08:16:08,984 - INFO -     → Gross Profit: $62.71 (27.75%)
2025-11-24 08:16:08,984 - INFO -   eBay - Order 14-13822-84611 [Normal]:
2025-11-24 08:16:08,984 - INFO -     Sales: $100.95
2025-11-24 08:16:08,984 - INFO -     Buy Price (incl. shipping): $27.69
2025-11-24 08:16:08,984 - INFO -     Commission+Fees: $21.18
2025-11-24 08:16:08,984 - INFO -     Payment Processor: $0.00
2025-11-24 08:16:08,984 - INFO -     Credits: -$0.00
2025-11-24 08:16:08,984 - INFO -     → COGS: $48.87 (was $27.69)
2025-11-24 08:16:08,984 - INFO -     → Gross Profit: $52.08 (51.59%)
2025-11-24 08:16:08,984 - INFO -   eBay - Order 17-13816-44560 [Normal]:
2025-11-24 08:16:08,984 - INFO -     Sales: $338.95
2025-11-24 08:16:08,984 - INFO -     Buy Price (incl. shipping): $152.58
2025-11-24 08:16:08,984 - INFO -     Commission+Fees: $71.10
2025-11-24 08:16:08,984 - INFO -     Payment Processor: $10.13
2025-11-24 08:16:08,985 - INFO -     Credits: -$0.00
2025-11-24 08:16:08,985 - INFO -     → COGS: $233.81 (was $237.96)
2025-11-24 08:16:08,985 - INFO -     → Gross Profit: $105.14 (31.02%)
2025-11-24 08:16:08,997 - INFO -   Web - Order 229634862 [Normal]:
2025-11-24 08:16:08,997 - INFO -     Sales: $186.95
2025-11-24 08:16:08,997 - INFO -     Buy Price (incl. shipping): $0.00
2025-11-24 08:16:08,997 - INFO -     Commission+Fees: $10.72
2025-11-24 08:16:08,997 - INFO -     Payment Processor: $5.03
2025-11-24 08:16:08,997 - INFO -     Credits: -$0.00
2025-11-24 08:16:08,997 - INFO -     → COGS: $15.75 (was $20.94)
2025-11-24 08:16:08,997 - INFO -     → Gross Profit: $171.20 (91.58%)
2025-11-24 08:16:08,998 - INFO -   Web - Order 229634851 [Normal]:
2025-11-24 08:16:08,998 - INFO -     Sales: $97.95
2025-11-24 08:16:08,998 - INFO -     Buy Price (incl. shipping): $0.00
2025-11-24 08:16:08,998 - INFO -     Commission+Fees: $5.62
2025-11-24 08:16:08,998 - INFO -     Payment Processor: $2.63
2025-11-24 08:16:08,998 - INFO -     Credits: -$0.00
2025-11-24 08:16:08,998 - INFO -     → COGS: $8.25 (was $10.96)
2025-11-24 08:16:08,998 - INFO -     → Gross Profit: $89.70 (91.58%)
2025-11-24 08:16:08,998 - INFO -   Web - Order 229634838 [Normal]:
2025-11-24 08:16:08,999 - INFO -     Sales: $168.95
2025-11-24 08:16:08,999 - INFO -     Buy Price (incl. shipping): $0.00
2025-11-24 08:16:08,999 - INFO -     Commission+Fees: $9.69
2025-11-24 08:16:08,999 - INFO -     Payment Processor: $4.54
2025-11-24 08:16:08,999 - INFO -     Credits: -$0.00
2025-11-24 08:16:08,999 - INFO -     → COGS: $14.23 (was $18.92)
2025-11-24 08:16:08,999 - INFO -     → Gross Profit: $154.72 (91.58%)
2025-11-24 08:16:08,999 - INFO -   Web - Order 229634827 [Normal]:
2025-11-24 08:16:08,999 - INFO -     Sales: $26.95
2025-11-24 08:16:08,999 - INFO -     Buy Price (incl. shipping): $0.00
2025-11-24 08:16:08,999 - INFO -     Commission+Fees: $1.55
2025-11-24 08:16:08,999 - INFO -     Payment Processor: $0.72
2025-11-24 08:16:08,999 - INFO -     Credits: -$0.00
2025-11-24 08:16:08,999 - INFO -     → COGS: $2.27 (was $3.01)
2025-11-24 08:16:08,999 - INFO -     → Gross Profit: $24.68 (91.58%)
2025-11-24 08:16:08,999 - INFO -   Web - Order 229634769 [Normal]:
2025-11-24 08:16:08,999 - INFO -     Sales: $10.95
2025-11-24 08:16:08,999 - INFO -     Buy Price (incl. shipping): $0.00
2025-11-24 08:16:08,999 - INFO -     Commission+Fees: $0.63
2025-11-24 08:16:08,999 - INFO -     Payment Processor: $0.29
2025-11-24 08:16:08,999 - INFO -     Credits: -$0.00
2025-11-24 08:16:08,999 - INFO -     → COGS: $0.92 (was $1.22)
2025-11-24 08:16:08,999 - INFO -     → Gross Profit: $10.03 (91.60%)
2025-11-24 08:16:08,999 - INFO -   Web - Order 229634726 [Normal]:
2025-11-24 08:16:08,999 - INFO -     Sales: $61.95
2025-11-24 08:16:09,000 - INFO -     Buy Price (incl. shipping): $0.00
2025-11-24 08:16:09,000 - INFO -     Commission+Fees: $3.55
2025-11-24 08:16:09,000 - INFO -     Payment Processor: $1.67
2025-11-24 08:16:09,000 - INFO -     Credits: -$0.00
2025-11-24 08:16:09,000 - INFO -     → COGS: $5.22 (was $6.94)
2025-11-24 08:16:09,000 - INFO -     → Gross Profit: $56.73 (91.57%)
2025-11-24 08:16:09,000 - INFO -   Web - Order 229634723 [Normal]:
2025-11-24 08:16:09,000 - INFO -     Sales: $66.95
2025-11-24 08:16:09,000 - INFO -     Buy Price (incl. shipping): $0.00
2025-11-24 08:16:09,000 - INFO -     Commission+Fees: $3.84
2025-11-24 08:16:09,000 - INFO -     Payment Processor: $1.80
2025-11-24 08:16:09,000 - INFO -     Credits: -$0.00
2025-11-24 08:16:09,000 - INFO -     → COGS: $5.64 (was $7.50)
2025-11-24 08:16:09,000 - INFO -     → Gross Profit: $61.31 (91.58%)
2025-11-24 08:16:09,000 - INFO -   Web - Order 229634721 [Normal]:
2025-11-24 08:16:09,000 - INFO -     Sales: $125.95
2025-11-24 08:16:09,000 - INFO -     Buy Price (incl. shipping): $0.00
2025-11-24 08:16:09,000 - INFO -     Commission+Fees: $7.22
2025-11-24 08:16:09,000 - INFO -     Payment Processor: $3.39
2025-11-24 08:16:09,000 - INFO -     Credits: -$0.00
2025-11-24 08:16:09,000 - INFO -     → COGS: $10.61 (was $14.11)
2025-11-24 08:16:09,000 - INFO -     → Gross Profit: $115.34 (91.58%)
2025-11-24 08:16:09,001 - INFO -   Web - Order 229634732 [Normal]:
2025-11-24 08:16:09,001 - INFO -     Sales: $51.95
2025-11-24 08:16:09,001 - INFO -     Buy Price (incl. shipping): $0.00
2025-11-24 08:16:09,001 - INFO -     Commission+Fees: $2.98
2025-11-24 08:16:09,001 - INFO -     Payment Processor: $0.00
2025-11-24 08:16:09,001 - INFO -     Credits: -$0.00
2025-11-24 08:16:09,001 - INFO -     → COGS: $2.98 (was $0.00)
2025-11-24 08:16:09,001 - INFO -     → Gross Profit: $48.97 (94.26%)
2025-11-24 08:16:09,001 - INFO -   Web - Order 229634711 [Normal]:
2025-11-24 08:16:09,001 - INFO -     Sales: $102.95
2025-11-24 08:16:09,001 - INFO -     Buy Price (incl. shipping): $0.00
2025-11-24 08:16:09,001 - INFO -     Commission+Fees: $5.91
2025-11-24 08:16:09,001 - INFO -     Payment Processor: $2.77
2025-11-24 08:16:09,001 - INFO -     Credits: -$0.00
2025-11-24 08:16:09,001 - INFO -     → COGS: $8.68 (was $11.53)
2025-11-24 08:16:09,001 - INFO -     → Gross Profit: $94.27 (91.57%)
2025-11-24 08:16:09,393 - INFO - 
================================================================================
2025-11-24 08:16:09,393 - INFO - COGS CALCULATION SUMMARY BY CHANNEL
2025-11-24 08:16:09,393 - INFO - ================================================================================
2025-11-24 08:16:09,393 - INFO - 
Amazon:
2025-11-24 08:16:09,393 - INFO -   Orders: 4371
2025-11-24 08:16:09,393 - INFO -   Revenue: $576,584.13
2025-11-24 08:16:09,393 - INFO -   COGS Breakdown:
2025-11-24 08:16:09,393 - INFO -     Buy Price (incl. shipping): $239,307.85
2025-11-24 08:16:09,393 - INFO -     Commission+Fees: $92,146.13
2025-11-24 08:16:09,393 - INFO -     Payment Processor: $251.77
2025-11-24 08:16:09,393 - INFO -     Credits: -$2,856.07
2025-11-24 08:16:09,393 - INFO -   Total COGS: $317,137.96
2025-11-24 08:16:09,393 - INFO -   Gross Margin: $259,446.17 (45.00%)
2025-11-24 08:16:09,393 - INFO - 
B2B:
2025-11-24 08:16:09,393 - INFO -   Orders: 16064
2025-11-24 08:16:09,393 - INFO -   Revenue: $1,613,922.71
2025-11-24 08:16:09,393 - INFO -   COGS Breakdown:
2025-11-24 08:16:09,393 - INFO -     Buy Price (incl. shipping): $911,556.42
2025-11-24 08:16:09,393 - INFO -     Commission+Fees: $30,467.57
2025-11-24 08:16:09,393 - INFO -     Payment Processor: $0.47
2025-11-24 08:16:09,393 - INFO -     Credits: -$30,040.61
2025-11-24 08:16:09,393 - INFO -   Total COGS: $802,023.41
2025-11-24 08:16:09,393 - INFO -   Gross Margin: $811,899.30 (50.31%)
2025-11-24 08:16:09,393 - INFO - 
Web:
2025-11-24 08:16:09,393 - INFO -   Orders: 1699
2025-11-24 08:16:09,393 - INFO -   Revenue: $209,433.25
2025-11-24 08:16:09,393 - INFO -   COGS Breakdown:
2025-11-24 08:16:09,393 - INFO -     Buy Price (incl. shipping): $76,654.27
2025-11-24 08:16:09,393 - INFO -     Commission+Fees: $11,134.49
2025-11-24 08:16:09,393 - INFO -     Payment Processor: $3,843.86
2025-11-24 08:16:09,393 - INFO -     Credits: -$1,076.95
2025-11-24 08:16:09,393 - INFO -   Total COGS: $85,660.14
2025-11-24 08:16:09,393 - INFO -   Gross Margin: $123,773.11 (59.10%)
2025-11-24 08:16:09,393 - INFO - 
eBay:
2025-11-24 08:16:09,393 - INFO -   Orders: 116
2025-11-24 08:16:09,393 - INFO -   Revenue: $16,994.20
2025-11-24 08:16:09,393 - INFO -   COGS Breakdown:
2025-11-24 08:16:09,393 - INFO -     Buy Price (incl. shipping): $5,733.10
2025-11-24 08:16:09,393 - INFO -     Commission+Fees: $3,390.26
2025-11-24 08:16:09,393 - INFO -     Payment Processor: $428.08
2025-11-24 08:16:09,393 - INFO -     Credits: -$248.90
2025-11-24 08:16:09,393 - INFO -   Total COGS: $8,805.97
2025-11-24 08:16:09,393 - INFO -   Gross Margin: $8,188.23 (48.18%)
2025-11-24 08:16:09,393 - INFO - 
================================================================================
2025-11-24 08:16:09,393 - INFO - OVERALL TOTALS
2025-11-24 08:16:09,393 - INFO - ================================================================================
2025-11-24 08:16:09,393 - INFO - Total Orders: 22250
2025-11-24 08:16:09,393 - INFO - Updated: 22221
2025-11-24 08:16:09,394 - INFO - Unchanged: 29
2025-11-24 08:16:09,394 - INFO - Missing buy price: 3266
2025-11-24 08:16:09,394 - INFO - 
Total Revenue: $2,416,934.29
2025-11-24 08:16:09,394 - INFO - Total COGS: $1,213,627.48
2025-11-24 08:16:09,394 - INFO - Total Gross Margin: $1,203,306.81 (49.79%)
2025-11-24 08:16:09,394 - INFO - ================================================================================

2025-11-24 08:16:09,394 - WARNING - ⚠️  3266 orders have NULL/zero buy price - COGS may be understated
2025-11-24 08:16:09,407 - INFO - 
================================================================================
2025-11-24 08:16:09,407 - INFO - Script completed successfully
2025-11-24 08:16:09,407 - INFO - ================================================================================