2025-11-22 23:17:07,980 - INFO - Log file: /home/centralgoparts/public_html/profitability/logs/final_cogs_20251122_231707.log
2025-11-22 23:17:07,980 - INFO - ================================================================================
2025-11-22 23:17:07,980 - INFO - FINAL COGS CALCULATION - 2025-11-22 23:17:07
2025-11-22 23:17:07,980 - INFO - LIVE MODE
2025-11-22 23:17:07,980 - INFO - ================================================================================
2025-11-22 23:17:07,980 - INFO - Date Range: 2025-07-25 to 2025-11-22 (120 days)
2025-11-22 23:17:07,988 - INFO - ================================================================================
2025-11-22 23:17:07,988 - INFO - Processing: FINAL COGS CALCULATION
2025-11-22 23:17:07,988 - INFO -   Formula: our_buy_price + commission_and_fee + payment_processor_fee
2025-11-22 23:17:07,988 - INFO -            - supplier_credits + loss_amount
2025-11-22 23:17:07,988 - INFO -   Note: our_buy_price already includes shipping & handling
2025-11-22 23:17:07,988 - INFO - ================================================================================
2025-11-22 23:17:08,041 - INFO - Found 5085 orders to calculate COGS
2025-11-22 23:17:08,042 - INFO -   Amazon - Order 114-2883921-5094625:
2025-11-22 23:17:08,042 - INFO -     Sales: $85.95
2025-11-22 23:17:08,042 - INFO -     Buy Price (incl. shipping): $41.52
2025-11-22 23:17:08,042 - INFO -     Commission+Fees: $0.00
2025-11-22 23:17:08,042 - INFO -     Payment Processor: $0.00
2025-11-22 23:17:08,042 - INFO -     Credits: -$0.00
2025-11-22 23:17:08,042 - INFO -     Loss: $5.84 (6.80% of sales)
2025-11-22 23:17:08,042 - INFO -     → COGS: $47.36 (was $0.00)
2025-11-22 23:17:08,042 - INFO -     → Gross Profit: $38.59 (44.89%)
2025-11-22 23:17:08,042 - INFO -   Amazon - Order 114-9014951-8101841:
2025-11-22 23:17:08,042 - INFO -     Sales: $447.95
2025-11-22 23:17:08,042 - INFO -     Buy Price (incl. shipping): $281.79
2025-11-22 23:17:08,042 - INFO -     Commission+Fees: $0.00
2025-11-22 23:17:08,042 - INFO -     Payment Processor: $0.00
2025-11-22 23:17:08,042 - INFO -     Credits: -$0.00
2025-11-22 23:17:08,042 - INFO -     Loss: $0.00 (0.00% of sales)
2025-11-22 23:17:08,042 - INFO -     → COGS: $281.79 (was $0.00)
2025-11-22 23:17:08,042 - INFO -     → Gross Profit: $166.16 (37.09%)
2025-11-22 23:17:08,043 - INFO -   Amazon - Order 113-4279429-0904210:
2025-11-22 23:17:08,043 - INFO -     Sales: $288.95
2025-11-22 23:17:08,043 - INFO -     Buy Price (incl. shipping): $171.03
2025-11-22 23:17:08,043 - INFO -     Commission+Fees: $0.00
2025-11-22 23:17:08,043 - INFO -     Payment Processor: $0.00
2025-11-22 23:17:08,043 - INFO -     Credits: -$0.00
2025-11-22 23:17:08,043 - INFO -     Loss: $0.00 (0.00% of sales)
2025-11-22 23:17:08,043 - INFO -     → COGS: $171.03 (was $0.00)
2025-11-22 23:17:08,043 - INFO -     → Gross Profit: $117.92 (40.81%)
2025-11-22 23:17:08,043 - INFO -   Amazon - Order 113-9098135-7270644:
2025-11-22 23:17:08,043 - INFO -     Sales: $152.50
2025-11-22 23:17:08,043 - INFO -     Buy Price (incl. shipping): $98.07
2025-11-22 23:17:08,043 - INFO -     Commission+Fees: $0.00
2025-11-22 23:17:08,043 - INFO -     Payment Processor: $0.00
2025-11-22 23:17:08,043 - INFO -     Credits: -$0.00
2025-11-22 23:17:08,043 - INFO -     Loss: $19.82 (13.00% of sales)
2025-11-22 23:17:08,043 - INFO -     → COGS: $117.89 (was $0.00)
2025-11-22 23:17:08,043 - INFO -     → Gross Profit: $34.61 (22.69%)
2025-11-22 23:17:08,043 - INFO -   Amazon - Order 113-9098135-7270644:
2025-11-22 23:17:08,043 - INFO -     Sales: $152.50
2025-11-22 23:17:08,043 - INFO -     Buy Price (incl. shipping): $97.49
2025-11-22 23:17:08,043 - INFO -     Commission+Fees: $0.00
2025-11-22 23:17:08,043 - INFO -     Payment Processor: $0.00
2025-11-22 23:17:08,043 - INFO -     Credits: -$0.00
2025-11-22 23:17:08,043 - INFO -     Loss: $19.82 (13.00% of sales)
2025-11-22 23:17:08,043 - INFO -     → COGS: $117.31 (was $0.00)
2025-11-22 23:17:08,043 - INFO -     → Gross Profit: $35.19 (23.07%)
2025-11-22 23:17:08,044 - INFO -   Amazon - Order 111-6420298-5201808:
2025-11-22 23:17:08,044 - INFO -     Sales: $98.95
2025-11-22 23:17:08,044 - INFO -     Buy Price (incl. shipping): $56.10
2025-11-22 23:17:08,044 - INFO -     Commission+Fees: $0.00
2025-11-22 23:17:08,044 - INFO -     Payment Processor: $0.00
2025-11-22 23:17:08,044 - INFO -     Credits: -$0.00
2025-11-22 23:17:08,044 - INFO -     Loss: $10.49 (10.60% of sales)
2025-11-22 23:17:08,044 - INFO -     → COGS: $66.59 (was $0.00)
2025-11-22 23:17:08,044 - INFO -     → Gross Profit: $32.36 (32.70%)
2025-11-22 23:17:08,044 - INFO -   Amazon - Order 114-8846989-7340230:
2025-11-22 23:17:08,044 - INFO -     Sales: $47.95
2025-11-22 23:17:08,044 - INFO -     Buy Price (incl. shipping): $0.00
2025-11-22 23:17:08,044 - INFO -     Commission+Fees: $0.00
2025-11-22 23:17:08,044 - INFO -     Payment Processor: $0.00
2025-11-22 23:17:08,044 - INFO -     Credits: -$0.00
2025-11-22 23:17:08,044 - INFO -     Loss: $1.39 (2.90% of sales)
2025-11-22 23:17:08,044 - INFO -     → COGS: $1.39 (was $0.00)
2025-11-22 23:17:08,044 - INFO -     → Gross Profit: $46.56 (97.10%)
2025-11-22 23:17:08,044 - INFO -   Amazon - Order 114-3555812-0521042:
2025-11-22 23:17:08,044 - INFO -     Sales: $26.00
2025-11-22 23:17:08,044 - INFO -     Buy Price (incl. shipping): $0.00
2025-11-22 23:17:08,044 - INFO -     Commission+Fees: $0.00
2025-11-22 23:17:08,044 - INFO -     Payment Processor: $0.00
2025-11-22 23:17:08,044 - INFO -     Credits: -$0.00
2025-11-22 23:17:08,044 - INFO -     Loss: $0.60 (2.30% of sales)
2025-11-22 23:17:08,044 - INFO -     → COGS: $0.60 (was $0.00)
2025-11-22 23:17:08,044 - INFO -     → Gross Profit: $25.40 (97.70%)
2025-11-22 23:17:08,045 - INFO -   Amazon - Order 114-3555812-0521042:
2025-11-22 23:17:08,045 - INFO -     Sales: $26.00
2025-11-22 23:17:08,045 - INFO -     Buy Price (incl. shipping): $0.00
2025-11-22 23:17:08,045 - INFO -     Commission+Fees: $0.00
2025-11-22 23:17:08,045 - INFO -     Payment Processor: $0.00
2025-11-22 23:17:08,045 - INFO -     Credits: -$0.00
2025-11-22 23:17:08,045 - INFO -     Loss: $0.60 (2.30% of sales)
2025-11-22 23:17:08,045 - INFO -     → COGS: $0.60 (was $0.00)
2025-11-22 23:17:08,045 - INFO -     → Gross Profit: $25.40 (97.70%)
2025-11-22 23:17:08,045 - INFO -   Amazon - Order 113-0098600-5582648:
2025-11-22 23:17:08,045 - INFO -     Sales: $43.95
2025-11-22 23:17:08,045 - INFO -     Buy Price (incl. shipping): $15.97
2025-11-22 23:17:08,045 - INFO -     Commission+Fees: $0.00
2025-11-22 23:17:08,045 - INFO -     Payment Processor: $0.00
2025-11-22 23:17:08,045 - INFO -     Credits: -$0.00
2025-11-22 23:17:08,045 - INFO -     Loss: $0.00 (0.00% of sales)
2025-11-22 23:17:08,045 - INFO -     → COGS: $15.97 (was $0.00)
2025-11-22 23:17:08,045 - INFO -     → Gross Profit: $27.98 (63.66%)
2025-11-22 23:17:08,193 - INFO -   B2B - Order 38974-0117:
2025-11-22 23:17:08,193 - INFO -     Sales: $44.14
2025-11-22 23:17:08,194 - INFO -     Buy Price (incl. shipping): $28.72
2025-11-22 23:17:08,194 - INFO -     Commission+Fees: $0.00
2025-11-22 23:17:08,194 - INFO -     Payment Processor: $0.00
2025-11-22 23:17:08,194 - INFO -     Credits: -$0.00
2025-11-22 23:17:08,194 - INFO -     Loss: $1.28 (2.90% of sales)
2025-11-22 23:17:08,194 - INFO -     → COGS: $30.00 (was $0.00)
2025-11-22 23:17:08,194 - INFO -     → Gross Profit: $14.14 (32.03%)
2025-11-22 23:17:08,194 - INFO -   B2B - Order 35422-0013:
2025-11-22 23:17:08,194 - INFO -     Sales: $213.94
2025-11-22 23:17:08,194 - INFO -     Buy Price (incl. shipping): $155.90
2025-11-22 23:17:08,194 - INFO -     Commission+Fees: $0.00
2025-11-22 23:17:08,194 - INFO -     Payment Processor: $0.00
2025-11-22 23:17:08,194 - INFO -     Credits: -$0.00
2025-11-22 23:17:08,194 - INFO -     Loss: $13.05 (6.10% of sales)
2025-11-22 23:17:08,194 - INFO -     → COGS: $168.95 (was $0.00)
2025-11-22 23:17:08,194 - INFO -     → Gross Profit: $44.99 (21.03%)
2025-11-22 23:17:08,194 - INFO -   B2B - Order 41918-0013:
2025-11-22 23:17:08,194 - INFO -     Sales: $44.27
2025-11-22 23:17:08,194 - INFO -     Buy Price (incl. shipping): $28.38
2025-11-22 23:17:08,194 - INFO -     Commission+Fees: $0.00
2025-11-22 23:17:08,194 - INFO -     Payment Processor: $0.00
2025-11-22 23:17:08,194 - INFO -     Credits: -$0.00
2025-11-22 23:17:08,194 - INFO -     Loss: $0.00 (0.00% of sales)
2025-11-22 23:17:08,194 - INFO -     → COGS: $28.38 (was $0.00)
2025-11-22 23:17:08,194 - INFO -     → Gross Profit: $15.89 (35.89%)
2025-11-22 23:17:08,194 - INFO -   B2B - Order 39304-0259:
2025-11-22 23:17:08,194 - INFO -     Sales: $41.54
2025-11-22 23:17:08,195 - INFO -     Buy Price (incl. shipping): $30.68
2025-11-22 23:17:08,195 - INFO -     Commission+Fees: $0.00
2025-11-22 23:17:08,195 - INFO -     Payment Processor: $0.00
2025-11-22 23:17:08,195 - INFO -     Credits: -$0.00
2025-11-22 23:17:08,195 - INFO -     Loss: $0.00 (0.00% of sales)
2025-11-22 23:17:08,195 - INFO -     → COGS: $30.68 (was $0.00)
2025-11-22 23:17:08,195 - INFO -     → Gross Profit: $10.86 (26.14%)
2025-11-22 23:17:08,195 - INFO -   B2B - Order 40481-0025:
2025-11-22 23:17:08,195 - INFO -     Sales: $173.45
2025-11-22 23:17:08,195 - INFO -     Buy Price (incl. shipping): $115.27
2025-11-22 23:17:08,195 - INFO -     Commission+Fees: $0.00
2025-11-22 23:17:08,195 - INFO -     Payment Processor: $0.00
2025-11-22 23:17:08,195 - INFO -     Credits: -$0.00
2025-11-22 23:17:08,195 - INFO -     Loss: $0.00 (0.00% of sales)
2025-11-22 23:17:08,195 - INFO -     → COGS: $115.27 (was $0.00)
2025-11-22 23:17:08,195 - INFO -     → Gross Profit: $58.18 (33.54%)
2025-11-22 23:17:08,195 - INFO -   B2B - Order 38617-0002:
2025-11-22 23:17:08,195 - INFO -     Sales: $351.76
2025-11-22 23:17:08,195 - INFO -     Buy Price (incl. shipping): $222.83
2025-11-22 23:17:08,195 - INFO -     Commission+Fees: $0.00
2025-11-22 23:17:08,195 - INFO -     Payment Processor: $0.00
2025-11-22 23:17:08,195 - INFO -     Credits: -$0.00
2025-11-22 23:17:08,195 - INFO -     Loss: $0.00 (0.00% of sales)
2025-11-22 23:17:08,195 - INFO -     → COGS: $222.83 (was $0.00)
2025-11-22 23:17:08,195 - INFO -     → Gross Profit: $128.93 (36.65%)
2025-11-22 23:17:08,195 - INFO -   B2B - Order 43998-0034:
2025-11-22 23:17:08,195 - INFO -     Sales: $53.79
2025-11-22 23:17:08,196 - INFO -     Buy Price (incl. shipping): $0.00
2025-11-22 23:17:08,196 - INFO -     Commission+Fees: $0.00
2025-11-22 23:17:08,196 - INFO -     Payment Processor: $0.00
2025-11-22 23:17:08,196 - INFO -     Credits: -$0.00
2025-11-22 23:17:08,196 - INFO -     Loss: $2.42 (4.50% of sales)
2025-11-22 23:17:08,196 - INFO -     → COGS: $2.42 (was $0.00)
2025-11-22 23:17:08,196 - INFO -     → Gross Profit: $51.37 (95.50%)
2025-11-22 23:17:08,196 - INFO -   B2B - Order 43998-0034:
2025-11-22 23:17:08,196 - INFO -     Sales: $8.93
2025-11-22 23:17:08,196 - INFO -     Buy Price (incl. shipping): $6.25
2025-11-22 23:17:08,196 - INFO -     Commission+Fees: $0.00
2025-11-22 23:17:08,196 - INFO -     Payment Processor: $0.00
2025-11-22 23:17:08,196 - INFO -     Credits: -$0.00
2025-11-22 23:17:08,196 - INFO -     Loss: $0.00 (0.00% of sales)
2025-11-22 23:17:08,196 - INFO -     → COGS: $6.25 (was $0.00)
2025-11-22 23:17:08,196 - INFO -     → Gross Profit: $2.68 (30.01%)
2025-11-22 23:17:08,196 - INFO -   B2B - Order 35831-0047:
2025-11-22 23:17:08,196 - INFO -     Sales: $37.53
2025-11-22 23:17:08,196 - INFO -     Buy Price (incl. shipping): $23.01
2025-11-22 23:17:08,196 - INFO -     Commission+Fees: $0.00
2025-11-22 23:17:08,196 - INFO -     Payment Processor: $0.00
2025-11-22 23:17:08,196 - INFO -     Credits: -$0.00
2025-11-22 23:17:08,196 - INFO -     Loss: $0.00 (0.00% of sales)
2025-11-22 23:17:08,196 - INFO -     → COGS: $23.01 (was $0.00)
2025-11-22 23:17:08,196 - INFO -     → Gross Profit: $14.52 (38.69%)
2025-11-22 23:17:08,196 - INFO -   B2B - Order 52076-0005:
2025-11-22 23:17:08,196 - INFO -     Sales: $43.58
2025-11-22 23:17:08,196 - INFO -     Buy Price (incl. shipping): $33.17
2025-11-22 23:17:08,196 - INFO -     Commission+Fees: $0.00
2025-11-22 23:17:08,196 - INFO -     Payment Processor: $0.00
2025-11-22 23:17:08,196 - INFO -     Credits: -$0.00
2025-11-22 23:17:08,197 - INFO -     Loss: $0.00 (0.00% of sales)
2025-11-22 23:17:08,197 - INFO -     → COGS: $33.17 (was $0.00)
2025-11-22 23:17:08,197 - INFO -     → Gross Profit: $10.41 (23.89%)
2025-11-22 23:17:08,716 - INFO -   eBay - Order 27-13744-51211:
2025-11-22 23:17:08,716 - INFO -     Sales: $107.95
2025-11-22 23:17:08,716 - INFO -     Buy Price (incl. shipping): $38.32
2025-11-22 23:17:08,716 - INFO -     Commission+Fees: $0.00
2025-11-22 23:17:08,716 - INFO -     Payment Processor: $3.43
2025-11-22 23:17:08,716 - INFO -     Credits: -$0.00
2025-11-22 23:17:08,716 - INFO -     Loss: $0.00 (0.00% of sales)
2025-11-22 23:17:08,716 - INFO -     → COGS: $41.75 (was $0.00)
2025-11-22 23:17:08,716 - INFO -     → Gross Profit: $66.20 (61.32%)
2025-11-22 23:17:08,717 - INFO -   eBay - Order 14-13760-78063:
2025-11-22 23:17:08,717 - INFO -     Sales: $117.95
2025-11-22 23:17:08,717 - INFO -     Buy Price (incl. shipping): $41.16
2025-11-22 23:17:08,717 - INFO -     Commission+Fees: $0.00
2025-11-22 23:17:08,717 - INFO -     Payment Processor: $3.72
2025-11-22 23:17:08,717 - INFO -     Credits: -$0.00
2025-11-22 23:17:08,717 - INFO -     Loss: $0.00 (0.00% of sales)
2025-11-22 23:17:08,717 - INFO -     → COGS: $44.88 (was $0.00)
2025-11-22 23:17:08,717 - INFO -     → Gross Profit: $73.07 (61.95%)
2025-11-22 23:17:08,717 - INFO -   eBay - Order 02-13764-68054:
2025-11-22 23:17:08,717 - INFO -     Sales: $44.95
2025-11-22 23:17:08,717 - INFO -     Buy Price (incl. shipping): $16.21
2025-11-22 23:17:08,717 - INFO -     Commission+Fees: $0.00
2025-11-22 23:17:08,717 - INFO -     Payment Processor: $1.60
2025-11-22 23:17:08,717 - INFO -     Credits: -$0.00
2025-11-22 23:17:08,717 - INFO -     Loss: $0.00 (0.00% of sales)
2025-11-22 23:17:08,717 - INFO -     → COGS: $17.81 (was $0.00)
2025-11-22 23:17:08,717 - INFO -     → Gross Profit: $27.14 (60.38%)
2025-11-22 23:17:08,717 - INFO -   eBay - Order 14-13743-47353:
2025-11-22 23:17:08,717 - INFO -     Sales: $35.95
2025-11-22 23:17:08,717 - INFO -     Buy Price (incl. shipping): $15.65
2025-11-22 23:17:08,717 - INFO -     Commission+Fees: $0.00
2025-11-22 23:17:08,717 - INFO -     Payment Processor: $1.34
2025-11-22 23:17:08,717 - INFO -     Credits: -$0.00
2025-11-22 23:17:08,717 - INFO -     Loss: $1.85 (5.15% of sales)
2025-11-22 23:17:08,717 - INFO -     → COGS: $18.84 (was $0.00)
2025-11-22 23:17:08,717 - INFO -     → Gross Profit: $17.11 (47.59%)
2025-11-22 23:17:08,718 - INFO -   eBay - Order 02-13746-52257:
2025-11-22 23:17:08,718 - INFO -     Sales: $66.95
2025-11-22 23:17:08,718 - INFO -     Buy Price (incl. shipping): $34.34
2025-11-22 23:17:08,718 - INFO -     Commission+Fees: $0.00
2025-11-22 23:17:08,718 - INFO -     Payment Processor: $2.24
2025-11-22 23:17:08,718 - INFO -     Credits: -$0.00
2025-11-22 23:17:08,718 - INFO -     Loss: $4.28 (6.40% of sales)
2025-11-22 23:17:08,718 - INFO -     → COGS: $40.86 (was $0.00)
2025-11-22 23:17:08,718 - INFO -     → Gross Profit: $26.09 (38.96%)
2025-11-22 23:17:08,718 - INFO -   eBay - Order 14-13728-83942:
2025-11-22 23:17:08,718 - INFO -     Sales: $75.95
2025-11-22 23:17:08,718 - INFO -     Buy Price (incl. shipping): $29.45
2025-11-22 23:17:08,718 - INFO -     Commission+Fees: $0.00
2025-11-22 23:17:08,718 - INFO -     Payment Processor: $2.50
2025-11-22 23:17:08,718 - INFO -     Credits: -$0.00
2025-11-22 23:17:08,718 - INFO -     Loss: $0.00 (0.00% of sales)
2025-11-22 23:17:08,718 - INFO -     → COGS: $31.95 (was $0.00)
2025-11-22 23:17:08,718 - INFO -     → Gross Profit: $44.00 (57.93%)
2025-11-22 23:17:08,718 - INFO -   eBay - Order 20-13714-82267:
2025-11-22 23:17:08,718 - INFO -     Sales: $56.95
2025-11-22 23:17:08,718 - INFO -     Buy Price (incl. shipping): $0.00
2025-11-22 23:17:08,718 - INFO -     Commission+Fees: $0.00
2025-11-22 23:17:08,718 - INFO -     Payment Processor: $1.95
2025-11-22 23:17:08,718 - INFO -     Credits: -$0.00
2025-11-22 23:17:08,718 - INFO -     Loss: $1.65 (2.90% of sales)
2025-11-22 23:17:08,718 - INFO -     → COGS: $3.60 (was $0.00)
2025-11-22 23:17:08,718 - INFO -     → Gross Profit: $53.35 (93.68%)
2025-11-22 23:17:08,719 - INFO -   eBay - Order 03-13737-25984:
2025-11-22 23:17:08,719 - INFO -     Sales: $229.95
2025-11-22 23:17:08,719 - INFO -     Buy Price (incl. shipping): $105.53
2025-11-22 23:17:08,719 - INFO -     Commission+Fees: $0.00
2025-11-22 23:17:08,719 - INFO -     Payment Processor: $6.97
2025-11-22 23:17:08,719 - INFO -     Credits: -$0.00
2025-11-22 23:17:08,719 - INFO -     Loss: $21.85 (9.50% of sales)
2025-11-22 23:17:08,719 - INFO -     → COGS: $134.35 (was $0.00)
2025-11-22 23:17:08,719 - INFO -     → Gross Profit: $95.60 (41.58%)
2025-11-22 23:17:08,719 - INFO -   eBay - Order 03-13736-19619:
2025-11-22 23:17:08,719 - INFO -     Sales: $46.95
2025-11-22 23:17:08,719 - INFO -     Buy Price (incl. shipping): $0.00
2025-11-22 23:17:08,719 - INFO -     Commission+Fees: $0.00
2025-11-22 23:17:08,719 - INFO -     Payment Processor: $1.66
2025-11-22 23:17:08,719 - INFO -     Credits: -$0.00
2025-11-22 23:17:08,719 - INFO -     Loss: $1.50 (3.20% of sales)
2025-11-22 23:17:08,719 - INFO -     → COGS: $3.16 (was $0.00)
2025-11-22 23:17:08,719 - INFO -     → Gross Profit: $43.79 (93.26%)
2025-11-22 23:17:08,719 - INFO -   eBay - Order 25-13705-00475:
2025-11-22 23:17:08,719 - INFO -     Sales: $29.95
2025-11-22 23:17:08,719 - INFO -     Buy Price (incl. shipping): $17.78
2025-11-22 23:17:08,719 - INFO -     Commission+Fees: $0.00
2025-11-22 23:17:08,719 - INFO -     Payment Processor: $1.17
2025-11-22 23:17:08,719 - INFO -     Credits: -$0.00
2025-11-22 23:17:08,719 - INFO -     Loss: $0.00 (0.00% of sales)
2025-11-22 23:17:08,719 - INFO -     → COGS: $18.95 (was $0.00)
2025-11-22 23:17:08,719 - INFO -     → Gross Profit: $11.00 (36.73%)
2025-11-22 23:17:08,723 - INFO -   Web - Order 229632683:
2025-11-22 23:17:08,723 - INFO -     Sales: $79.94
2025-11-22 23:17:08,723 - INFO -     Buy Price (incl. shipping): $48.70
2025-11-22 23:17:08,723 - INFO -     Commission+Fees: $0.00
2025-11-22 23:17:08,723 - INFO -     Payment Processor: $2.15
2025-11-22 23:17:08,723 - INFO -     Credits: -$0.00
2025-11-22 23:17:08,724 - INFO -     Loss: $2.48 (3.10% of sales)
2025-11-22 23:17:08,724 - INFO -     → COGS: $53.33 (was $0.00)
2025-11-22 23:17:08,724 - INFO -     → Gross Profit: $26.61 (33.29%)
2025-11-22 23:17:08,724 - INFO -   Web - Order 229632683:
2025-11-22 23:17:08,724 - INFO -     Sales: $79.94
2025-11-22 23:17:08,724 - INFO -     Buy Price (incl. shipping): $37.61
2025-11-22 23:17:08,724 - INFO -     Commission+Fees: $0.00
2025-11-22 23:17:08,724 - INFO -     Payment Processor: $2.15
2025-11-22 23:17:08,724 - INFO -     Credits: -$0.00
2025-11-22 23:17:08,724 - INFO -     Loss: $0.00 (0.00% of sales)
2025-11-22 23:17:08,724 - INFO -     → COGS: $39.76 (was $0.00)
2025-11-22 23:17:08,724 - INFO -     → Gross Profit: $40.18 (50.26%)
2025-11-22 23:17:08,724 - INFO -   Web - Order 229632677:
2025-11-22 23:17:08,724 - INFO -     Sales: $103.94
2025-11-22 23:17:08,724 - INFO -     Buy Price (incl. shipping): $58.26
2025-11-22 23:17:08,724 - INFO -     Commission+Fees: $0.00
2025-11-22 23:17:08,724 - INFO -     Payment Processor: $2.80
2025-11-22 23:17:08,724 - INFO -     Credits: -$0.00
2025-11-22 23:17:08,724 - INFO -     Loss: $9.87 (9.50% of sales)
2025-11-22 23:17:08,724 - INFO -     → COGS: $70.93 (was $0.00)
2025-11-22 23:17:08,724 - INFO -     → Gross Profit: $33.01 (31.75%)
2025-11-22 23:17:08,724 - INFO -   Web - Order 229632674:
2025-11-22 23:17:08,724 - INFO -     Sales: $131.94
2025-11-22 23:17:08,724 - INFO -     Buy Price (incl. shipping): $81.01
2025-11-22 23:17:08,724 - INFO -     Commission+Fees: $0.00
2025-11-22 23:17:08,724 - INFO -     Payment Processor: $3.55
2025-11-22 23:17:08,724 - INFO -     Credits: -$0.00
2025-11-22 23:17:08,724 - INFO -     Loss: $0.00 (0.00% of sales)
2025-11-22 23:17:08,724 - INFO -     → COGS: $84.56 (was $0.00)
2025-11-22 23:17:08,724 - INFO -     → Gross Profit: $47.38 (35.91%)
2025-11-22 23:17:08,725 - INFO -   Web - Order 229632659:
2025-11-22 23:17:08,725 - INFO -     Sales: $59.94
2025-11-22 23:17:08,725 - INFO -     Buy Price (incl. shipping): $18.62
2025-11-22 23:17:08,725 - INFO -     Commission+Fees: $0.00
2025-11-22 23:17:08,725 - INFO -     Payment Processor: $1.61
2025-11-22 23:17:08,725 - INFO -     Credits: -$0.00
2025-11-22 23:17:08,725 - INFO -     Loss: $5.69 (9.50% of sales)
2025-11-22 23:17:08,725 - INFO -     → COGS: $25.92 (was $0.00)
2025-11-22 23:17:08,725 - INFO -     → Gross Profit: $34.02 (56.75%)
2025-11-22 23:17:08,725 - INFO -   Web - Order 229632651:
2025-11-22 23:17:08,725 - INFO -     Sales: $125.94
2025-11-22 23:17:08,725 - INFO -     Buy Price (incl. shipping): $69.46
2025-11-22 23:17:08,725 - INFO -     Commission+Fees: $0.00
2025-11-22 23:17:08,725 - INFO -     Payment Processor: $3.39
2025-11-22 23:17:08,725 - INFO -     Credits: -$0.00
2025-11-22 23:17:08,725 - INFO -     Loss: $0.00 (0.00% of sales)
2025-11-22 23:17:08,725 - INFO -     → COGS: $72.85 (was $0.00)
2025-11-22 23:17:08,725 - INFO -     → Gross Profit: $53.09 (42.15%)
2025-11-22 23:17:08,725 - INFO -   Web - Order 229632630:
2025-11-22 23:17:08,725 - INFO -     Sales: $347.94
2025-11-22 23:17:08,725 - INFO -     Buy Price (incl. shipping): $188.29
2025-11-22 23:17:08,725 - INFO -     Commission+Fees: $0.00
2025-11-22 23:17:08,725 - INFO -     Payment Processor: $9.36
2025-11-22 23:17:08,725 - INFO -     Credits: -$0.00
2025-11-22 23:17:08,725 - INFO -     Loss: $0.00 (0.00% of sales)
2025-11-22 23:17:08,725 - INFO -     → COGS: $197.65 (was $0.00)
2025-11-22 23:17:08,725 - INFO -     → Gross Profit: $150.29 (43.19%)
2025-11-22 23:17:08,726 - INFO -   Web - Order 229632613:
2025-11-22 23:17:08,726 - INFO -     Sales: $27.94
2025-11-22 23:17:08,726 - INFO -     Buy Price (incl. shipping): $12.28
2025-11-22 23:17:08,726 - INFO -     Commission+Fees: $0.00
2025-11-22 23:17:08,726 - INFO -     Payment Processor: $0.75
2025-11-22 23:17:08,726 - INFO -     Credits: -$0.00
2025-11-22 23:17:08,726 - INFO -     Loss: $2.27 (8.13% of sales)
2025-11-22 23:17:08,726 - INFO -     → COGS: $15.30 (was $0.00)
2025-11-22 23:17:08,726 - INFO -     → Gross Profit: $12.64 (45.23%)
2025-11-22 23:17:08,726 - INFO -   Web - Order 229632610:
2025-11-22 23:17:08,726 - INFO -     Sales: $65.44
2025-11-22 23:17:08,726 - INFO -     Buy Price (incl. shipping): $26.29
2025-11-22 23:17:08,726 - INFO -     Commission+Fees: $0.00
2025-11-22 23:17:08,726 - INFO -     Payment Processor: $1.76
2025-11-22 23:17:08,726 - INFO -     Credits: -$0.00
2025-11-22 23:17:08,726 - INFO -     Loss: $5.50 (8.41% of sales)
2025-11-22 23:17:08,726 - INFO -     → COGS: $33.55 (was $0.00)
2025-11-22 23:17:08,726 - INFO -     → Gross Profit: $31.89 (48.73%)
2025-11-22 23:17:08,726 - INFO -   Web - Order 229632610:
2025-11-22 23:17:08,726 - INFO -     Sales: $214.44
2025-11-22 23:17:08,726 - INFO -     Buy Price (incl. shipping): $0.00
2025-11-22 23:17:08,726 - INFO -     Commission+Fees: $0.00
2025-11-22 23:17:08,726 - INFO -     Payment Processor: $5.77
2025-11-22 23:17:08,726 - INFO -     Credits: -$0.00
2025-11-22 23:17:08,726 - INFO -     Loss: $0.00 (0.00% of sales)
2025-11-22 23:17:08,726 - INFO -     → COGS: $5.77 (was $0.00)
2025-11-22 23:17:08,726 - INFO -     → Gross Profit: $208.67 (97.31%)
2025-11-22 23:17:08,794 - INFO - 
================================================================================
2025-11-22 23:17:08,794 - INFO - COGS CALCULATION SUMMARY BY CHANNEL
2025-11-22 23:17:08,794 - INFO - ================================================================================
2025-11-22 23:17:08,794 - INFO - 
Amazon:
2025-11-22 23:17:08,794 - INFO -   Orders: 1019
2025-11-22 23:17:08,794 - INFO -   Revenue: $134,655.08
2025-11-22 23:17:08,794 - INFO -   COGS Breakdown:
2025-11-22 23:17:08,794 - INFO -     Buy Price (incl. shipping): $62,107.84
2025-11-22 23:17:08,794 - INFO -     Commission+Fees: $0.00
2025-11-22 23:17:08,794 - INFO -     Payment Processor: $10.45
2025-11-22 23:17:08,794 - INFO -     Credits: -$290.01
2025-11-22 23:17:08,794 - INFO -     Loss: $6,042.68
2025-11-22 23:17:08,794 - INFO -   Total COGS: $67,870.96
2025-11-22 23:17:08,794 - INFO -   Gross Margin: $66,784.12 (49.60%)
2025-11-22 23:17:08,794 - INFO - 
B2B:
2025-11-22 23:17:08,794 - INFO -   Orders: 3732
2025-11-22 23:17:08,794 - INFO -   Revenue: $345,774.36
2025-11-22 23:17:08,794 - INFO -   COGS Breakdown:
2025-11-22 23:17:08,794 - INFO -     Buy Price (incl. shipping): $206,328.66
2025-11-22 23:17:08,794 - INFO -     Commission+Fees: $0.00
2025-11-22 23:17:08,794 - INFO -     Payment Processor: $0.00
2025-11-22 23:17:08,794 - INFO -     Credits: -$784.05
2025-11-22 23:17:08,794 - INFO -     Loss: $4,320.45
2025-11-22 23:17:08,794 - INFO -   Total COGS: $209,865.06
2025-11-22 23:17:08,794 - INFO -   Gross Margin: $135,909.30 (39.31%)
2025-11-22 23:17:08,794 - INFO - 
Web:
2025-11-22 23:17:08,794 - INFO -   Orders: 294
2025-11-22 23:17:08,794 - INFO -   Revenue: $40,123.82
2025-11-22 23:17:08,794 - INFO -   COGS Breakdown:
2025-11-22 23:17:08,794 - INFO -     Buy Price (incl. shipping): $18,986.56
2025-11-22 23:17:08,794 - INFO -     Commission+Fees: $0.00
2025-11-22 23:17:08,794 - INFO -     Payment Processor: $1,079.35
2025-11-22 23:17:08,794 - INFO -     Credits: -$55.85
2025-11-22 23:17:08,794 - INFO -     Loss: $2,174.50
2025-11-22 23:17:08,794 - INFO -   Total COGS: $22,184.56
2025-11-22 23:17:08,794 - INFO -   Gross Margin: $17,939.26 (44.71%)
2025-11-22 23:17:08,794 - INFO - 
eBay:
2025-11-22 23:17:08,794 - INFO -   Orders: 40
2025-11-22 23:17:08,794 - INFO -   Revenue: $5,461.00
2025-11-22 23:17:08,794 - INFO -   COGS Breakdown:
2025-11-22 23:17:08,794 - INFO -     Buy Price (incl. shipping): $1,881.13
2025-11-22 23:17:08,794 - INFO -     Commission+Fees: $0.00
2025-11-22 23:17:08,794 - INFO -     Payment Processor: $170.33
2025-11-22 23:17:08,794 - INFO -     Credits: -$0.00
2025-11-22 23:17:08,794 - INFO -     Loss: $162.71
2025-11-22 23:17:08,795 - INFO -   Total COGS: $2,214.17
2025-11-22 23:17:08,795 - INFO -   Gross Margin: $3,246.83 (59.45%)
2025-11-22 23:17:08,795 - INFO - 
================================================================================
2025-11-22 23:17:08,795 - INFO - OVERALL TOTALS
2025-11-22 23:17:08,795 - INFO - ================================================================================
2025-11-22 23:17:08,795 - INFO - Total Orders: 5085
2025-11-22 23:17:08,795 - INFO - Updated: 5085
2025-11-22 23:17:08,795 - INFO - Unchanged: 0
2025-11-22 23:17:08,795 - INFO - Missing buy price: 470
2025-11-22 23:17:08,795 - INFO - 
Total Revenue: $526,014.26
2025-11-22 23:17:08,795 - INFO - Total COGS: $302,134.74
2025-11-22 23:17:08,795 - INFO - Total Gross Margin: $223,879.52 (42.56%)
2025-11-22 23:17:08,795 - INFO - ================================================================================

2025-11-22 23:17:08,795 - WARNING - ⚠️  470 orders have NULL/zero buy price - COGS may be understated
2025-11-22 23:17:08,798 - INFO - 
================================================================================
2025-11-22 23:17:08,798 - INFO - Script completed successfully
2025-11-22 23:17:08,798 - INFO - ================================================================================