Hi @mukund2021,
The product URL you referenced is regrettably producing a 404 error when trying to load that.
I’ve performed some cross-testing for us today though on several of my sites which have the latest versions of WordPress, WooCommerce and our free Storefront theme as the only enabled software. When doing so I’ve not been able to replicate the behaviour which you describe with regards to External/Affiliate products not working as they should.
Test Product: https://woostaging.mystagingwebsite.com/product/external-affiliate-product/
You can find the documentation relating to External/Affiliate products for WooCommerce on this page below
https://docs.woocommerce.com/document/managing-products/#adding-an-external-affiliate-product
If the External/Affiliate products are still not working for your particular site. From what you have described, it could be code from another plugin or theme which has caused a possible conflict and affected the functionality of WooCommerce.
To see if that is the case we’d suggest carrying out a conflict test on your site by disabling all other plugins aside from WooCommerce along with switching to a theme like Storefront. This will help with trying to and locate what software you have installed which could possibly be causing this behaviour? You could use a free plugin called Health Check and Troubleshooting to carry out such testing.
When in Troubleshooting mode all plugins will be deactivated and only the admin of the site carrying out the troubleshooting would see those changes. Any customers visiting the site would see no changes at all.
Once you have disabled all other plugins and switched themes if the behaviour is resolved you can then enabled your theme and sites plugins testing after each one is enabled until the behaviour returns to locate the culprit.
https://docs.woocommerce.com/document/how-to-test-for-conflicts/