in the “wp_shopping_cart.php” file search for the following line of code
if ($_POST['addcart'])
inside that if statement you can add your condition and put the redirection code so it redirects to the target page.
Once you do this it will work similar to what it doesn’t when you add a product from my products page