2025-11-23 07:40:14,354 - INFO - ================================================================================
2025-11-23 07:40:14,354 - INFO - SCRIPT 8: FIX INCORRECT BUY PRICES
2025-11-23 07:40:14,354 - INFO - LIVE MODE
2025-11-23 07:40:14,354 - INFO - ================================================================================
2025-11-23 07:40:14,354 - INFO - Log file: /home/centralgoparts/public_html/profitability/logs/fix_buy_prices_20251123_074014.log
2025-11-23 07:40:14,354 - INFO - Started at: 2025-11-23 07:40:14.354589
2025-11-23 07:40:14,363 - INFO - 
================================================================================
2025-11-23 07:40:14,363 - INFO - CHECKING BUY PRICE FORMULA ACCURACY
2025-11-23 07:40:14,363 - INFO - Formula: our_buy_price = supplier_price + supplier_shipping + handling
2025-11-23 07:40:14,363 - INFO - ================================================================================
2025-11-23 07:40:14,450 - INFO - Checking 15445 orders...
2025-11-23 07:40:14,457 - INFO - ✓ All orders have correct buy prices
2025-11-23 07:40:14,467 - INFO - 
================================================================================
2025-11-23 07:40:14,467 - INFO - CHECKING GROSS PROFIT AND MARGIN ACCURACY FOR ALL ORDERS
2025-11-23 07:40:14,467 - INFO - ================================================================================
2025-11-23 07:40:14,654 - INFO - Checking 22250 orders for correct gross profit and margin...
2025-11-23 07:40:14,683 - INFO - Found 3375 orders with incorrect COGS/profit/margin
2025-11-23 07:40:14,684 - INFO - 
Top 10 worst cases:
2025-11-23 07:40:14,684 - INFO -   1. Order 09309-0007: current profit=$1539.13, should be=$0.00, diff=$1539.13
2025-11-23 07:40:14,684 - INFO -   2. Order 114-2610813-2893038: current profit=$1832.92, should be=$464.97, diff=$1367.95
2025-11-23 07:40:14,684 - INFO -   3. Order 42554-0033: current profit=$998.21, should be=$0.00, diff=$998.21
2025-11-23 07:40:14,684 - INFO -   4. Order 55384-0123: current profit=$971.77, should be=$0.00, diff=$971.77
2025-11-23 07:40:14,685 - INFO -   5. Order 111-1151565-7246635: current profit=$1191.56, should be=$243.61, diff=$947.95
2025-11-23 07:40:14,685 - INFO -   6. Order 229626760: current profit=$920.95, should be=$0.00, diff=$920.95
2025-11-23 07:40:14,685 - INFO -   7. Order 113-2622259-0641816: current profit=$883.95, should be=$0.00, diff=$883.95
2025-11-23 07:40:14,685 - INFO -   8. Order 57376-1604: current profit=$803.30, should be=$0.00, diff=$803.30
2025-11-23 07:40:14,685 - INFO -   9. Order 229623070: current profit=$725.06, should be=$-64.40, diff=$789.46
2025-11-23 07:40:14,685 - INFO -   10. Order 112-9758611-8573856: current profit=$788.95, should be=$0.00, diff=$788.95
2025-11-23 07:40:15,110 - INFO - 
Fixed 3375 orders
2025-11-23 07:40:15,121 - INFO - 
================================================================================
2025-11-23 07:40:15,121 - INFO - SUMMARY
2025-11-23 07:40:15,121 - INFO - ================================================================================
2025-11-23 07:40:15,121 - INFO - Orders with incorrect buy prices: 0
2025-11-23 07:40:15,121 - INFO - COGS recalculated for buy price fixes: 0
2025-11-23 07:40:15,121 - INFO - Orders with incorrect COGS/profit/margin: 3375
2025-11-23 07:40:15,121 - INFO - ================================================================================
2025-11-23 07:40:15,121 - INFO - 
Completed at: 2025-11-23 07:40:15.121698
2025-11-23 07:40:15,121 - INFO - Total duration: 0.77 seconds