2025-11-22 23:35:16,287 - INFO - ================================================================================
2025-11-22 23:35:16,287 - INFO - SCRIPT 8: FIX INCORRECT BUY PRICES
2025-11-22 23:35:16,287 - INFO - LIVE MODE
2025-11-22 23:35:16,287 - INFO - ================================================================================
2025-11-22 23:35:16,287 - INFO - Log file: /home/centralgoparts/public_html/profitability/logs/fix_buy_prices_20251122_233516.log
2025-11-22 23:35:16,287 - INFO - Started at: 2025-11-22 23:35:16.287055
2025-11-22 23:35:16,297 - INFO - 
================================================================================
2025-11-22 23:35:16,297 - INFO - CHECKING BUY PRICE FORMULA ACCURACY
2025-11-22 23:35:16,297 - INFO - Formula: our_buy_price = supplier_price + supplier_shipping + handling
2025-11-22 23:35:16,297 - INFO - ================================================================================
2025-11-22 23:35:16,357 - INFO - Checking 8550 orders...
2025-11-22 23:35:16,362 - INFO - Found 511 orders with incorrect buy prices
2025-11-22 23:35:16,363 - INFO - 
Top 10 worst cases:
2025-11-22 23:35:16,363 - INFO -   1. Order 113-9436842-9996220: current=$124.13, should be=$259.52, diff=$135.39, source=Supplier e-mail
2025-11-22 23:35:16,363 - INFO -   2. Order 229625601: current=$42.53, should be=$106.31, diff=$63.78, source=Supplier e-mail
2025-11-22 23:35:16,363 - INFO -   3. Order 229627646: current=$74.64, should be=$130.11, diff=$55.47, source=DEPO Included
2025-11-22 23:35:16,363 - INFO -   4. Order 229629320: current=$148.37, should be=$199.96, diff=$51.59, source=DEPO Included
2025-11-22 23:35:16,363 - INFO -   5. Order 111-3293198-4241046: current=$179.01, should be=$216.75, diff=$37.74, source=Supplier e-mail
2025-11-22 23:35:16,363 - INFO -   6. Order 111-4482456-5120254: current=$156.47, should be=$192.17, diff=$35.70, source=Supplier e-mail
2025-11-22 23:35:16,363 - INFO -   7. Order 112-6948967-7257042: current=$17.73, should be=$52.05, diff=$34.32, source=Supplier e-mail
2025-11-22 23:35:16,363 - INFO -   8. Order 114-9675120-7822648: current=$24.97, should be=$59.22, diff=$34.25, source=Supplier e-mail
2025-11-22 23:35:16,363 - INFO -   9. Order 37317-0004: current=$110.41, should be=$144.55, diff=$34.14, source=Supplier e-mail
2025-11-22 23:35:16,363 - INFO -   10. Order 37317-0004: current=$58.47, should be=$92.61, diff=$34.14, source=Supplier e-mail
2025-11-22 23:35:16,444 - INFO - 
Fixed 511 orders
2025-11-22 23:35:16,455 - INFO - 
================================================================================
2025-11-22 23:35:16,455 - INFO - RECALCULATING COGS FOR FIXED ORDERS
2025-11-22 23:35:16,455 - INFO - ================================================================================
2025-11-22 23:35:16,461 - INFO - Recalculating COGS for 511 fixed orders
2025-11-22 23:35:16,548 - INFO - Recalculated COGS for 511 orders
2025-11-22 23:35:16,555 - INFO - 
================================================================================
2025-11-22 23:35:16,555 - INFO - CHECKING GROSS PROFIT AND MARGIN ACCURACY FOR ALL ORDERS
2025-11-22 23:35:16,556 - INFO - ================================================================================
2025-11-22 23:35:16,644 - INFO - Checking 11610 orders for correct gross profit and margin...
2025-11-22 23:35:16,660 - INFO - Found 2236 orders with incorrect COGS/profit/margin
2025-11-22 23:35:16,660 - INFO - 
Top 10 worst cases:
2025-11-22 23:35:16,660 - INFO -   1. Order 42554-0033: current profit=$0.00, should be=$998.21, diff=$998.21
2025-11-22 23:35:16,660 - INFO -   2. Order 55384-0123: current profit=$0.00, should be=$971.77, diff=$971.77
2025-11-22 23:35:16,660 - INFO -   3. Order 229626760: current profit=$0.00, should be=$920.95, diff=$920.95
2025-11-22 23:35:16,660 - INFO -   4. Order 46125-0007: current profit=$0.00, should be=$898.98, diff=$898.98
2025-11-22 23:35:16,660 - INFO -   5. Order 113-2622259-0641816: current profit=$0.00, should be=$883.95, diff=$883.95
2025-11-22 23:35:16,660 - INFO -   6. Order 55826-0008: current profit=$0.00, should be=$883.29, diff=$883.29
2025-11-22 23:35:16,660 - INFO -   7. Order 03569-0056: current profit=$0.00, should be=$878.86, diff=$878.86
2025-11-22 23:35:16,660 - INFO -   8. Order 08024-0021: current profit=$0.00, should be=$817.34, diff=$817.34
2025-11-22 23:35:16,660 - INFO -   9. Order 14444-0001: current profit=$0.00, should be=$814.43, diff=$814.43
2025-11-22 23:35:16,660 - INFO -   10. Order 57376-1604: current profit=$0.00, should be=$803.30, diff=$803.30
2025-11-22 23:35:17,118 - INFO - 
Fixed 2236 orders
2025-11-22 23:35:17,124 - INFO - 
================================================================================
2025-11-22 23:35:17,124 - INFO - SUMMARY
2025-11-22 23:35:17,124 - INFO - ================================================================================
2025-11-22 23:35:17,124 - INFO - Orders with incorrect buy prices: 511
2025-11-22 23:35:17,124 - INFO - COGS recalculated for buy price fixes: 511
2025-11-22 23:35:17,124 - INFO - Orders with incorrect COGS/profit/margin: 2236
2025-11-22 23:35:17,124 - INFO - ================================================================================
2025-11-22 23:35:17,124 - INFO - 
Completed at: 2025-11-22 23:35:17.124868
2025-11-22 23:35:17,124 - INFO - Total duration: 0.84 seconds