the Isuzu 6VD1 was fitted to the Frontera ... the Y32 is the GM 3.2 V6 fitted to the Vauxhall Omega and never made it to the Frontera
The 6VD1 came in SOHC and DOHC versions when fitted to the Trooper. I believe that the Frontera B series only had the DOHC version.
Looking at my version of EPC ... which is the latest version ... it shows only one type of waterpump for all the Isuzu V6 versions (including the Monterey ... see what I did there

)
I would say that Eurocarparts have got it wrong (not that unusual) and you have gained a paperweight.
The VX part number for the V6 waterpump is 97167554.