2025-11-22 03:25:07,173 - INFO - ================================================================================
2025-11-22 03:25:07,174 - INFO - SCRIPT 8: FIX INCORRECT BUY PRICES
2025-11-22 03:25:07,174 - INFO - LIVE MODE
2025-11-22 03:25:07,174 - INFO - ================================================================================
2025-11-22 03:25:07,174 - INFO - Log file: /home/centralgoparts/public_html/profitability/logs/fix_buy_prices_20251122_032507.log
2025-11-22 03:25:07,174 - INFO - Started at: 2025-11-22 03:25:07.173864
2025-11-22 03:25:07,183 - INFO - 
================================================================================
2025-11-22 03:25:07,183 - INFO - CHECKING BUY PRICE FORMULA ACCURACY
2025-11-22 03:25:07,183 - INFO - Formula: our_buy_price = supplier_price + supplier_shipping + handling
2025-11-22 03:25:07,183 - INFO - ================================================================================
2025-11-22 03:25:07,200 - INFO - Checking 3283 orders...
2025-11-22 03:25:07,201 - INFO - Found 30 orders with incorrect buy prices
2025-11-22 03:25:07,201 - INFO - 
Top 10 worst cases:
2025-11-22 03:25:07,201 - INFO -   1. Order 111-9973049-7877062: current=$130.99, should be=$175.71, diff=$44.72, source=Supplier e-mail
2025-11-22 03:25:07,201 - INFO -   2. Order 112-6140972-5615432: current=$48.00, should be=$84.93, diff=$36.93, source=Snapshot
2025-11-22 03:25:07,201 - INFO -   3. Order 112-0524702-4945862: current=$179.01, should be=$210.44, diff=$31.43, source=Supplier e-mail
2025-11-22 03:25:07,201 - INFO -   4. Order 111-8827566-8237808: current=$133.80, should be=$152.67, diff=$18.87, source=DEPO Included
2025-11-22 03:25:07,201 - INFO -   5. Order 229632685: current=$39.21, should be=$58.08, diff=$18.87, source=DEPO Included
2025-11-22 03:25:07,201 - INFO -   6. Order 113-7585114-5345009: current=$33.77, should be=$51.51, diff=$17.74, source=Snapshot
2025-11-22 03:25:07,201 - INFO -   7. Order 44122-0005: current=$89.21, should be=$106.95, diff=$17.74, source=DEPO Included
2025-11-22 03:25:07,202 - INFO -   8. Order 114-2628415-7746655: current=$72.79, should be=$90.53, diff=$17.74, source=DEPO Included
2025-11-22 03:25:07,202 - INFO -   9. Order 112-3526702-9468238: current=$108.15, should be=$122.63, diff=$14.48, source=DEPO Included
2025-11-22 03:25:07,202 - INFO -   10. Order 112-4777599-6361006: current=$77.00, should be=$91.48, diff=$14.48, source=Supplier e-mail
2025-11-22 03:25:07,207 - INFO - 
Fixed 30 orders
2025-11-22 03:25:07,216 - INFO - 
================================================================================
2025-11-22 03:25:07,216 - INFO - RECALCULATING COGS FOR FIXED ORDERS
2025-11-22 03:25:07,216 - INFO - ================================================================================
2025-11-22 03:25:07,217 - INFO - Recalculating COGS for 30 fixed orders
2025-11-22 03:25:07,222 - INFO - Recalculated COGS for 30 orders
2025-11-22 03:25:07,230 - INFO - 
================================================================================
2025-11-22 03:25:07,230 - INFO - CHECKING GROSS PROFIT AND MARGIN ACCURACY FOR ALL ORDERS
2025-11-22 03:25:07,230 - INFO - ================================================================================
2025-11-22 03:25:07,258 - INFO - Checking 4353 orders for correct gross profit and margin...
2025-11-22 03:25:07,265 - INFO - Found 4321 orders with incorrect COGS/profit/margin
2025-11-22 03:25:07,266 - INFO - 
Top 10 worst cases:
2025-11-22 03:25:07,266 - INFO -   1. Order 114-2610813-2893038: current profit=$0.00, should be=$1832.92, diff=$1832.92
2025-11-22 03:25:07,266 - INFO -   2. Order 113-7029522-3957813: current profit=$53.04, should be=$987.31, diff=$934.27
2025-11-22 03:25:07,266 - INFO -   3. Order 45459-0171: current profit=$56.72, should be=$911.12, diff=$854.40
2025-11-22 03:25:07,266 - INFO -   4. Order 57376-1775: current profit=$0.00, should be=$843.07, diff=$843.07
2025-11-22 03:25:07,266 - INFO -   5. Order 09904-0040: current profit=$0.00, should be=$721.89, diff=$721.89
2025-11-22 03:25:07,266 - INFO -   6. Order 114-4567223-1498617: current profit=$0.00, should be=$674.76, diff=$674.76
2025-11-22 03:25:07,266 - INFO -   7. Order 114-1373475-4695439: current profit=$0.00, should be=$655.95, diff=$655.95
2025-11-22 03:25:07,266 - INFO -   8. Order 56972-0033: current profit=$0.00, should be=$609.58, diff=$609.58
2025-11-22 03:25:07,266 - INFO -   9. Order 48538-0049: current profit=$-620.00, should be=$-15.57, diff=$604.43
2025-11-22 03:25:07,266 - INFO -   10. Order 46167-0104: current profit=$18.74, should be=$616.03, diff=$597.29
2025-11-22 03:25:07,972 - INFO - 
Fixed 4321 orders
2025-11-22 03:25:07,975 - INFO - 
================================================================================
2025-11-22 03:25:07,975 - INFO - SUMMARY
2025-11-22 03:25:07,975 - INFO - ================================================================================
2025-11-22 03:25:07,975 - INFO - Orders with incorrect buy prices: 30
2025-11-22 03:25:07,975 - INFO - COGS recalculated for buy price fixes: 30
2025-11-22 03:25:07,975 - INFO - Orders with incorrect COGS/profit/margin: 4321
2025-11-22 03:25:07,975 - INFO - ================================================================================
2025-11-22 03:25:07,975 - INFO - 
Completed at: 2025-11-22 03:25:07.975617
2025-11-22 03:25:07,975 - INFO - Total duration: 0.80 seconds