2025-11-22 03:35:40,236 - INFO - ================================================================================
2025-11-22 03:35:40,236 - INFO - SCRIPT 8: FIX INCORRECT BUY PRICES
2025-11-22 03:35:40,236 - INFO - LIVE MODE
2025-11-22 03:35:40,236 - INFO - ================================================================================
2025-11-22 03:35:40,236 - INFO - Log file: /home/centralgoparts/public_html/profitability/logs/fix_buy_prices_20251122_033540.log
2025-11-22 03:35:40,236 - INFO - Started at: 2025-11-22 03:35:40.236400
2025-11-22 03:35:40,245 - INFO - 
================================================================================
2025-11-22 03:35:40,245 - INFO - CHECKING BUY PRICE FORMULA ACCURACY
2025-11-22 03:35:40,245 - INFO - Formula: our_buy_price = supplier_price + supplier_shipping + handling
2025-11-22 03:35:40,245 - INFO - ================================================================================
2025-11-22 03:35:40,286 - INFO - Checking 7843 orders...
2025-11-22 03:35:40,290 - INFO - Found 405 orders with incorrect buy prices
2025-11-22 03:35:40,290 - INFO - 
Top 10 worst cases:
2025-11-22 03:35:40,290 - INFO -   1. Order 45603-0014: current=$95.54, should be=$153.49, diff=$57.95, source=Supplier e-mail
2025-11-22 03:35:40,290 - INFO -   2. Order 39395-0002: current=$55.78, should be=$111.39, diff=$55.61, source=Supplier e-mail
2025-11-22 03:35:40,290 - INFO -   3. Order 114-1002094-7701003: current=$25.97, should be=$74.90, diff=$48.93, source=DEPO Included
2025-11-22 03:35:40,290 - INFO -   4. Order 112-5333333-6717834: current=$110.41, should be=$158.31, diff=$47.90, source=Supplier e-mail
2025-11-22 03:35:40,290 - INFO -   5. Order 111-4446937-0529040: current=$142.75, should be=$190.65, diff=$47.90, source=Supplier e-mail
2025-11-22 03:35:40,290 - INFO -   6. Order 111-9930385-7029051: current=$130.99, should be=$175.18, diff=$44.19, source=Supplier e-mail
2025-11-22 03:35:40,290 - INFO -   7. Order 111-8337010-0339466: current=$25.97, should be=$68.98, diff=$43.01, source=DEPO Included
2025-11-22 03:35:40,290 - INFO -   8. Order 111-6934845-7985838: current=$179.01, should be=$222.02, diff=$43.01, source=Supplier e-mail
2025-11-22 03:35:40,290 - INFO -   9. Order 39397-0066: current=$72.06, should be=$108.70, diff=$36.64, source=DEPO Included
2025-11-22 03:35:40,290 - INFO -   10. Order 113-1901190-0928259: current=$97.67, should be=$133.37, diff=$35.70, source=Supplier e-mail
2025-11-22 03:35:40,345 - INFO - 
Fixed 405 orders
2025-11-22 03:35:40,355 - INFO - 
================================================================================
2025-11-22 03:35:40,355 - INFO - RECALCULATING COGS FOR FIXED ORDERS
2025-11-22 03:35:40,355 - INFO - ================================================================================
2025-11-22 03:35:40,359 - INFO - Recalculating COGS for 405 fixed orders
2025-11-22 03:35:40,423 - INFO - Recalculated COGS for 405 orders
2025-11-22 03:35:40,431 - INFO - 
================================================================================
2025-11-22 03:35:40,431 - INFO - CHECKING GROSS PROFIT AND MARGIN ACCURACY FOR ALL ORDERS
2025-11-22 03:35:40,431 - INFO - ================================================================================
2025-11-22 03:35:40,514 - INFO - Checking 10548 orders for correct gross profit and margin...
2025-11-22 03:35:40,536 - INFO - Found 5818 orders with incorrect COGS/profit/margin
2025-11-22 03:35:40,537 - INFO - 
Top 10 worst cases:
2025-11-22 03:35:40,538 - INFO -   1. Order 09309-0007: current profit=$0.00, should be=$1539.13, diff=$1539.13
2025-11-22 03:35:40,538 - INFO -   2. Order 111-1151565-7246635: current profit=$0.00, should be=$1191.56, diff=$1191.56
2025-11-22 03:35:40,538 - INFO -   3. Order 44013-0060: current profit=$0.00, should be=$852.91, diff=$852.91
2025-11-22 03:35:40,538 - INFO -   4. Order 229631126: current profit=$0.00, should be=$837.83, diff=$837.83
2025-11-22 03:35:40,538 - INFO -   5. Order 112-0648650-4677822: current profit=$16.34, should be=$760.84, diff=$744.50
2025-11-22 03:35:40,538 - INFO -   6. Order 229631117: current profit=$0.00, should be=$735.94, diff=$735.94
2025-11-22 03:35:40,538 - INFO -   7. Order 42972-0068: current profit=$0.00, should be=$733.70, diff=$733.70
2025-11-22 03:35:40,538 - INFO -   8. Order 33925-0022: current profit=$0.00, should be=$730.12, diff=$730.12
2025-11-22 03:35:40,538 - INFO -   9. Order 12-13674-60418: current profit=$0.00, should be=$724.66, diff=$724.66
2025-11-22 03:35:40,538 - INFO -   10. Order 60550-0001: current profit=$0.00, should be=$712.52, diff=$712.52
2025-11-22 03:35:41,543 - INFO - 
Fixed 5818 orders
2025-11-22 03:35:41,549 - INFO - 
================================================================================
2025-11-22 03:35:41,550 - INFO - SUMMARY
2025-11-22 03:35:41,550 - INFO - ================================================================================
2025-11-22 03:35:41,550 - INFO - Orders with incorrect buy prices: 405
2025-11-22 03:35:41,550 - INFO - COGS recalculated for buy price fixes: 405
2025-11-22 03:35:41,550 - INFO - Orders with incorrect COGS/profit/margin: 5818
2025-11-22 03:35:41,550 - INFO - ================================================================================
2025-11-22 03:35:41,550 - INFO - 
Completed at: 2025-11-22 03:35:41.550151
2025-11-22 03:35:41,550 - INFO - Total duration: 1.31 seconds