2025-11-22 21:55:28,102 - INFO - ================================================================================
2025-11-22 21:55:28,102 - INFO - SCRIPT 8: FIX INCORRECT BUY PRICES
2025-11-22 21:55:28,102 - INFO - LIVE MODE
2025-11-22 21:55:28,102 - INFO - ================================================================================
2025-11-22 21:55:28,102 - INFO - Log file: /home/centralgoparts/public_html/profitability/logs/fix_buy_prices_20251122_215528.log
2025-11-22 21:55:28,102 - INFO - Started at: 2025-11-22 21:55:28.102184
2025-11-22 21:55:28,110 - INFO - 
================================================================================
2025-11-22 21:55:28,111 - INFO - CHECKING BUY PRICE FORMULA ACCURACY
2025-11-22 21:55:28,111 - INFO - Formula: our_buy_price = supplier_price + supplier_shipping + handling
2025-11-22 21:55:28,111 - INFO - ================================================================================
2025-11-22 21:55:28,154 - INFO - Checking 8025 orders...
2025-11-22 21:55:28,157 - INFO - Found 285 orders with incorrect buy prices
2025-11-22 21:55:28,157 - INFO - 
Top 10 worst cases:
2025-11-22 21:55:28,157 - INFO -   1. Order 114-1002094-7701003: current=$25.97, should be=$74.90, diff=$48.93, source=DEPO Included
2025-11-22 21:55:28,157 - INFO -   2. Order 111-8337010-0339466: current=$25.97, should be=$68.98, diff=$43.01, source=DEPO Included
2025-11-22 21:55:28,157 - INFO -   3. Order 39397-0066: current=$72.06, should be=$108.70, diff=$36.64, source=DEPO Included
2025-11-22 21:55:28,157 - INFO -   4. Order 37369-0014: current=$61.88, should be=$97.10, diff=$35.22, source=DEPO Included
2025-11-22 21:55:28,158 - INFO -   5. Order 04260-0002: current=$95.43, should be=$129.69, diff=$34.26, source=DEPO Included
2025-11-22 21:55:28,158 - INFO -   6. Order 46469-0006: current=$39.11, should be=$70.61, diff=$31.50, source=DEPO Included
2025-11-22 21:55:28,158 - INFO -   7. Order 01447-0010: current=$28.49, should be=$59.92, diff=$31.43, source=DEPO Included
2025-11-22 21:55:28,158 - INFO -   8. Order 113-7046550-7281008: current=$85.00, should be=$114.55, diff=$29.55, source=DEPO Included
2025-11-22 21:55:28,158 - INFO -   9. Order 111-3543190-9565021: current=$60.55, should be=$90.10, diff=$29.55, source=DEPO Included
2025-11-22 21:55:28,158 - INFO -   10. Order 114-7502400-2704268: current=$276.58, should be=$300.42, diff=$23.84, source=DEPO Included
2025-11-22 21:55:28,195 - INFO - 
Fixed 285 orders
2025-11-22 21:55:28,204 - INFO - 
================================================================================
2025-11-22 21:55:28,204 - INFO - RECALCULATING COGS FOR FIXED ORDERS
2025-11-22 21:55:28,204 - INFO - ================================================================================
2025-11-22 21:55:28,207 - INFO - Recalculating COGS for 285 fixed orders
2025-11-22 21:55:28,244 - INFO - Recalculated COGS for 285 orders
2025-11-22 21:55:28,251 - INFO - 
================================================================================
2025-11-22 21:55:28,251 - INFO - CHECKING GROSS PROFIT AND MARGIN ACCURACY FOR ALL ORDERS
2025-11-22 21:55:28,251 - INFO - ================================================================================
2025-11-22 21:55:28,322 - INFO - Checking 10548 orders for correct gross profit and margin...
2025-11-22 21:55:28,334 - INFO - ✓ All orders have correct COGS, gross profit, and gross margin
2025-11-22 21:55:28,337 - INFO - 
================================================================================
2025-11-22 21:55:28,337 - INFO - SUMMARY
2025-11-22 21:55:28,337 - INFO - ================================================================================
2025-11-22 21:55:28,337 - INFO - Orders with incorrect buy prices: 285
2025-11-22 21:55:28,337 - INFO - COGS recalculated for buy price fixes: 285
2025-11-22 21:55:28,337 - INFO - Orders with incorrect COGS/profit/margin: 0
2025-11-22 21:55:28,337 - INFO - ================================================================================
2025-11-22 21:55:28,337 - INFO - 
Completed at: 2025-11-22 21:55:28.337791
2025-11-22 21:55:28,337 - INFO - Total duration: 0.24 seconds