2025-11-23 04:46:39,548 - INFO - ================================================================================
2025-11-23 04:46:39,548 - INFO - SCRIPT 8: FIX INCORRECT BUY PRICES
2025-11-23 04:46:39,548 - INFO - LIVE MODE
2025-11-23 04:46:39,548 - INFO - ================================================================================
2025-11-23 04:46:39,548 - INFO - Log file: /home/centralgoparts/public_html/profitability/logs/fix_buy_prices_20251123_044639.log
2025-11-23 04:46:39,548 - INFO - Started at: 2025-11-23 04:46:39.548499
2025-11-23 04:46:39,556 - INFO - 
================================================================================
2025-11-23 04:46:39,556 - INFO - CHECKING BUY PRICE FORMULA ACCURACY
2025-11-23 04:46:39,556 - INFO - Formula: our_buy_price = supplier_price + supplier_shipping + handling
2025-11-23 04:46:39,556 - INFO - ================================================================================
2025-11-23 04:46:39,642 - INFO - Checking 15445 orders...
2025-11-23 04:46:39,649 - INFO - ✓ All orders have correct buy prices
2025-11-23 04:46:39,660 - INFO - 
================================================================================
2025-11-23 04:46:39,660 - INFO - CHECKING GROSS PROFIT AND MARGIN ACCURACY FOR ALL ORDERS
2025-11-23 04:46:39,660 - INFO - ================================================================================
2025-11-23 04:46:39,829 - INFO - Checking 22250 orders for correct gross profit and margin...
2025-11-23 04:46:39,855 - INFO - Found 3375 orders with incorrect COGS/profit/margin
2025-11-23 04:46:39,856 - INFO - 
Top 10 worst cases:
2025-11-23 04:46:39,856 - INFO -   1. Order 09309-0007: current profit=$0.00, should be=$1539.13, diff=$1539.13
2025-11-23 04:46:39,856 - INFO -   2. Order 114-2610813-2893038: current profit=$464.97, should be=$1832.92, diff=$1367.95
2025-11-23 04:46:39,856 - INFO -   3. Order 42554-0033: current profit=$0.00, should be=$998.21, diff=$998.21
2025-11-23 04:46:39,856 - INFO -   4. Order 55384-0123: current profit=$0.00, should be=$971.77, diff=$971.77
2025-11-23 04:46:39,856 - INFO -   5. Order 111-1151565-7246635: current profit=$243.61, should be=$1191.56, diff=$947.95
2025-11-23 04:46:39,856 - INFO -   6. Order 229626760: current profit=$0.00, should be=$920.95, diff=$920.95
2025-11-23 04:46:39,856 - INFO -   7. Order 113-2622259-0641816: current profit=$0.00, should be=$883.95, diff=$883.95
2025-11-23 04:46:39,856 - INFO -   8. Order 57376-1604: current profit=$0.00, should be=$803.30, diff=$803.30
2025-11-23 04:46:39,856 - INFO -   9. Order 229623070: current profit=$-64.40, should be=$725.06, diff=$789.46
2025-11-23 04:46:39,856 - INFO -   10. Order 112-9758611-8573856: current profit=$0.00, should be=$788.95, diff=$788.95
2025-11-23 04:46:40,317 - INFO - 
Fixed 3375 orders
2025-11-23 04:46:40,328 - INFO - 
================================================================================
2025-11-23 04:46:40,328 - INFO - SUMMARY
2025-11-23 04:46:40,328 - INFO - ================================================================================
2025-11-23 04:46:40,328 - INFO - Orders with incorrect buy prices: 0
2025-11-23 04:46:40,328 - INFO - COGS recalculated for buy price fixes: 0
2025-11-23 04:46:40,328 - INFO - Orders with incorrect COGS/profit/margin: 3375
2025-11-23 04:46:40,328 - INFO - ================================================================================
2025-11-23 04:46:40,328 - INFO - 
Completed at: 2025-11-23 04:46:40.328949
2025-11-23 04:46:40,328 - INFO - Total duration: 0.78 seconds