The mixing of heterogeneous petroleum products in large-scale storage tanks is critical for ensuring product homogeneity, yet it presents challenges due to stratification and varying fluid properties. This study develops a computational fluid dynamics (CFD) model based on Navier-Stokes equations, incorporating multi-phase flow and turbulence models, to simulate hydrodynamic processes in a 10,000 m3 cylindrical tank. The model accounts for realistic product properties (density: 800–950 kg/m3, viscosity: 1–100 cP) and mixer configurations (jet and impeller). Experimental validation using a 1 m3 scaled-down tank, with measurements from Particle Image Velocimetry (PIV) and density sensors, confirms the model’s accuracy in predicting concentration profiles and mixing times. Results show that jet mixers achieve 95% homogeneity in 15–25 minutes with 50–80 kW energy consumption, outperforming impellers in large volumes, while tank design modifications, such as baffles, reduce dead zones by 15%. These findings enable optimized mixing strategies, improving product quality, reducing energy costs by up to 20%, and minimizing environmental risks in refineries and storage terminals. Future work includes integrating real-time IoT sensor data for dynamic process control. Objective. To quantitatively compare the efficacy of hydrodynamic treatment versus traditional mechanical-chemical methods for bottomhole zone (BHZ) rehabilitation in hydrogeological wells, optimizing specific capacity recovery, treatment longevity, and environmental sustainability across diverse aquifer lithologies. Methodic. An integrated framework combined computational fluid dynamics modeling (k-ε turbulence + Schnerr-Sauer cavitation, ANSYS Fluent), laboratory coreflood experiments (n=24 sandstone, limestone, siltstone cores, φ=15-28%), and field trials (6 wells, Dnipro basin, 80-150 m depth). Hydrodynamic parameters included jet velocities of 150-250 m/s; traditional methods encompassed 10% HCl acidizing and mechanical brushing/surging. Metrics included permeability (k), specific capacity (Sc), skin factor (Ss), and turbidity, analyzed via ANOVA (α=0.05) and cost-benefit NPV calculations. Results. Hydrodynamic treatment achieved 245% specific capacity recovery with 87.5% retention at 12 months, surpassing acidizing (69.0% retention, +145%) and mechanical methods (57.9%, +55%) (p<0.01). Permeability gains reached 420% in fractured limestones and 283% in porous sands, driven by micro-fracturing (Δσh=2-4 МПа) and cavitation (τw=2.5-4.2 kPa). Acidizing excelled in clay-silt (+300%), mechanical methods in shallow wells. Hydrodynamic ROI was 4.2x (18 months), with 65% lower waste costs. Novelty. This study pioneers a validated CFD-coreflood-field framework (R2=0.94), introducing a composite efficiency index (E=0.78-0.91) and lithology-specific decision matrix, bridging theoretical hydrodynamics with practical BHZ rehabilitation across confined, unconfined, and low-permeability aquifers. Practical significance. The decision matrix enables 20-30% productivity gains in 70% of groundwater wells, with zero chemical footprint and 85% water recycling establishing hydrodynamic treatment as a sustainable standard. Guidelines support national groundwater policy, enhancing rural water supply resilience under climate-driven scarcity. Keywords: computational fluid dynamics, multi-phase flow, petroleum storage, mixing efficiency, turbulence modeling, jet mixers, impellers, stratification, tank design, energy optimization