2025-11-22 23:53:44,320 - INFO - ================================================================================
2025-11-22 23:53:44,321 - INFO - SCRIPT 8: FIX INCORRECT BUY PRICES
2025-11-22 23:53:44,321 - INFO - LIVE MODE
2025-11-22 23:53:44,321 - INFO - ================================================================================
2025-11-22 23:53:44,321 - INFO - Log file: /home/centralgoparts/public_html/profitability/logs/fix_buy_prices_20251122_235344.log
2025-11-22 23:53:44,321 - INFO - Started at: 2025-11-22 23:53:44.320814
2025-11-22 23:53:44,330 - INFO - 
================================================================================
2025-11-22 23:53:44,330 - INFO - CHECKING BUY PRICE FORMULA ACCURACY
2025-11-22 23:53:44,330 - INFO - Formula: our_buy_price = supplier_price + supplier_shipping + handling
2025-11-22 23:53:44,330 - INFO - ================================================================================
2025-11-22 23:53:44,413 - INFO - Checking 15011 orders...
2025-11-22 23:53:44,421 - INFO - Found 1027 orders with incorrect buy prices
2025-11-22 23:53:44,421 - INFO - 
Top 10 worst cases:
2025-11-22 23:53:44,421 - INFO -   1. Order 113-9436842-9996220: current=$124.13, should be=$259.52, diff=$135.39, source=Supplier e-mail
2025-11-22 23:53:44,421 - INFO -   2. Order 229625601: current=$36.53, should be=$100.31, diff=$63.78, source=Snapshot
2025-11-22 23:53:44,421 - INFO -   3. Order 45603-0014: current=$95.54, should be=$153.49, diff=$57.95, source=Supplier e-mail
2025-11-22 23:53:44,421 - INFO -   4. Order 39395-0002: current=$55.78, should be=$111.39, diff=$55.61, source=Supplier e-mail
2025-11-22 23:53:44,421 - INFO -   5. Order 229627646: current=$74.64, should be=$130.11, diff=$55.47, source=DEPO Included
2025-11-22 23:53:44,421 - INFO -   6. Order 229629320: current=$148.37, should be=$199.96, diff=$51.59, source=DEPO Included
2025-11-22 23:53:44,421 - INFO -   7. Order 112-9034261-6789810: current=$63.08, should be=$113.02, diff=$49.94, source=Snapshot
2025-11-22 23:53:44,421 - INFO -   8. Order 114-1002094-7701003: current=$25.97, should be=$74.90, diff=$48.93, source=DEPO Included
2025-11-22 23:53:44,421 - INFO -   9. Order 112-5333333-6717834: current=$110.41, should be=$158.31, diff=$47.90, source=Supplier e-mail
2025-11-22 23:53:44,422 - INFO -   10. Order 111-4446937-0529040: current=$142.75, should be=$190.65, diff=$47.90, source=Supplier e-mail
2025-11-22 23:53:44,566 - INFO - 
Fixed 1027 orders
2025-11-22 23:53:44,577 - INFO - 
================================================================================
2025-11-22 23:53:44,577 - INFO - RECALCULATING COGS FOR FIXED ORDERS
2025-11-22 23:53:44,577 - INFO - ================================================================================
2025-11-22 23:53:44,585 - INFO - Recalculating COGS for 1027 fixed orders
2025-11-22 23:53:44,745 - INFO - Recalculated COGS for 1027 orders
2025-11-22 23:53:44,752 - INFO - 
================================================================================
2025-11-22 23:53:44,752 - INFO - CHECKING GROSS PROFIT AND MARGIN ACCURACY FOR ALL ORDERS
2025-11-22 23:53:44,752 - INFO - ================================================================================
2025-11-22 23:53:44,901 - INFO - Checking 21148 orders for correct gross profit and margin...
2025-11-22 23:53:44,927 - INFO - Found 3958 orders with incorrect COGS/profit/margin
2025-11-22 23:53:44,928 - INFO - 
Top 10 worst cases:
2025-11-22 23:53:44,928 - INFO -   1. Order 114-2610813-2893038: current profit=$0.00, should be=$1832.92, diff=$1832.92
2025-11-22 23:53:44,928 - INFO -   2. Order 09309-0007: current profit=$0.00, should be=$1539.13, diff=$1539.13
2025-11-22 23:53:44,928 - INFO -   3. Order 111-1151565-7246635: current profit=$0.00, should be=$1191.56, diff=$1191.56
2025-11-22 23:53:44,928 - INFO -   4. Order 42554-0033: current profit=$0.00, should be=$998.21, diff=$998.21
2025-11-22 23:53:44,928 - INFO -   5. Order 55384-0123: current profit=$0.00, should be=$971.77, diff=$971.77
2025-11-22 23:53:44,928 - INFO -   6. Order 229626760: current profit=$0.00, should be=$920.95, diff=$920.95
2025-11-22 23:53:44,928 - INFO -   7. Order 46125-0007: current profit=$0.00, should be=$898.98, diff=$898.98
2025-11-22 23:53:44,928 - INFO -   8. Order 111-3588066-0027417: current profit=$0.00, should be=$886.95, diff=$886.95
2025-11-22 23:53:44,928 - INFO -   9. Order 113-2622259-0641816: current profit=$0.00, should be=$883.95, diff=$883.95
2025-11-22 23:53:44,928 - INFO -   10. Order 55826-0008: current profit=$0.00, should be=$883.29, diff=$883.29
2025-11-22 23:53:45,536 - INFO - 
Fixed 3958 orders
2025-11-22 23:53:45,546 - INFO - 
================================================================================
2025-11-22 23:53:45,547 - INFO - SUMMARY
2025-11-22 23:53:45,547 - INFO - ================================================================================
2025-11-22 23:53:45,547 - INFO - Orders with incorrect buy prices: 1027
2025-11-22 23:53:45,547 - INFO - COGS recalculated for buy price fixes: 1027
2025-11-22 23:53:45,547 - INFO - Orders with incorrect COGS/profit/margin: 3958
2025-11-22 23:53:45,547 - INFO - ================================================================================
2025-11-22 23:53:45,547 - INFO - 
Completed at: 2025-11-22 23:53:45.547217
2025-11-22 23:53:45,547 - INFO - Total duration: 1.23 seconds