2025-11-22 23:17:29,154 - INFO - ================================================================================
2025-11-22 23:17:29,154 - INFO - SCRIPT 8: FIX INCORRECT BUY PRICES
2025-11-22 23:17:29,154 - INFO - LIVE MODE
2025-11-22 23:17:29,154 - INFO - ================================================================================
2025-11-22 23:17:29,154 - INFO - Log file: /home/centralgoparts/public_html/profitability/logs/fix_buy_prices_20251122_231729.log
2025-11-22 23:17:29,154 - INFO - Started at: 2025-11-22 23:17:29.154605
2025-11-22 23:17:29,163 - INFO - 
================================================================================
2025-11-22 23:17:29,163 - INFO - CHECKING BUY PRICE FORMULA ACCURACY
2025-11-22 23:17:29,163 - INFO - Formula: our_buy_price = supplier_price + supplier_shipping + handling
2025-11-22 23:17:29,163 - INFO - ================================================================================
2025-11-22 23:17:29,187 - INFO - Checking 4598 orders...
2025-11-22 23:17:29,189 - INFO - Found 390 orders with incorrect buy prices
2025-11-22 23:17:29,189 - INFO - 
Top 10 worst cases:
2025-11-22 23:17:29,189 - INFO -   1. Order 45603-0014: current=$95.54, should be=$153.49, diff=$57.95, source=Supplier e-mail
2025-11-22 23:17:29,189 - INFO -   2. Order 39395-0002: current=$55.78, should be=$111.39, diff=$55.61, source=Supplier e-mail
2025-11-22 23:17:29,189 - INFO -   3. Order 114-1002094-7701003: current=$25.97, should be=$74.90, diff=$48.93, source=DEPO Included
2025-11-22 23:17:29,189 - INFO -   4. Order 112-5333333-6717834: current=$110.41, should be=$158.31, diff=$47.90, source=Supplier e-mail
2025-11-22 23:17:29,189 - INFO -   5. Order 111-4446937-0529040: current=$142.75, should be=$190.65, diff=$47.90, source=Supplier e-mail
2025-11-22 23:17:29,189 - INFO -   6. Order 111-9930385-7029051: current=$130.99, should be=$175.18, diff=$44.19, source=Supplier e-mail
2025-11-22 23:17:29,189 - INFO -   7. Order 111-8337010-0339466: current=$25.97, should be=$68.98, diff=$43.01, source=DEPO Included
2025-11-22 23:17:29,189 - INFO -   8. Order 111-6934845-7985838: current=$179.01, should be=$222.02, diff=$43.01, source=Supplier e-mail
2025-11-22 23:17:29,189 - INFO -   9. Order 39397-0066: current=$72.06, should be=$108.70, diff=$36.64, source=DEPO Included
2025-11-22 23:17:29,189 - INFO -   10. Order 113-1901190-0928259: current=$97.67, should be=$133.37, diff=$35.70, source=Supplier e-mail
2025-11-22 23:17:29,242 - INFO - 
Fixed 390 orders
2025-11-22 23:17:29,250 - INFO - 
================================================================================
2025-11-22 23:17:29,250 - INFO - RECALCULATING COGS FOR FIXED ORDERS
2025-11-22 23:17:29,251 - INFO - ================================================================================
2025-11-22 23:17:29,254 - INFO - Recalculating COGS for 390 fixed orders
2025-11-22 23:17:29,308 - INFO - Recalculated COGS for 390 orders
2025-11-22 23:17:29,315 - INFO - 
================================================================================
2025-11-22 23:17:29,315 - INFO - CHECKING GROSS PROFIT AND MARGIN ACCURACY FOR ALL ORDERS
2025-11-22 23:17:29,315 - INFO - ================================================================================
2025-11-22 23:17:29,356 - INFO - Checking 6195 orders for correct gross profit and margin...
2025-11-22 23:17:29,362 - INFO - Found 1108 orders with incorrect COGS/profit/margin
2025-11-22 23:17:29,363 - INFO - 
Top 10 worst cases:
2025-11-22 23:17:29,363 - INFO -   1. Order 09309-0007: current profit=$0.00, should be=$1539.13, diff=$1539.13
2025-11-22 23:17:29,363 - INFO -   2. Order 111-1151565-7246635: current profit=$0.00, should be=$1191.56, diff=$1191.56
2025-11-22 23:17:29,363 - INFO -   3. Order 44013-0060: current profit=$0.00, should be=$852.91, diff=$852.91
2025-11-22 23:17:29,363 - INFO -   4. Order 229631117: current profit=$0.00, should be=$735.94, diff=$735.94
2025-11-22 23:17:29,363 - INFO -   5. Order 42972-0068: current profit=$0.00, should be=$733.70, diff=$733.70
2025-11-22 23:17:29,363 - INFO -   6. Order 33925-0022: current profit=$0.00, should be=$730.12, diff=$730.12
2025-11-22 23:17:29,363 - INFO -   7. Order 60550-0001: current profit=$0.00, should be=$712.52, diff=$712.52
2025-11-22 23:17:29,363 - INFO -   8. Order 229632252: current profit=$0.00, should be=$707.95, diff=$707.95
2025-11-22 23:17:29,363 - INFO -   9. Order 113-8204700-2324214: current profit=$0.00, should be=$707.95, diff=$707.95
2025-11-22 23:17:29,363 - INFO -   10. Order 03021-0055: current profit=$0.00, should be=$693.67, diff=$693.67
2025-11-22 23:17:29,522 - INFO - 
Fixed 1108 orders
2025-11-22 23:17:29,525 - INFO - 
================================================================================
2025-11-22 23:17:29,525 - INFO - SUMMARY
2025-11-22 23:17:29,525 - INFO - ================================================================================
2025-11-22 23:17:29,525 - INFO - Orders with incorrect buy prices: 390
2025-11-22 23:17:29,525 - INFO - COGS recalculated for buy price fixes: 390
2025-11-22 23:17:29,525 - INFO - Orders with incorrect COGS/profit/margin: 1108
2025-11-22 23:17:29,525 - INFO - ================================================================================
2025-11-22 23:17:29,525 - INFO - 
Completed at: 2025-11-22 23:17:29.525524
2025-11-22 23:17:29,525 - INFO - Total duration: 0.37 seconds