2025-11-23 04:26:26,887 - INFO - ================================================================================
2025-11-23 04:26:26,887 - INFO - SCRIPT 8: FIX INCORRECT BUY PRICES
2025-11-23 04:26:26,887 - INFO - LIVE MODE
2025-11-23 04:26:26,888 - INFO - ================================================================================
2025-11-23 04:26:26,888 - INFO - Log file: /home/centralgoparts/public_html/profitability/logs/fix_buy_prices_20251123_042626.log
2025-11-23 04:26:26,888 - INFO - Started at: 2025-11-23 04:26:26.887703
2025-11-23 04:26:26,896 - INFO - 
================================================================================
2025-11-23 04:26:26,896 - INFO - CHECKING BUY PRICE FORMULA ACCURACY
2025-11-23 04:26:26,896 - INFO - Formula: our_buy_price = supplier_price + supplier_shipping + handling
2025-11-23 04:26:26,896 - INFO - ================================================================================
2025-11-23 04:26:26,975 - INFO - Checking 15445 orders...
2025-11-23 04:26:26,982 - INFO - Found 128 orders with incorrect buy prices
2025-11-23 04:26:26,982 - INFO - 
Top 10 worst cases:
2025-11-23 04:26:26,982 - INFO -   1. Order 57702-0007: current=$260.34, should be=$271.19, diff=$10.85, source=Snapshot
2025-11-23 04:26:26,982 - INFO -   2. Order 340657: current=$257.48, should be=$268.21, diff=$10.73, source=Snapshot
2025-11-23 04:26:26,982 - INFO -   3. Order 340662: current=$200.01, should be=$208.34, diff=$8.33, source=Snapshot
2025-11-23 04:26:26,982 - INFO -   4. Order 00271-0010: current=$193.75, should be=$201.82, diff=$8.07, source=Snapshot
2025-11-23 04:26:26,982 - INFO -   5. Order 51895-0032: current=$180.57, should be=$188.09, diff=$7.52, source=Snapshot
2025-11-23 04:26:26,982 - INFO -   6. Order 06414-0009: current=$176.43, should be=$183.78, diff=$7.35, source=Snapshot
2025-11-23 04:26:26,982 - INFO -   7. Order 340641: current=$162.71, should be=$169.49, diff=$6.78, source=Snapshot
2025-11-23 04:26:26,982 - INFO -   8. Order 36951-0019: current=$142.26, should be=$148.19, diff=$5.93, source=Snapshot
2025-11-23 04:26:26,982 - INFO -   9. Order 49235-0027: current=$123.95, should be=$129.11, diff=$5.16, source=Snapshot
2025-11-23 04:26:26,982 - INFO -   10. Order 39479-0051: current=$120.09, should be=$125.09, diff=$5.00, source=Snapshot
2025-11-23 04:26:26,998 - INFO - 
Fixed 128 orders
2025-11-23 04:26:27,009 - INFO - 
================================================================================
2025-11-23 04:26:27,010 - INFO - RECALCULATING COGS FOR FIXED ORDERS
2025-11-23 04:26:27,010 - INFO - ================================================================================
2025-11-23 04:26:27,011 - INFO - Recalculating COGS for 128 fixed orders
2025-11-23 04:26:27,028 - INFO - Recalculated COGS for 128 orders
2025-11-23 04:26:27,034 - INFO - 
================================================================================
2025-11-23 04:26:27,034 - INFO - CHECKING GROSS PROFIT AND MARGIN ACCURACY FOR ALL ORDERS
2025-11-23 04:26:27,034 - INFO - ================================================================================
2025-11-23 04:26:27,195 - INFO - Checking 22250 orders for correct gross profit and margin...
2025-11-23 04:26:27,221 - INFO - Found 3375 orders with incorrect COGS/profit/margin
2025-11-23 04:26:27,222 - INFO - 
Top 10 worst cases:
2025-11-23 04:26:27,222 - INFO -   1. Order 09309-0007: current profit=$0.00, should be=$1539.13, diff=$1539.13
2025-11-23 04:26:27,222 - INFO -   2. Order 114-2610813-2893038: current profit=$464.97, should be=$1832.92, diff=$1367.95
2025-11-23 04:26:27,223 - INFO -   3. Order 42554-0033: current profit=$0.00, should be=$998.21, diff=$998.21
2025-11-23 04:26:27,223 - INFO -   4. Order 55384-0123: current profit=$0.00, should be=$971.77, diff=$971.77
2025-11-23 04:26:27,223 - INFO -   5. Order 111-1151565-7246635: current profit=$243.61, should be=$1191.56, diff=$947.95
2025-11-23 04:26:27,223 - INFO -   6. Order 229626760: current profit=$0.00, should be=$920.95, diff=$920.95
2025-11-23 04:26:27,223 - INFO -   7. Order 113-2622259-0641816: current profit=$0.00, should be=$883.95, diff=$883.95
2025-11-23 04:26:27,223 - INFO -   8. Order 57376-1604: current profit=$0.00, should be=$803.30, diff=$803.30
2025-11-23 04:26:27,223 - INFO -   9. Order 229623070: current profit=$-64.40, should be=$725.06, diff=$789.46
2025-11-23 04:26:27,223 - INFO -   10. Order 112-9758611-8573856: current profit=$0.00, should be=$788.95, diff=$788.95
2025-11-23 04:26:27,664 - INFO - 
Fixed 3375 orders
2025-11-23 04:26:27,676 - INFO - 
================================================================================
2025-11-23 04:26:27,676 - INFO - SUMMARY
2025-11-23 04:26:27,676 - INFO - ================================================================================
2025-11-23 04:26:27,676 - INFO - Orders with incorrect buy prices: 128
2025-11-23 04:26:27,676 - INFO - COGS recalculated for buy price fixes: 128
2025-11-23 04:26:27,676 - INFO - Orders with incorrect COGS/profit/margin: 3375
2025-11-23 04:26:27,676 - INFO - ================================================================================
2025-11-23 04:26:27,676 - INFO - 
Completed at: 2025-11-23 04:26:27.676459
2025-11-23 04:26:27,676 - INFO - Total duration: 0.79 seconds