2025-11-24 06:35:25,736 - INFO - ================================================================================
2025-11-24 06:35:25,736 - INFO - SCRIPT 8: FIX INCORRECT BUY PRICES
2025-11-24 06:35:25,736 - INFO - LIVE MODE
2025-11-24 06:35:25,736 - INFO - ================================================================================
2025-11-24 06:35:25,736 - INFO - Log file: /home/centralgoparts/public_html/profitability/logs/fix_buy_prices_20251124_063525.log
2025-11-24 06:35:25,736 - INFO - Started at: 2025-11-24 06:35:25.735950
2025-11-24 06:35:25,744 - INFO - 
================================================================================
2025-11-24 06:35:25,744 - INFO - CHECKING BUY PRICE FORMULA ACCURACY
2025-11-24 06:35:25,744 - INFO - Formula: our_buy_price = supplier_price + supplier_shipping + handling
2025-11-24 06:35:25,744 - INFO - ================================================================================
2025-11-24 06:35:25,829 - INFO - Checking 16595 orders...
2025-11-24 06:35:25,837 - INFO - Found 792 orders with incorrect buy prices
2025-11-24 06:35:25,837 - INFO - 
Top 10 worst cases:
2025-11-24 06:35:25,837 - INFO -   1. Order 229629320: current=$148.37, should be=$251.54, diff=$103.17, source=DEPO Included
2025-11-24 06:35:25,838 - INFO -   2. Order 36777-0021: current=$60.43, should be=$126.07, diff=$65.64, source=Supplier e-mail
2025-11-24 06:35:25,838 - INFO -   3. Order 229627646: current=$74.64, should be=$130.11, diff=$55.47, source=DEPO Included
2025-11-24 06:35:25,838 - INFO -   4. Order 114-1002094-7701003: current=$25.97, should be=$74.90, diff=$48.93, source=DEPO Included
2025-11-24 06:35:25,838 - INFO -   5. Order 113-2061362-2230661: current=$230.95, should be=$278.03, diff=$47.08, source=Supplier e-mail
2025-11-24 06:35:25,838 - INFO -   6. Order 111-8337010-0339466: current=$25.97, should be=$68.98, diff=$43.01, source=DEPO Included
2025-11-24 06:35:25,838 - INFO -   7. Order 113-9723689-1937841: current=$130.99, should be=$168.99, diff=$38.00, source=Supplier e-mail
2025-11-24 06:35:25,838 - INFO -   8. Order 111-3293198-4241046: current=$179.01, should be=$216.75, diff=$37.74, source=Supplier e-mail
2025-11-24 06:35:25,838 - INFO -   9. Order 39397-0066: current=$72.06, should be=$108.70, diff=$36.64, source=DEPO Included
2025-11-24 06:35:25,838 - INFO -   10. Order 37369-0014: current=$61.88, should be=$97.10, diff=$35.22, source=DEPO Included
2025-11-24 06:35:25,936 - INFO - 
Fixed 792 orders
2025-11-24 06:35:25,948 - INFO - 
================================================================================
2025-11-24 06:35:25,948 - INFO - RECALCULATING COGS FOR FIXED ORDERS
2025-11-24 06:35:25,948 - INFO - ================================================================================
2025-11-24 06:35:25,953 - INFO - Recalculating COGS for 792 fixed orders
2025-11-24 06:35:26,058 - INFO - Recalculated COGS for 792 orders
2025-11-24 06:35:26,068 - INFO - 
================================================================================
2025-11-24 06:35:26,068 - INFO - CHECKING GROSS PROFIT AND MARGIN ACCURACY FOR ALL ORDERS
2025-11-24 06:35:26,068 - INFO - ================================================================================
2025-11-24 06:35:26,251 - INFO - Checking 22250 orders for correct gross profit and margin...
2025-11-24 06:35:26,284 - INFO - ✓ All orders have correct COGS, gross profit, and gross margin
2025-11-24 06:35:26,293 - INFO - 
================================================================================
2025-11-24 06:35:26,293 - INFO - SUMMARY
2025-11-24 06:35:26,293 - INFO - ================================================================================
2025-11-24 06:35:26,293 - INFO - Orders with incorrect buy prices: 792
2025-11-24 06:35:26,293 - INFO - COGS recalculated for buy price fixes: 792
2025-11-24 06:35:26,293 - INFO - Orders with incorrect COGS/profit/margin: 0
2025-11-24 06:35:26,293 - INFO - ================================================================================
2025-11-24 06:35:26,293 - INFO - 
Completed at: 2025-11-24 06:35:26.293643
2025-11-24 06:35:26,293 - INFO - Total duration: 0.56 seconds